【SQL开源代码栏目提醒】:网学会员SQL开源代码为您提供chatroom_backup.sql参考,解决您在chatroom_backup.sql学习中工作中的难题,参考学习。
/*
SQLyog v3.71
Host - localhost : Database - chatroom
**************************************************************
Server version 4.1.7-nt
*/
create database if not exists `chatroom`;
use `chatroom`;
/*
Table structure for logs
*/
drop table if exists `logs`;
CREATE TABLE `logs` (
`LogID` int(11) NOT NULL auto_increment,
`LogUser` varchar(20) NOT NULL default '',
`InTime` datetime default NULL,
`OutTime` datetime default NULL,
`IP` varchar(20) default NULL,
PRIMARY KEY (`LogID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*
Table data for chatroom.logs
*/
INSERT INTO `logs` VALUES
(2,'local','2004-12-28 17:06:01','2004-12-29 15:36:33','127.0.0.1'),
(4,'local','2004-12-28 17:29:19','2004-12-29 15:36:33','127.0.0.1'),
(26,'萧红','2004-12-29 15:17:21','2004-12-29 15:36:33','127.0.0.1'),
(27,'local','2004-12-29 15:31:45','2004-12-29 15:36:33','127.0.0.1'),
(28,'local','2004-12-29 15:33:53','2004-12-29 15:37:53','127.0.0.1'),
(29,'local','2004-12-29 15:55:35','2004-12-29 15:55:47','127.0.0.1'),
(30,'local','2004-12-29 16:10:08','2004-12-29 16:10:35','127.0.0.1'),
(31,'local','2004-12-29 16:10:43','2004-12-29 21:10:18','127.0.0.1'),
(32,'admin','2004-12-29 21:12:37','2004-12-30 18:19:17','127.0.0.1'),
(33,'admin','2004-12-30 17:35:40','2004-12-30 18:19:17','127.0.0.1'),
(34,'admin','2004-12-30 17:36:28','2004-12-30 18:19:17','127.0.0.1'),
(35,'admin','2004-12-30 17:37:36','2004-12-30 18:19:17','127.0.0.1'),
(36,'admin','2004-12-30 18:16:18','2004-12-30 18:19:17','127.0.0.1'),
(37,'admin','2004-12-30 18:19:56','2004-12-30 18:27:29','127.0.0.1'),
(38,'admin','2004-12-30 18:27:52','2004-12-31 09:48:09','127.0.0.1'),
(39,'ls','2004-12-31 09:56:40','2004-12-31 09:58:41','127.0.0.1'),
(40,'admin','2004-12-31 09:58:53','2005-01-24 20:37:47','127.0.0.1'),
(41,'local','2005-01-08 11:32:00','2005-01-08 11:32:15','162.105.250.3'),
(42,'gg','2005-01-10 12:41:28','0000-00-00 00:00:00','127.0.0.1'),
(43,'admin','2005-01-24 19:56:49','2005-01-24 20:37:47','127.0.0.1'),
(44,'admin','2005-01-24 20:57:53','2005-01-25 10:25:21','127.0.0.1'),
(45,'admin','2005-01-25 10:15:17','2005-01-25 10:25:21','127.0.0.1'),
(46,'admin','2005-01-25 10:25:46','0000-00-00 00:00:00','127.0.0.1');
/*
Table structure for messages
*/
drop table if exists `messages`;
CREATE TABLE `messages` (
`MesID` int(4) NOT NULL auto_increment,
`ToUser` varchar(20) NOT NULL default '',
`FromUser` varchar(20) NOT NULL default '',
`Time` time NOT NULL default '00:00:00',
`Content` varchar(255) default NULL,
`Color` varchar(20) default NULL,
PRIMARY KEY (`MesID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*
Table data for chatroom.messages
*/
INSERT INTO `messages` VALUES
(1,'所有人','管理员','16:10:00','[公告]:local光临聊天室',NULL),
(2,'All','local','20:14:00','sdfsf',NULL),
(3,'所有人','local','20:15:00','jkiojuwemlkmvsd',NULL),
(5,'所有人','local','20:16:00','jkiojuwemlkmvsd',NULL),
(6,'所有人','local','20:16:00','打发',NULL),
(30,'所有人','local','20:30:10','似的',NULL),
(31,'所有人','local','20:30:10','似的',NULL),
(45,'所有人','local','20:40:38','似的','#FF0000'),
(46,'所有人','local','20:40:40','似的','#FF0000'),
(47,'所有人','local','20:40:46','三大幅','#FF0000'),
(48,'所有人','local','20:40:50','三大幅','#800080'),
(51,'所有人','local','20:42:49','三大幅','#008000'),
(52,'所有人','管理员','21:12:00','[公告]:admin光临聊天室',NULL),
(66,'所有人','管理员','22:13:00','[公告]:[公告]:local被踢出聊天室!',NULL),
(67,'所有人','管理员','22:23:00','[公告]:萧红被踢出聊天室!','red'),
(68,'所有人','管理员','22:24:00','[公告]:萧红被踢出聊天室!','red'),
(69,'所有人','管理员','09:48:00','[公告]:admin退出聊天室!','red'),
(70,'所有人','管理员','09:56:00','[公告]:ls光临聊天室',NULL),
(71,'所有人','管理员','09:58:00','[公告]:ls退出聊天室!','red'),
(72,'所有人','管理员','09:58:00','[公告]:admin光临聊天室',NULL),
(73,'所有人','管理员','09:58:00','[公告]:ls被永久删除帐号!','red'),
(74,'所有人','管理员','11:32:00','[公告]:local光临聊天室',NULL),
(75,'所有人','local','11:32:11','good!'