⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 syspoll.sql

📁 网上投票与统计网上投票与统计网上投票与统计网上投票与统计
💻 SQL
字号:
🔍 
-- MySQL dump 10.9
--
-- Host: localhost    Database: syspoll
-- ------------------------------------------------------
-- Server version	4.1.14-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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `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 `vote_admin`
--


/*!40000 ALTER TABLE `vote_admin` DISABLE KEYS */;
LOCK TABLES `vote_admin` WRITE;
INSERT INTO `vote_admin` VALUES (1,'superstar','f19179a06954edd0','2007-01-22 11:09:26','1'),(2,'chengqi','f5c844c1558f3445','2007-01-23 08:57:56','1'),(3,'zhangli','625f02e373b15ba8','2007-01-22 12:24:08','1');
UNLOCK TABLES;
/*!40000 ALTER TABLE `vote_admin` ENABLE KEYS */;

--
-- Table structure for table `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 `vote_area`
--


/*!40000 ALTER TABLE `vote_area` DISABLE KEYS */;
LOCK TABLES `vote_area` WRITE;
INSERT INTO `vote_area` 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','单个投票区','1',10),(6,'演示区F','2005-09-20 20:02:13','投票区','1',0),(7,'测试区','2007-01-22 11:28:55','测试','1',6),(8,'测试2','2007-01-22 16:25:38','测试2','1',8),(9,'测试3','2007-01-22 19:46:20','测试3','1',9);
UNLOCK TABLES;
/*!40000 ALTER TABLE `vote_area` ENABLE KEYS */;

--
-- Table structure for table `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 `vote_group`
--


/*!40000 ALTER TABLE `vote_group` DISABLE KEYS */;
LOCK TABLES `vote_group` WRITE;
INSERT INTO `vote_group` VALUES (1,'默认投票区','2005-08-10 20:50:00','3,4,7','本组包含一个特定的图片投票，和二个普通投票的综合演示','1',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','对用户交友方式进行调查的问卷演示。（调查问卷对外不能查看调查结果）','1',0),(5,'系统投票组','2005-09-15 16:14:45','10','系统投票组','0',1),(6,'测试组','2007-01-22 15:24:31','11,13,8','测试组','1',3),(7,'测试1','2007-01-22 15:34:01','11,12,14,15','测试1','0',1),(8,'测试2组','2007-01-22 16:29:18','13,18,19','测试2组','1',3),(9,'测试3','2007-01-22 19:48:24','20,21','测试3','1',3),(10,'测试调查问卷','2007-01-22 20:11:36','17,19,22','测试调查问卷','1',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `vote_group` ENABLE KEYS */;

--
-- Table structure for table `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 `vote_vote`
--


/*!40000 ALTER TABLE `vote_vote` DISABLE KEYS */;
LOCK TABLES `vote_vote` WRITE;
INSERT INTO `vote_vote` 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),(11,'来看看','2007-01-22 11:30:04',1,'1',1,'1',1),(12,'投票主题','2007-01-22 12:30:22',2,'1',1,'1',1),(13,'新主题','2007-01-22 12:34:13',2,'0',2,'1',1),(14,'测试主题','2007-01-22 12:41:32',2,'1',1,'1',1),(15,'测试新区','2007-01-22 14:56:38',2,'1',1,'1',1),(16,'继续测试分页','2007-01-22 15:31:57',2,'0',1,'0',1),(17,'测试2投票1','2007-01-22 16:26:53',2,'1',0,'1',1),(18,'测试2投票2','2007-01-22 16:27:31',2,'1',1,'1',1),(19,'测试3投票3','2007-01-22 18:14:19',2,'0',0,'1',1),(20,'测试3.1','2007-01-22 19:47:01',2,'1',1,'1',1),(21,'测试3.2','2007-01-22 19:47:39',2,'1',0,'1',1),(22,'测试3.4','2007-01-23 08:59:38',2,'0',0,'1',1);
UNLOCK TABLES;
/*!40000 ALTER TABLE `vote_vote` ENABLE KEYS */;

--
-- Table structure for table `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 `vote_voteitem`
--


/*!40000 ALTER TABLE `vote_voteitem` DISABLE KEYS */;
LOCK TABLES `vote_voteitem` WRITE;
INSERT INTO `vote_voteitem` 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,3),(28,'??°?',8,30),(42,'A,你喜欢红色',12,0),(43,'B,你喜欢兰色',12,0),(44,'C,你喜欢紫色',12,0),(45,'D,你喜欢黄色',12,0),(49,'B',13,0),(50,'C',13,0),(51,'A',13,1),(62,'?ì?ò',1,0),(63,'±±??',1,0),(64,'???ì',1,0),(65,'????',1,0),(66,'其次',15,0),(67,'最后',15,0),(68,'首先',15,0),(69,'????????',2,0),(70,'???±??????',2,0),(71,'?????à????×?±???????',2,0),(72,'1',16,0),(73,'2',16,0),(74,'3',16,0),(75,'这个是第一点',11,0),(76,'这个是第二点',11,0),(77,'这个是第三点',11,1),(78,'4 你觉得这个怎么样？',14,0),(79,'1 你认为这个好麽？',14,0),(80,'3 你认为这个好麽',14,1),(81,'',14,0),(82,'2 你认为这个好麽？',14,0),(95,'C',17,0),(96,'A',17,0),(97,'B',17,1),(98,'C',18,0),(99,'B',18,0),(100,'A',18,0),(101,'A',19,0),(102,'B',19,0),(103,'C',19,1),(104,'a',20,0),(105,'b',20,3),(106,'c',20,0),(107,'a',21,1),(108,'b',21,1),(109,'c',21,2),(110,'a',22,0),(111,'b',22,0),(112,'v',22,0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `vote_voteitem` ENABLE KEYS */;

--
-- Table structure for table `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 `vote_voter`
--


/*!40000 ALTER TABLE `vote_voter` DISABLE KEYS */;
LOCK TABLES `vote_voter` WRITE;
INSERT INTO `vote_voter` VALUES (14,4,'GanGuimin','127.0.0.1','2005-09-20 17:24:19','??±±????','Goodsuperstar@msn.com'),(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),(29,7,'匿名用户1169453702421','127.0.0.1','2007-01-22 16:15:02',NULL,NULL),(30,6,'匿名用户1169454098828','127.0.0.1','2007-01-22 16:21:38',NULL,NULL),(31,8,'匿名用户1169454682921','127.0.0.1','2007-01-22 16:31:22',NULL,NULL),(32,9,'匿名用户1169466542906','127.0.0.1','2007-01-22 19:49:02',NULL,NULL),(33,9,'匿名用户1169466789562','11.201.5.2','2007-01-22 19:53:09',NULL,NULL),(34,9,'匿名用户1169466875078','88.88.0.2','2007-01-22 19:54:35',NULL,NULL),(35,10,'123','127.0.0.1','2007-01-22 20:12:59','123','123');
UNLOCK TABLES;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -