Chat room Php&mysql (vi) _php Foundation

# The corresponding database


# phpMyAdmin Mysql-dump
# http://phpwizard.net/phpMyAdmin/
#
# Host: localhost:3306 database: study28

# --------------------------------------------------------
#
# The structure of the datasheet ' Chat_user '
#

CREATE TABLE Chat_user (
UserID varchar is not NULL,
passwd varchar is not NULL,
Last_time Int (a) DEFAULT ' 0 ' not NULL,
ID varchar (not NULL),
Sex varchar (5) Not NULL
);


# --------------------------------------------------------
#
# The structure of the datasheet ' Chat_user_list '
#

CREATE TABLE Chat_user_list (
UserID Int (a) DEFAULT ' 0 ' not NULL,
passwd varchar is not NULL,
Last_time Int (a) DEFAULT ' 0 ' not NULL,
ID varchar (not NULL),
Sex varchar (5) Not NULL
);


# --------------------------------------------------------
#
# The structure of the datasheet ' Private_chat '
#

CREATE TABLE Private_chat (
Sender varchar is not NULL,
Object varchar () not NULL,
Message varchar (255) is not NULL,
R1 tinyint (4) DEFAULT ' 0 ' not NULL,
R2 tinyint (4) DEFAULT ' 0 ' not NULL
);


# --------------------------------------------------------
#
# Structure of the datasheet ' user '
#

CREATE TABLE User (
ID varchar not NULL,
UserID varchar is not NULL,
Name varchar is not NULL,
passwd varchar is not NULL,
Sex varchar (5) Not NULL,
Age char (3) is not NULL,
Question varchar is not NULL,
Answer varchar is not NULL,
Birthday varchar is not NULL,
OICQ varchar (ten) is not NULL,
Height varchar (4) Not NULL,
Myphoto char (3) not NULL,
Email varchar not NULL,
Homepage varchar is not NULL,
Hobby varchar () not NULL,
Number varchar (ten) is not NULL,
Room varchar is not NULL,
Department varchar is not NULL,
Phone varchar not NULL,
Ready1 varchar (ten) is not NULL,
Ready2 varchar (ten) is not NULL,
Ready3 varchar (ten) is not NULL,
KEY ID (ID, userid)
);


# --------------------------------------------------------
#
# The structure of the datasheet ' User_message '
#

CREATE TABLE User_message (
UserID varchar is not NULL,
Object varchar Not NULL,
Message varchar (255) is not NULL,
status int (2) DEFAULT ' 0 ' not NULL,
Action1 varchar is not NULL,
Color varchar (+) DEFAULT ' 0 ' not NULL,
row int (a) DEFAULT ' 0 ' not NULL,
TIME1 varchar (ten) is not NULL,
ID Int (TEN) DEFAULT ' 0 ' not NULL
);


# --------------------------------------------------------
#
# The structure of the datasheet ' User_stus '
#

CREATE TABLE User_stus (
ID varchar (not NULL),
Status varchar (6) Not NULL,
Date1 varchar () 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 (not NULL),
R2 char (2) not NULL,
R3 char (2) not NULL,
R4 char (2) not NULL,
PRIMARY KEY (ID),
KEY ID (ID)
);