CREATE TABLE `dle_chat` (
  `message_id` smallint(6) NOT NULL auto_increment,
  `author` varchar(255) NOT NULL default '',
  `author_group` mediumint(6) NOT NULL default '0',
  `message` tinytext NOT NULL,
  `color` varchar(255) NOT NULL default '',
  `font_style` varchar(255) NOT NULL default '',
  `time` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`message_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=5 ;


CREATE TABLE `dle_chat_log_dates` (
  `date` varchar(100) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;


CREATE TABLE `dle_chat_log_messages` (
  `id` tinyint(3) unsigned NOT NULL auto_increment,
  `date` varchar(100) NOT NULL default '',
  `file_adress` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=1 ;


CREATE TABLE `dle_chat_online` (
  `id` tinyint(6) NOT NULL auto_increment,
  `user_name` varchar(200) NOT NULL default '',
  `user_id` smallint(6) NOT NULL default '0',
  `time` datetime default NULL,
  `ip` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=10 ;