?? 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,'默認(rèn)投票區(qū)','2005-08-10 20:30:30','系統(tǒng)默認(rèn)投票區(qū)域，所有沒有指定投票區(qū)的投票都默認(rèn)屬于該區(qū)域','1',1),
(2,'演示區(qū)B','2005-08-11 14:44:01','問卷調(diào)查區(qū)','1',4),
(3,'演示區(qū)C','2005-08-11 14:46:10','單個投票演示區(qū)','1',2),
(4,'演示區(qū)D','2005-09-20 19:57:49','單個投票區(qū)','1',3),
(5,'演示區(qū)E','2005-09-20 19:58:29','單個投票區(qū)','0',0),
(6,'演示區(qū)F','2005-09-20 20:02:13','投票區(qū)','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,'金山毒霸認(rèn)知度調(diào)查','2005-08-10 20:50:00','3,4,7','本組包含一個特定的圖片投票，和二個普通投票的綜合演示。','0',3),
(2,'對本投票系統(tǒng)的調(diào)查','2005-08-31 20:50:00','5','您覺得這個投票系統(tǒng)好用嗎？（單個投票演示）','1',1),
(3,'投票系統(tǒng)調(diào)查','2005-09-06 22:17:48','6','對本投票系統(tǒng)的建議和意見','1',1),
(4,'對用戶交友方式進(jìn)行調(diào)查','2005-09-17 23:03:13','8,9','對用戶交友方式進(jìn)行調(diào)查的問卷演示。（調(diào)查問卷對外不能查看調(diào)查結(jié)果）','0',0),
(5,'系統(tǒng)投票組','2005-09-15 16:14:45','10','系統(tǒng)投票組','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,'中國的下列城市中，您最情有獨(dú)鐘的城市有哪些？','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,'您覺得這個投票系統(tǒng)怎么樣？','2005-08-13 22:37:12',1,'1',1,'1',1),
(6,'您覺得本投票系統(tǒng)還需要哪些改進(jìn)？','2005-08-15 20:37:12',1,'0',1,'1',1),
(7,'您覺得金山毒霸最大的特色是什么？','2005-08-29 01:36:59',1,'0',1,'1',1),
(8,'您會在哪里瀏覽網(wǎng)上交友信息？','2005-08-29 01:49:07',1,'0',0,'1',1),
(9,'您最喜歡通過哪種渠道結(jié)識男女朋友？','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,'買電腦預(yù)裝',4,1),
(2,'軟件店購買',4,3),
(3,'網(wǎng)上下載',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,'全方位對電腦進(jìn)行保護(hù)',7,1),
(10,'其他',6,3),
(11,'界面需要重新設(shè)計(jì)',6,5),
(12,'進(jìn)一步降低投票的難度',6,1),
(13,'管理員管理需要加強(qiáng)',6,4),
(14,'增加幫助功能',6,6),
(15,'沒聽說過',10,0),
(16,'不行',10,0),
(17,'可以',10,0),
(18,'湊合，馬馬虎虎',5,2),
(19,'還不錯',5,3),
(20,'太濫了',5,0),
(21,'交友網(wǎng)站',9,10),
(22,'婚介機(jī)構(gòu)',9,8),
(23,'短信交友',9,12),
(24,'論壇聊天室',9,21),
(25,'即時通訊軟件',9,25),
(26,'家里',8,12),
(27,'公司',8,2),
(28,'網(wǎng)吧',8,30),
(29,'人太多，不準(zhǔn)備出游了',2,23),
(30,'暫時還沒有',2,10);
INSERT INTO `vote_voteitem` (`VoteItem_ID`,`VoteItem_ItemText`,`VoteItem_VoteID`,`VoteItem_PolledTimes`) VALUES
(31,'正在聯(lián)系',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','湖北武漢','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);
/*!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 */;
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -