Remove MD5 Fixed

fratika · 2023-05-26T21:48:25+00:00

Put this in Query Analizer. [hide thanked=1] if exists (select * from dbo.sysobjects where id = object_id(N'.[MANG_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[MANG_INFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'.[MEMB_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[MEMB_INFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'.[MEMB_OUT]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[MEMB_OUT] GO if exists (select * from dbo.sysobjects where id = object_id(N'.') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table . GO if exists (select * from dbo.sysobjects where id = object_id(N'.[VI_CURR_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[VI_CURR_INFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'.[VI_FQNW_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[VI_FQNW_INFO] GO if exists (select * from dbo.sysobjects where id = object_id(N'.[VI_MIDS_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table .[VI_MIDS_INFO] GO CREATE TABLE .[MANG_INFO] ( [mang_guid] NOT NULL , [mang___id] (15) COLLATE Polish_CI_AS NOT NULL , [mang__pwd] (15) COLLATE Polish_CI_AS NOT NULL , [mang_name] (20) COLLATE Polish_CI_AS NOT NULL , [mail_addr] (50) COLLATE Polish_CI_AS NOT NULL , [levl_name] (30) COLLATE Polish_CI_AS NULL , [part_name] (30) COLLATE Polish_CI_AS NULL , [auth_code] (30) COLLATE Polish_CI_AS NULL , [appl_days] (8) COLLATE Polish_CI_AS NOT NULL , [ctl1_code] (1) COLLATE Polish_CI_AS NOT NULL , [Group_code] (2) COLLATE Polish_CI_AS NULL , [dep_code] (4) COLLATE Polish_CI_AS NOT NULL , NOT NULL ) ON GO CREATE TABLE .[MEMB_INFO] ( [memb_guid] IDENTITY (1, 1) NOT NULL , [memb___id] (10) COLLATE Polish_CI_AS NOT NULL , [memb__pwd] (10) COLLATE Polish_CI_AS NOT NULL , [memb_name] (10) COLLATE Polish_CI_AS NOT NULL , [sno__numb] (13) COLLATE Polish_CI_AS NOT NULL , [post_code] (6) COLLATE Polish_CI_AS NULL , [addr_info] (50) COLLATE Polish_CI_AS NULL , [addr_deta] (50) COLLATE Polish_CI_AS NULL , [tel__numb] (20) COLLATE Polish_CI_AS NULL , [phon_numb] (15) COLLATE Polish_CI_AS NULL , [mail_addr] (50) COLLATE Polish_CI_AS NULL , [fpas_ques] (50) COLLATE Polish_CI_AS NULL , [fpas_answ] (50) COLLATE Polish_CI_AS NULL , [job__code] (2) COLLATE Polish_CI_AS NULL , [appl_days] NULL , [modi_days] NULL , [out__days] NULL , [true_days] NULL , [mail_chek] (1) COLLATE Polish_CI_AS NULL , [bloc_code] (1) COLLATE Polish_CI_AS NOT NULL , [ctl1_code] (1) COLLATE Polish_CI_AS NOT NULL , NOT NULL ) ON GO CREATE TABLE .[MEMB_OUT] ( [out__guid] NOT NULL , [memb_guid] NOT NULL , [sno__numb] (7) COLLATE Polish_CI_AS NULL , [memb_name] (15) COLLATE Polish_CI_AS NULL , [appl_days] NULL , [ctl1_code] (1) COLLATE Polish_CI_AS NULL ) ON GO CREATE TABLE . ( NOT NULL , [memb___id] (10) COLLATE Polish_CI_AS NOT NULL , [memb__pwd] (10) COLLATE Polish_CI_AS NOT NULL , [memb_name] (10) COLLATE Polish_CI_AS NOT NULL , [sno__numb] (13) COLLATE Polish_CI_AS NOT NULL , [tel__numb] (20) COLLATE Polish_CI_AS NULL , [phon_numb] (15) COLLATE Polish_CI_AS NULL , [mail_addr] (50) COLLATE Polish_CI_AS NULL , [fpas_ques] (50) COLLATE Polish_CI_AS NULL , [fpas_answ] (50) COLLATE Polish_CI_AS NULL , [bloc_code] (1) COLLATE Polish_CI_AS NULL ) ON GO CREATE TABLE .[VI_CURR_INFO] ( [ends_days] (8) COLLATE Polish_CI_AS NULL , [chek_code] (1) COLLATE Polish_CI_AS NOT NULL , [used_time] NULL , [memb___id] (10) COLLATE Polish_CI_AS NOT NULL , [memb_name] (10) COLLATE Polish_CI_AS NOT NULL , [memb_guid] NOT NULL , [sno__numb] (18) COLLATE Polish_CI_AS NOT NULL , [Bill_Section] NULL , [Bill_Value] NULL , [Bill_Hour] NULL , [Surplus_Point] NULL , [Surplus_Minute] NULL , [Increase_Days] NULL ) ON GO CREATE TABLE .[VI_FQNW_INFO] ( [appl_code] (10) COLLATE Polish_CI_AS NOT NULL , [ctrl_text] (50) COLLATE Polish_CI_AS NULL , [fpas_ques] (50) COLLATE Polish_CI_AS NOT NULL , [fpas_answ] (50) COLLATE Polish_CI_AS NOT NULL , [appl_days] (8) COLLATE Polish_CI_AS NOT NULL , [ctl1_code] (1) COLLATE Polish_CI_AS NOT NULL , [memb_name] (10) COLLATE Polish_CI_AS NOT NULL , [memb_guid] NOT NULL , [fanw_guid] NOT NULL , [memb___id] (10) COLLATE Polish_CI_AS NOT NULL , [sno__numb] (18) COLLATE Polish_CI_AS NOT NULL ) ON GO CREATE TABLE .[VI_MIDS_INFO] ( [memb___id] (10) COLLATE Polish_CI_AS NOT NULL , [memb_name] (10) COLLATE Polish_CI_AS NOT NULL , [sno__numb] (18) COLLATE Polish_CI_AS NOT NULL , [appl_days] (8) COLLATE Polish_CI_AS NOT NULL , [chek_code] (1) COLLATE Polish_CI_AS NOT NULL , [prev_info] (50) COLLATE Polish_CI_AS NOT NULL , [modi_info] (10) COLLATE Polish_CI_AS NOT NULL , [cont_text] COLLATE Polish_CI_AS NOT NULL , [mids_guid] NOT NULL , [admin_name] (10) COLLATE Polish_CI_AS NULL ) ON TEXTIMAGE_ON GO ALTER TABLE MEMB_INFO ALTER COLUMN memb__pwd VARCHAR(10) NOT NULL GO