create database vote
go 
use vote
go
--創建管理員信息表
drop table admin
create table admin
(
	id int identity (1,1) primary key,
	adminID varchar(20) not null,
	adminPwd varchar(20) not null,
)
go
insert into admin(adminID,adminPwd) values('51aspx','51aspx')
go
select * from admin
go
drop table voteMaster
--投票主表
create table voteMaster
(
	id int identity(1,1) primary key,
	voteTitle varchar(50) not null,
	voteSum int default(0)
)
go
insert into voteMaster(voteTitle) values('對網站建設的意見')
insert into voteMaster(voteTitle) values('你是怎么知道這個網站的')
go
select * from voteMaster
--創建投票詳細信息
go
create table voteDetails
(
	id int foreign key references voteMaster(id),
	voteDetailsID int identity (1,1),
	voteItem varchar(50) not null,
	voteNum int default(0)
)
go
insert into voteDetails(id,voteItem) values(1,'非常好')
insert into voteDetails(id,voteItem) values(1,'還可以')
insert into voteDetails(id,voteItem) values(1,'一般')
insert into voteDetails(id,voteItem) values(1,'沒見過這么爛的')
insert into voteDetails(id,voteItem) values(2,'誤闖進來')
insert into voteDetails(id,voteItem) values(2,'百度')
insert into voteDetails(id,voteItem) values(2,'別人介紹')
insert into voteDetails(id,voteItem) values(2,'友情鏈接')
go
select * from voteDetails

--創建系統配置信息表
drop table voteConfig
go
create table voteConfig
(
	id int foreign key  references voteMaster(id),
	voteIP int default(0),
	voteTime int default(0)
)
go
insert into voteConfig(id) values(1)
go
select * from voteConfig
--創建投票者信息表
drop table voter
create table voter
(
	id int foreign key references voteMaster(id),
	ip varchar(20) not null,
	voterTime datetime default(getdate()),
	voterNum int default(1),
	primary key(id,ip),
)
go
insert into voter(id,IP) values(1,'192.168.1.1')
insert into voter(id,IP) values(1,'192.168.1.2')
insert into voter(id,IP) values(2,'192.168.1.111')
insert into voter(id,IP) values(2,'192.168.1.222')
go
select * from voter