【SQL开源代码栏目提醒】:网学会员,鉴于大家对SQL开源代码十分关注,论文会员在此为大家搜集整理了“ChatRoom.sql”一文,供大家参考学习!
drop database if exists ChatRoom;
create database ChatRoom;
use chatroom;
create table RegUsers(
RegID int(4) NOT NULL auto_increment,
NickName varchar(20) NOT NULL,
Pass
word varchar(12) NOT NULL,
Email varchar(30),
RegTime datetime,
IsKicked tinyint,
PRIMARY KEY (RegID)
);
CREATE TABLE Logs (
LogID int(11) NOT NULL auto_increment,
LogUser varchar(20) not null,
InTime datetime ,
OutTime datetime,
PRIMARY KEY(LogID)
);
create table Online(
OnID int(4) NOT NULL auto_increment,
NickName varchar(20) NOT NULL,
InTime datetime,
IP varchar(20),
PRIMARY KEY (OnID)
);
CREATE TABLE messages (
MesID int(4) Not null auto_increment,
ToUser varchar(20) NOT NULL,
FromUser varchar(20) NOT NULL ,
Time time NOT NULL ,
Content varchar(255) default NULL,
Color varchar(20),
PRIMARY KEY (MesID)
);