Chatting room php & mysql (6)

# & Nbsp; corresponding & nbsp; database # php (as the mainstream development language) MyAdminMySQL (the best combination with PHP)-Dump # http: // php (as the mainstream development language) wizard.net/php (as the mainstream development language) MyAdmin/# HOST: localhost: 3306 data # corresponding database


# Php (as the mainstream development language) MyAdmin MySQL (the best combination with PHP)-Dump
# Http: // php (as the mainstream development language) wizard.net/php (as the mainstream development language) MyAdmin/
#
# HOST: localhost: 3306 database: study28

#--------------------------------------------------------
#
# Structure of the data table 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
);


#--------------------------------------------------------
#
# Structure of the data table 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
);


#--------------------------------------------------------
#
# Data table structure 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
);


#--------------------------------------------------------
#
# Data table structure 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,
Holobby 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
);


#--------------------------------------------------------
#