聊天室php&mysql(六)

#;;相应的;;数据库 # 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) );