建库建表语句
--建立数据库create Database newssystem--建立类别表create table category( id int identity(1,1) primary key, [name] varchar(100) not null)--建立新闻表create table news( id int identity(1,1) primary key, title varchar(100) not null, [content] text not null, createTime datetime not null, caId int)--建立评论表create table comment( id int identity (1,1) primary key, [content] text not null, createTime datetime not null, userIp varchar(15) not null, newsid int)?
?
