chatroom_backup.sql

php开发实例完全剖析

/* 
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!','#00CC00'),
(76,'所有人','管理员','11:32:00','[公告]:local退出聊天室！','red'),
(77,'所有人','管理员','12:41:00','[公告]:gg光临聊天室',NULL),
(78,'所有人','管理员','20:37:00','[公告]:admin退出聊天室！','red'),
(79,'所有人','管理员','10:25:00','[公告]:admin退出聊天室！','red'),
(80,'所有人','管理员','10:25:00','[公告]:退出聊天室！','red'),
(81,'所有人','admin','14:01:11','测试','#FF0000'),
(82,'所有人','admin','14:01:15','测试','#FF0000'),
(83,'所有人','admin','14:01:16','测试','#FF0000'),
(84,'所有人','admin','14:01:16','测试','#FF0000'),
(85,'所有人','admin','14:01:17','测试','#FF0000');

/*
Table structure for online
*/

drop table if exists `online`;
CREATE TABLE `online` (
  `OnID` int(4) NOT NULL auto_increment,
  `NickName` varchar(20) NOT NULL default '',
  `InTime` datetime default NULL,
  `IP` varchar(20) default NULL,
  PRIMARY KEY  (`OnID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for chatroom.online
*/

INSERT INTO `online` VALUES 
(44,'gg','2005-01-10 12:41:28','127.0.0.1'),
(48,'admin','2005-01-25 10:25:46','127.0.0.1');

/*
Table structure for regusers
*/

drop table if exists `regusers`;
CREATE TABLE `regusers` (
  `RegID` int(4) NOT NULL auto_increment,
  `NickName` varchar(20) NOT NULL default '',
  `Password` varchar(50) NOT NULL default '',
  `Email` varchar(30) default NULL,
  `RegTime` datetime default NULL,
  `IsKicked` tinyint(4) default NULL,
  PRIMARY KEY  (`RegID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*
Table data for chatroom.regusers
*/

INSERT INTO `regusers` VALUES 
(1,'萧红','e10adc3949ba59abbe56e057f20f883e','[e-mail]','2004-12-28 14:54:13',1),
(2,'local','e10adc3949ba59abbe56e057f20f883e','[e-mail]','2004-12-28 14:55:40',0),
(4,'admin','e10adc3949ba59abbe56e057f20f883e','[e-mail]','2004-12-29 21:11:26',NULL),
(6,'gg','e10adc3949ba59abbe56e057f20f883e','gg@g.g','2005-01-10 12:41:21',NULL);