/*创建bbsDB数据库*/usemasterifexists(select*fromsysdatabaseswherename='bbsDB')dropdatabasebbsDBcreatedatabasebbsDBon(name='bbsDB_data',filename='D:\project\bbsDB_data.mdf',size=10,filegrowth=20%)logon(name='bbsDB_log',filename='D:\project\bbsDB_log.ldf',size=3,maxsize=20,filegrowth=10%)/*创建bbsUsers表*/usebbsdbifexists(select*fromsysobjectswherename='bbsUsers')droptablebbsUserscreatetablebbsUsers(UIDintidentity(1,1)notnull,--学号，标识列Unamevarchar(15)notnull,--用户昵称Upasswordvarchar(10)notnull,--用户密码Uemailvarchar(20),--邮箱地址Usexbitnotnull,--用户性别Uclassint,--等级Uremarkvarchar(20),--备注UregDatedatetimenotnull,--注册日期Ustateintnull,--状态Upointintnull--用户积分)/*创建bbsUsers表中的约束*/altertablebbsUsersaddconstraintPK_uidprimarykey(uid),--主键constraintDF_Upassworddefault(888888)forUpassword,--初始密码为888888constraintDF_Usexdefault(1)forUsex,--性别默认为男constraintDF_UregDatedefault(getdate())forUregDate,--注册日期默认为系统日期constraintDF_Ustatedefault(0)forUstate,--状态默认为离线constraintDF_Upointdefault(20)forUpoint,--积分默认为20点constraintCK_Uemailcheck(Uemaillike'%@%'),--电子邮件必须含有@符号constraintCK_Upasswordcheck(len(Upassword)>=6)--密码至少为六位