--
-- Структура таблицы `admlog`
--
CREATE TABLE IF NOT EXISTS `admlog` (
  `admlog_id` int(11) unsigned NOT NULL auto_increment,
  `admlog_user` varchar(20) NOT NULL,
  `admlog_request` varchar(255) NOT NULL default '',
  `admlog_referer` varchar(255) NOT NULL default '',
  `admlog_ip` varchar(20) NOT NULL default '',
  `admlog_brow` varchar(25) NOT NULL default '',
  `admlog_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`admlog_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `advert`
--
CREATE TABLE IF NOT EXISTS `advert` (
  `adv_id` int(11) unsigned NOT NULL auto_increment,
  `adv_url` varchar(100) NOT NULL,
  `adv_title` varchar(100) NOT NULL,
  `adv_user` varchar(20) NOT NULL,
  PRIMARY KEY  (`adv_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `antimat`
--
CREATE TABLE IF NOT EXISTS `antimat` (
  `mat_id` int(11) unsigned NOT NULL auto_increment,
  `mat_string` varchar(100) NOT NULL,
  PRIMARY KEY  (`mat_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `avatars`
--
CREATE TABLE IF NOT EXISTS `avatars` (
  `avatars_id` int(11) unsigned NOT NULL auto_increment,
  `avatars_cats` smallint(4) unsigned NOT NULL,
  `avatars_name` varchar(20) NOT NULL,
  PRIMARY KEY  (`avatars_id`),
  KEY `avatars_cats` (`avatars_cats`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `ban`
--
CREATE TABLE IF NOT EXISTS `ban` (
  `ban_id` int(11) unsigned NOT NULL auto_increment,
  `ban_ip` varchar(20) NOT NULL,
  `ban_user` varchar(20) NOT NULL default '',
  `ban_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ban_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `bank`
--
CREATE TABLE IF NOT EXISTS `bank` (
  `bank_id` int(11) unsigned NOT NULL auto_increment,
  `bank_user` varchar(20) NOT NULL,
  `bank_sum` int(11) unsigned NOT NULL default '0',
  `bank_oper` int(11) unsigned NOT NULL default '0',
  `bank_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`bank_id`),
  UNIQUE KEY `bank_user` (`bank_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `blacklogin`
--
CREATE TABLE IF NOT EXISTS `blacklogin` (
  `black_id` int(11) unsigned NOT NULL auto_increment,
  `black_login` varchar(20) NOT NULL,
  `black_user` varchar(20) NOT NULL default '',
  `black_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`black_id`),
  KEY `black_login` (`black_login`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `blackmail`
--
CREATE TABLE IF NOT EXISTS `blackmail` (
  `black_id` int(11) unsigned NOT NULL auto_increment,
  `black_mail` varchar(50) NOT NULL,
  `black_user` varchar(20) NOT NULL default '',
  `black_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`black_id`),
  KEY `black_mail` (`black_mail`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `blogs`
--
CREATE TABLE IF NOT EXISTS `blogs` (
  `blogs_id` int(11) unsigned NOT NULL auto_increment,
  `blogs_cats_id` smallint(4) unsigned NOT NULL default '0',
  `blogs_user` varchar(20) NOT NULL,
  `blogs_title` varchar(50) NOT NULL,
  `blogs_text` text NOT NULL,
  `blogs_tags` varchar(100) NOT NULL,
  `blogs_rating` mediumint(8) NOT NULL default '0',
  `blogs_read` int(11) unsigned NOT NULL default '0',
  `blogs_comments` mediumint(8) unsigned NOT NULL default '0',
  `blogs_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`blogs_id`),
  KEY `blogs_user` (`blogs_user`),
  KEY `blogs_time` (`blogs_time`),
  KEY `blogs_cats_id` (`blogs_cats_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `catsblog`
--
CREATE TABLE IF NOT EXISTS `catsblog` (
  `cats_id` smallint(4) unsigned NOT NULL auto_increment,
  `cats_order` smallint(4) unsigned NOT NULL default '0',
  `cats_name` varchar(100) NOT NULL,
  `cats_count` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cats_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
  `chat_id` int(11) unsigned NOT NULL auto_increment,
  `chat_user` varchar(20) NOT NULL,
  `chat_text` text NOT NULL,
  `chat_ip` varchar(20) NOT NULL,
  `chat_brow` varchar(25) NOT NULL,
  `chat_time` int(11) unsigned NOT NULL,
  `chat_edit` varchar(20) NOT NULL default '',
  `chat_edit_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`chat_id`),
  KEY `chat_time` (`chat_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `commblog`
--
CREATE TABLE IF NOT EXISTS `commblog` (
  `commblog_id` int(11) unsigned NOT NULL auto_increment,
  `commblog_cats` smallint(4) unsigned NOT NULL,
  `commblog_blog` int(11) unsigned NOT NULL,
  `commblog_text` text NOT NULL,
  `commblog_author` varchar(20) NOT NULL,
  `commblog_time` int(11) unsigned NOT NULL default '0',
  `commblog_ip` varchar(20) NOT NULL,
  `commblog_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commblog_id`),
  KEY `commblog_blog` (`commblog_blog`),
  KEY `commblog_time` (`commblog_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `commnews`
--
CREATE TABLE IF NOT EXISTS `commnews` (
  `commnews_id` int(11) unsigned NOT NULL auto_increment,
  `commnews_news_id` mediumint(8) unsigned NOT NULL,
  `commnews_text` text NOT NULL,
  `commnews_author` varchar(20) NOT NULL,
  `commnews_time` int(11) unsigned NOT NULL,
  `commnews_ip` varchar(20) NOT NULL,
  `commnews_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commnews_id`),
  KEY `commnews_news_id` (`commnews_news_id`),
  KEY `commnews_time` (`commnews_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `commphoto`
--
CREATE TABLE IF NOT EXISTS `commphoto` (
  `commphoto_id` int(11) unsigned NOT NULL auto_increment,
  `commphoto_gid` mediumint(8) unsigned NOT NULL,
  `commphoto_text` text NOT NULL,
  `commphoto_user` varchar(20) NOT NULL,
  `commphoto_time` int(11) unsigned NOT NULL default '0',
  `commphoto_ip` varchar(20) NOT NULL,
  `commphoto_brow` varchar(25) NOT NULL,
  PRIMARY KEY  (`commphoto_id`),
  KEY `commphoto_gid` (`commphoto_gid`),
  KEY `commphoto_time` (`commphoto_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `contact`
--
CREATE TABLE IF NOT EXISTS `contact` (
  `contact_id` int(11) unsigned NOT NULL auto_increment,
  `contact_user` varchar(20) NOT NULL,
  `contact_name` varchar(20) NOT NULL,
  `contact_text` text NOT NULL,
  `contact_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`contact_id`),
  KEY `contact_user` (`contact_user`),
  KEY `contact_time` (`contact_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `counter`
--
CREATE TABLE IF NOT EXISTS `counter` (
  `count_id` tinyint(1) unsigned NOT NULL auto_increment,
  `count_hours` mediumint(8) unsigned NOT NULL,
  `count_days` mediumint(8) unsigned NOT NULL,
  `count_allhosts` int(11) unsigned NOT NULL,
  `count_allhits` int(11) unsigned NOT NULL,
  `count_dayhosts` mediumint(8) unsigned NOT NULL,
  `count_dayhits` mediumint(8) unsigned NOT NULL,
  `count_hosts24` mediumint(8) unsigned NOT NULL,
  `count_hits24` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `counter24`
--
CREATE TABLE IF NOT EXISTS `counter24` (
  `count_id` mediumint(8) unsigned NOT NULL auto_increment,
  `count_hour` mediumint(8) unsigned NOT NULL,
  `count_hosts` mediumint(8) unsigned NOT NULL,
  `count_hits` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `counter31`
--
CREATE TABLE IF NOT EXISTS `counter31` (
  `count_id` mediumint(8) unsigned NOT NULL auto_increment,
  `count_days` mediumint(8) unsigned NOT NULL,
  `count_hosts` mediumint(8) unsigned NOT NULL,
  `count_hits` mediumint(8) unsigned NOT NULL,
  PRIMARY KEY  (`count_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `error`
--
CREATE TABLE IF NOT EXISTS `error` (
  `error_id` int(11) unsigned NOT NULL auto_increment,
  `error_num` smallint(4) unsigned NOT NULL,
  `error_request` varchar(255) NOT NULL default '',
  `error_referer` varchar(255) NOT NULL default '',
  `error_username` varchar(20) NOT NULL default '',
  `error_ip` varchar(20) NOT NULL default '',
  `error_brow` varchar(25) NOT NULL default '',
  `error_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`error_id`),
  KEY `error_num` (`error_num`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `flood`
--
CREATE TABLE IF NOT EXISTS `flood` (
  `flood_id` int(11) unsigned NOT NULL auto_increment,
  `flood_user` varchar(20) NOT NULL,
  `flood_page` varchar(30) NOT NULL,
  `flood_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`flood_id`),
  KEY `flood_user` (`flood_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `forums`
--
CREATE TABLE IF NOT EXISTS `forums` (
  `forums_id` smallint(4) unsigned NOT NULL auto_increment,
  `forums_order` smallint(4) unsigned NOT NULL default '0',
  `forums_parent` smallint(4) unsigned NOT NULL default '0',
  `forums_title` varchar(100) NOT NULL,
  `forums_topics` int(11) unsigned NOT NULL default '0',
  `forums_posts` int(11) unsigned NOT NULL default '0',
  `forums_last_id` int(11) unsigned NOT NULL default '0',
  `forums_last_themes` varchar(100) NOT NULL default '',
  `forums_last_user` varchar(20) NOT NULL default '',
  `forums_last_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`forums_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `guest`
--
CREATE TABLE IF NOT EXISTS `guest` (
  `guest_id` int(11) unsigned NOT NULL auto_increment,
  `guest_user` varchar(20) NOT NULL,
  `guest_text` text NOT NULL,
  `guest_ip` varchar(20) NOT NULL,
  `guest_brow` varchar(25) NOT NULL,
  `guest_time` int(11) unsigned NOT NULL,
  `guest_reply` text NOT NULL,
  `guest_edit` varchar(20) NOT NULL default '',
  `guest_edit_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guest_id`),
  KEY `guest_time` (`guest_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `headers`
--
CREATE TABLE IF NOT EXISTS `headers` (
  `head_id` int(11) unsigned NOT NULL auto_increment,
  `head_url` varchar(100) NOT NULL,
  `head_title` varchar(100) NOT NULL,
  PRIMARY KEY  (`head_id`),
  KEY `head_url` (`head_url`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `ignore`
--
CREATE TABLE IF NOT EXISTS `ignore` (
  `ignore_id` int(11) unsigned NOT NULL auto_increment,
  `ignore_user` varchar(20) NOT NULL,
  `ignore_name` varchar(20) NOT NULL,
  `ignore_text` text NOT NULL,
  `ignore_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`ignore_id`),
  KEY `ignore_user` (`ignore_user`),
  KEY `ignore_time` (`ignore_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `inbox`
--
CREATE TABLE IF NOT EXISTS `inbox` (
  `inbox_id` int(11) unsigned NOT NULL auto_increment,
  `inbox_user` varchar(20) NOT NULL,
  `inbox_author` varchar(20) NOT NULL,
  `inbox_text` text NOT NULL,
  `inbox_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`inbox_id`),
  KEY `inbox_user` (`inbox_user`),
  KEY `inbox_time` (`inbox_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `lotinfo`
--
CREATE TABLE IF NOT EXISTS `lotinfo` (
  `lot_id` int(11) unsigned NOT NULL auto_increment,
  `lot_date` smallint(4) unsigned NOT NULL,
  `lot_sum` int(11) unsigned NOT NULL default '0',
  `lot_newnum` smallint(4) unsigned NOT NULL default '0',
  `lot_oldnum` smallint(4) unsigned NOT NULL default '0',
  `lot_winners` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`lot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `lotusers`
--
CREATE TABLE IF NOT EXISTS `lotusers` (
  `lot_id` int(11) unsigned NOT NULL auto_increment,
  `lot_user` varchar(20) NOT NULL,
  `lot_num` smallint(4) unsigned NOT NULL default '0',
  `lot_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`lot_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `navigation`
--
CREATE TABLE IF NOT EXISTS `navigation` (
  `nav_id` int(11) unsigned NOT NULL auto_increment,
  `nav_url` varchar(100) NOT NULL,
  `nav_title` varchar(100) NOT NULL,
  `nav_order` smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`nav_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `news`
--
CREATE TABLE IF NOT EXISTS `news` (
  `news_id` mediumint(8) unsigned NOT NULL auto_increment,
  `news_title` varchar(100) NOT NULL,
  `news_text` text NOT NULL,
  `news_author` varchar(20) NOT NULL,
  `news_time` int(11) unsigned NOT NULL default '0',
  `news_comments` mediumint(8) unsigned NOT NULL default '0',
  `news_closed` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`news_id`),
  KEY `news_time` (`news_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `notebook`
--
CREATE TABLE IF NOT EXISTS `notebook` (
  `note_id` int(11) unsigned NOT NULL auto_increment,
  `note_user` varchar(20) NOT NULL,
  `note_text` text NOT NULL,
  `note_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`note_id`),
  UNIQUE KEY `note_user` (`note_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `online`
--
CREATE TABLE IF NOT EXISTS `online` (
  `online_id` bigint(20) unsigned NOT NULL auto_increment,
  `online_ip` varchar(20) NOT NULL,
  `online_brow` varchar(25) NOT NULL,
  `online_time` int(11) unsigned NOT NULL,
  `online_user` varchar(20) NOT NULL default '',
  PRIMARY KEY  (`online_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `outbox`
--
CREATE TABLE IF NOT EXISTS `outbox` (
  `outbox_id` int(11) unsigned NOT NULL auto_increment,
  `outbox_user` varchar(20) NOT NULL,
  `outbox_author` varchar(20) NOT NULL,
  `outbox_text` text NOT NULL,
  `outbox_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`outbox_id`),
  KEY `outbox_user` (`outbox_user`),
  KEY `outbox_time` (`outbox_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `photo`
--
CREATE TABLE IF NOT EXISTS `photo` (
  `photo_id` mediumint(8) unsigned NOT NULL auto_increment,
  `photo_user` varchar(20) NOT NULL,
  `photo_title` varchar(50) NOT NULL,
  `photo_text` text NOT NULL,
  `photo_link` varchar(50) NOT NULL,
  `photo_time` int(11) unsigned NOT NULL,
  `photo_rating` mediumint(8) NOT NULL default '0',
  `photo_closed` tinyint(1) unsigned NOT NULL default '0',
  `photo_comments` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`photo_id`),
  KEY `photo_user` (`photo_user`),
  KEY `photo_time` (`photo_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `posts`
--
CREATE TABLE IF NOT EXISTS `posts` (
  `posts_id` int(11) unsigned NOT NULL auto_increment,
  `posts_forums_id` smallint(4) unsigned NOT NULL,
  `posts_topics_id` mediumint(8) unsigned NOT NULL,
  `posts_user` varchar(20) NOT NULL,
  `posts_text` text NOT NULL,
  `posts_time` int(11) unsigned NOT NULL,
  `posts_ip` varchar(20) NOT NULL,
  `posts_brow` varchar(25) NOT NULL,
  `posts_edit` varchar(20) NOT NULL default '',
  `posts_edit_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`posts_id`),
  KEY `posts_topics_id` (`posts_topics_id`),
  KEY `posts_time` (`posts_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `pyramid`
--
CREATE TABLE IF NOT EXISTS `pyramid` (
  `pyramid_id` int(11) unsigned NOT NULL auto_increment,
  `pyramid_link` varchar(50) NOT NULL,
  `pyramid_name` varchar(50) NOT NULL,
  `pyramid_user` varchar(20) NOT NULL,
  PRIMARY KEY  (`pyramid_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `ratedblog`
--
CREATE TABLE IF NOT EXISTS `ratedblog` (
  `rated_id` int(11) unsigned NOT NULL auto_increment,
  `rated_blog` int(11) unsigned NOT NULL,
  `rated_user` varchar(20) NOT NULL,
  `rated_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`rated_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `ratedphoto`
--
CREATE TABLE IF NOT EXISTS `ratedphoto` (
  `rated_id` int(11) unsigned NOT NULL auto_increment,
  `rated_photo` int(11) unsigned NOT NULL,
  `rated_user` varchar(20) NOT NULL,
  `rated_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`rated_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `rating`
--
CREATE TABLE IF NOT EXISTS `rating` (
  `rating_id` int(11) unsigned NOT NULL auto_increment,
  `rating_user` varchar(20) NOT NULL,
  `rating_login` varchar(20) NOT NULL,
  `rating_vote` tinyint(1) unsigned NOT NULL,
  `rating_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`rating_id`),
  KEY `rating_user` (`rating_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `readblog`
--
CREATE TABLE IF NOT EXISTS `readblog` (
  `read_id` int(11) unsigned NOT NULL auto_increment,
  `read_blog` int(11) unsigned NOT NULL,
  `read_ip` varchar(20) NOT NULL,
  `read_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`read_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;


--
-- Структура таблицы `rekuser`
--
CREATE TABLE IF NOT EXISTS `rekuser` (
  `rek_id` int(11) unsigned NOT NULL auto_increment,
  `rek_site` varchar(50) NOT NULL,
  `rek_name` varchar(50) NOT NULL,
  `rek_color` varchar(10) NOT NULL default '',
  `rek_bold` tinyint(1) unsigned NOT NULL default '0',
  `rek_user` varchar(20) NOT NULL,
  `rek_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`rek_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `setting`
--
CREATE TABLE IF NOT EXISTS `setting` (
  `setting_name` varchar(25) NOT NULL,
  `setting_value` varchar(255) NOT NULL,
  PRIMARY KEY  (`setting_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Структура таблицы `smiles`
--
CREATE TABLE IF NOT EXISTS `smiles` (
  `smiles_id` int(11) unsigned NOT NULL auto_increment,
  `smiles_cats` smallint(4) unsigned NOT NULL,
  `smiles_name` varchar(20) NOT NULL,
  `smiles_code` varchar(20) NOT NULL,
  PRIMARY KEY  (`smiles_id`),
  KEY `smiles_cats` (`smiles_cats`),
  KEY `smiles_code` (`smiles_code`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `spam`
--
CREATE TABLE IF NOT EXISTS `spam` (
  `spam_id` int(11) unsigned NOT NULL auto_increment,
  `spam_key` tinyint(1) unsigned NOT NULL,
  `spam_idnum` int(11) unsigned NOT NULL,
  `spam_user` varchar(20) NOT NULL,
  `spam_login` varchar(20) NOT NULL,
  `spam_text` text NOT NULL,
  `spam_time` int(11) unsigned NOT NULL,
  `spam_addtime` int(11) unsigned NOT NULL,
  `spam_link` varchar(100) NOT NULL,
  PRIMARY KEY  (`spam_id`),
  KEY `spam_key` (`spam_key`),
  KEY `spam_time` (`spam_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `status`
--
CREATE TABLE IF NOT EXISTS `status` (
  `status_id` int(11) unsigned NOT NULL auto_increment,
  `status_topoint` mediumint(8) unsigned NOT NULL,
  `status_point` mediumint(8) unsigned NOT NULL,
  `status_name` varchar(50) NOT NULL,
  `status_color` varchar(10) NOT NULL default '',
  PRIMARY KEY  (`status_id`),
  KEY `status_topoint` (`status_topoint`),
  KEY `status_point` (`status_point`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `topics`
--
CREATE TABLE IF NOT EXISTS `topics` (
  `topics_id` mediumint(8) unsigned NOT NULL auto_increment,
  `topics_forums_id` smallint(4) unsigned NOT NULL,
  `topics_title` varchar(100) NOT NULL,
  `topics_author` varchar(20) NOT NULL,
  `topics_closed` tinyint(1) unsigned NOT NULL default '0',
  `topics_locked` tinyint(1) unsigned NOT NULL default '0',
  `topics_posts` int(11) unsigned NOT NULL default '0',
  `topics_last_user` varchar(20) NOT NULL default '',
  `topics_last_time` int(11) unsigned NOT NULL default '0',
  `topics_mod` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`topics_id`),
  KEY `topics_forums_id` (`topics_forums_id`),
  KEY `topics_locked` (`topics_locked`),
  KEY `topics_last_time` (`topics_last_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `trash`
--
CREATE TABLE IF NOT EXISTS `trash` (
  `trash_id` int(11) unsigned NOT NULL auto_increment,
  `trash_user` varchar(20) NOT NULL,
  `trash_author` varchar(20) NOT NULL,
  `trash_text` text NOT NULL,
  `trash_time` int(11) unsigned NOT NULL,
  `trash_del` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`trash_id`),
  KEY `trash_user` (`trash_user`),
  KEY `trash_time` (`trash_time`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `users`
--
CREATE TABLE IF NOT EXISTS `users` (
  `users_id` int(11) unsigned NOT NULL auto_increment,
  `users_login` varchar(20) character set utf8 collate utf8_bin NOT NULL,
  `users_pass` varchar(40) NOT NULL,
  `users_email` varchar(50) NOT NULL,
  `users_joined` int(11) unsigned NOT NULL,
  `users_level` smallint(4) unsigned NOT NULL default '107',
  `users_nickname` varchar(20) NOT NULL default '',
  `users_name` varchar(20) NOT NULL default '',
  `users_country` varchar(30) NOT NULL default '',
  `users_city` varchar(50) NOT NULL default '',
  `users_info` text NOT NULL,
  `users_note` text NOT NULL,
  `users_site` varchar(50) NOT NULL default '',
  `users_icq` int(10) unsigned NOT NULL default '0',
  `users_jabber` varchar(50) NOT NULL default '',
  `users_gender` varchar(1) NOT NULL default '',
  `users_birthday` varchar(10) NOT NULL default '',
  `users_visits` int(11) unsigned NOT NULL default '0',
  `users_newprivat` smallint(4) unsigned NOT NULL default '0',
  `users_newwall` smallint(4) unsigned NOT NULL default '0',
  `users_allforum` int(11) unsigned NOT NULL default '0',
  `users_allguest` int(11) unsigned NOT NULL default '0',
  `users_allcomments` int(11) unsigned NOT NULL default '0',
  `users_themes` varchar(20) NOT NULL default '',
  `users_postguest` smallint(4) unsigned NOT NULL default '0',
  `users_postnews` smallint(4) unsigned NOT NULL default '0',
  `users_postprivat` smallint(4) unsigned NOT NULL default '0',
  `users_postforum` smallint(4) unsigned NOT NULL default '0',
  `users_themesforum` smallint(4) unsigned NOT NULL default '0',
  `users_postboard` smallint(4) unsigned NOT NULL default '0',
  `users_timezone` varchar(3) NOT NULL default '0',
  `users_showtime` tinyint(1) unsigned NOT NULL default '0',
  `users_bbpanel` tinyint(1) unsigned NOT NULL default '0',
  `users_point` int(11) unsigned NOT NULL default '0',
  `users_money` int(11) unsigned NOT NULL default '0',
  `users_ban` tinyint(1) unsigned NOT NULL default '0',
  `users_timeban` int(11) unsigned NOT NULL default '0',
  `users_timelastban` int(11) unsigned NOT NULL default '0',
  `users_reasonban` text NOT NULL,
  `users_loginsendban` varchar(20) NOT NULL default '',
  `users_totalban` tinyint(2) unsigned NOT NULL default '0',
  `users_explainban` tinyint(1) unsigned NOT NULL default '0',
  `users_status` varchar(50) NOT NULL default '',
  `users_avatar` varchar(50) NOT NULL default '',
  `users_picture` varchar(50) NOT NULL default '',
  `users_rating` mediumint(8) NOT NULL default '0',
  `users_posrating` mediumint(8) unsigned NOT NULL default '0',
  `users_negrating` mediumint(8) unsigned NOT NULL default '0',
  `users_keypasswd` varchar(20) NOT NULL default '',
  `users_timepasswd` int(11) unsigned NOT NULL default '0',
  `users_timelastlogin` int(11) unsigned NOT NULL default '0',
  `users_confirmreg` tinyint(1) unsigned NOT NULL default '0',
  `users_confirmregkey` varchar(30) NOT NULL default '',
  `users_secquest` varchar(50) NOT NULL default '',
  `users_secanswer` varchar(40) NOT NULL default '',
  `users_sumcredit` int(11) unsigned NOT NULL default '0',
  `users_timecredit` int(11) unsigned NOT NULL default '0',
  `users_timeaddlist` int(11) unsigned NOT NULL default '0',
  `users_timenickname` int(11) unsigned NOT NULL default '0',
  `users_ipbinding` tinyint(1) unsigned NOT NULL default '0',
  `users_navigation` tinyint(1) unsigned NOT NULL default '0',
  `users_person` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`users_id`),
  UNIQUE KEY `users_login` (`users_login`),
  KEY `users_level` (`users_level`),
  KEY `users_email` (`users_email`),
  KEY `users_nickname` (`users_nickname`),
  KEY `users_themes` (`users_themes`),
  KEY `users_point` (`users_point`),
  KEY `users_money` (`users_money`),
  KEY `users_rating` (`users_rating`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `visit`
--
CREATE TABLE IF NOT EXISTS `visit` (
  `visit_id` int(11) unsigned NOT NULL auto_increment,
  `visit_user` varchar(20) NOT NULL,
  `visit_self` varchar(255) NOT NULL default '',
  `visit_ip` varchar(20) NOT NULL default '',
  `visit_count` int(11) unsigned NOT NULL default '0',
  `visit_allcount` int(11) unsigned NOT NULL default '0',
  `visit_nowtime` int(11) unsigned NOT NULL default '0',
  `visit_alltime` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`visit_id`),
  UNIQUE KEY `visit_user` (`visit_user`),
  KEY `visit_nowtime` (`visit_nowtime`),
  KEY `visit_alltime` (`visit_alltime`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `vote`
--
CREATE TABLE IF NOT EXISTS `vote` (
  `vote_id` smallint(4) unsigned NOT NULL auto_increment,
  `vote_title` varchar(100) NOT NULL,
  `vote_count` smallint(4) unsigned NOT NULL default '0',
  `vote_closed` tinyint(1) unsigned NOT NULL default '0',
  `vote_time` int(11) unsigned NOT NULL default '0',
  PRIMARY KEY  (`vote_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `voteanswer`
--
CREATE TABLE IF NOT EXISTS `voteanswer` (
  `answer_id` mediumint(8) unsigned NOT NULL auto_increment,
  `answer_vote_id` smallint(4) unsigned NOT NULL,
  `answer_option` varchar(50) NOT NULL,
  `answer_result` smallint(4) unsigned NOT NULL default '0',
  PRIMARY KEY  (`answer_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `votepoll`
--
CREATE TABLE IF NOT EXISTS `votepoll` (
  `poll_id` int(11) unsigned NOT NULL auto_increment,
  `poll_vote_id` smallint(4) unsigned NOT NULL,
  `poll_user` varchar(20) NOT NULL,
  PRIMARY KEY  (`poll_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

--
-- Структура таблицы `wall`
--
CREATE TABLE IF NOT EXISTS `wall` (
  `wall_id` int(11) unsigned NOT NULL auto_increment,
  `wall_user` varchar(20) NOT NULL,
  `wall_login` varchar(20) NOT NULL,
  `wall_text` text NOT NULL,
  `wall_time` int(11) unsigned NOT NULL,
  PRIMARY KEY  (`wall_id`),
  KEY `wall_user` (`wall_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
