BBS(php & mysql)完整版(八)

//完毕 wish you sucess!! # 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) );