dump_mysql.sql

实现网站投票功能

--
-- Table structure for table 'poll_data'
--

CREATE TABLE poll_data (
  id int(11) NOT NULL auto_increment,
  poll_id int(11) NOT NULL default '0',
  option_id int(11) NOT NULL default '0',
  option_text varchar(100) NOT NULL default '',
  color varchar(20) NOT NULL default '',
  votes int(14) NOT NULL default '0',
  PRIMARY KEY  (poll_id,option_id),
  KEY id (id)
) TYPE=MyISAM;

--
-- Dumping data for table 'poll_data'
--


INSERT INTO poll_data VALUES (1,1,1,'Linux','blue',49);
INSERT INTO poll_data VALUES (2,1,2,'Solaris','yellow',12);
INSERT INTO poll_data VALUES (3,1,3,'FreeBSD','green',29);
INSERT INTO poll_data VALUES (4,1,4,'WindowsNT','brown',17);
INSERT INTO poll_data VALUES (5,1,5,'Unix','grey',10);
INSERT INTO poll_data VALUES (6,1,6,'BSD','red',15);
INSERT INTO poll_data VALUES (7,1,7,'other','purple',9);
INSERT INTO poll_data VALUES (8,2,5,'Sybase','orange',2);
INSERT INTO poll_data VALUES (9,2,4,'MS SQL','green',9);
INSERT INTO poll_data VALUES (10,2,3,'Oracle','blue',17);
INSERT INTO poll_data VALUES (11,2,2,'PostgreSQL','gold',6);
INSERT INTO poll_data VALUES (12,2,1,'MySQL','pink',23);
INSERT INTO poll_data VALUES (13,2,6,'other','brown',3);
INSERT INTO poll_data VALUES (14,2,7,'DB/2','grey',4);
INSERT INTO poll_data VALUES (15,3,1,'PHP','red',65);
INSERT INTO poll_data VALUES (16,3,2,'Perl','orange',34);
INSERT INTO poll_data VALUES (17,3,3,'ASP','green',17);
INSERT INTO poll_data VALUES (18,3,4,'JSP','purple',20);
INSERT INTO poll_data VALUES (19,3,5,'Python','gold',7);
INSERT INTO poll_data VALUES (20,3,6,'other','aqua',16);

--
-- Table structure for table 'poll_index'
--

CREATE TABLE poll_index (
  poll_id int(11) unsigned NOT NULL auto_increment,
  question varchar(100) NOT NULL default '',
  timestamp int(11) NOT NULL default '0',
  status smallint(2) NOT NULL default '0',
  logging smallint(2) NOT NULL default '0',
  exp_time int(11) NOT NULL default '0',
  expire smallint(2) NOT NULL default '0',
  comments smallint(2) NOT NULL default '0',
  PRIMARY KEY  (poll_id)
) TYPE=MyISAM;

--
-- Dumping data for table 'poll_index'
--


INSERT INTO poll_index VALUES (1,'Which OS is your Website running on?',1019467656,1,1,1020331656,1,1);
INSERT INTO poll_index VALUES (2,'Which database engine do you prefer?',1019467706,1,0,1020331656,0,1);
INSERT INTO poll_index VALUES (3,'What is your favourite scripting language?',1019467706,1,0,1020331656,0,1);

--
-- Table structure for table 'poll_ip'