exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MembInfoModify]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[MembInfoModify]GOif 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]GOif 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]GOif 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]GOCREATE TABLE [dbo].[MANG_INFO] ([mang_guid] [int] NOT NULL ,[mang___id] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,[mang__pwd] [nvarchar] (15) COLLATE Polish_CI_AS NOT NULL ,[mang_name] [nvarchar] (20) COLLATE Polish_CI_AS NOT NULL ,[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,[levl_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,[part_name] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,[auth_code] [nvarchar] (30) COLLATE Polish_CI_AS NULL ,[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,[Group_code] [nvarchar] (2) COLLATE Polish_CI_AS NULL ,[dep_code] [nvarchar] (4) COLLATE Polish_CI_AS NOT NULL ,[perm] [int] NOT NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[MEMB_INFO] ([memb_guid] [int] IDENTITY (1, 1) NOT NULL ,[memb___id] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb__pwd] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb_name] [varchar] (10) COLLATE Polish_CI_AS NOT NULL ,[sno__numb] [char] (13) COLLATE Polish_CI_AS NOT NULL ,[post_code] [char] (6) COLLATE Polish_CI_AS NULL ,[addr_info] [varchar] (50) COLLATE Polish_CI_AS NULL ,[addr_deta] [varchar] (50) COLLATE Polish_CI_AS NULL ,[tel__numb] [varchar] (20) COLLATE Polish_CI_AS NULL ,[phon_numb] [varchar] (15) COLLATE Polish_CI_AS NULL ,[mail_addr] [varchar] (50) COLLATE Polish_CI_AS NULL ,[fpas_ques] [varchar] (50) COLLATE Polish_CI_AS NULL ,[fpas_answ] [varchar] (50) COLLATE Polish_CI_AS NULL ,[job__code] [char] (2) COLLATE Polish_CI_AS NULL ,[appl_days] [datetime] NULL ,[modi_days] [datetime] NULL ,[out__days] [datetime] NULL ,[true_days] [datetime] NULL ,[mail_chek] [char] (1) COLLATE Polish_CI_AS NULL ,[bloc_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,[ctl1_code] [char] (1) COLLATE Polish_CI_AS NOT NULL ,[adminaccess] [int] NOT NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[MEMB_OUT] ([out__guid] [int] NOT NULL ,[memb_guid] [int] NOT NULL ,[sno__numb] [nvarchar] (7) COLLATE Polish_CI_AS NULL ,[memb_name] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,[appl_days] [smalldatetime] NULL ,[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[MembInfoModify] ([Number] [int] NOT NULL ,[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb__pwd] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[sno__numb] [nvarchar] (13) COLLATE Polish_CI_AS NOT NULL ,[tel__numb] [nvarchar] (20) COLLATE Polish_CI_AS NULL ,[phon_numb] [nvarchar] (15) COLLATE Polish_CI_AS NULL ,[mail_addr] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,[bloc_code] [nvarchar] (1) COLLATE Polish_CI_AS NULL) ON [PRIMARY]GOCREATE TABLE [dbo].[VI_CURR_INFO] ([ends_days] [nvarchar] (8) COLLATE Polish_CI_AS NULL ,[chek_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,[used_time] [int] NULL ,[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb_guid] [int] NOT NULL ,[sno__numb] [nvarchar] (18) COLLATE Polish_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]GOCREATE TABLE [dbo].[VI_FQNW_INFO] ([appl_code] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[ctrl_text] [nvarchar] (50) COLLATE Polish_CI_AS NULL ,[fpas_ques] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,[fpas_answ] [nvarchar] (50) COLLATE Polish_CI_AS NOT NULL ,[appl_days] [nvarchar] (8) COLLATE Polish_CI_AS NOT NULL ,[ctl1_code] [nvarchar] (1) COLLATE Polish_CI_AS NOT NULL ,[memb_name] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[memb_guid] [int] NOT NULL ,[fanw_guid] [int] NOT NULL ,[memb___id] [nvarchar] (10) COLLATE Polish_CI_AS NOT NULL ,[sno__numb]