# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主机: localhost:3306 数据库 : database
# --------------------------------------------------------
#
# 数据表的结构 'bbs_html'
#
CREATE TABLE bbs_html (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;date1 varchar(20) NOT NULL,
;;;title varchar(40) NOT NULL,
;;;content text NOT NULL,
;;;r1 int(15) DEFAULT '0' NOT NULL,
;;;r2 int(15) DEFAULT '0' NOT NULL,
;;;number tinyint(4) DEFAULT '0' NOT NULL,
;;;row tinyint(5) DEFAULT '0' NOT NULL,
;;;r3 int(15) DEFAULT '0' NOT NULL,
;;;r4 int(15) DEFAULT '0' NOT NULL,
;;;r5 int(15) DEFAULT '0' NOT NULL,
;;;UNIQUE id (id)
);
# --------------------------------------------------------
#
# 数据表的结构 'bbs_js'
#
CREATE TABLE bbs_js (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;date1 varchar(20) NOT NULL,
;;;title varchar(40) NOT NULL,
;;;content text NOT NULL,
;;;r1 int(15) DEFAULT '0' NOT NULL,
;;;r2 int(15) DEFAULT '0' NOT NULL,
;;;number tinyint(4) DEFAULT '0' NOT NULL,
;;;row tinyint(5) DEFAULT '0' NOT NULL,
;;;r3 int(15) DEFAULT '0' NOT NULL,
;;;r4 int(15) DEFAULT '0' NOT NULL,
;;;r5 int(15) DEFAULT '0' NOT NULL,
;;;UNIQUE id (id)
);
# --------------------------------------------------------
#
# 数据表的结构 'bbs_mysql'
#
CREATE TABLE bbs_mysql (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;date1 varchar(20) NOT NULL,
;;;title varchar(40) NOT NULL,
;;;content text NOT NULL,
;;;r1 int(15) DEFAULT '0' NOT NULL,
;;;r2 int(15) DEFAULT '0' NOT NULL,
;;;number tinyint(4) DEFAULT '0' NOT NULL,
;;;row tinyint(5) DEFAULT '0' NOT NULL,
;;;r3 int(15) DEFAULT '0' NOT NULL,
;;;r4 int(15) DEFAULT '0' NOT NULL,
;;;r5 int(15) DEFAULT '0' NOT NULL,
;;;UNIQUE id (id)
);
# --------------------------------------------------------
#
# 数据表的结构 'bbs_php'
#
CREATE TABLE bbs_php (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;date1 varchar(20) NOT NULL,
;;;title varchar(40) NOT NULL,
;;;content text NOT NULL,
;;;r1 int(15) DEFAULT '0' NOT NULL,
;;;r2 int(15) DEFAULT '0' NOT NULL,
;;;number tinyint(4) DEFAULT '0' NOT NULL,
;;;row tinyint(5) DEFAULT '0' NOT NULL,
;;;r3 int(15) DEFAULT '0' NOT NULL,
;;;r4 int(15) DEFAULT '0' NOT NULL,
;;;r5 int(15) DEFAULT '0' NOT NULL,
;;;UNIQUE id (id)
);
# --------------------------------------------------------
#
# 数据表的结构 'bbs_re'
#
CREATE TABLE bbs_re (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;title varchar(40) NOT NULL,
;;;content text NOT NULL,
;;;date1 varchar(30) NOT NULL
);
# --------------------------------------------------------
#
# 数据表的结构 'user'
#
CREATE TABLE user (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;userid varchar(20) NOT NULL,
;;;name varchar(20) NOT NULL,
;;;passwd varchar(20) NOT NULL,
;;;sex varchar(5) NOT NULL,
;;;age char(3) NOT NULL,
;;;question varchar(20) NOT NULL,
;;;answer varchar(20) NOT NULL,
;;;birthday varchar(20) NOT NULL,
;;;oicq varchar(10) NOT NULL,
;;;height varchar(4) NOT NULL,
;;;myphoto char(3) NOT NULL,
;;;email varchar(30) NOT NULL,
;;;homepage varchar(40) NOT NULL,
;;;hobby varchar(40) NOT NULL,
;;;number varchar(10) NOT NULL,
;;;room varchar(20) NOT NULL,
;;;department varchar(20) NOT NULL,
;;;phone varchar(20) NOT NULL,
;;;ready1 varchar(10) NOT NULL,
;;;ready2 varchar(10) NOT NULL,
;;;ready3 varchar(10) NOT NULL,
;;;UNIQUE userid (userid),
;;;KEY id (id, userid)
);
# --------------------------------------------------------
#
# 数据表的结构 'user_stus'
#
CREATE TABLE user_stus (
;;;id int(15) DEFAULT '0' NOT NULL,
;;;status varchar(6) NOT NULL,
;;;userid varchar(15) DEFAULT '0' NOT NULL,
;;;ip varchar(20) NOT NULL,
;;;r2 char(2) NOT NULL,
;;;r3 char(2) NOT NULL,
;;;r4 char(2) NOT NULL,
;;;PRIMARY KEY (userid)
);
标签：
