use master
go
create database bookDB
go
use bookDB
go
create table guestInfo
(
ID int identity(1,1) primary key not null,
userName varchar(20) not null,
Sex varchar(4) not null,
QQ varchar(20),
Url varchar(40),
Email varchar(40),
Content varchar(300) not null,
Reply varchar(300),
imageAddress varchar(20) not null,
postTime datetime default(getdate())
)
go
update guestInfo set imageAddress = 'boy.GIF';
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥1','男','136598752','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥2','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥3','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥4','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥5','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥6','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥7','男','773657393','我喜欢美眉!!','boy.GIF')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥8','男','773657393','我喜欢美眉!!','boy.GIF')
go
create table adminInfo
(
userid int identity(1,1) primary key not null,
userName varchar(20) not null,
userPwd varchar(20) not null,
userNum varchar(10)
)
go
--51aspx.com
insert into adminInfo(userName,userPwd,userNum) values('admin','admin','0')
insert into adminInfo(userName,userPwd,userNum) values('zhou','123','0')
insert into adminInfo(userName,userPwd,userNUm) values('shu','123','0')
go
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女1','女','136598752','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女2','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女3','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女4','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女5','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女6','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女7','女','773657393','我喜欢帅哥!!','girl.gif')
insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女8','女','773657393','我喜欢帅哥!!','girl.gif')
go
--delete from guestInfo where userName = '美女1';
select * from guestInfo
select * from adminInfo
go
--select userNum from adminInfo