syspoll.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','2005-09-20 22:25:58','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,'default vote area','2005-08-10 20:30:30','this is the default vote area','1',1);
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,'test Vote Group','2007-01-24 11:37:17','1','test vote group','0',1);
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,'testVote','2005-08-10 20:35:12',1,'0',1,'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 (4,'B:不是',1,0),(5,'C:不确定',1,0),(6,'A:是',1,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;
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 */;