BBS(php & mysql)完整版(八)_PHP教程

//完成wish you sucess!!

# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主機: localhost:3306 資料庫: data
# ----------------------------------------------- ---------
#
# 資料表的結構'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,
   title varchar(40) NOT NULL,    r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
 ' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 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,
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
  40) NOT NULL,
   content text NOT NULL,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' N ) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT 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,
 NULL,
   date1 varchar(20) NOT NULL,
   title varchar(40) NOT NULL,
   content text NOT NULL,
 r2 int(15) DEFAULT '0' NOT NULL,
   number tinyint(4) DEFAULT '0' NOT NULL,
   row tinyint(5) DEFAULT '0' NOT N N1,    r4 int(15) DEFAULT '0' NOT NULL,
   r5 int(15) DEFAULT '0' NOT NULL,
 );


# ---------------------------------------- ----------------
#
# 資料表的結構'bbs_php'
#

CREATE TABLE bbs_php (
   id int (15) DEFAULT '0' NOT NULL,
   userid varchar(20) NOT NULL,
   date1 varchar(20) NOT NULL,    date1 varchar(20) NOT NULL,   ,
   r1 int(15) DEFAULT '0' NOT NULL,
   r2 int(15) DEFAULT '0' NOT NULL,
  number tinyint(4) DEULT tinyint(5) DEFAULT '0' NOT NULL,
   r3 int(15) DEFAULT '0' NOT NULL,
   r4 int(15) DEFAULT '0' NOT NULL,

'0' NOT NULL,
   UNIQUE id (id)
);


# --------------------- -----------------------------------
#
# 資料表的結構'bbs_re'
#

CREATE TABLE bbs_re (
   id int(15) DEFAULT '0' NOT NULL,
   id varchar(20) NOT NULL,
   id varchar(20) 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 (20) NOT NULL,
   passwd varchar(20) NOT NULL,
   sex varchar(5) NOT NULL,
   age char(3) NOT NULL,  
   answer varchar(20) NOT NULL,
   birthday varchar(20) NOT NULL,
   oicq varchar(10) NOT NULL,
   oicq varchar(10) NOT NULL,
   oicq varchar(10) NOT NULL,
 3) NOT NULL,
   email varchar(30) NOT NULL,
   homepage varchar(40) NOT NULL,
   ho 🎜>   room varchar(20) NOT NULL,
   department varchar(20) NOT NULL,
電話varchar(20) NOT NULL,
   ready1 varchar(10) NOT NULL,
   ready2 varchar(10) NOT NULL,
   ready2 varchar(10) NOT NULL,
  
   KEY id (id, userid)
);


# ------------------------- --------------- ----------------
#
# 資料表的結構'user_stus'
#

CREATE TABLE user_stus (
   id int (15) DEFAULT '0' NOT NULL,
   status varchar(6) NOT NULL,
   status varchar(6) NOT ,
   ip varchar(20) NOT NULL,
r2 char(2) NOT NULL,
   r3 char(2) NOT NULL,  使用者ID）
);

http://www.bkjia.com/PHPjc/315662.html

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/315662.htmlTechArticle// 祝你成功！ ！ # phpMyAdmin MySQL-Dump # http://phpwizard.net/phpMyAdmin/ # # 主機: localhost:3306 資料庫: 資料庫# ----------------------- --- ----------------------...