sql创建基本语句

create database bbsDB
    on primary
(
    name='bbsDB',
    filename='D:\project',
    size=10mb,
    maxsize=20mb,
    filegrowth=3mb
)

use bbsDB

create table tbl_bbsUser
(
    id int identity(1,1) primary key not null,
    name varchar(10),
    account varchar(20) not null,
    password varchar(20) not null
)
create table tbl_bbsSection
(
    SID int identity(1,1) not null,
    Sname varchar(32) not null,
    SmasterID int not null,
    Sprofile varchar(20),
    SclickCount int,
    StopicCount int
)
create table tbl_bbsReply
(
    RID int identity(1,1) primary key,
    RtID int not null,
    RsID int not null,
    RuID int not null,
    Rface int,
    Rcontents varchar(30) not null,
    Rtime datetime,
    RclickCount int
)
create table tbl_bbsTopic
(
    TID int identity(1,1) primary key not null,
    TsID int not null,
    TuID int not null,
    TreplyCount int,
    Tface int,
    Ttopic varchar(20) not null,
    Tcontents varchar(30) not null,
    Ttime datetime,
    TclickCount int,
    Tstate int not null,
    TlastReply datetime
)