SQL数据库修改代码

use  master
go
if exists(select * from sysdatabases where name = 'bbs')
drop database bbs
go
create database bbs
on primary
(
    name = 'bbs_Data',
        filename = 'F:\bbs_Data.mdf',
        size = 5mb,
        maxsize = 200mb,
    filegrowth = 20%
)
go
use bbs
create table BBSUsers
(
    UID int identity(1,1) primary key not null,
    UName varchar(20) not null,
    UPassword varchar(20) not null,
    UEmail varchar(50) ,
    UBirthday datetime,
    USex bit not null,
    Uclass int not null,
    UStatement text,
    URegDate datetime,
    UState int not null,
    UPoint int,
)
   alter table BBSUsers add constraint PK_UID primary key(UID)      --主键
 
   alter table BBSUsers add constraint DF_Upassword  default (888888) for Upassword   --初始密码默认为6个8
 
   alter table BBSUsers add constraint DF_Usex default (1) for Usex      --性别默认为男（1）
   
   alter table BBSUsers add constraint DF_Uclass default (1) for Uclass   --级别默认为1星级
   
   alter table BBSUsers add constraint DF_UregDate   default (getDate( )) for UregDate --注册日期默认为当前日期
            
   alter table BBSUsers add constraint DF_Ustate  default (0) for Ustate    --状态默认为离线
 
   alter table BBSUsers add constraint DF_Upoint default (20) for Upoint    --默认积分20点

  alter table BBSUsers add constraint CK_Uemail    --必须包含'@'字符
  check (Uemail like '%@%')   --%表示任意多个字符

  alter table BBSUsers add constraint CK_Upassword --密码至少6位
  check (len(Upassword) >= 6)
go

create table BBSTopic
(
    TID int identity(1,1)  not null,
    TNumber int not null,
    TSID int not null,
    TUID int not null,
    TReplyCount int,
    TEmotion int,
    TTopic varchar(20) not null,
    TContents varchar(30) not null,
    TTime datetime,
    TClickCount int,
    TFlag int not null,
    TLastClickT datetime,
)
alter table BBSTopic add constraint PK_TID primary key(TID)
go
create table BBSReply
(
    RID int identity(1,1) primary key,
    RNumber int not null,
    RTID int not null,
    RUID int not null,
    REmotion int,
    RTopic varchar(20) not null,
    RContents int not null,
    RTime datetime,
)
go
create table BBSSection
(
    SID int identity(1,1) primary key,
    SName varchar(32) not null,
    SMasterID int not null,
    SStatement varchar(50),
    SClickcount int,
    STopicCount int,
)
go