create table.txt

PHP源码_环保设计大赛网上投票系统

环保设计大赛网上投票系统


数据库 studentunion 运行于 localhost
# phpMyAdmin MySQL-Dump
# version 2.2.6-rc2
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# 主机: localhost
# 建立日期: Nov 21, 2002 at 02:24 PM
# 伺服机版本: 3.23.47
# PHP 版本: 4.2.1
# 数据库 : `studentunion`
# --------------------------------------------------------

#
# 数据表的结构 `huanbao_pic`
#

CREATE TABLE huanbao_pic (
  id int(11) NOT NULL auto_increment,
  huanbao_user_id int(11) NOT NULL default '0',
  url varchar(100) NOT NULL default '',
  info varchar(80) NOT NULL default '',
  Filename varchar(80) NOT NULL default '',
  joindate datetime NOT NULL default '0000-00-00 00:00:00',
  Filesize varchar(11) NOT NULL default '0',
  Filetype varchar(50) NOT NULL default '',
  pass tinyint(4) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# 数据表的结构 `huanbao_user`
#

CREATE TABLE huanbao_user (
  id int(11) NOT NULL auto_increment,
  author varchar(100) NOT NULL default '',
  product varchar(100) NOT NULL default '',
  info text NOT NULL,
  password varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# 数据表的结构 `huanbao_vote_ip`
#

CREATE TABLE huanbao_vote_ip (
  id int(11) NOT NULL auto_increment,
  ip varchar(15) NOT NULL default '',
  datetime varchar(16) NOT NULL default '',
  vote_id int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
# --------------------------------------------------------

#
# 数据表的结构 `huanbao_vote_list`
#

CREATE TABLE huanbao_vote_list (
  id int(11) NOT NULL auto_increment,
  number int(11) default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;