【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,ch6.sql,希望对大家有所帮助!
-- MySQL dump 9.09
--
-- Host: localhost Database: ch6
-- ------------------------------------------------------
-- Server version 4.0.16-nt
--
-- Table structure for table `chat`
--
CREATE TABLE chat (
ID bigint(20) NOT NULL auto_increment,
ChatRoom varchar(50) default NULL,
ChatFrom varchar(50) default NULL,
ChatTo varchar(50) default NULL,
ChatTime datetime default '0000-00-00 00:00:00',
ChatAction varchar(50) default NULL,
ChatContent varchar(200) default NULL,
Secret tinyint(1) default '0',
PRIMARY KEY (ID),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
--
-- Dumping data for table `chat`
--
--
-- Table structure for table `userlist`
--
CREATE TABLE userlist (
ID bigint(20) NOT NULL auto_increment,
ChatRoom varchar(50) default NULL,
UserName varchar(50) default NULL,
ChatTime bigint(20) default NULL,
DenyRoom varchar(50) default NULL,
DenyTime bigint(20) default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
--
-- Dumping data for table `userlist`
--
--
-- Table structure for table `users`
--
CREATE TABLE users (
ID bigint(20) NOT NULL auto_increment,
UserName varchar(50) default NULL,
UserPass
word varchar(50) default NULL,
LoginTime bigint(20) default NULL,
PRIMARY KEY (ID),
UNIQUE KEY ID (ID)
) TYPE=MyISAM;
--
-- Dumping data for table `users`
--