聊天室php&mysql(六)_PHP教程

#  對應的  資料庫


# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主機: localhosthost:3306 資料庫>
# --------------------------------------------- -----------
#
# 資料表的結構'chat_user'
#

CREATE TABLE chat_user (
   userid varchar(20) NOT NULL ,
   passwd varchar(20) NOT NULL,
   last_time int(10) DEFAULT '0' NOT NULL,
   >);


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

CREATE TABLE chat_user_list (
   userid int(10) DEFAULT '0' NOT NULL,
   passwd varchar(20) NOT NULL,
   last 
   sex varchar(5) NOT NULL
);


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

CREATE TABLE private_chat (
   sender varchar(20) NOT NULL,
   object varchar(20) NOT NULL,
   object varchar(20) NOT NULL,
   object varchar(20) NOT NULL,
   object varchar(20) NOT NULL,
  int(4 ) DEFAULT '0' NOT NULL,
   r2 tinyint(4) DEFAULT '0' NOT NULL
);


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

CREATE TABLE user (
   id varchar(15) NOT NULL,
   id varchar(20) NOT NULL,
   id varchar(20) NOT NcharULL,    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,
   height varchar(4) NOT NULL,
   myphoto char(3 ) NOT NULL,
   email varchar(20) NOT NULL,
   homepage varchar(20) NOT NULL,
   ho >   room varchar(20) NOT NULL,
   department varchar(20) NOT NULL,
   phone varchar(20) NOT NULL,
NOT NULL,
   ready3 varchar(10) NOT NULL,
   KEY id (id, userid)
);


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

CREATE TABLE user_message (
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
   userid varchar(20) NOT NULL,
 varchar(255) NOT NULL,
   status int(2) DEFAULT '0' NOT NULL,
   action1 varchar(20) NOT NULL,
   color varchar(20) NOT NULL,
   color var of >   row int(10) DEFAULT '0' NOT NULL,
   time1 varchar(10) NOT NULL,
   id int(10) DEFAULT '0' NOTULL
;
;
; 🎜># ----------------------------------------------- ---------
#
# 資料表的結構'user_stus'
#

CREATE TABLE user_stus (
   id varchar(20) NOT NULL,
   status varchar(6) NOT NULL,
   date1 varchar(30) NOT NULL,
   value int(5) DEFAULT '0' NOTULL,    number int(4) DEFAULT '0' NOT NULL,
   ip varchar(20) NOT NULL,
   r2 char(2) NOT NULL,
   r2 char(2) NOT NULL,   🎜>   r4 char(2) NOT NULL,
   PRIMARY KEY (id),
   KEY id (id)
);





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

www.bkjia.com

true

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

TechArticle#對應的資料庫# phpMyAdmin MySQL-Dump # http://phpwizard.net/phpMyAdmin/ # # 主機: localhost:3306 資料庫: study28 # ------------------------------------------- ----------...