62,041
社区成员
发帖
与我相关
我的任务
分享
create table dbo.mbr_members (
uid varchar(20) collate Chinese_PRC_CI_AS not null,
nickName varchar(20) collate Chinese_PRC_CI_AS null,
password varchar(20) collate Chinese_PRC_CI_AS not null,
userName varchar(50) collate Chinese_PRC_CI_AS null,
birthday datetime null,
sex char(1) collate Chinese_PRC_CI_AS null,
address varchar(100) collate Chinese_PRC_CI_AS null,
email varchar(50) collate Chinese_PRC_CI_AS null,
tel varchar(30) collate Chinese_PRC_CI_AS null,
mobilephone varchar(11) collate Chinese_PRC_CI_AS null,
msn varchar(50) collate Chinese_PRC_CI_AS null,
qq varchar(12) collate Chinese_PRC_CI_AS null,
confirmData int null constraint DF_mbr_members_confirmData default (0),
confirmExpireDate datetime null,
loginCount int null constraint DF_mbr_members_loginCount default (0),
lastLoginDate datetime null,
signupDate datetime null constraint DF__mbr_membe__signu__0F624AF8 default getdate(),
lastLoginIp varchar(15) collate Chinese_PRC_CI_AS null,
loginFail int null constraint DF_mbr_members_loginFail default (0),
isLock bit not null constraint DF__mbr_membe__isLoc__10566F31 default (0),
isDel bit not null constraint DF__mbr_membe__isDel__114A936A default (0),
constraint PK_MBR_MEMBERS primary key nonclustered (uid)
on "PRIMARY"
)
on "PRIMARY"
go