【SQL开源代码栏目提醒】:网学会员鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“pvote.sql”一文,供大家参考学习
# MySQL-Front 3.2 (Build 6.2)
/*!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 CHARACTER SET 'gbk' */;
# Host: 127.0.0.1 Database: pvote
# ------------------------------------------------------
# Server version 5.0.21-community-nt
#
# Table structure for table admin
#
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
`user` varchar(20) NOT NULL default 'admin',
`pass` varchar(20) NOT NULL default 'admin',
PRIMARY KEY (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# Dumping data for table admin
#
INSERT INTO `admin` (`user`,`pass`) VALUES ('admin','admin');
#
# Table structure for table ip
#
DROP TABLE IF EXISTS `ip`;
CREATE TABLE `ip` (
`pollorder` int(255) unsigned NOT NULL default '0',
`ip0` varchar(255) default NULL,
`ip1` varchar(255) default NULL,
`ip2` varchar(255) default NULL,
`ip3` varchar(255) default NULL,
`ip4` varchar(255) default NULL,
`ip5` varchar(255) default NULL,
`ip6` varchar(255) default NULL,
`ip7` varchar(255) default NULL,
`ip8` varchar(255) default NULL,
`ip9` varchar(255) default NULL,
PRIMARY KEY (`pollorder`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# Dumping data for table ip
#
INSERT INTO `ip` (`pollorder`,`ip0`,`ip1`,`ip2`,`ip3`,`ip4`,`ip5`,`ip6`,`ip7`,`ip8`,`ip9`) VALUES (1,'',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
#
# Table structure for table polls
#
DROP TABLE IF EXISTS `polls`;
CREATE TABLE `polls` (
`id` int(255) unsigned NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`writein` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# Dumping data for table polls
#
INSERT INTO `polls` (`id`,`title`,`writein`) VALUES (1,'您最喜欢的颜色',0);
#
# Table structure for table questions
#
DROP TABLE IF EXISTS `questions`;
CREATE TABLE `questions` (
`id` int(255) unsigned NOT NULL auto_increment,
`pollid` int(255) unsigned NOT NULL default '0',
`question` varchar(255) NOT NULL default '',
`votes` int(255) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
#
# Dumping data for table questions
#
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (1,1,'红色',20);
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (2,1,'黄色',30);
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (3,1,'蓝色',80);
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (4,1,'绿色',10);
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (5,1,'白色',12);
INSERT INTO `questions` (`id`,`pollid`,`question`,`votes`) VALUES (6,1,'橙色',40);
/*!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 */;