syspoll.sql

这是一个实用性很强而且功能强大齐全的投票系统

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.12a-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema `syspoll`
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ `syspoll`;
USE `syspoll`;

--
-- Table structure for table `syspoll`.`vote_admin`
--

DROP TABLE IF EXISTS `vote_admin`;
CREATE TABLE `vote_admin` (
  `Admin_ID` int(10) unsigned NOT NULL auto_increment,
  `Admin_Name` varchar(45) NOT NULL default '',
  `Admin_Pwd` varchar(45) NOT NULL default '',
  `Admin_LastLoginDate` datetime default NULL,
  `Admin_Status` char(1) NOT NULL default '1',
  PRIMARY KEY  (`Admin_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_admin`
--

/*!40000 ALTER TABLE `vote_admin` DISABLE KEYS */;
INSERT INTO `vote_admin` (`Admin_ID`,`Admin_Name`,`Admin_Pwd`,`Admin_LastLoginDate`,`Admin_Status`) VALUES 
 (1,'superstar','f19179a06954edd0','2005-09-20 22:25:58','1');
/*!40000 ALTER TABLE `vote_admin` ENABLE KEYS */;


--
-- Table structure for table `syspoll`.`vote_area`
--

DROP TABLE IF EXISTS `vote_area`;
CREATE TABLE `vote_area` (
  `Area_ID` int(10) unsigned NOT NULL auto_increment,
  `Area_Name` varchar(45) NOT NULL default '',
  `Area_CreateDate` datetime default NULL,
  `Area_Describe` varchar(45) default NULL,
  `Area_Status` char(1) NOT NULL default '1',
  `Area_DefaultGroup` int(10) unsigned default NULL,
  PRIMARY KEY  (`Area_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_area`
--

/*!40000 ALTER TABLE `vote_area` DISABLE KEYS */;
INSERT INTO `vote_area` (`Area_ID`,`Area_Name`,`Area_CreateDate`,`Area_Describe`,`Area_Status`,`Area_DefaultGroup`) VALUES 
 (1,'默认投票区','2005-08-10 20:30:30','系统默认投票区域，所有没有指定投票区的投票都默认属于该区域','1',1),
 (2,'演示区B','2005-08-11 14:44:01','问卷调查区','1',4),
 (3,'演示区C','2005-08-11 14:46:10','单个投票演示区','1',2),
 (4,'演示区D','2005-09-20 19:57:49','单个投票区','1',3),
 (5,'演示区E','2005-09-20 19:58:29','单个投票区','0',0),
 (6,'演示区F','2005-09-20 20:02:13','投票区','1',0);
/*!40000 ALTER TABLE `vote_area` ENABLE KEYS */;


--
-- Table structure for table `syspoll`.`vote_group`
--

DROP TABLE IF EXISTS `vote_group`;
CREATE TABLE `vote_group` (
  `Group_ID` int(10) unsigned NOT NULL auto_increment,
  `Group_Name` varchar(45) NOT NULL default '',
  `Group_CreateDate` datetime default NULL,
  `Group_VoteID` varchar(45) NOT NULL default '',
  `Group_Describe` text,
  `Group_Status` char(1) NOT NULL default '1',
  `Group_TypeID` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Group_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_group`
--

/*!40000 ALTER TABLE `vote_group` DISABLE KEYS */;
INSERT INTO `vote_group` (`Group_ID`,`Group_Name`,`Group_CreateDate`,`Group_VoteID`,`Group_Describe`,`Group_Status`,`Group_TypeID`) VALUES 
 (1,'金山毒霸认知度调查','2005-08-10 20:50:00','3,4,7','本组包含一个特定的图片投票，和二个普通投票的综合演示。','0',3),
 (2,'对本投票系统的调查','2005-08-31 20:50:00','5','您觉得这个投票系统好用吗？（单个投票演示）','1',1),
 (3,'投票系统调查','2005-09-06 22:17:48','6','对本投票系统的建议和意见','1',1),
 (4,'对用户交友方式进行调查','2005-09-17 23:03:13','8,9','对用户交友方式进行调查的问卷演示。（调查问卷对外不能查看调查结果）','0',0),
 (5,'系统投票组','2005-09-15 16:14:45','10','系统投票组','0',1);
/*!40000 ALTER TABLE `vote_group` ENABLE KEYS */;


--
-- Table structure for table `syspoll`.`vote_vote`
--

DROP TABLE IF EXISTS `vote_vote`;
CREATE TABLE `vote_vote` (
  `Vote_ID` int(10) unsigned NOT NULL auto_increment,
  `Vote_Title` varchar(45) NOT NULL default '',
  `Vote_CreateDate` datetime default NULL,
  `Vote_CreateUser` int(10) unsigned NOT NULL default '0',
  `Vote_isSingle` char(1) NOT NULL default '',
  `Vote_TypeID` int(10) unsigned NOT NULL default '0',
  `Vote_Published` char(1) NOT NULL default '',
  `Vote_Area` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`Vote_ID`),
  KEY `FK_vote_admin` (`Vote_CreateUser`),
  KEY `FK_vote_area` (`Vote_Area`),
  CONSTRAINT `FK_vote_admin` FOREIGN KEY (`Vote_CreateUser`) REFERENCES `vote_admin` (`Admin_ID`),
  CONSTRAINT `FK_vote_area` FOREIGN KEY (`Vote_Area`) REFERENCES `vote_area` (`Area_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_vote`
--

/*!40000 ALTER TABLE `vote_vote` DISABLE KEYS */;
INSERT INTO `vote_vote` (`Vote_ID`,`Vote_Title`,`Vote_CreateDate`,`Vote_CreateUser`,`Vote_isSingle`,`Vote_TypeID`,`Vote_Published`,`Vote_Area`) VALUES 
 (1,'中国的下列城市中，您最情有独钟的城市有哪些？','2005-08-10 20:35:12',1,'0',0,'1',1),
 (2,'“十一”黄金周，你有出游的打算吗？','2005-08-10 20:36:12',1,'1',1,'1',1),
 (3,'您最喜欢哪个系列的金山毒霸？','2005-08-10 20:38:12',1,'1',2,'1',1),
 (4,'您是通过什么方式获得的金山毒霸？','2005-08-09 20:37:12',1,'1',1,'1',1),
 (5,'您觉得这个投票系统怎么样？','2005-08-13 22:37:12',1,'1',1,'1',1),
 (6,'您觉得本投票系统还需要哪些改进？','2005-08-15 20:37:12',1,'0',1,'1',1),
 (7,'您觉得金山毒霸最大的特色是什么？','2005-08-29 01:36:59',1,'0',1,'1',1),
 (8,'您会在哪里浏览网上交友信息？','2005-08-29 01:49:07',1,'0',0,'1',1),
 (9,'您最喜欢通过哪种渠道结识男女朋友？','2005-08-29 02:07:51',1,'1',0,'1',1),
 (10,'您觉得“流行音乐赏”怎么样？','2005-09-14 20:56:09',1,'1',1,'1',1);
/*!40000 ALTER TABLE `vote_vote` ENABLE KEYS */;


--
-- Table structure for table `syspoll`.`vote_voteitem`
--

DROP TABLE IF EXISTS `vote_voteitem`;
CREATE TABLE `vote_voteitem` (
  `VoteItem_ID` int(10) unsigned NOT NULL auto_increment,
  `VoteItem_ItemText` varchar(45) NOT NULL default '',
  `VoteItem_VoteID` int(10) unsigned NOT NULL default '0',
  `VoteItem_PolledTimes` int(10) unsigned default '0',
  PRIMARY KEY  (`VoteItem_ID`),
  KEY `FK_vote_voteitem` (`VoteItem_VoteID`),
  CONSTRAINT `FK_vote_voteitem` FOREIGN KEY (`VoteItem_VoteID`) REFERENCES `vote_vote` (`Vote_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_voteitem`
--

/*!40000 ALTER TABLE `vote_voteitem` DISABLE KEYS */;
INSERT INTO `vote_voteitem` (`VoteItem_ID`,`VoteItem_ItemText`,`VoteItem_VoteID`,`VoteItem_PolledTimes`) VALUES 
 (1,'买电脑预装',4,1),
 (2,'软件店购买',4,3),
 (3,'网上下载',4,3),
 (4,'/xvote/vote/images/About2003.gif',3,5),
 (5,'/xvote/vote/images/About2002.gif',3,2),
 (6,'/xvote/vote/images/About2001.gif',3,1),
 (7,'及时病毒升级',7,6),
 (8,'界面漂亮，美观大方',7,6),
 (9,'全方位对电脑进行保护',7,1),
 (10,'其他',6,3),
 (11,'界面需要重新设计',6,5),
 (12,'进一步降低投票的难度',6,1),
 (13,'管理员管理需要加强',6,4),
 (14,'增加帮助功能',6,6),
 (15,'没听说过',10,0),
 (16,'不行',10,0),
 (17,'可以',10,0),
 (18,'凑合，马马虎虎',5,2),
 (19,'还不错',5,3),
 (20,'太滥了',5,0),
 (21,'交友网站',9,10),
 (22,'婚介机构',9,8),
 (23,'短信交友',9,12),
 (24,'论坛聊天室',9,21),
 (25,'即时通讯软件',9,25),
 (26,'家里',8,12),
 (27,'公司',8,2),
 (28,'网吧',8,30),
 (29,'人太多，不准备出游了',2,23),
 (30,'暂时还没有',2,10);
INSERT INTO `vote_voteitem` (`VoteItem_ID`,`VoteItem_ItemText`,`VoteItem_VoteID`,`VoteItem_PolledTimes`) VALUES 
 (31,'正在联系',2,12),
 (32,'重庆',1,23),
 (33,'上海',1,34),
 (34,'广州',1,43),
 (35,'北京',1,29),
 (36,'天津',1,21),
 (37,'武汉',1,16),
 (38,'苏州',1,48);
/*!40000 ALTER TABLE `vote_voteitem` ENABLE KEYS */;


--
-- Table structure for table `syspoll`.`vote_voter`
--

DROP TABLE IF EXISTS `vote_voter`;
CREATE TABLE `vote_voter` (
  `Voter_ID` int(10) unsigned NOT NULL auto_increment,
  `Voter_GroupID` int(10) unsigned NOT NULL default '0',
  `Voter_Name` varchar(45) default NULL,
  `Voter_IPAddress` varchar(45) NOT NULL default '',
  `Voter_PollDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `Voter_Contact` varchar(45) default NULL,
  `Voter_E_mail` varchar(45) default NULL,
  PRIMARY KEY  (`Voter_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `syspoll`.`vote_voter`
--

/*!40000 ALTER TABLE `vote_voter` DISABLE KEYS */;
INSERT INTO `vote_voter` (`Voter_ID`,`Voter_GroupID`,`Voter_Name`,`Voter_IPAddress`,`Voter_PollDate`,`Voter_Contact`,`Voter_E_mail`) VALUES 
 (14,4,'GanGuimin','127.0.0.1','2005-09-20 17:24:19','湖北武汉','[e-mail]'),
 (26,2,'匿名用户1127225000894','127.0.0.1','2005-09-20 22:03:20',NULL,NULL),
 (27,1,'匿名用户1127225043244','127.0.0.1','2005-09-20 22:04:03',NULL,NULL),
 (28,3,'匿名用户1127225179761','127.0.0.1','2005-09-20 22:06:19',NULL,NULL);
/*!40000 ALTER TABLE `vote_voter` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;