форум вебмастероff на AlfaSpace.NET

 
CREATE TABLE `chat_ban_list` ( 
`user_id` int(10) unsigned NOT NULL default '0', 
`chat_id` int(10) unsigned NOT NULL default '0', 
`ip` int(10) unsigned NOT NULL default '0', 
`time` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`chat_id`,`user_id`) 
) TYPE=MyISAM; 

CREATE TABLE `chat_messages` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`ip` int(10) unsigned NOT NULL default '0', 
`from_id` int(10) unsigned NOT NULL default '0', 
`to_id` int(10) unsigned NOT NULL default '0', 
`time` int(10) unsigned NOT NULL default '0', 
`title` varchar(255) NOT NULL default '', 
`msg` text NOT NULL, 
`is_new` tinyint(3) unsigned NOT NULL default '0', 
`is_del_from` tinyint(3) unsigned NOT NULL default '0', 
`is_del_to` tinyint(3) unsigned NOT NULL default '0', 
PRIMARY KEY  (`id`), 
KEY `from_id` (`from_id`), 
KEY `to_id` (`to_id`) 
) TYPE=MyISAM; 

CREATE TABLE `chat_moderators` ( 
`user_id` int(10) unsigned NOT NULL default '0', 
`chat_id` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`chat_id`,`user_id`) 
) TYPE=MyISAM; 

CREATE TABLE `chat_users` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`name` char(16) NOT NULL default '', 
`password` char(16) binary NOT NULL default '', 
`sex` char(1) NOT NULL default '', 
`ip` int(10) unsigned NOT NULL default '0', 
`tmp_id` int(10) unsigned NOT NULL default '0', 
`last_visit` int(10) unsigned NOT NULL default '0', 
`first_visit` int(10) unsigned NOT NULL default '0', 
`color` char(6) NOT NULL default '999999', 
`msg_order` tinyint(4) NOT NULL default '0', 
`font_size` tinyint(4) NOT NULL default '10', 
`visits_count` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`id`), 
UNIQUE KEY `name` (`name`) 
) TYPE=MyISAM; 

CREATE TABLE `chatrooms` ( 
`id` int(10) unsigned NOT NULL auto_increment, 
`title` char(255) NOT NULL default '', 
`last_visit` int(10) unsigned NOT NULL default '0', 
`users_count` int(10) unsigned NOT NULL default '0', 
PRIMARY KEY  (`id`) 
) TYPE=MyISAM;