--
-- Структура таблицы `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;