USE rd;
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_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;