奇迹Mu 删除MD5加密数据库语句！

标签：CI 加密 Chinese PRC Mu COLLATE NULL nvarchar MD5

很多GM在自己都不知道的情况下，就给游戏加了MD5的加密，MD5加密通常都是32位的加密，在写程序的逻辑上，通常会进行好几次的循环加密，导致很多用户注册或是登陆的时候会显示错误，今天MU-GM给大家提供一个清除数据库MD5的SQL语句。

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MANG_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MANG_INFO]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MEMB_INFO]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_OUT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MEMB_OUT]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[MembInfoModify]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_CURR_INFO]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_FQNW_INFO]

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)

drop table [dbo].[VI_MIDS_INFO]

GO

CREATE TABLE [dbo].[MANG_INFO] (

[mang_guid] [int] NOT NULL ,

[mang___id] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[mang__pwd] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[mang_name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[mail_addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[levl_name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

[part_name] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

[auth_code] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,

[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Group_code] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,

[dep_code] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[perm] [int] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[MEMB_INFO] (

[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,

[memb___id] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb__pwd] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_name] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[sno__numb] [char] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[post_code] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,

[addr_info] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[addr_deta] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[tel__numb] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

[phon_numb] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

[mail_addr] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[fpas_ques] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[fpas_answ] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[job__code] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,

[appl_days] [datetime] NULL ,

[modi_days] [datetime] NULL ,

[out__days] [datetime] NULL ,

[true_days] [datetime] NULL ,

[mail_chek] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,

[bloc_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[ctl1_code] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[adminaccess] [int] NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[MEMB_OUT] (

[out__guid] [int] NOT NULL ,

[memb_guid] [int] NOT NULL ,

[sno__numb] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,

[memb_name] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

[appl_days] [smalldatetime] NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[MembInfoModify] (

[Number] [int] NOT NULL ,

[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb__pwd] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (13) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[tel__numb] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,

[phon_numb] [nvarchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,

[mail_addr] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[bloc_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[VI_CURR_INFO] (

[ends_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,

[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[used_time] [int] NULL ,

[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_guid] [int] NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[Bill_Section] [int] NULL ,

[Bill_Value] [int] NULL ,

[Bill_Hour] [int] NULL ,

[Surplus_Point] [int] NULL ,

[Surplus_Minute] [datetime] NULL ,

[Increase_Days] [int] NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[VI_FQNW_INFO] (

[appl_code] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[ctrl_text] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,

[fpas_ques] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[fpas_answ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[ctl1_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_guid] [int] NOT NULL ,

[fanw_guid] [int] NOT NULL ,

[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL

) ON [PRIMARY]

GO

CREATE TABLE [dbo].[VI_MIDS_INFO] (

[memb___id] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[memb_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[sno__numb] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[appl_days] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[chek_code] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[prev_info] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[modi_info] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,

[cont_text] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,

[mids_guid] [int] NOT NULL ,

[admin_name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

ALTER TABLE MEMB_INFO ALTER COLUMN memb__pwd VARCHAR(10) NOT NULL

GO

 

标签：CI,加密,Chinese,PRC,Mu,COLLATE,NULL,nvarchar,MD5
From： https://www.cnblogs.com/muonline/p/17876717.html