# phpMyAdmin MySQL-Dump
# http://phpwizard.net/phpMyAdmin/
#
# 主机: localhost:3306 数据库 : study28
# --------------------------------------------------------
#
# 数据表的结构 'chat_user'
#
CREATE TABLE chat_user (
;;;userid varchar(20) NOT NULL,
;;;passwd varchar(20) NOT NULL,
;;;last_time int(10) DEFAULT '0' NOT NULL,
;;;id varchar(20) NOT NULL,
;;;sex varchar(5) NOT NULL
);
# --------------------------------------------------------
#
# 数据表的结构 'chat_user_list'
#
CREATE TABLE chat_user_list (
;;;userid int(10) DEFAULT '0' NOT NULL,
;;;passwd varchar(20) NOT NULL,
;;;last_time int(10) DEFAULT '0' NOT NULL,
;;;id varchar(20) NOT NULL,
;;;sex varchar(5) NOT NULL
);
# --------------------------------------------------------
#
# 数据表的结构 'private_chat'
#
CREATE TABLE private_chat (
;;;sender varchar(20) NOT NULL,
;;;object varchar(20) NOT NULL,
;;;message varchar(255) NOT NULL,
;;;r1 tinyint(4) DEFAULT '0' NOT NULL,
;;;r2 tinyint(4) DEFAULT '0' NOT NULL
);
# --------------------------------------------------------
#
# 数据表的结构 'user'
#
CREATE TABLE user (
;;;id varchar(15) 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(20) NOT NULL,
;;;homepage varchar(20) 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,
;;;KEY id (id, userid)
);
# --------------------------------------------------------
#
# 数据表的结构 'user_message'
#
CREATE TABLE user_message (
;;;userid varchar(20) NOT NULL,
;;;object varchar(15) NOT NULL,
;;;message varchar(255) NOT NULL,
;;;status int(2) DEFAULT '0' NOT NULL,
;;;action1 varchar(20) NOT NULL,
;;;color varchar(10) DEFAULT '0' NOT NULL,
;;;row int(10) DEFAULT '0' NOT NULL,
;;;time1 varchar(10) NOT NULL,
;;;id int(10) DEFAULT '0' NOT NULL
);
# --------------------------------------------------------
#
# 数据表的结构 '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' NOT NULL,
;;;photo int(2) DEFAULT '0' NOT NULL,
;;;number int(4) 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 (id),
;;;KEY id (id)
);
标签: