当前文件： QuikStartVote/App_Data/vote.sql[1K，2009-6-12 11:52:48]，打开代码结构图

		            
 1create database vote
 2go 
 3use vote
 4go
 5--创建管理员信息表
 6drop table admin
 7create table admin
 8(
 9    id int identity (1,1) primary key,
10    adminID varchar(20) not null,
11    adminPwd varchar(20) not null,
12)
13go
14insert into admin(adminID,adminPwd) values('51aspx','51aspx')
15go
16select * from admin
17go
18drop table voteMaster
19--投票主表
20create table voteMaster
21(
22    id int identity(1,1) primary key,
23    voteTitle varchar(50) not null,
24    voteSum int default(0)
25)
26go
27insert into voteMaster(voteTitle) values('对网站建设的意见')
28insert into voteMaster(voteTitle) values('你是怎么知道这个网站的')
29go
30select * from voteMaster
31--创建投票详细信息
32go
33create table voteDetails
34(
35    id int foreign key references voteMaster(id),
36    voteDetailsID int identity (1,1),
37    voteItem varchar(50) not null,
38    voteNum int default(0)
39)
40go
41insert into voteDetails(id,voteItem) values(1,'非常好')
42insert into voteDetails(id,voteItem) values(1,'还可以')
43insert into voteDetails(id,voteItem) values(1,'一般')
44insert into voteDetails(id,voteItem) values(1,'没见过这么烂的')
45insert into voteDetails(id,voteItem) values(2,'误闯进来')
46insert into voteDetails(id,voteItem) values(2,'百度')
47insert into voteDetails(id,voteItem) values(2,'别人介绍')
48insert into voteDetails(id,voteItem) values(2,'友情链接')
49go
50select * from voteDetails
51
52--创建系统配置信息表
53drop table voteConfig
54go
55create table voteConfig
56(
57    id int foreign key  references voteMaster(id),
58    voteIP int default(0),
59    voteTime int default(0)
60)
61go
62insert into voteConfig(id) values(1)
63go
64select * from voteConfig
65--创建投票者信息表
66drop table voter
67create table voter
68(
69    id int foreign key references voteMaster(id),
70    ip varchar(20) not null,
71    voterTime datetime default(getdate()),
72    voterNum int default(1),
73    primary key(id,ip),
74)
75go
76insert into voter(id,IP) values(1,'192.168.1.1')
77insert into voter(id,IP) values(1,'192.168.1.2')
78insert into voter(id,IP) values(2,'192.168.1.111')
79insert into voter(id,IP) values(2,'192.168.1.222')
80go
81select * from voter