来源：自学PHP网 时间：2014-12-25 09:57 作者： 阅读:次
[导读] BBSphpamp;mysql完整版八,//完毕wishyousucess!!#phpMyAdminMySQL-Dump#http://phpwizard.net/phpMyAdmin/##主机:localhost:3306数据库:database#--------------------------------------------------------##数据表的结构'bbs_html'#CREATET...
|
//完毕 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) ); |
自学PHP网专注网站建设学习,PHP程序学习,平面设计学习，以及操作系统学习
京ICP备14009008号-1@版权所有www.zixuephp.com
网站声明：本站所有视频，教程都由网友上传，站长收集和分享给大家学习使用，如由牵扯版权问题请联系站长邮箱904561283@qq.com
