sql.sql

来自「漂亮的留言管理系统」· SQL 代码 · 共 35 行

create database myBoard
go
use myBoard
create table guest
(
ID int identity(1,1) primary key,
userName varchar(20) not null,
sex varchar(10) not null,
url varchar(20),
qq varchar(20),
email varchar(20),
content varchar(1000) not null,
reply varchar(1000),
postTime datetime default(getdate()),
imageUrl varchar(20) not null,
faceUrl varchar(20) not null
)
drop table guest
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic1.gif','face1.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic2.gif','face2.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic3.gif','face3.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic4.gif','face4.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic5.gif','face5.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','女','我是帅哥','pic6.gif','face6.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic7.gif','face7.gif')
insert into guest(userName,sex,content,imageUrl,faceUrl) values('wbuild','男','我是帅哥','pic8.gif','face8.gif')
select * from guest
drop table admin
create table admin
(
adminName varchar(20) not null,
adminPwd varchar(20) not null,
total varchar(20)
)