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)
);

(0)

相关推荐

  • 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 '

  • BBS(php & mysql)完整版(一)

    //此页面为say.php <? include "signup/mysql.inc"; if($id1){        $sql="select * from $table where id='$id1'";    //显示回复题目        $result=mysql_query($sql)or die(mysql_error());        $row=mysql_fetch_array($result);        $title=&quo

  • BBS(php & mysql)完整版(五)

    //下面为menu_comment.js function fwLoadMenus() {   if (window.fw_menu_0) return;   window.fw_menu_0 = new Menu("root",92,20,"Verdana, Arial, Helvetica, sans-serif",12,"#6666ff","#ffffff","#FF9999","#6666

  • BBS(php & mysql)完整版(七)

    //下面是  top.js function KB_keepItInIE(theName,theWantTop,theWantLeft) { theRealTop=parseInt(document.body.scrollTop) theTrueTop=theWantTop+theRealTop document.all[theName].style.top=theTrueTop theRealLeft=parseInt(document.body.scrollLeft) theTrueLeft

  • BBS(php & mysql)完整版(二)

    //此页面为look.php <? include "signup/mysql.inc"; $sql="select * from ".$table." where id='$id'"; $result=mysql_query($sql)or die(mysql_error()); $row=mysql_fetch_array($result); $number=++$row["number"]; $sql="

  • BBS(php & mysql)完整版(三)

    //此页面为php3.php <? include "signup/mysql.inc"; switch($part){    case "1" :$table="bbs_php";break;    case "2" :$table="bbs_mysql";break;    case "3" :$table="bbs_html";break;    case

  • BBS(php & mysql)完整版(六)

    +proto.menuBorder;             var focusItem = body.document.layers[n];             focusItem.clip.width = body.clip.width;             focusItem.Menu = l.Menu;             focusItem.top = -30;             focusItem.captureEvents(Event.MOUSEDOWN);   

  • BBS(php & mysql)完整版(四)

    //此页面为 top.php <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <script language="JavaScript1.2" src="js/fw_menu.js"

  • Mysql命令大全(完整版)

    一.连接数据库 格式:mysql -h主机地址 -u用户名 -p用户密码 1.1.连接到本机上的MYSQL. 首先打开DOS窗口,然后进入目录mysql\bin,再键入命令mysql -u root -p,回车后提示你输密码. 注意用户名前可以有空格也可以没有空格,但是密码前必须没有空格,否则让你重新输入密码. 如果刚安装好MYSQL,超级用户root是没有密码的,故直接回车即可进入到MYSQL中了,MYSQL的提示符是: mysql> 1.2连接到远程主机上的MYSQL. 假设远程主机的IP为

  • Mybatis Generator最完美配置文件详解(完整版)

    最近没做项目,重新整理了一个最完整的Mybatis Generator(简称MBG)的最完整配置文件,带详解,再也不用去看EN的User Guide了: <?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE generatorConfiguration PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"

随机推荐