db.sql

来自「本程序使用ajax技术实现聊天室程序.使用ajax动态获取聊天记录.」· SQL 代码 · 共 31 行

--Chat Table
DROP TABLE IF EXISTS CHAT;
CREATE TABLE CHAT (
  CHAT_ID INT(16) NOT NULL AUTO_INCREMENT,
  CHAT_NAME VARCHAR(64) DEFAULT NULL,
  START_TIME DATETIME DEFAULT NULL,
  PRIMARY KEY  (CHAT_ID)
) TYPE=MyISAM ;
--User Table
DROP TABLE IF EXISTS USER;
CREATE TABLE USER (
  USER_ID INT(16) NOT NULL AUTO_INCREMENT,
  USER_NAME VARCHAR(64) DEFAULT NULL,
  START_TIME DATETIME DEFAULT NULL,
  PRIMARY KEY  (USER_ID)
) TYPE=MyISAM ;
--Message Table
DROP TABLE IF EXISTS MESSAGE;
CREATE TABLE MESSAGE (
  MESSAGE_ID INT(16) NOT NULL AUTO_INCREMENT,
  CHAT_ID INT(16) NOT NULL DEFAULT '0',
  USER_ID INT(16) NOT NULL DEFAULT '0',
  USER_NAME VARCHAR(64) DEFAULT NULL,
  MESSAGE TEXT,
  POST_TIME DATETIME DEFAULT NULL,
  PRIMARY KEY  (MESSAGE_ID)
) TYPE=MyISAM ;

INSERT INTO CHAT VALUES(1,'Beijing','');
INSERT INTO CHAT VALUES(2,'Shanghai','');
INSERT INTO CHAT VALUES(3,'Guangzhou','');