【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,01.sql,希望对大家有所帮助!
锘?- phpMyAdmin SQL Dump
-- version 2.6.0-pl3
-- http://www.phpmyadmin.net
--
-- 涓绘満: localhost
-- 鐢熸垚鏃ユ湡: 2007 骞?04 鏈?11 鏃?21:42
-- 鏈嶅姟鍣ㄧ増鏈? 5.0.0
--
PHP 鐗堟湰: 5.1.4
--
-- 鏁版嵁搴? `vote`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `ee_item_info`
--
CREATE TABLE `ee_item_info` (
`F_ID` int(10) NOT NULL auto_increment,
`F_ID_VOTE_INFO` int(10) NOT NULL default '0',
`F_ITEM_TITLE` varchar(50) NOT NULL default '',
`F_ITEM_COUNT` int(10) NOT NULL default '0',
`F_ITEM_ORDER` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`F_ID`)
) TYPE=MyISAM;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`ee_item_info`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `ee_vote_user`
--
CREATE TABLE `ee_vote_user` (
`F_ID` int(10) NOT NULL auto_increment,
`F_ID_VOTE_INFO` int(10) NOT NULL default '0',
`F_USER_IP` int(15) NOT NULL default '0',
`F_USER_TIME` INT(11) NOT NULL,
`F_USER_AREA` varchar(20) NOT NULL default '',
PRIMARY KEY (`F_ID`)
) TYPE=MyISAM ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`ee_vote_user`
--
-- --------------------------------------------------------
--
-- 琛ㄧ殑缁撴瀯 `em_vote_info`
--
CREATE TABLE `em_vote_info` (
`F_ID` int(10) NOT NULL auto_increment,
`F_VOTE_TITLE` varchar(255) NOT NULL default '',
`F_VOTE_START` INT(11) NOT NULL,
`F_VOTE_END` INT(11) NOT NULL,
`F_VOTE_ITEM_TYPE` tinyint(4) NOT NULL default '0',
`F_VOTE_IS_DISPLAY` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`F_ID`)
) TYPE=MyISAM ;
--
-- 瀵煎嚭琛ㄤ腑鐨勬暟鎹?`em_vote_info`
--