-- MySQL dump 10.9
--
-- Host: localhost Database: chat
-- ------------------------------------------------------
-- Server version 4.1.12-Debian_1ubuntu3.1-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `c_ban_users`
--
DROP TABLE IF EXISTS `c_ban_users`;
CREATE TABLE `c_ban_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`rooms` varchar(100) NOT NULL default '',
`ban_until` int(11) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `c_ban_users`
--
/*!40000 ALTER TABLE `c_ban_users` DISABLE KEYS */;
LOCK TABLES `c_ban_users` WRITE;
UNLOCK TABLES;
/*!40000 ALTER TABLE `c_ban_users` ENABLE KEYS */;
--
-- Table structure for table `c_messages`
--
DROP TABLE IF EXISTS `c_messages`;
CREATE TABLE `c_messages` (
`type` tinyint(1) NOT NULL default '0',
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`m_time` int(11) NOT NULL default '0',
`address` varchar(30) NOT NULL default '',
`message` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `c_messages`
--
/*!40000 ALTER TABLE `c_messages` DISABLE KEYS */;
LOCK TABLES `c_messages` WRITE;
INSERT INTO `c_messages` VALUES (0,'303423d60c5b10f9','SYS enter',0,1144416911,'','sprintf(L_ENTER_ROM, \"T101\")'),(0,'303423d60c5b10f9','SYS welcome',0,1144416912,'T101','sprintf(\"Welcome to our chat. Please obey the net etiquette while chatting: try to be pleasant and polite.\")'),(0,'303423d60c5b10f9','SYS enter',0,1144417009,'','sprintf(L_ENTER_ROM, \"L101\")'),(0,'303423d60c5b10f9','SYS welcome',0,1144417010,'L101','sprintf(\"Welcome to our chat. Please obey the net etiquette while chatting: try to be pleasant and polite.\")'),(0,'303423d60c5b10f9','T101',1,1144417024,'','I have a son...'),(0,'303423d60c5b10f9','L101',1,1144417037,'','what is his name?');
UNLOCK TABLES;
/*!40000 ALTER TABLE `c_messages` ENABLE KEYS */;
--
-- Table structure for table `c_reg_users`
--
DROP TABLE IF EXISTS `c_reg_users`;
CREATE TABLE `c_reg_users` (
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`password` varchar(32) NOT NULL default '',
`firstname` varchar(64) NOT NULL default '',
`lastname` varchar(64) NOT NULL default '',
`country` varchar(64) NOT NULL default '',
`website` varchar(64) NOT NULL default '',
`email` varchar(64) NOT NULL default '',
`showemail` tinyint(1) NOT NULL default '0',
`perms` varchar(9) NOT NULL default '',
`rooms` varchar(128) NOT NULL default '',
`reg_time` int(11) NOT NULL default '0',
`ip` varchar(16) NOT NULL default '',
`gender` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `c_reg_users`
--
/*!40000 ALTER TABLE `c_reg_users` DISABLE KEYS */;
LOCK TABLES `c_reg_users` WRITE;
INSERT INTO `c_reg_users` VALUES ('admin',0,'8461311ab521d63b5bd7cdbd74f9393d','','','','','',0,'admin','',1137815474,'65.188.223.157',0),('T1',1,'ce499dea30cfce118f4fe85da0227e83','T1','T1','','','T1@home.com',0,'moderator','db2a33567a349ad5',1138043357,'204.156.77.13',0),('T2',1,'71d2c46af01feeea54a0f541243e297b','T2','T2','','','T2@home.com',0,'moderator','92ed4f1826c1ddef',1137988735,'65.188.223.157',0),('L1',1,'9ec4c0afd450ceac7adb81c3bcfc9732','L1','L1','','','L1@home.com',0,'user','',1137904795,'65.188.223.157',0),('L2',1,'7e6aa2d53f6ee2b1a34b017fa403cb76','L2','L2','','','L2@home.com',0,'user','',1137905025,'65.188.223.157',0),('T101',1,'4f46e4bd7742f9632b7e244be116893b','T101','T101','','','T101@home.com',0,'moderator','2957956d54bfb31a,3e44f9432975f6b9,4ed9da17fda698c0,a24f596fc3c1a1e4,5c92a30ae2ae294e,1702c8f430629456,fdcdcacde5e48552,da0522658',1144416911,'204.156.77.12',0),('L101',1,'d1f084ada920d832e3b7500487c5e4d6','L101','L101','','','L101@home.com',0,'moderator','669db6a85a548788,11c76c31a55c70f2,803987e708e93022,07a46ea941089857,84c9582eda6623ec',1144417009,'204.156.77.13',0),('T1003',1,'d387970359a2a24f54d024e29a87ec28','T1003','T1003','','','T1003@home.com',0,'moderator','0d77261909e51c60,205de712d6fc1cca,70bbe3cfeb8feaf2,ea9583db2e462dad,bfb6c775a1811e96,8698879d463ce980',1140315740,'70.176.237.35',0),('L1003',1,'dc42ea5e86574eef5d5fd8526fc72488','L1003','L1003','','','L1003@home.com',0,'user','',1140315553,'70.176.237.35',0),('T1006',1,'dd8f47feaf36e03c07bab9989f1a700e','T1006','T1006','','','T1006@home.com',0,'moderator','c294326eaa25e317,3cb31d806a42ed5f,9e4f168c6232a89a,989dd2af60a5cba7',1140057112,'70.176.237.35',0),('L1006',1,'4823186d8166b0fd4a0ee312707cf77c','L1006','L1006','','','L1006@home.com',0,'user','',1140057152,'70.176.237.35',0),('T2006',1,'f32dcaec29585fba54df2c7aac79f3bd','T2006','T2006','','','T2006@home.com',0,'moderator','6d141f1a0a563821',1139604011,'152.13.179.158',0),('L2006',1,'e2280e337a3420adfbc2d9e9e7fe42b6','L2006','L2006','','','L2006@home.com',0,'moderator','fdba3f354f3a73c5',1139604067,'152.13.179.158',0),('T2015',1,'dfaf550abae83750ed916414a3442531','T2015','T2015','','','T2015@home.com',0,'moderator','c63577bc65f80385,98489be63db5eb29',1139888471,'65.188.151.75',0),('L2015',1,'cf1b8ba8cca4a9905c622ba68de09172','L2015','L2015','','','L2015@home.com',0,'user','',1139887832,'65.188.151.75',0),('T2029',1,'e65178191c527db78c53d1695dc195dd','T2029','T2029','','','T2029@home.com',0,'moderator','1c32204b7d341e56,d023c5277e224df8',1139940533,'152.13.73.58',0),('L2029',1,'339cccbf70f1017293e44e607f72c19a','L2029','L2029','','','L2029@home.com',0,'user','',1139940586,'152.13.73.58',0),('T2007',1,'156cdbc862cbd0272b97cb0677301cda','T2007','T2007','','','T2007@home.com',0,'moderator','aad821c9f26fde8e,b7c605fd2e9da938,d9f97fb33fdbc2ed',1140066839,'152.13.135.98',0),('L2007',1,'c5391b3236672fe6209ad92728c2dbe2','L2007','L2007','','','L2007@home.com',0,'user','',1140066904,'152.13.135.98',0),('T2016',1,'dafae668a277e40ef016f90d69cc09da','T2016','T2016','','','T2016@home.com',0,'user','',1140093599,'65.188.223.157',0),('L2016',1,'a580993d66cbe18f2e3995da29f882c8','L2016','L2016','','','L2016@home.com',0,'user','',1140093639,'65.188.223.157',0),('T2013',1,'dc96bb2594566e5b694cce6647022c99','T2013','T2013','','','T2013@home.com',0,'moderator','0dd168ba5508841f,441cf4ee66d55de1,479da67aec56cdd8',1140100475,'152.13.73.116',0),('L2013',1,'ecb587567fa8a77c017184515f42262a','L2013','L2013','','','L2013@home.com',0,'user','',1140100501,'152.13.73.116',0),('T2043',1,'36115c92188ad64f4c6f7a0b9a831b23','T2043','T2043','','','T2043@home.com',0,'moderator','b7993f152b2086a0,88ef2e4f25495f89',1140103945,'152.13.73.66',0),('L2043',1,'3b979527f03f6b9ec258dfad0826f71d','L2043','L2043','','','L2043@home.com',0,'user','',1140103972,'152.13.73.66',0),('T2005',1,'aad866b14b2330efa91cf63049f9b8e0','T2005','T2005','','','T2005@home.com',0,'moderator','ae0a970b70ae3bdd,589a8a891857dd03',1140121527,'65.190.58.173',0),('L2005',1,'c782f10350f097c39004bf113815200f','L2005','L2005','','','L2005@home.com',0,'user','',1140121576,'65.190.58.173',0),('T1012',1,'f551738740676bcb489ce966d54d77b2','T1012','T1012','','','T1012@home.com',0,'moderator','3ad05a2140debbe3,e36fed7b669ecfa9,024555bda1f0fc60',1140402282,'65.188.209.82',0),('L1012',1,'f999a8be8df00bb6dff0b80b497b2f59','L1012','L1012','','','L1012@home.com',0,'user','',1140402328,'65.188.209.82',0);
UNLOCK TABLES;
/*!40000 ALTER TABLE `c_reg_users` ENABLE KEYS */;
--
-- Table structure for table `c_users`
--
DROP TABLE IF EXISTS `c_users`;
CREATE TABLE `c_users` (
`room` varchar(30) NOT NULL default '',
`username` varchar(30) NOT NULL default '',
`latin1` tinyint(1) NOT NULL default '0',
`u_time` int(11) NOT NULL default '0',
`status` char(1) NOT NULL default '',
`ip` varchar(16) NOT NULL default '',
UNIQUE KEY `room` (`room`,`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `c_users`
--
/*!40000 ALTER TABLE `c_users` DISABLE KEYS */;
LOCK TABLES `c_users` WRITE;
INSERT INTO `c_users` VALUES ('303423d60c5b10f9','T101',1,1144417198,'m','204.156.77.12'),('303423d60c5b10f9','L101',1,1144417088,'r','204.156.77.13');
UNLOCK TABLES;
/*!40000 ALTER TABLE `c_users` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;