chatroom.sql

来自「php开发实例完全剖析」· SQL 代码 · 共 40 行

 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,
	Password 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)
);