sql.php
-- phpMyAdmin SQL Dump
-- version 2.10.3
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jul 03, 2011 at 12:09 AM
-- Server version: 5.0.51
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `db_vote`
--
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote`
--
CREATE TABLE `tb_vote` (
`tb_vote_id` int(5) NOT NULL auto_increment,
`tb_vote_name` varchar(50) NOT NULL,
`tb_vote_num` int(5) NOT NULL default '0',
`tb_vote_type` int(1) NOT NULL default '0',
PRIMARY KEY (`tb_vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26 ;
--
-- Dumping data for table `tb_vote`
--
INSERT INTO `tb_vote` VALUES (25, '那些東西是您喜歡的?', 6, 1);
INSERT INTO `tb_vote` VALUES (24, '總統大選您會投誰?', 3, 0);
-- --------------------------------------------------------
--
-- Table structure for table `tb_voter`
--
CREATE TABLE `tb_voter` (
`tb_voter_id` int(10) NOT NULL auto_increment,
`tb_voter_name` varchar(50) NOT NULL,
`tb_voter_pass` varchar(50) NOT NULL,
`tb_voter_activation` text NOT NULL,
`tb_voter_mail` varchar(80) NOT NULL,
`tb_voter_tel` varchar(50) NOT NULL,
`tb_voter_address` varchar(80) NOT NULL,
`tb_voter_ip` varchar(50) NOT NULL,
`tb_voter_type` varchar(50) NOT NULL,
PRIMARY KEY (`tb_voter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=78 ;
--
-- Dumping data for table `tb_voter`
--
INSERT INTO `tb_voter` VALUES (68, 'fdddf', 'e940a3ba6df738388b772344a8a112e4', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=4ed68f3009bd25ed96d236cb956250db&&pass=e940a3ba6df738388b772344a8a112e4', 'sp@mrbccd.com', '13604338', 'dsfdsfdsf', '127.0.0.1', '1');
INSERT INTO `tb_voter` VALUES (67, 'sdfsdf', 'ec37aa25501f5aea74d5eb3d19b08333', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=d58e3582afa99040e27b92b13c8f2280&&pass=ec37aa25501f5aea74d5eb3d19b08333', 'spcn@mrbccd.com', '13604338', 'sdfdsfs', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (66, 'sddsfsd', '013f890e35d1b7f5e45f21e60f7863d6', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=6df9626d17c2f0135899ec71b43b3d42&&pass=013f890e35d1b7f5e45f21e60f7863d6', 'spcn@mrbccd.com', 'sddsds', 'sddsds', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (65, 'dsfdsf', '6fbfd5e68d3306e51350bea0232f8fa5', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=d6e9c56d7f078d298ed4695d899effbe&&pass=6fbfd5e68d3306e51350bea0232f8fa5', 'pankaihua1103@mrbccd.com', 'sdfsd', 'sdfdss', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (64, 'fghfg', 'c1ebb4933e06ce5617483f665e26627c', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=b0069c74a975f155fb785aa954de7562&&pass=c1ebb4933e06ce5617483f665e26627c', 'pankaihua1103@mrbccd.com', 'dfsdf', 'dfdf', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (62, 'sdfds', 'ec37aa25501f5aea74d5eb3d19b08333', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=6fbfd5e68d3306e51350bea0232f8fa5&&pass=ec37aa25501f5aea74d5eb3d19b08333', 'pankaihua1103@mrbccd.com', 'ddd', 'dddd', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (63, 'sdfds', '3ae5e9658fbd7d4048bd40820b7d227d', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=6fbfd5e68d3306e51350bea0232f8fa5&&pass=3ae5e9658fbd7d4048bd40820b7d227d', 'pankaihua1103@mrbccd.com', 'ddd', 'dddd', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (61, 'dfs', 'd58e3582afa99040e27b92b13c8f2280', 'http://127.0.0.1/MR/sl/11/12/register_ok.php?name=4ec503be252d765ea37621a629afdaa6&&pass=d58e3582afa99040e27b92b13c8f2280', 'pankaihua1103@mrbccd.com', 'sdfds', 'sdfds', '127.0.0.1', '0');
INSERT INTO `tb_voter` VALUES (60, '溜溜', '202cb962ac59075b964b07152d234b70', 'http://192.168.1.59/MR/sl/06/12/register_ok.php?name=7b8816485f8a15230957fe4039b648c0&&pass=202cb962ac59075b964b07152d234b70', 'spcn@mrbccd.com', '13604338', '長春市', '192.168.1.59', '1');
INSERT INTO `tb_voter` VALUES (59, '潘華', '698d51a19d8a121ce581499d7b701668', 'http://192.168.1.59/MR/sl/06/12/register_ok.php?name=0e77083a5e2fa59da6f289e7f2eb6725&&pass=698d51a19d8a121ce581499d7b701668', 'spcn@mrbccd.com', '1360433', '長春市', '192.168.1.59', '1');
INSERT INTO `tb_voter` VALUES (69, '123456', 'e10adc3949ba59abbe56e057f20f883e', 'http://127.0.0.1/MR/sl/11/13/register_ok.php?name=e10adc3949ba59abbe56e057f20f883e&&pass=e10adc3949ba59abbe56e057f20f883e', 'sp@mrbccd.com', '13604338784', 'sdfsdfsdf', '127.0.0.1', '1');
INSERT INTO `tb_voter` VALUES (70, 'sdfsdfsdf', '733540828109ecc5c86ff7fb515e6c4c', 'http://192.168.1.59/MR/11/13/register_ok.php?name=73a90acaae2b1ccc0e969709665bc62f&&pass=733540828109ecc5c86ff7fb515e6c4c', 'dfd@mrbccd.com', '1360433', 'dfgdfgdf', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (71, 'sdfsd', 'd58e3582afa99040e27b92b13c8f2280', 'http://192.168.1.59/MR/11/13/register_ok.php?name=84d9cfc2f395ce883a41d7ffc1bbcf4e&&pass=d58e3582afa99040e27b92b13c8f2280', 'sfdfdfn@mrbccd.com', '13604338', 'sdfsdfds', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (72, 'sdfsdf', '726784b1a8c22c54054674ef3bdb4153', 'http://192.168.1.59/MR/11/13/register_ok.php?name=d58e3582afa99040e27b92b13c8f2280&&pass=726784b1a8c22c54054674ef3bdb4153', 'sfdfdfn@mrbccd.com', '1360433', 'sdfsdfds', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (73, 'sdfsdf', 'aaec21a67e5619f786c4c84349cba673', 'http://192.168.1.59/MR/11/13/register_ok.php?name=d58e3582afa99040e27b92b13c8f2280&&pass=aaec21a67e5619f786c4c84349cba673', 'sfdfdfn@mrbccd.com', '1360433', 'sdfsdfds', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (74, 'mrosft', '698d51a19d8a121ce581499d7b701668', 'http://192.168.1.59/MR/11/02/register_ok.php?name=bee3ffc488f8b859d981e8c1ae697941&&pass=698d51a19d8a121ce581499d7b701668', 'sp@mrbccd.com', '1360433', '長春市', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (75, 'mrosft', '698d51a19d8a121ce581499d7b701668', 'http://192.168.1.59/MR/11/02/register_ok.php?name=bee3ffc488f8b859d981e8c1ae697941&&pass=698d51a19d8a121ce581499d7b701668', 'sp@mrbccd.com', '1360433', '長春市', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (76, 'mrosft', '698d51a19d8a121ce581499d7b701668', 'http://192.168.1.59/MR/11/02/register_ok.php?name=bee3ffc488f8b859d981e8c1ae697941&&pass=698d51a19d8a121ce581499d7b701668', 'sp@mrbccd.com', '1360433', '長春市', '192.168.1.59', '0');
INSERT INTO `tb_voter` VALUES (77, 'yaohuaq', 'e10adc3949ba59abbe56e057f20f883e', 'http://localhost/mr/11/02/register_ok.php?name=d52064aaa0e90285ac410341a5f8ae16&&pass=e10adc3949ba59abbe56e057f20f883e', 'yaohuaq@mr.com', '0431-84978981', 'china', '127.0.0.1', '0');
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_more`
--
CREATE TABLE `tb_vote_more` (
`tb_vote_id` int(10) NOT NULL auto_increment,
`tb_vote_subject` varchar(80) NOT NULL,
`tb_vote_content` mediumtext NOT NULL,
`tb_vote_counts` varchar(50) NOT NULL,
`tb_vote_type` varchar(50) NOT NULL,
`tb_vote_explain` mediumtext NOT NULL,
`tb_vote_photo` varchar(80) NOT NULL,
PRIMARY KEY (`tb_vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `tb_vote_more`
--
INSERT INTO `tb_vote_more` VALUES (1, '優秀負責人', '喬伊', '100', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (2, '優秀負責人', '薛嶽', '104', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (3, '優秀負責人', '劉易', '75', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (4, '優秀負責人', '金一', '78', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (5, '優秀負責人', '梁毅', '90', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (6, '優秀負責人', '董一', '70', '多選', '', '');
INSERT INTO `tb_vote_more` VALUES (7, '優秀負責人', '寇一', '96', '多選', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_more_ip`
--
CREATE TABLE `tb_vote_more_ip` (
`tb_vote_ip_id` int(10) NOT NULL auto_increment,
`tb_vote_subject` varchar(80) NOT NULL,
`tb_vote_ip` varchar(50) NOT NULL,
PRIMARY KEY (`tb_vote_ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `tb_vote_more_ip`
--
INSERT INTO `tb_vote_more_ip` VALUES (1, '優秀負責人', '127.0.0.1');
INSERT INTO `tb_vote_more_ip` VALUES (2, '優秀負責人', '192.168.1.59');
INSERT INTO `tb_vote_more_ip` VALUES (3, '優秀負責人', '192.168.1.59');
INSERT INTO `tb_vote_more_ip` VALUES (4, '優秀負責人', '192.168.1.59');
INSERT INTO `tb_vote_more_ip` VALUES (24, '優秀負責人', '10.9.1.65');
INSERT INTO `tb_vote_more_ip` VALUES (23, '優秀負責人', '10.9.1.65');
INSERT INTO `tb_vote_more_ip` VALUES (22, '優秀負責人', '10.9.1.65');
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_odd`
--
CREATE TABLE `tb_vote_odd` (
`tb_vote_id` int(10) NOT NULL auto_increment,
`tb_vote_subject` varchar(80) NOT NULL,
`tb_vote_content` varchar(80) NOT NULL,
`tb_vote_counts` varchar(50) NOT NULL,
`tb_vote_type` varchar(50) NOT NULL,
`tb_vote_photo` varchar(80) NOT NULL,
`tb_vote_explain` mediumtext NOT NULL,
PRIMARY KEY (`tb_vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `tb_vote_odd`
--
INSERT INTO `tb_vote_odd` VALUES (1, '優秀員工', '李一', '501', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (2, '優秀員工', '張楊', '300', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (3, '優秀員工', '王幻', '550', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (4, '優秀員工', '程一', '751', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (5, '優秀員工', '霍伊', '950', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (6, '優秀員工', '陸一', '600', '單選', '', '');
INSERT INTO `tb_vote_odd` VALUES (7, '優秀員工', '喬伊', '851', '單選', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_odd_ip`
--
CREATE TABLE `tb_vote_odd_ip` (
`tb_vote_ip_id` int(10) NOT NULL auto_increment,
`tb_vote_id` varchar(10) NOT NULL,
`tb_vote_subject` varchar(80) NOT NULL,
`tb_vote_content` text NOT NULL,
`tb_vote_date` datetime NOT NULL,
`tb_vote_ip` varchar(50) NOT NULL,
PRIMARY KEY (`tb_vote_ip_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tb_vote_odd_ip`
--
INSERT INTO `tb_vote_odd_ip` VALUES (1, '2', '優秀員工', '張楊', '2008-05-30 01:50:18', '127.0.0.1');
INSERT INTO `tb_vote_odd_ip` VALUES (2, '5', '優秀員工', '霍伊', '2008-06-23 03:43:07', '127.0.0.1');
INSERT INTO `tb_vote_odd_ip` VALUES (6, '4', '優秀員工', '程一', '2008-08-08 03:12:43', '192.168.1.59');
INSERT INTO `tb_vote_odd_ip` VALUES (9, '7', '優秀員工', '喬伊', '2009-08-03 02:15:03', '10.9.1.65');
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_record`
--
CREATE TABLE `tb_vote_record` (
`tb_record_id` int(5) NOT NULL auto_increment,
`tb_vote_id` int(5) NOT NULL default '0',
`tb_record_name` varchar(50) NOT NULL,
`tb_record_num` int(5) NOT NULL default '0',
`tb_record_color` int(1) NOT NULL default '0',
PRIMARY KEY (`tb_record_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=75 ;
--
-- Dumping data for table `tb_vote_record`
--
INSERT INTO `tb_vote_record` VALUES (31, 15, '歐陽一', 3, 1);
INSERT INTO `tb_vote_record` VALUES (32, 15, '南宮一', 4, 2);
INSERT INTO `tb_vote_record` VALUES (33, 16, '羽毛球', 0, 3);
INSERT INTO `tb_vote_record` VALUES (34, 16, '射擊', 8, 5);
INSERT INTO `tb_vote_record` VALUES (28, 14, '程一', 4, 1);
INSERT INTO `tb_vote_record` VALUES (29, 14, '張一', 6, 4);
INSERT INTO `tb_vote_record` VALUES (30, 14, '歐陽一', 9, 2);
INSERT INTO `tb_vote_record` VALUES (35, 17, 'C7', 0, 1);
INSERT INTO `tb_vote_record` VALUES (36, 17, '張三', 1, 4);
INSERT INTO `tb_vote_record` VALUES (37, 17, '歐陽', 0, 2);
INSERT INTO `tb_vote_record` VALUES (38, 18, 'fgegr', 1, 2);
INSERT INTO `tb_vote_record` VALUES (39, 18, 'gre', 0, 2);
INSERT INTO `tb_vote_record` VALUES (40, 18, 'gre', 1, 3);
INSERT INTO `tb_vote_record` VALUES (41, 18, 'gr', 0, 4);
INSERT INTO `tb_vote_record` VALUES (42, 18, 'grgeg', 0, 5);
INSERT INTO `tb_vote_record` VALUES (43, 19, 'qeg', 0, 1);
INSERT INTO `tb_vote_record` VALUES (44, 19, 'grqg', 1, 1);
INSERT INTO `tb_vote_record` VALUES (45, 19, 'qgrqe', 0, 1);
INSERT INTO `tb_vote_record` VALUES (46, 19, 'gqgr', 0, 1);
INSERT INTO `tb_vote_record` VALUES (47, 19, 'qqegrqg', 0, 1);
INSERT INTO `tb_vote_record` VALUES (48, 19, 'eqgq', 0, 1);
INSERT INTO `tb_vote_record` VALUES (49, 19, 'qegqegr', 0, 1);
INSERT INTO `tb_vote_record` VALUES (50, 20, '65ki85ki8', 0, 2);
INSERT INTO `tb_vote_record` VALUES (51, 20, 'kr67urk8i', 0, 3);
INSERT INTO `tb_vote_record` VALUES (52, 21, 'e', 0, 1);
INSERT INTO `tb_vote_record` VALUES (53, 21, 'egrwa', 2, 1);
INSERT INTO `tb_vote_record` VALUES (54, 21, 'htwh', 0, 1);
INSERT INTO `tb_vote_record` VALUES (55, 21, 'gq43hg35', 0, 1);
INSERT INTO `tb_vote_record` VALUES (56, 21, 'hq4h5', 0, 1);
INSERT INTO `tb_vote_record` VALUES (57, 22, 'wrhw', 0, 1);
INSERT INTO `tb_vote_record` VALUES (58, 22, 'wrhtw', 0, 1);
INSERT INTO `tb_vote_record` VALUES (59, 22, 'werhwh', 0, 1);
INSERT INTO `tb_vote_record` VALUES (60, 22, 'whwh', 0, 1);
INSERT INTO `tb_vote_record` VALUES (61, 22, 'w54hh54h52w', 0, 1);
INSERT INTO `tb_vote_record` VALUES (62, 23, 'het5', 0, 1);
INSERT INTO `tb_vote_record` VALUES (63, 23, 'h', 0, 1);
INSERT INTO `tb_vote_record` VALUES (64, 23, '', 0, 1);
INSERT INTO `tb_vote_record` VALUES (65, 23, '', 0, 1);
INSERT INTO `tb_vote_record` VALUES (66, 24, '馬先生', 0, 1);
INSERT INTO `tb_vote_record` VALUES (67, 24, '蔡小姐', 0, 1);
INSERT INTO `tb_vote_record` VALUES (68, 24, '不想投', 0, 1);
INSERT INTO `tb_vote_record` VALUES (69, 25, '花不完的錢', 0, 1);
INSERT INTO `tb_vote_record` VALUES (70, 25, '法拉利', 0, 1);
INSERT INTO `tb_vote_record` VALUES (71, 25, '黃金', 0, 1);
INSERT INTO `tb_vote_record` VALUES (72, 25, '瑪瑙', 0, 1);
INSERT INTO `tb_vote_record` VALUES (73, 25, '鑽石', 0, 1);
INSERT INTO `tb_vote_record` VALUES (74, 25, '名牌包', 0, 1);
-- --------------------------------------------------------
--
-- Table structure for table `tb_vote_subject`
--
CREATE TABLE `tb_vote_subject` (
`tb_vote_subject_id` int(10) NOT NULL auto_increment,
`tb_vote_subject_name` varchar(80) NOT NULL,
`tb_vote_subject_text` text NOT NULL,
PRIMARY KEY (`tb_vote_subject_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `tb_vote_subject`
--
INSERT INTO `tb_vote_subject` VALUES (1, '優秀員工', '評選公司內部的優秀員工。');
INSERT INTO `tb_vote_subject` VALUES (2, '優秀負責人', '評選公司內部優秀負責人');
INSERT INTO `tb_vote_subject` VALUES (9, '我最喜歡的比賽項目', '評選我最喜歡的比賽項目');
INSERT INTO `tb_vote_subject` VALUES (8, '我最喜愛的運動員', '評選我最喜愛的運行員'); |