mpRVMyC3

1if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_MEMB_DETA_MEMB_INFO]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1)
2ALTER TABLE [dbo].[MEMB_DETA] DROP CONSTRAINT FK_MEMB_DETA_MEMB_INFO
3GO
4
5if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_INFO]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
6drop table [dbo].[MEMB_INFO]
7GO
8
9CREATE TABLE [dbo].[MEMB_INFO] (
10	[memb_guid] [int] IDENTITY (1, 1) NOT NULL ,
11	[memb___id] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
12	[memb__pwd] [varbinary] (16) NULL ,
13	[memb_name] [varchar] (10) COLLATE Modern_Spanish_CI_AS NOT NULL ,
14	[sno__numb] [char] (13) COLLATE Modern_Spanish_CI_AS NOT NULL ,
15	[post_code] [char] (6) COLLATE Modern_Spanish_CI_AS NULL ,
16	[addr_info] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
17	[addr_deta] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
18	[tel__numb] [varchar] (20) COLLATE Modern_Spanish_CI_AS NULL ,
19	[phon_numb] [varchar] (15) COLLATE Modern_Spanish_CI_AS NULL ,
20	[mail_addr] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
21	[fpas_ques] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
22	[fpas_answ] [varchar] (50) COLLATE Modern_Spanish_CI_AS NULL ,
23	[job__code] [char] (2) COLLATE Modern_Spanish_CI_AS NULL ,
24	[appl_days] [datetime] NULL ,
25	[modi_days] [datetime] NULL ,
26	[out__days] [datetime] NULL ,
27	[true_days] [datetime] NULL ,
28	[mail_chek] [char] (1) COLLATE Modern_Spanish_CI_AS NULL ,
29	[bloc_code] [char] (1) COLLATE Modern_Spanish_CI_AS NOT NULL ,
30	[ctl1_code] [char] (1) COLLATE Modern_Spanish_CI_AS NOT NULL ,
31	[SCFIsVip] [smallint] NOT NULL ,
32	[SCFVipMoney] [int] NOT NULL ,
33	[SCFVipDays] [int] NOT NULL ,
34	[SCFWareVipCount] [int] NOT NULL ,
35	[SCFLuckyCoins] [int] NOT NULL 
36) ON [PRIMARY]
37GO