vote.sql

SQL数据库在App_Data下面 是sql格式的 用的时候只需要修改App_Code下面的DB字符串就可以了 有的代码我做了注释

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