当前文件： WebReply/bookDB.sql[2K，2009-6-12 11:58:26]，打开代码结构图

		            
 1use master
 2go
 3
 4create database bookDB
 5go
 6
 7use bookDB
 8go
 9
10create table guestInfo
11(
12    ID int identity(1,1) primary key not null,
13    userName varchar(20) not null,
14    Sex varchar(4) not null,
15    QQ varchar(20),
16    Url varchar(40),
17    Email varchar(40),
18    Content varchar(300) not null,
19    Reply varchar(300),
20    imageAddress varchar(20) not null,
21    postTime datetime default(getdate())
22)
23go
24
25update guestInfo set imageAddress = 'boy.GIF';
26
27
28insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥1','男','136598752','我喜欢美眉！！','boy.GIF')
29insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥2','男','773657393','我喜欢美眉！！','boy.GIF')
30insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥3','男','773657393','我喜欢美眉！！','boy.GIF')
31insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥4','男','773657393','我喜欢美眉！！','boy.GIF')
32insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥5','男','773657393','我喜欢美眉！！','boy.GIF')
33insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥6','男','773657393','我喜欢美眉！！','boy.GIF')
34insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥7','男','773657393','我喜欢美眉！！','boy.GIF')
35insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('帅哥8','男','773657393','我喜欢美眉！！','boy.GIF')
36go
37
38create table adminInfo
39(
40    userid int identity(1,1) primary key not null,
41    userName varchar(20) not null,
42    userPwd varchar(20) not null,
43    userNum varchar(10)  
44)
45go
46--51aspx.com
47insert into adminInfo(userName,userPwd,userNum) values('admin','admin','0')
48insert into adminInfo(userName,userPwd,userNum) values('zhou','123','0')
49insert into adminInfo(userName,userPwd,userNUm) values('shu','123','0')
50go
51
52
53insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女1','女','136598752','我喜欢帅哥！！','girl.gif')
54insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女2','女','773657393','我喜欢帅哥！！','girl.gif')
55insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女3','女','773657393','我喜欢帅哥！！','girl.gif')
56insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女4','女','773657393','我喜欢帅哥！！','girl.gif')
57insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女5','女','773657393','我喜欢帅哥！！','girl.gif')
58insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女6','女','773657393','我喜欢帅哥！！','girl.gif')
59insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女7','女','773657393','我喜欢帅哥！！','girl.gif')
60insert into guestInfo(userName,Sex,QQ,Content,ImageAddress) values('美女8','女','773657393','我喜欢帅哥！！','girl.gif')
61go
62
63--delete from  guestInfo where userName = '美女1';
64select * from guestInfo
65select * from adminInfo
66go
67--select userNum from adminInfo
68