vote_backup.sql

php开发实例完全剖析

/* 
SQLyog v3.71
Host - localhost : Database - vote
**************************************************************
Server version 4.1.7-nt
*/

create database if not exists `vote`;

use `vote`;

/*
Table structure for email
*/

drop table if exists `email`;
CREATE TABLE `email` (
  `id` int(6) NOT NULL default '0',
  `email` varchar(50) NOT NULL default '',
  PRIMARY KEY  (`id`,`email`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for vote.email
*/

INSERT INTO `email` VALUES 
(2,'gg@t.m'),
(2,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]'),
(3,'[e-mail]');

/*
Table structure for title
*/

drop table if exists `title`;
CREATE TABLE `title` (
  `id` int(6) NOT NULL auto_increment,
  `username` varchar(20) NOT NULL default '',
  `email` varchar(50) NOT NULL default '',
  `title` varchar(250) NOT NULL default '',
  `types` tinyint(2) NOT NULL default '1',
  `choice` text NOT NULL,
  `times` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for vote.title
*/

INSERT INTO `title` VALUES 
(2,'admin','[e-mail]','印度洋海啸死难人数多的原因？',2,'#自然条件恶劣，属于天灾#没有很好的海啸预警机制#抢救不及时#人们的逃生经验不丰富，跑不快#没有国际救援','2005-01-05 10:44:37'),
(3,'admin','[e-mail]','你觉得本投票管理系统怎么样？',1,'很好#好#一般#差#很差','2005-01-05 16:22:11');

/*
Table structure for vote
*/

drop table if exists `vote`;
CREATE TABLE `vote` (
  `id` int(6) NOT NULL auto_increment,
  `titleid` int(6) NOT NULL default '0',
  `info` text NOT NULL,
  `vcount` int(4) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for vote.vote
*/

INSERT INTO `vote` VALUES 
(6,2,'自然条件恶劣，属于天灾',2),
(7,2,'没有很好的海啸预警机制',1),
(8,2,'抢救不及时',0),
(9,2,'人们的逃生经验不丰富，跑不快',2),
(10,2,'没有国际救援',0),
(11,3,'很好',2),
(12,3,'好',5),
(13,3,'一般',3),
(14,3,'差',1),
(15,3,'很差',1);