USE rd;
CREATE TABLE `adverts` (
  `ID` int(15) NOT NULL auto_increment,
  `area` varchar(255) NOT NULL default '',
  `subject` varchar(255) NOT NULL default '',
  `title` varchar(255) NOT NULL default '',
  `description` text NOT NULL,
  `price` varchar(255) NOT NULL default '',
  `contact` varchar(255) NOT NULL default '',
  `email` varchar(255) NOT NULL default '',
  `tel` varchar(255) NOT NULL default '',
  `photo` varchar(255) NOT NULL default '',
  `PWD` varchar(35) NOT NULL default '',
  `date` varchar(25) NOT NULL default '',
  `IP` varchar(255) NOT NULL default '',
  `verified` char(3) NOT NULL default '',
  `kill_status` char(3) NOT NULL default '',
  `kill_date` varchar(15) NOT NULL default '',
  `kill_IP` varchar(255) NOT NULL default '',
  KEY `ID` (`ID`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;
INSERT INTO `adverts` VALUES (7, 'Chow Gar', 'Chow1', 'Chow1', 'Chow1', 'Chow1', 'Chow1', 'Chow1', 'Chow1', '7.jpg', 'Chow1', '11 02 05 15:47:20', '127.0.0.1', 'Yes', 'Off', 'Open', '');
INSERT INTO `adverts` VALUES (6, 'General', 'General4', '', '', '', '', '', '', '6.jpg', '', '11 02 05 15:46:59', '127.0.0.1', 'Yes', 'Off', 'Open', '');
INSERT INTO `adverts` VALUES (5, 'General', 'General3', '', '', '', '', '', '', '5.jpg', '', '11 02 05 15:46:42', '127.0.0.1', 'Yes', 'Off', 'Open', '');
INSERT INTO `adverts` VALUES (4, 'General', 'General2', '', '', '', '', '', '', '4.jpg', '', '11 02 05 15:46:02', '127.0.0.1', 'Yes', 'Off', 'Open', '');
INSERT INTO `adverts` VALUES (3, 'General', 'General1', '', '', '', '', '', '', '3.jpg', '', '11 02 05 15:45:23', '127.0.0.1', 'Yes', 'Off', 'Open', '');
INSERT INTO `adverts` VALUES (8, 'General', 'aaaaaaaaaaa', '', '', '', '', '', '', '', '', '12 02 05 02:07:34', '127.0.0.1', 'Yes', 'Off', 'Open', '');
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'
) TYPE=MyISAM;
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
) TYPE=MyISAM;
INSERT INTO `c_messages` VALUES (1, 'Char-Gar', 'SYS enter', 0, 1108165067, '', 'sprintf(L_ENTER_ROM, "Brett")');
INSERT INTO `c_messages` VALUES (1, 'Char-Gar', 'SYS welcome', 0, 1108165068, 'Brett', 'sprintf("Welcome to our chat. Please obey the net etiquette while chatting: <I>try to be pleasant and polite</I>.")');
INSERT INTO `c_messages` VALUES (1, 'Char-Gar', 'Brett', 1, 1108165073, '', '<FONT COLOR="#000000">hello all</FONT>');
INSERT INTO `c_messages` VALUES (1, 'Char-Gar', 'Brett', 1, 1108165076, '', '<FONT COLOR="#000000">ddd</FONT>');
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'
) TYPE=MyISAM;
INSERT INTO `c_reg_users` VALUES ('Admin', 0, '817857b0693710898411438234078b55', 'Robert', 'Dawkins', 'English', 'www-chow-gar.com', 'rd018a2653@blueyonder.co.uk', 1, 'admin', '', 1107328530, '127.0.0.1', 1);
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`)
) TYPE=MyISAM;