root/sql.sql

-- phpMyAdmin SQL Dump
-- version 3.3.7
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Янв 28 2011 г., 14:47
-- Версия сервера: 5.1.40
-- Версия PHP: 5.3.3

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- База данных: `test`
--

-- --------------------------------------------------------

--
-- Структура таблицы `banlist`
--

DROP TABLE IF EXISTS `banlist`;
CREATE TABLE IF NOT EXISTS `banlist` (
  `ban_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `ban_userid` mediumint(8) NOT NULL DEFAULT '0',
  `ban_ip` varchar(16) DEFAULT '',
  `ban_email` varchar(255) DEFAULT NULL,
  `ban_added` int(11) NOT NULL DEFAULT '0',
  `ban_until` int(11) NOT NULL DEFAULT '0',
  `ban_type` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ban_id`),
  KEY `ban_ip_user_id` (`ban_ip`,`ban_userid`),
  KEY `ban_type` (`ban_type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `banlist`
--


-- --------------------------------------------------------

--
-- Структура таблицы `bookmarks`
--

DROP TABLE IF EXISTS `bookmarks`;
CREATE TABLE IF NOT EXISTS `bookmarks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `torrentid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `bookmarks`
--


-- --------------------------------------------------------

--
-- Структура таблицы `categories`
--

DROP TABLE IF EXISTS `categories`;
CREATE TABLE IF NOT EXISTS `categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `cat_parent_id` int(10) DEFAULT NULL,
  `torrents_limit` int(11) DEFAULT '0',
  `anonymous_view` tinyint(1) DEFAULT '1',
  `allow_upload` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `categories`
--


-- --------------------------------------------------------

--
-- Структура таблицы `chat_messages`
--

DROP TABLE IF EXISTS `chat_messages`;
CREATE TABLE IF NOT EXISTS `chat_messages` (
  `chat_msg_id` int(10) NOT NULL AUTO_INCREMENT,
  `chat_uid` int(10) NOT NULL DEFAULT '0',
  `chat_msg` text NOT NULL,
  `chat_msg_added` int(11) NOT NULL DEFAULT '0',
  `chat_user_ip` varchar(16) NOT NULL DEFAULT '',
  PRIMARY KEY (`chat_msg_id`),
  KEY `chat_uid` (`chat_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `chat_messages`
--


-- --------------------------------------------------------

--
-- Структура таблицы `cheaters`
--

DROP TABLE IF EXISTS `cheaters`;
CREATE TABLE IF NOT EXISTS `cheaters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` int(11) DEFAULT '0',
  `userid` int(10) DEFAULT '0',
  `torrentid` int(10) DEFAULT '0',
  `che_useragent` varchar(60) DEFAULT NULL,
  `che_peer_id` blob,
  `rate` int(11) DEFAULT '0',
  `beforeup` bigint(20) DEFAULT '0',
  `upthis` bigint(20) DEFAULT '0',
  `timediff` varchar(255) DEFAULT NULL,
  `userip` varchar(16) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `torrentid` (`torrentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `cheaters`
--


-- --------------------------------------------------------

--
-- Структура таблицы `checkcomm`
--

DROP TABLE IF EXISTS `checkcomm`;
CREATE TABLE IF NOT EXISTS `checkcomm` (
  `checkcomm_userid` int(10) DEFAULT '0',
  `checkcomm_notify_status` tinyint(1) DEFAULT '0',
  `checkcomm_view_status` tinyint(1) NOT NULL DEFAULT '0',
  `checkcomm_for_id` int(10) DEFAULT '0',
  `checkcomm_type` tinyint(1) DEFAULT '0',
  `checkcomm_last_comment_id` int(10) DEFAULT '0',
  KEY `userid` (`checkcomm_userid`),
  KEY `checkcomm_last_comment_id` (`checkcomm_last_comment_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `checkcomm`
--


-- --------------------------------------------------------

--
-- Структура таблицы `comments`
--

DROP TABLE IF EXISTS `comments`;
CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `comment_user` int(10) unsigned DEFAULT '0',
  `comment_added` int(11) DEFAULT '0',
  `comment_text` text,
  `comment_editedby` int(10) unsigned DEFAULT '0',
  `comment_editedat` int(11) DEFAULT '0',
  `comment_type` tinyint(1) DEFAULT '0',
  `comment_for_id` int(10) DEFAULT '0',
  `comment_reputation` int(10) DEFAULT '0',
  PRIMARY KEY (`comment_id`),
  KEY `user` (`comment_user`),
  KEY `comment_for_id` (`comment_for_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `comments`
--


-- --------------------------------------------------------

--
-- Структура таблицы `config`
--

DROP TABLE IF EXISTS `config`;
CREATE TABLE IF NOT EXISTS `config` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `value` varchar(255) DEFAULT NULL,
  `is_dynamic` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`name`),
  KEY `is_dynamic` (`is_dynamic`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `config`
--

INSERT INTO `config` (`name`, `value`, `is_dynamic`) VALUES
('siteonline', '1', 0),
('onlinesince', UNIX_TIMESTAMP(NOW()), 0),
('sitename', '', 0),
('autoclean_last_run_clean_peers', '1296214237', 1),
('sitemail', '', 0),
('max_torrent_size', '100000000', 0),
('announce_interval', '1800', 0),
('min_announce_interval', '1740', 0),
('signup_timeout', '1', 0),
('minvotes', '5', 0),
('ttl', '0', 0),
('maxusers', '100000', 0),
('torrent_dir', '/torrents', 0),
('user_limit_ary_torrents', 'a:10:{s:1:"W";i:1;s:1:"D";i:10;i:0;i:0;i:1;i:5;i:2;i:10;i:3;i:20;i:4;i:0;i:5;i:0;i:6;i:0;i:7;i:0;}', 0),
('merge_time', '24', 0),
('site_desc', '', 0),
('cookie_name', 'tbdev_sz', 0),
('cookie_path', '/', 0),
('cookie_domain', '', 0),
('cookie_secure', '0', 0),
('session_length', '3600', 0),
('allow_html', '0', 0),
('allow_html_tags', 'b,i,u,pre', 0),
('allow_bbcode', '1', 0),
('allow_smilies', '1', 0),
('allow_sig', '0', 0),
('email_function_name', 'mail', 0),
('allow_avatar_local', '0', 0),
('allow_avatar_remote', '1', 0),
('allow_avatar_upload', '1', 0),
('enable_confirm', '0', 0),
('allow_autologin', '1', 0),
('max_autologin_time', '60', 0),
('override_user_style', '0', 0),
('posts_per_page', '15', 0),
('topics_per_page', '50', 0),
('hot_threshold', '25', 0),
('max_poll_options', '20', 0),
('max_sig_chars', '255', 0),
('max_inbox_privmsgs', '30', 0),
('max_sentbox_privmsgs', '30', 0),
('max_savebox_privmsgs', '50', 0),
('board_email_sig', '', 0),
('smtp_delivery', '0', 0),
('smtp_host', '', 0),
('smtp_username', '', 0),
('smtp_password', '', 0),
('sendmail_fix', '0', 0),
('flood_interval', '15', 0),
('avatar_filesize', '153600', 0),
('avatar_max_width', '100', 0),
('avatar_max_height', '100', 0),
('avatar_path', 'pic/avatars', 0),
('avatar_gallery_path', 'images/avatars/gallery', 0),
('smilies_path', 'pic/smilies', 0),
('default_style', '1', 0),
('default_dateformat', 'Y-m-d H:i', 0),
('board_timezone', '0', 0),
('prune_enable', '1', 0),
('privmsg_disable', '0', 0),
('gzip_compress', '0', 0),
('record_online_users', '0', 1),
('record_online_date', '0', 1),
('server_name', '', 0),
('server_port', '', 0),
('script_path', '', 0),
('version', '0.3.4svn324', 0),
('default_lang', 'english', 0),
('max_login_attempts', '5', 0),
('login_reset_time', '30', 0),
('online_time', '300', 0),
('time_to_merge', '24', 0),
('merge_flood_interval', '5', 0),
('search_flood_interval', '0', 0),
('rand_seed', '8fa36961e6c15829e3cbda4392c9a836', 1),
('search_min_chars', '3', 0),
('inactive_users_del_days', '0', 0),
('postimg_width', '500', 0),
('postimg_height', '300', 0),
('alternate_ttl', '0', 0),
('board_dst', '0', 0),
('waittime', '0', 0),
('tpl_allow_php', '1', 0),
('smtp_port', '25', 0),
('allow_invite', '0', 0),
('autoclean_interval_receive_invites', '0', 0),
('number_invites', '', 0),
('allow_autowarn', '0', 0),
('autowarn_settings', '', 0),
('activate_via_email', '1', 0),
('allow_clons', '1', 0),
('autowarn_min_added', '0', 0),
('demote_uploader_days', '0', 0),
('allow_my_bonus', '0', 0),
('my_bonus_points', '0', 0),
('my_bonus_settings', '', 0),
('my_bonus_title_length', '0', 0),
('check_dnsbl', '0', 0),
('email_enable', '1', 0),
('email_package_size', '100', 0),
('max_warn_for_user', '4', 0),
('captcha_width', '250', 0),
('captcha_height', '60', 0),
('captcha_example_code', 'SAMPLE', 0),
('captcha_background_color', '#E5ECF9', 0),
('captcha_jpeg', '0', 0),
('captcha_jpeg_quality', '50', 0),
('captcha_pre_letters', '0', 0),
('captcha_pre_letters_great', '0', 0),
('captcha_font', '0', 0),
('captcha_trans_letters', '0', 0),
('captcha_chess', '0', 0),
('captcha_ellipses', '0', 0),
('captcha_arcs', '0', 0),
('captcha_lines', '0', 0),
('captcha_image', '0', 0),
('captcha_bg_transition', '25', 0),
('captcha_gammacorrect', '0.8', 0),
('captcha_foreground_lattice_width', '0', 0),
('captcha_foreground_lattice_height', '0', 0),
('captcha_lattice_color', '#FFFFFF', 0),
('max_register_attempts_per_session', '3', 0),
('uploadapp_promote_text', '', 0),
('max_torrent_allow_seed', '10', 0),
('uploader_promoted_demote_days', '0', 0),
('uploadapp_delete_records_days', '0', 0),
('uploadapp_min_uploaded', '0', 0),
('uploadapp_min_added', '0', 0),
('uploadapp_min_ratio', '0', 0),
('show_online_users', '0', 0),
('server_protocol', '', 0),
('force_server_vars', '0', 0),
('inactive_users_del_min_class', '0', 0),
('inactive_users_parked_del_days', '0', 0),
('promote_to_power_megs_limit', '0', 0),
('promote_to_power_min_ratio', '0', 0),
('promote_to_power_reg_date_ago', '0', 0),
('promote_to_power_demote_ratio', '0', 0),
('autoclean_interval_clean_peers', '30', 0),
('autoclean_interval_sync_torrents_info', '30', 0),
('autoclean_interval_clean_pending_accounts', '1440', 0),
('autoclean_interval_clean_inactive_users', '3600', 0),
('autoclean_interval_clean_old_torrents', '1440', 0),
('autoclean_interval_autowarn_autodemote', '1440', 0),
('autoclean_interval_demote_uploaders', '3600', 0),
('autoclean_interval_remove_expired_warnings', '60', 0),
('autoclean_interval_parse_queue', '10', 0),
('autoclean_interval_tidy_cache', '10', 0),
('autoclean_last_run_sync_torrents_info', '1277214019', 1),
('autoclean_last_run_clean_pending_accounts', '1296214237', 1),
('autoclean_last_run_clean_inactive_users', '1296214237', 1),
('autoclean_last_run_clean_old_torrents', '1296214237', 1),
('autoclean_last_run_autowarn_autodemote', '1296214237', 1),
('autoclean_last_run_remove_expired_warnings', '1296214237', 1),
('autoclean_last_run_demote_uploaders', '1296214237', 1),
('autoclean_last_run_receive_invites', '0', 1),
('autoclean_last_run_parse_queue', '1296214237', 1),
('autoclean_last_run_tidy_cache', '1296214237', 1),
('autoclean_interval_promote_demote_users', '1440', 0),
('autoclean_last_run_promote_demote_users', '1296214237', 1),
('user_limit_ary_allow_download', 'a:10:{s:1:"W";i:1;s:1:"D";i:1;i:0;i:0;i:1;i:1;i:2;i:1;i:3;i:1;i:4;i:1;i:5;i:1;i:6;i:1;i:7;i:1;}', 0),
('min_seeders_for_sos_button', '3', 0),
('min_class_allow_upload', '4', 0),
('default_type_moderated_torrents', '2', 0),
('site_keywords', '', 0),
('autoclean_interval_delete_old_sessions', '10', 0),
('autoclean_last_run_delete_old_sessions', '1296214237', 1),
('cleanup_lock', '0', 1),
('offline_text', '', 0),
('count_helpdesk_not_solved', '0', 1),
('count_reports_not_solved', '0', 1),
('count_candidates_waiting', '0', 1),
('points_settings', '', 0),
('tags_max_allow', '10', 0),
('tags_max_length', '50', 0),
('tags_min_length', '3', 0),
('load_db_lastread', '0', 0),
('load_anon_lastread', '1', 0),
('load_db_track', '0', 0),
('anonymous_announce', '1', 0),
('smtp_auth_method', '', 0);

-- --------------------------------------------------------

--
-- Структура таблицы `confirm`
--

DROP TABLE IF EXISTS `confirm`;
CREATE TABLE IF NOT EXISTS `confirm` (
  `confirm_id` char(32) NOT NULL DEFAULT '',
  `session_id` char(32) NOT NULL DEFAULT '',
  `code` char(10) DEFAULT NULL,
  PRIMARY KEY (`session_id`,`confirm_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `confirm`
--


-- --------------------------------------------------------

--
-- Структура таблицы `countries`
--

DROP TABLE IF EXISTS `countries`;
CREATE TABLE IF NOT EXISTS `countries` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL,
  `flagpic` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=108 ;

--
-- Дамп данных таблицы `countries`
--

INSERT INTO `countries` (`id`, `name`, `flagpic`) VALUES
(1, 'Sweden', 'sweden.gif'),
(2, 'United States of America', 'usa.gif'),
(3, 'Russia', 'russia.gif'),
(4, 'Finland', 'finland.gif'),
(5, 'Canada', 'canada.gif'),
(6, 'France', 'france.gif'),
(7, 'Germany', 'germany.gif'),
(8, 'China', 'china.gif'),
(9, 'Italy', 'italy.gif'),
(10, 'Denmark', 'denmark.gif'),
(11, 'Norway', 'norway.gif'),
(12, 'United Kingdom', 'uk.gif'),
(13, 'Ireland', 'ireland.gif'),
(14, 'Poland', 'poland.gif'),
(15, 'Netherlands', 'netherlands.gif'),
(16, 'Belgium', 'belgium.gif'),
(17, 'Japan', 'japan.gif'),
(18, 'Brazil', 'brazil.gif'),
(19, 'Argentina', 'argentina.gif'),
(20, 'Australia', 'australia.gif'),
(21, 'New Zealand', 'newzealand.gif'),
(23, 'Spain', 'spain.gif'),
(24, 'Portugal', 'portugal.gif'),
(25, 'Mexico', 'mexico.gif'),
(26, 'Singapore', 'singapore.gif'),
(70, 'India', 'india.gif'),
(65, 'Albania', 'albania.gif'),
(29, 'South Africa', 'southafrica.gif'),
(30, 'South Korea', 'southkorea.gif'),
(31, 'Jamaica', 'jamaica.gif'),
(32, 'Luxembourg', 'luxembourg.gif'),
(33, 'Hong Kong', 'hongkong.gif'),
(34, 'Belize', 'belize.gif'),
(35, 'Algeria', 'algeria.gif'),
(36, 'Angola', 'angola.gif'),
(37, 'Austria', 'austria.gif'),
(38, 'Yugoslavia', 'yugoslavia.gif'),
(39, 'Western Samoa', 'westernsamoa.gif'),
(40, 'Malaysia', 'malaysia.gif'),
(41, 'Dominican Republic', 'dominicanrep.gif'),
(42, 'Greece', 'greece.gif'),
(43, 'Guatemala', 'guatemala.gif'),
(44, 'Israel', 'israel.gif'),
(45, 'Pakistan', 'pakistan.gif'),
(46, 'Czech Republic', 'czechrep.gif'),
(47, 'Serbia', 'serbia.gif'),
(48, 'Seychelles', 'seychelles.gif'),
(49, 'Taiwan', 'taiwan.gif'),
(50, 'Puerto Rico', 'puertorico.gif'),
(51, 'Chile', 'chile.gif'),
(52, 'Cuba', 'cuba.gif'),
(53, 'Congo', 'congo.gif'),
(54, 'Afghanistan', 'afghanistan.gif'),
(55, 'Turkey', 'turkey.gif'),
(56, 'Uzbekistan', 'uzbekistan.gif'),
(57, 'Switzerland', 'switzerland.gif'),
(58, 'Kiribati', 'kiribati.gif'),
(59, 'Philippines', 'philippines.gif'),
(60, 'Burkina Faso', 'burkinafaso.gif'),
(61, 'Nigeria', 'nigeria.gif'),
(62, 'Iceland', 'iceland.gif'),
(63, 'Nauru', 'nauru.gif'),
(64, 'Slovenia', 'slovenia.gif'),
(66, 'Turkmenistan', 'turkmenistan.gif'),
(67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif'),
(68, 'Andorra', 'andorra.gif'),
(69, 'Lithuania', 'lithuania.gif'),
(71, 'Netherlands Antilles', 'nethantilles.gif'),
(72, 'Ukraine', 'ukraine.gif'),
(73, 'Venezuela', 'venezuela.gif'),
(74, 'Hungary', 'hungary.gif'),
(75, 'Romania', 'romania.gif'),
(76, 'Vanuatu', 'vanuatu.gif'),
(77, 'Vietnam', 'vietnam.gif'),
(78, 'Trinidad & Tobago', 'trinidadandtobago.gif'),
(79, 'Honduras', 'honduras.gif'),
(80, 'Kyrgyzstan', 'kyrgyzstan.gif'),
(81, 'Ecuador', 'ecuador.gif'),
(82, 'Bahamas', 'bahamas.gif'),
(83, 'Peru', 'peru.gif'),
(84, 'Cambodia', 'cambodia.gif'),
(85, 'Barbados', 'barbados.gif'),
(86, 'Bangladesh', 'bangladesh.gif'),
(87, 'Laos', 'laos.gif'),
(88, 'Uruguay', 'uruguay.gif'),
(89, 'Antigua Barbuda', 'antiguabarbuda.gif'),
(90, 'Paraguay', 'paraguay.gif'),
(93, 'Thailand', 'thailand.gif'),
(92, 'Union of Soviet Socialist Republics', 'ussr.gif'),
(94, 'Senegal', 'senegal.gif'),
(95, 'Togo', 'togo.gif'),
(96, 'North Korea', 'northkorea.gif'),
(97, 'Croatia', 'croatia.gif'),
(98, 'Estonia', 'estonia.gif'),
(99, 'Colombia', 'colombia.gif'),
(100, 'Lebanon', 'lebanon.gif'),
(101, 'Latvia', 'latvia.gif'),
(102, 'Costa Rica', 'costarica.gif'),
(103, 'Egypt', 'egypt.gif'),
(104, 'Bulgaria', 'bulgaria.gif'),
(105, 'Isla de Muerte', 'jollyroger.gif'),
(106, 'Belarus', 'belarus.gif'),
(107, 'Kazakhstan', 'kazakhstan.gif');

-- --------------------------------------------------------

--
-- Структура таблицы `disallow`
--

DROP TABLE IF EXISTS `disallow`;
CREATE TABLE IF NOT EXISTS `disallow` (
  `disallow_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `disallow_username` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`disallow_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `disallow`
--


-- --------------------------------------------------------

--
-- Структура таблицы `files`
--

DROP TABLE IF EXISTS `files`;
CREATE TABLE IF NOT EXISTS `files` (
  `torrent` int(10) unsigned DEFAULT '0',
  `filename` text,
  `size` bigint(20) unsigned DEFAULT '0',
  KEY `torrent` (`torrent`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `files`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_auth_access`
--

DROP TABLE IF EXISTS `forum_auth_access`;
CREATE TABLE IF NOT EXISTS `forum_auth_access` (
  `group_id` mediumint(8) DEFAULT '0',
  `forum_id` smallint(5) unsigned DEFAULT '0',
  `auth_view` tinyint(1) DEFAULT '0',
  `auth_read` tinyint(1) DEFAULT '0',
  `auth_post` tinyint(1) DEFAULT '0',
  `auth_reply` tinyint(1) DEFAULT '0',
  `auth_edit` tinyint(1) DEFAULT '0',
  `auth_delete` tinyint(1) DEFAULT '0',
  `auth_sticky` tinyint(1) DEFAULT '0',
  `auth_announce` tinyint(1) DEFAULT '0',
  `auth_vote` tinyint(1) DEFAULT '0',
  `auth_pollcreate` tinyint(1) DEFAULT '0',
  `auth_attachments` tinyint(1) DEFAULT '0',
  `auth_mod` tinyint(1) DEFAULT '0',
  KEY `group_id` (`group_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_auth_access`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_categories`
--

DROP TABLE IF EXISTS `forum_categories`;
CREATE TABLE IF NOT EXISTS `forum_categories` (
  `cat_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `cat_title` varchar(100) DEFAULT NULL,
  `cat_order` mediumint(8) unsigned DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `cat_order` (`cat_order`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `forum_categories`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_forums`
--

DROP TABLE IF EXISTS `forum_forums`;
CREATE TABLE IF NOT EXISTS `forum_forums` (
  `forum_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `cat_id` mediumint(8) unsigned DEFAULT '0',
  `forum_name` varchar(150) DEFAULT NULL,
  `forum_desc` text,
  `forum_status` tinyint(4) DEFAULT '0',
  `forum_order` mediumint(8) unsigned DEFAULT '1',
  `forum_posts` mediumint(8) unsigned DEFAULT '0',
  `forum_topics` mediumint(8) unsigned DEFAULT '0',
  `forum_last_post_id` mediumint(8) unsigned DEFAULT '0',
  `prune_next` int(11) DEFAULT NULL,
  `prune_enable` tinyint(1) DEFAULT '0',
  `auth_view` tinyint(2) DEFAULT '0',
  `auth_read` tinyint(2) DEFAULT '0',
  `auth_post` tinyint(2) DEFAULT '0',
  `auth_reply` tinyint(2) DEFAULT '0',
  `auth_edit` tinyint(2) DEFAULT '0',
  `auth_delete` tinyint(2) DEFAULT '0',
  `auth_sticky` tinyint(2) DEFAULT '0',
  `auth_announce` tinyint(2) DEFAULT '0',
  `auth_vote` tinyint(2) DEFAULT '0',
  `auth_pollcreate` tinyint(2) DEFAULT '0',
  `auth_attachments` tinyint(2) DEFAULT '0',
  `forum_parent` int(11) DEFAULT '0',
  `forum_last_post_time` int(11) DEFAULT '0',
  PRIMARY KEY (`forum_id`),
  KEY `forums_order` (`forum_order`),
  KEY `cat_id` (`cat_id`),
  KEY `forum_last_post_id` (`forum_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_forums`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_groups`
--

DROP TABLE IF EXISTS `forum_groups`;
CREATE TABLE IF NOT EXISTS `forum_groups` (
  `group_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `group_type` tinyint(4) DEFAULT '1',
  `group_name` varchar(40) DEFAULT NULL,
  `group_description` varchar(255) DEFAULT NULL,
  `group_moderator` mediumint(8) DEFAULT '0',
  `group_single_user` tinyint(1) DEFAULT '1',
  PRIMARY KEY (`group_id`),
  KEY `group_single_user` (`group_single_user`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=388 ;

--
-- Дамп данных таблицы `forum_groups`
--

INSERT INTO `forum_groups` (`group_id`, `group_type`, `group_name`, `group_description`, `group_moderator`, `group_single_user`) VALUES
(385, 1, '', '', 1, 0),
(56, 1, '', '', 1, 0),
(7, 1, '', '', 1, 0),
(387, 1, '', '', 1, 0),
(55, 1, '', '', 1, 0),
(6, 1, '', '', 1, 0),
(386, 1, 'VIP', '', 1, 0),
(1, 1, 'Anonymous', 'Personal User', 1, 0),
(2, 1, 'Admin', 'Personal User', 1, 0),
(126, 1, '', 'Personal User', 1, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `forum_posts`
--

DROP TABLE IF EXISTS `forum_posts`;
CREATE TABLE IF NOT EXISTS `forum_posts` (
  `post_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` mediumint(8) unsigned DEFAULT '0',
  `forum_id` smallint(5) unsigned DEFAULT '0',
  `poster_id` mediumint(8) DEFAULT '0',
  `post_time` int(11) DEFAULT '0',
  `post_created` int(11) DEFAULT '0',
  `poster_ip` varchar(16) DEFAULT NULL,
  `post_username` varchar(25) DEFAULT NULL,
  `enable_bbcode` tinyint(1) DEFAULT '1',
  `enable_html` tinyint(1) DEFAULT '0',
  `enable_smilies` tinyint(1) DEFAULT '1',
  `enable_sig` tinyint(1) DEFAULT '1',
  `post_edit_time` int(11) DEFAULT NULL,
  `post_edit_count` smallint(5) unsigned DEFAULT '0',
  `post_reputation` int(10) DEFAULT '0',
  PRIMARY KEY (`post_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_id` (`topic_id`),
  KEY `poster_id` (`poster_id`),
  KEY `post_time` (`post_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `forum_posts`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_posts_text`
--

DROP TABLE IF EXISTS `forum_posts_text`;
CREATE TABLE IF NOT EXISTS `forum_posts_text` (
  `post_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `post_subject` varchar(255) DEFAULT NULL,
  `post_text` mediumtext,
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_posts_text`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_prune`
--

DROP TABLE IF EXISTS `forum_prune`;
CREATE TABLE IF NOT EXISTS `forum_prune` (
  `prune_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `forum_id` smallint(5) unsigned DEFAULT '0',
  `prune_days` smallint(5) unsigned DEFAULT '0',
  `prune_freq` smallint(5) unsigned DEFAULT '0',
  PRIMARY KEY (`prune_id`),
  KEY `forum_id` (`forum_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `forum_prune`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_search_results`
--

DROP TABLE IF EXISTS `forum_search_results`;
CREATE TABLE IF NOT EXISTS `forum_search_results` (
  `search_id` int(11) unsigned NOT NULL DEFAULT '0',
  `session_id` varchar(32) DEFAULT NULL,
  `search_array` longtext,
  `search_time` int(11) DEFAULT '0',
  PRIMARY KEY (`search_id`),
  KEY `session_id` (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_search_results`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_search_wordlist`
--

DROP TABLE IF EXISTS `forum_search_wordlist`;
CREATE TABLE IF NOT EXISTS `forum_search_wordlist` (
  `word_text` varchar(50) NOT NULL DEFAULT '',
  `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `word_common` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`word_text`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `forum_search_wordlist`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_search_wordmatch`
--

DROP TABLE IF EXISTS `forum_search_wordmatch`;
CREATE TABLE IF NOT EXISTS `forum_search_wordmatch` (
  `post_id` mediumint(8) unsigned DEFAULT '0',
  `word_id` mediumint(8) unsigned DEFAULT '0',
  `title_match` tinyint(1) DEFAULT '0',
  KEY `post_id` (`post_id`),
  KEY `word_id` (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_search_wordmatch`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_topics`
--

DROP TABLE IF EXISTS `forum_topics`;
CREATE TABLE IF NOT EXISTS `forum_topics` (
  `topic_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `forum_id` smallint(8) unsigned DEFAULT '0',
  `topic_title` varchar(255) DEFAULT NULL,
  `topic_poster` mediumint(8) DEFAULT '0',
  `topic_time` int(11) DEFAULT '0',
  `topic_views` mediumint(8) unsigned DEFAULT '0',
  `topic_replies` mediumint(8) unsigned DEFAULT '0',
  `topic_status` tinyint(3) DEFAULT '0',
  `topic_vote` tinyint(1) DEFAULT '0',
  `topic_type` tinyint(3) DEFAULT '0',
  `topic_first_post_id` mediumint(8) unsigned DEFAULT '0',
  `topic_first_post_sticky` tinyint(1) DEFAULT '0',
  `topic_last_post_id` mediumint(8) unsigned DEFAULT '0',
  `topic_moved_id` mediumint(8) unsigned DEFAULT '0',
  `topic_last_post_time` int(11) DEFAULT '0',
  PRIMARY KEY (`topic_id`),
  KEY `forum_id` (`forum_id`),
  KEY `topic_moved_id` (`topic_moved_id`),
  KEY `topic_status` (`topic_status`),
  KEY `topic_type` (`topic_type`),
  KEY `topic_last_post_id` (`topic_last_post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `forum_topics`
--


-- --------------------------------------------------------

--
-- Структура таблицы `forum_user_group`
--

DROP TABLE IF EXISTS `forum_user_group`;
CREATE TABLE IF NOT EXISTS `forum_user_group` (
  `group_id` mediumint(8) DEFAULT '0',
  `user_id` mediumint(8) DEFAULT '0',
  `user_pending` tinyint(1) DEFAULT NULL,
  KEY `group_id` (`group_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `forum_user_group`
--

INSERT INTO `forum_user_group` (`group_id`, `user_id`, `user_pending`) VALUES
(1, 0, 0),
(6, 1, 0),
(7, 1, 0),
(55, 1, 0),
(56, 1, 0),
(126, 1, 0),
(385, 1, 0),
(386, 1, 0),
(387, 1, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `friends`
--

DROP TABLE IF EXISTS `friends`;
CREATE TABLE IF NOT EXISTS `friends` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `friendid` int(10) unsigned DEFAULT '0',
  `blockid` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `friends`
--


-- --------------------------------------------------------

--
-- Структура таблицы `helpdesk`
--

DROP TABLE IF EXISTS `helpdesk`;
CREATE TABLE IF NOT EXISTS `helpdesk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(60) DEFAULT NULL,
  `msg_problem` text,
  `added` int(11) DEFAULT '0',
  `solved_date` int(11) DEFAULT '0',
  `solved` tinyint(1) DEFAULT '0',
  `added_by` int(10) DEFAULT '0',
  `solved_by` int(10) DEFAULT '0',
  `msg_answer` text,
  UNIQUE KEY `id` (`id`),
  KEY `added_by` (`added_by`),
  KEY `solved_by` (`solved_by`),
  KEY `solved` (`solved`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `helpdesk`
--


-- --------------------------------------------------------

--
-- Структура таблицы `indexreleases`
--

DROP TABLE IF EXISTS `indexreleases`;
CREATE TABLE IF NOT EXISTS `indexreleases` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(250) DEFAULT NULL,
  `cover` varchar(250) DEFAULT NULL,
  `description` text,
  `torrent_id` int(10) DEFAULT '0',
  `forum_link` mediumint(8) DEFAULT '0',
  `imdb_link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `torrent_id` (`torrent_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `indexreleases`
--


-- --------------------------------------------------------

--
-- Структура таблицы `invites`
--

DROP TABLE IF EXISTS `invites`;
CREATE TABLE IF NOT EXISTS `invites` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `invite_user` int(10) unsigned DEFAULT '0',
  `invite_email` varchar(255) DEFAULT NULL,
  `hash` varchar(32) DEFAULT NULL,
  `added` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `invite_user` (`invite_user`),
  KEY `invite_email` (`invite_email`),
  KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `invites`
--


-- --------------------------------------------------------

--
-- Структура таблицы `messages`
--

DROP TABLE IF EXISTS `messages`;
CREATE TABLE IF NOT EXISTS `messages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sender` int(10) unsigned DEFAULT '0',
  `receiver` int(10) unsigned DEFAULT '0',
  `added` int(11) DEFAULT '0',
  `subject` varchar(255) DEFAULT NULL,
  `msg` text,
  `unread` tinyint(1) DEFAULT '1',
  `location` tinyint(1) DEFAULT '1',
  `saved` tinyint(1) DEFAULT '0',
  `reply_to` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `receiver` (`receiver`),
  KEY `sender` (`sender`),
  KEY `location` (`location`),
  KEY `reply_to` (`reply_to`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `messages`
--


-- --------------------------------------------------------

--
-- Структура таблицы `news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE IF NOT EXISTS `news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(11) DEFAULT '0',
  `added` int(11) DEFAULT '0',
  `body` text,
  `title` varchar(255) DEFAULT NULL,
  `news_announce_time` int(4) DEFAULT '0',
  `news_announce_user_classes` varchar(255) DEFAULT NULL,
  `news_comments` int(10) DEFAULT '0',
  `news_disable_comments` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `news`
--


-- --------------------------------------------------------

--
-- Структура таблицы `offers`
--

DROP TABLE IF EXISTS `offers`;
CREATE TABLE IF NOT EXISTS `offers` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `name` varchar(225) DEFAULT NULL,
  `descr` text,
  `added` int(11) DEFAULT '0',
  `category` int(11) DEFAULT '0',
  `comments` int(11) DEFAULT '0',
  `votes` smallint(10) DEFAULT '0',
  `filled` int(10) unsigned DEFAULT '0',
  `filledby` int(10) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`),
  KEY `filledby` (`filledby`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `offers`
--


-- --------------------------------------------------------

--
-- Структура таблицы `offers_votes`
--

DROP TABLE IF EXISTS `offers_votes`;
CREATE TABLE IF NOT EXISTS `offers_votes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `offerid` int(10) unsigned DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `offers_votes`
--


-- --------------------------------------------------------

--
-- Структура таблицы `peers`
--

DROP TABLE IF EXISTS `peers`;
CREATE TABLE IF NOT EXISTS `peers` (
  `fid` int(10) unsigned DEFAULT '0',
  `peer_id` blob,
  `ip` varchar(16) DEFAULT NULL,
  `port` smallint(5) unsigned DEFAULT '0',
  `uploaded` bigint(20) unsigned DEFAULT '0',
  `downloaded` bigint(20) unsigned DEFAULT '0',
  `left` bigint(20) unsigned DEFAULT '0',
  `started` int(11) DEFAULT '0',
  `mtime` int(11) DEFAULT '0',
  `uid` int(10) unsigned DEFAULT '0',
  `useragent` varchar(60) DEFAULT NULL,
  `downspeed` bigint(20) unsigned DEFAULT '0',
  `upspeed` bigint(20) unsigned DEFAULT '0',
  `announced` int(11) DEFAULT '0',
  `completed` int(11) DEFAULT '0',
  `active` tinyint(4) DEFAULT '0',
  UNIQUE KEY `fid_uid` (`fid`,`uid`),
  KEY `peer_id` (`peer_id`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `peers`
--


-- --------------------------------------------------------

--
-- Структура таблицы `ranks`
--

DROP TABLE IF EXISTS `ranks`;
CREATE TABLE IF NOT EXISTS `ranks` (
  `rank_id` int(10) NOT NULL AUTO_INCREMENT,
  `rank_name` varchar(255) NOT NULL,
  `rank_points` int(10) NOT NULL,
  `rank_image` varchar(255) NOT NULL,
  `rank_level` int(10) NOT NULL DEFAULT '0',
  `rank_simpaty_limit` int(3) NOT NULL DEFAULT '0',
  PRIMARY KEY (`rank_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `ranks`
--

INSERT INTO `ranks` (`rank_id`, `rank_name`, `rank_points`, `rank_image`, `rank_level`, `rank_simpaty_limit`) VALUES
(1, 'Base Rank', 0, '', 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `ratings`
--

DROP TABLE IF EXISTS `ratings`;
CREATE TABLE IF NOT EXISTS `ratings` (
  `torrent` int(10) unsigned NOT NULL DEFAULT '0',
  `user` int(10) unsigned NOT NULL DEFAULT '0',
  `rating` tinyint(3) unsigned DEFAULT '0',
  PRIMARY KEY (`torrent`,`user`),
  KEY `user` (`user`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `ratings`
--


-- --------------------------------------------------------

--
-- Структура таблицы `release_groups`
--

DROP TABLE IF EXISTS `release_groups`;
CREATE TABLE IF NOT EXISTS `release_groups` (
  `group_id` smallint(5) NOT NULL AUTO_INCREMENT,
  `pic_url` varchar(100) DEFAULT NULL,
  `group_name` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `release_groups`
--


-- --------------------------------------------------------

--
-- Структура таблицы `reports`
--

DROP TABLE IF EXISTS `reports`;
CREATE TABLE IF NOT EXISTS `reports` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `addedby` int(10) unsigned DEFAULT '0',
  `votedfor` int(10) unsigned DEFAULT '0',
  `type` tinyint(1) DEFAULT '0',
  `reason` varchar(255) DEFAULT NULL,
  `dealtby` int(10) unsigned DEFAULT '0',
  `dealtwith` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `dealtwith` (`dealtwith`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `reports`
--


-- --------------------------------------------------------

--
-- Структура таблицы `requests`
--

DROP TABLE IF EXISTS `requests`;
CREATE TABLE IF NOT EXISTS `requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `userid` int(10) unsigned DEFAULT '0',
  `request` varchar(225) DEFAULT NULL,
  `descr` text,
  `added` int(11) DEFAULT '0',
  `hits` int(10) unsigned DEFAULT '0',
  `filled` int(10) unsigned DEFAULT '0',
  `comments` int(10) unsigned DEFAULT '0',
  `cat` int(10) unsigned DEFAULT '0',
  `filledby` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `requests`
--


-- --------------------------------------------------------

--
-- Структура таблицы `requests_votes`
--

DROP TABLE IF EXISTS `requests_votes`;
CREATE TABLE IF NOT EXISTS `requests_votes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `requestid` int(10) unsigned DEFAULT '0',
  `userid` int(10) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `requests_votes`
--


-- --------------------------------------------------------

--
-- Структура таблицы `sessions`
--

DROP TABLE IF EXISTS `sessions`;
CREATE TABLE IF NOT EXISTS `sessions` (
  `session_id` varchar(32) NOT NULL DEFAULT '',
  `session_user_id` mediumint(8) DEFAULT '0',
  `session_start` int(11) DEFAULT '0',
  `session_time` int(11) DEFAULT '0',
  `session_ip` varchar(16) DEFAULT NULL,
  `session_page` varchar(255) DEFAULT NULL,
  `session_logged_in` tinyint(1) DEFAULT '0',
  `session_admin` tinyint(2) DEFAULT '0',
  PRIMARY KEY (`session_id`),
  KEY `session_user_id` (`session_user_id`),
  KEY `session_ip` (`session_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы `sessions_keys`
--

DROP TABLE IF EXISTS `sessions_keys`;
CREATE TABLE IF NOT EXISTS `sessions_keys` (
  `key_id` varchar(32) NOT NULL DEFAULT '',
  `user_id` mediumint(8) NOT NULL DEFAULT '0',
  `last_ip` varchar(16) DEFAULT NULL,
  `last_login` int(11) DEFAULT '0',
  PRIMARY KEY (`key_id`,`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- --------------------------------------------------------

--
-- Структура таблицы `simpaty`
--

DROP TABLE IF EXISTS `simpaty`;
CREATE TABLE IF NOT EXISTS `simpaty` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `touserid` int(10) unsigned DEFAULT '0',
  `fromuserid` int(10) unsigned DEFAULT '0',
  `simpaty` tinyint(1) DEFAULT '0',
  `type` tinyint(1) DEFAULT '0',
  `simpid` int(10) DEFAULT '0',
  `respect_time` int(11) DEFAULT '0',
  `description` text,
  PRIMARY KEY (`id`),
  KEY `touserid` (`touserid`),
  KEY `fromuserid` (`fromuserid`),
  KEY `simpid` (`simpid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `simpaty`
--


-- --------------------------------------------------------

--
-- Структура таблицы `sitelog`
--

DROP TABLE IF EXISTS `sitelog`;
CREATE TABLE IF NOT EXISTS `sitelog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `added` int(11) DEFAULT '0',
  `txt` text,
  `log_view_level` tinyint(2) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `added` (`added`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `sitelog`
--


-- --------------------------------------------------------

--
-- Структура таблицы `smilies`
--

DROP TABLE IF EXISTS `smilies`;
CREATE TABLE IF NOT EXISTS `smilies` (
  `smilies_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `smile_url` varchar(100) DEFAULT NULL,
  `emoticon` varchar(75) DEFAULT NULL,
  PRIMARY KEY (`smilies_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=178 ;

--
-- Дамп данных таблицы `smilies`
--

INSERT INTO `smilies` (`smilies_id`, `code`, `smile_url`, `emoticon`) VALUES
(1, ':-)', 'smile1.gif', 'smile1'),
(2, ':smile:', 'smile2.gif', 'smile2'),
(3, ':-D', 'grin.gif', 'grin'),
(4, ':lol:', 'laugh.gif', 'laugh'),
(5, ':w00t:', 'w00t.gif', 'w00t'),
(6, ':-P', 'tongue.gif', 'tongue'),
(7, ';-)', 'wink.gif', 'wink'),
(8, ':-|', 'noexpression.gif', 'noexpression'),
(9, ':-/', 'confused.gif', 'confused'),
(10, ':-(', 'sad.gif', 'sad'),
(11, ':''-(', 'cry.gif', ''),
(12, ':weep:', 'weep.gif', 'weep'),
(13, ':-O', 'ohmy.gif', 'ohmy'),
(14, ':o)', 'clown.gif', 'clown'),
(15, '8-)', 'cool1.gif', 'cool1'),
(16, '|-)', 'sleeping.gif', 'sleeping'),
(17, ':innocent:', 'innocent.gif', 'innocent'),
(18, ':whistle:', 'whistle.gif', 'whistle'),
(19, ':unsure:', 'unsure.gif', 'unsure'),
(20, ':closedeyes:', 'closedeyes.gif', 'closedeyes'),
(21, ':cool:', 'cool2.gif', 'cool2'),
(22, ':fun:', 'fun.gif', 'fun'),
(23, ':thumbsup:', 'thumbsup.gif', 'thumbsup'),
(24, ':thumbsdown:', 'thumbsdown.gif', 'thumbsdown'),
(25, ':blush:', 'blush.gif', 'blush'),
(26, ':yes:', 'yes.gif', 'yes'),
(27, ':no:', 'no.gif', 'no'),
(28, ':love:', 'love.gif', 'love'),
(29, ':?:', 'question.gif', 'question'),
(30, ':!:', 'excl.gif', 'excl'),
(31, ':idea:', 'idea.gif', 'idea'),
(32, ':arrow:', 'arrow.gif', 'arrow'),
(33, ':arrow2:', 'arrow2.gif', 'arrow2'),
(34, ':hmm:', 'hmm.gif', 'hmm'),
(35, ':hmmm:', 'hmmm.gif', 'hmmm'),
(36, ':huh:', 'huh.gif', 'huh'),
(37, ':geek:', 'geek.gif', 'geek'),
(38, ':look:', 'look.gif', 'look'),
(39, ':rolleyes:', 'rolleyes.gif', 'rolleyes'),
(40, ':kiss:', 'kiss.gif', 'kiss'),
(41, ':shifty:', 'shifty.gif', 'shifty'),
(42, ':blink:', 'blink.gif', 'blink'),
(43, ':smartass:', 'smartass.gif', 'smartass'),
(44, ':sick:', 'sick.gif', 'sick'),
(45, ':crazy:', 'crazy.gif', 'crazy'),
(46, ':wacko:', 'wacko.gif', 'wacko'),
(47, ':alien:', 'alien.gif', 'alien'),
(48, ':wizard:', 'wizard.gif', 'wizard'),
(49, ':wave:', 'wave.gif', 'wave'),
(50, ':wavecry:', 'wavecry.gif', 'wavecry'),
(51, ':baby:', 'baby.gif', 'baby'),
(52, ':angry:', 'angry.gif', 'angry'),
(53, ':ras:', 'ras.gif', 'ras'),
(54, ':sly:', 'sly.gif', 'sly'),
(55, ':devil:', 'devil.gif', 'devil'),
(56, ':evil:', 'evil.gif', 'evil'),
(57, ':evilmad:', 'evilmad.gif', 'evilmad'),
(58, ':sneaky:', 'sneaky.gif', 'sneaky'),
(59, ':axe:', 'axe.gif', 'axe'),
(60, ':slap:', 'slap.gif', 'slap'),
(61, ':wall:', 'wall.gif', 'wall'),
(62, ':rant:', 'rant.gif', 'rant'),
(63, ':jump:', 'jump.gif', 'jump'),
(64, ':yucky:', 'yucky.gif', 'yucky'),
(65, ':nugget:', 'nugget.gif', 'nugget'),
(66, ':smart:', 'smart.gif', 'smart'),
(67, ':shutup:', 'shutup.gif', 'shutup'),
(68, ':shutup2:', 'shutup2.gif', 'shutup2'),
(69, ':crockett:', 'crockett.gif', 'crockett'),
(70, ':zorro:', 'zorro.gif', 'zorro'),
(71, ':snap:', 'snap.gif', 'snap'),
(72, ':beer:', 'beer.gif', 'beer'),
(73, ':beer2:', 'beer2.gif', 'beer2'),
(74, ':drunk:', 'drunk.gif', 'drunk'),
(75, ':strongbench:', 'strongbench.gif', 'strongbench'),
(76, ':weakbench:', 'weakbench.gif', 'weakbench'),
(77, ':dumbells:', 'dumbells.gif', 'dumbells'),
(78, ':music:', 'music.gif', 'music'),
(79, ':stupid:', 'stupid.gif', 'stupid'),
(80, ':dots:', 'dots.gif', 'dots'),
(81, ':offtopic:', 'offtopic.gif', 'offtopic'),
(82, ':spam:', 'spam.gif', ''),
(83, ':oops:', 'oops.gif', 'oops'),
(84, ':lttd:', 'lttd.gif', 'lttd'),
(85, ':please:', 'please.gif', 'please'),
(86, ':sorry:', 'sorry.gif', ''),
(87, ':hi:', 'hi.gif', ''),
(88, ':yay:', 'yay.gif', 'yay'),
(89, ':cake:', 'cake.gif', 'cake'),
(90, ':hbd:', 'hbd.gif', ''),
(91, ':band:', 'band.gif', 'band'),
(92, ':punk:', 'punk.gif', 'punk'),
(93, ':rofl:', 'rofl.gif', 'rofl'),
(94, ':bounce:', 'bounce.gif', 'bounce'),
(95, ':mbounce:', 'mbounce.gif', 'mbounce'),
(96, ':thankyou:', 'thankyou.gif', ''),
(97, ':gathering:', 'gathering.gif', 'gathering'),
(98, ':hang:', 'hang.gif', 'hang'),
(99, ':chop:', 'chop.gif', 'chop'),
(100, ':rip:', 'rip.gif', 'rip'),
(101, ':whip:', 'whip.gif', 'whip'),
(102, ':judge:', 'judge.gif', 'judge'),
(103, ':chair:', 'chair.gif', 'chair'),
(104, ':tease:', 'tease.gif', 'tease'),
(105, ':box:', 'box.gif', 'box'),
(106, ':boxing:', 'boxing.gif', 'boxing'),
(107, ':guns:', 'guns.gif', 'guns'),
(108, ':shoot:', 'shoot.gif', 'shoot'),
(109, ':shoot2:', 'shoot2.gif', 'shoot2'),
(110, ':flowers:', 'flowers.gif', 'flowers'),
(111, ':wub:', 'wub.gif', 'wub'),
(112, ':lovers:', 'lovers.gif', 'lovers'),
(113, ':kissing:', 'kissing.gif', 'kissing'),
(114, ':kissing2:', 'kissing2.gif', 'kissing2'),
(115, ':console:', 'console.gif', 'console'),
(116, ':group:', 'group.gif', 'group'),
(117, ':hump:', 'hump.gif', 'hump'),
(118, ':hooray:', 'hooray.gif', 'hooray'),
(119, ':happy2:', 'happy2.gif', 'happy2'),
(120, ':clap:', 'clap.gif', 'clap'),
(121, ':clap2:', 'clap2.gif', 'clap2'),
(122, ':weirdo:', 'weirdo.gif', 'weirdo'),
(123, ':yawn:', 'yawn.gif', 'yawn'),
(124, ':bow:', 'bow.gif', 'bow'),
(125, ':dawgie:', 'dawgie.gif', 'dawgie'),
(126, ':cylon:', 'cylon.gif', 'cylon'),
(127, ':book:', 'book.gif', 'book'),
(128, ':fish:', 'fish.gif', 'fish'),
(129, ':mama:', 'mama.gif', 'mama'),
(130, ':pepsi:', 'pepsi.gif', 'pepsi'),
(131, ':medieval:', 'medieval.gif', 'medieval'),
(132, ':rambo:', 'rambo.gif', 'rambo'),
(133, ':ninja:', 'ninja.gif', 'ninja'),
(134, ':hannibal:', 'hannibal.gif', 'hannibal'),
(135, ':party:', 'party.gif', 'party'),
(136, ':snorkle:', 'snorkle.gif', 'snorkle'),
(137, ':evo:', 'evo.gif', 'evo'),
(138, ':king:', 'king.gif', 'king'),
(139, ':chef:', 'chef.gif', 'chef'),
(140, ':mario:', 'mario.gif', 'mario'),
(141, ':pope:', 'pope.gif', 'pope'),
(142, ':fez:', 'fez.gif', 'fez'),
(143, ':cap:', 'cap.gif', 'cap'),
(144, ':cowboy:', 'cowboy.gif', 'cowboy'),
(145, ':pirate:', 'pirate.gif', 'pirate'),
(146, ':pirate2:', 'pirate2.gif', 'pirate2'),
(147, ':rock:', 'rock.gif', 'rock'),
(148, ':cigar:', 'cigar.gif', 'cigar'),
(149, ':icecream:', 'icecream.gif', 'icecream'),
(150, ':oldtimer:', 'oldtimer.gif', 'oldtimer'),
(151, ':trampoline:', 'trampoline.gif', 'trampoline'),
(152, ':banana:', 'bananadance.gif', 'bananadance'),
(153, ':smurf:', 'smurf.gif', 'smurf'),
(154, ':yikes:', 'yikes.gif', 'yikes'),
(155, ':osama:', 'osama.gif', 'osama'),
(156, ':saddam:', 'saddam.gif', 'saddam'),
(157, ':santa:', 'santa.gif', 'santa'),
(158, ':indian:', 'indian.gif', 'indian'),
(159, ':pimp:', 'pimp.gif', 'pimp'),
(160, ':nuke:', 'nuke.gif', 'nuke'),
(161, ':jacko:', 'jacko.gif', 'jacko'),
(162, ':ike:', 'ike.gif', 'ike'),
(163, ':greedy:', 'greedy.gif', 'greedy'),
(164, ':super:', 'super.gif', 'super'),
(165, ':wolverine:', 'wolverine.gif', 'wolverine'),
(166, ':spidey:', 'spidey.gif', 'spidey'),
(167, ':spider:', 'spider.gif', 'spider'),
(168, ':bandana:', 'bandana.gif', 'bandana'),
(169, ':construction:', 'construction.gif', 'construction'),
(170, ':sheep:', 'sheep.gif', 'sheep'),
(171, ':police:', 'police.gif', 'police'),
(172, ':detective:', 'detective.gif', 'detective'),
(173, ':bike:', 'bike.gif', 'bike'),
(174, ':fishing:', 'fishing.gif', 'fishing'),
(175, ':clover:', 'clover.gif', 'clover'),
(176, ':horse:', 'horse.gif', 'horse'),
(177, ':shit:', 'shit.gif', 'shit');

-- --------------------------------------------------------

--
-- Структура таблицы `snatched`
--

DROP TABLE IF EXISTS `snatched`;
CREATE TABLE IF NOT EXISTS `snatched` (
  `torrentid` int(10) DEFAULT '0',
  `userid` int(10) DEFAULT '0',
  `uploaded` bigint(20) unsigned DEFAULT '0',
  `downloaded` bigint(20) unsigned DEFAULT '0',
  `last_action` int(11) DEFAULT '0',
  `completedat` int(11) DEFAULT '0',
  UNIQUE KEY `fid_uid` (`torrentid`,`userid`),
  KEY `userid` (`userid`),
  KEY `torrentid` (`torrentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `snatched`
--


-- --------------------------------------------------------

--
-- Структура таблицы `sos`
--

DROP TABLE IF EXISTS `sos`;
CREATE TABLE IF NOT EXISTS `sos` (
  `torrentid` int(11) DEFAULT '0',
  `userid` int(11) DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `sos`
--


-- --------------------------------------------------------

--
-- Структура таблицы `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE IF NOT EXISTS `tags` (
  `tag_name` varchar(255) NOT NULL,
  `tag_type` tinyint(1) NOT NULL,
  `tag_for_id` int(10) NOT NULL,
  `tag_count` int(10) NOT NULL DEFAULT '0',
  `tag_cat_id` int(10) NOT NULL DEFAULT '0',
  KEY `tag_type` (`tag_type`),
  KEY `tag_for_id` (`tag_for_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `tags`
--


-- --------------------------------------------------------

--
-- Структура таблицы `tags_users`
--

DROP TABLE IF EXISTS `tags_users`;
CREATE TABLE IF NOT EXISTS `tags_users` (
  `tag_users_uid` int(10) NOT NULL,
  `tag_users_for_id` int(10) NOT NULL,
  `tag_users_type` tinyint(1) NOT NULL,
  `tag_users_name` varchar(255) NOT NULL,
  KEY `tag_users_type` (`tag_users_type`),
  KEY `tag_users_for_id` (`tag_users_for_id`),
  KEY `tag_users_uid` (`tag_users_uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `tags_users`
--


-- --------------------------------------------------------

--
-- Структура таблицы `thanks`
--

DROP TABLE IF EXISTS `thanks`;
CREATE TABLE IF NOT EXISTS `thanks` (
  `torrentid` int(10) DEFAULT '0',
  `userid` int(10) DEFAULT '0',
  KEY `torrentid` (`torrentid`),
  KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `thanks`
--


-- --------------------------------------------------------

--
-- Структура таблицы `themes`
--

DROP TABLE IF EXISTS `themes`;
CREATE TABLE IF NOT EXISTS `themes` (
  `themes_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `template_name` varchar(30) DEFAULT NULL,
  `style_name` varchar(30) DEFAULT NULL,
  `is_use_right_menu` tinyint(1) DEFAULT '0',
  `is_use_left_menu` tinyint(1) DEFAULT '0',
  `head_stylesheet` varchar(100) DEFAULT NULL,
  `body_background` varchar(100) DEFAULT NULL,
  `body_bgcolor` varchar(6) DEFAULT NULL,
  `body_text` varchar(6) DEFAULT NULL,
  `body_link` varchar(6) DEFAULT NULL,
  `body_vlink` varchar(6) DEFAULT NULL,
  `body_alink` varchar(6) DEFAULT NULL,
  `body_hlink` varchar(6) DEFAULT NULL,
  `tr_color1` varchar(6) DEFAULT NULL,
  `tr_color2` varchar(6) DEFAULT NULL,
  `tr_color3` varchar(6) DEFAULT NULL,
  `tr_class1` varchar(25) DEFAULT NULL,
  `tr_class2` varchar(25) DEFAULT NULL,
  `tr_class3` varchar(25) DEFAULT NULL,
  `th_color1` varchar(6) DEFAULT NULL,
  `th_color2` varchar(6) DEFAULT NULL,
  `th_color3` varchar(6) DEFAULT NULL,
  `th_class1` varchar(25) DEFAULT NULL,
  `th_class2` varchar(25) DEFAULT NULL,
  `th_class3` varchar(25) DEFAULT NULL,
  `td_color1` varchar(6) DEFAULT NULL,
  `td_color2` varchar(6) DEFAULT NULL,
  `td_color3` varchar(6) DEFAULT NULL,
  `td_class1` varchar(25) DEFAULT NULL,
  `td_class2` varchar(25) DEFAULT NULL,
  `td_class3` varchar(25) DEFAULT NULL,
  `fontface1` varchar(50) DEFAULT NULL,
  `fontface2` varchar(50) DEFAULT NULL,
  `fontface3` varchar(50) DEFAULT NULL,
  `fontsize1` tinyint(4) DEFAULT NULL,
  `fontsize2` tinyint(4) DEFAULT NULL,
  `fontsize3` tinyint(4) DEFAULT NULL,
  `fontcolor1` varchar(6) DEFAULT NULL,
  `fontcolor2` varchar(6) DEFAULT NULL,
  `fontcolor3` varchar(6) DEFAULT NULL,
  `span_class1` varchar(25) DEFAULT NULL,
  `span_class2` varchar(25) DEFAULT NULL,
  `span_class3` varchar(25) DEFAULT NULL,
  `img_size_poll` smallint(5) unsigned DEFAULT NULL,
  `img_size_privmsg` smallint(5) unsigned DEFAULT NULL,
  `online_color` varchar(6) DEFAULT NULL,
  `offline_color` varchar(6) DEFAULT NULL,
  `hidden_color` varchar(6) DEFAULT NULL,
  `hidden_torrent_color` varchar(6) DEFAULT NULL,
  PRIMARY KEY (`themes_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Дамп данных таблицы `themes`
--

INSERT INTO `themes` (`themes_id`, `template_name`, `style_name`, `is_use_right_menu`, `is_use_left_menu`, `head_stylesheet`, `body_background`, `body_bgcolor`, `body_text`, `body_link`, `body_vlink`, `body_alink`, `body_hlink`, `tr_color1`, `tr_color2`, `tr_color3`, `tr_class1`, `tr_class2`, `tr_class3`, `th_color1`, `th_color2`, `th_color3`, `th_class1`, `th_class2`, `th_class3`, `td_color1`, `td_color2`, `td_color3`, `td_class1`, `td_class2`, `td_class3`, `fontface1`, `fontface2`, `fontface3`, `fontsize1`, `fontsize2`, `fontsize3`, `fontcolor1`, `fontcolor2`, `fontcolor3`, `span_class1`, `span_class2`, `span_class3`, `img_size_poll`, `img_size_privmsg`, `online_color`, `offline_color`, `hidden_color`, `hidden_torrent_color`) VALUES
(1, 'main', 'main', 1, 1, 'main.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, ''Courier New'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', NULL, NULL, '008500', 'DF0000', 'EBD400', ''),
(2, 'reflection', 'reflection', 0, 0, 'reflection.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \\\\''Courier New\\\\'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', 0, 0, '008500', 'DF0000', 'EBD400', 'CCCCCC'),
(3, 'bithdtv', 'bithdtv', 0, 0, 'bithdtv.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, \\''Courier New\\'', sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '', 0, 0, '008500', 'DF0000', 'EBD400', 'CCCCCC');

-- --------------------------------------------------------

--
-- Структура таблицы `torrents`
--

DROP TABLE IF EXISTS `torrents`;
CREATE TABLE IF NOT EXISTS `torrents` (
  `fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `info_hash` blob,
  `name` varchar(255) DEFAULT NULL,
  `filename` varchar(255) DEFAULT NULL,
  `descr` text,
  `category` int(10) unsigned DEFAULT '0',
  `size` bigint(20) unsigned DEFAULT '0',
  `ctime` int(11) DEFAULT '0',
  `numfiles` int(10) unsigned DEFAULT '0',
  `comments` int(10) unsigned DEFAULT '0',
  `views` int(10) unsigned DEFAULT '0',
  `hits` int(10) unsigned DEFAULT '0',
  `completed` int(10) unsigned DEFAULT '0',
  `leechers` int(10) unsigned DEFAULT '0',
  `seeders` int(10) unsigned DEFAULT '0',
  `mtime` int(11) DEFAULT '0',
  `banned` tinyint(1) DEFAULT '0',
  `owner` int(10) unsigned DEFAULT '0',
  `numratings` int(10) unsigned DEFAULT '0',
  `ratingsum` int(10) unsigned DEFAULT '0',
  `nfo` text,
  `hidden` tinyint(1) DEFAULT '0',
  `free` tinyint(1) DEFAULT '0',
  `visible` tinyint(1) DEFAULT '0',
  `disable_comments` tinyint(1) DEFAULT '0',
  `flags` tinyint(1) DEFAULT '0',
  `moderated` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`fid`),
  UNIQUE KEY `info_hash` (`info_hash`(20)),
  KEY `owner` (`owner`),
  KEY `ratingsum` (`ratingsum`),
  KEY `numratings` (`numratings`),
  KEY `times_completed` (`completed`),
  KEY `numfiles` (`numfiles`),
  KEY `comments` (`comments`),
  KEY `category` (`category`),
  KEY `size` (`size`),
  KEY `name` (`name`),
  KEY `banned` (`banned`),
  KEY `hidden` (`hidden`),
  KEY `visible` (`visible`),
  KEY `free` (`free`),
  KEY `disable_comments` (`disable_comments`),
  KEY `flags` (`flags`),
  KEY `ctime` (`ctime`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `torrents`
--


-- --------------------------------------------------------

--
-- Структура таблицы `uploadapp`
--

DROP TABLE IF EXISTS `uploadapp`;
CREATE TABLE IF NOT EXISTS `uploadapp` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `active` tinyint(1) DEFAULT '1',
  `userid` int(10) DEFAULT '0',
  `applied` int(11) DEFAULT '0',
  `content` longtext,
  `comment` longtext,
  `seeding` tinyint(1) DEFAULT '0',
  `othergrps` tinyint(1) DEFAULT '0',
  `seedtime` varchar(100) DEFAULT NULL,
  `modcomments` text,
  `votes` text,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users` (`userid`),
  KEY `active` (`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `uploadapp`
--


-- --------------------------------------------------------

--
-- Структура таблицы `users`
--

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `uid` int(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(40) DEFAULT NULL,
  `name_append` text NOT NULL,
  `pass` varchar(32) DEFAULT NULL,
  `secret` blob,
  `email` varchar(80) DEFAULT NULL,
  `status` tinyint(1) DEFAULT '0',
  `added` int(11) DEFAULT '0',
  `editsecret` blob,
  `privacy` tinyint(1) DEFAULT '1',
  `acceptpms` tinyint(1) DEFAULT '1',
  `ip` varchar(16) DEFAULT NULL,
  `class` tinyint(3) unsigned DEFAULT '1',
  `avatar` varchar(100) DEFAULT NULL,
  `uploaded` bigint(20) unsigned DEFAULT '0',
  `downloaded` bigint(20) unsigned DEFAULT '0',
  `title` varchar(30) DEFAULT NULL,
  `country` int(10) unsigned DEFAULT '0',
  `notifs` mediumtext,
  `modcomment` text,
  `enabled` tinyint(1) DEFAULT '1',
  `avatars` tinyint(1) DEFAULT '1',
  `donor` tinyint(1) DEFAULT '0',
  `warneduntil` int(11) DEFAULT '0',
  `warn` tinyint(1) unsigned DEFAULT '0',
  `torrentsperpage` int(3) unsigned DEFAULT '0',
  `deletepms` tinyint(1) DEFAULT '1',
  `savepms` tinyint(1) DEFAULT '0',
  `torrent_pass` varchar(32) DEFAULT NULL,
  `tzoffset` decimal(5,2) DEFAULT '0.00',
  `user_dst` tinyint(1) DEFAULT '0',
  `hiddentorrents` tinyint(1) DEFAULT '0',
  `parked` tinyint(1) DEFAULT '0',
  `invites` int(10) DEFAULT '0',
  `invited_by` int(10) DEFAULT '0',
  `download` int(9) DEFAULT '0',
  `upload` int(9) DEFAULT '0',
  `icq` varchar(10) DEFAULT NULL,
  `msn` varchar(30) DEFAULT NULL,
  `aim` varchar(30) DEFAULT NULL,
  `yahoo` varchar(30) DEFAULT NULL,
  `skype` varchar(20) DEFAULT NULL,
  `commentpm` tinyint(1) DEFAULT '1',
  `gender` tinyint(1) DEFAULT '0',
  `birthday` date DEFAULT '0000-00-00',
  `autodemote` tinyint(1) DEFAULT '1',
  `language` varchar(255) DEFAULT NULL,
  `total_seed_time` int(11) DEFAULT '0',
  `user_reputation` int(11) DEFAULT '0',
  `user_reputation_level` int(11) DEFAULT '0',
  `user_session_time` int(11) DEFAULT '0',
  `user_session_page` varchar(255) DEFAULT NULL,
  `user_level` tinyint(4) DEFAULT '0',
  `user_posts` mediumint(8) unsigned DEFAULT '0',
  `user_lastvisit` int(11) DEFAULT '0',
  `user_sig` text,
  `user_style` tinyint(3) DEFAULT '0',
  `can_leech` tinyint(4) DEFAULT '1',
  `torrents_limit` int(11) DEFAULT '0',
  `user_unread_pms` int(10) DEFAULT '0',
  `user_rank_id` int(10) DEFAULT '0',
  `user_lastmark` int(11) DEFAULT '0',
  `user_bans` varchar(29) NOT NULL DEFAULT '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0',
  `user_torrents_uploaded` int(10) NOT NULL DEFAULT '0',
  `user_requests_created` int(10) NOT NULL DEFAULT '0',
  `user_offers_created` int(10) NOT NULL DEFAULT '0',
  `user_requests_filled` int(10) NOT NULL DEFAULT '0',
  `user_offers_filled` int(10) NOT NULL DEFAULT '0',
  PRIMARY KEY (`uid`),
  UNIQUE KEY `torrent_pass` (`torrent_pass`),
  UNIQUE KEY `username` (`name`),
  KEY `country` (`country`),
  KEY `enabled` (`enabled`),
  KEY `gender` (`gender`),
  KEY `upload` (`upload`),
  KEY `download` (`download`),
  KEY `parked` (`parked`),
  KEY `points` (`user_reputation`),
  KEY `class` (`class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `users`
--

INSERT INTO `users` (`uid`, `name`, `name_append`, `pass`, `secret`, `email`, `status`, `added`, `editsecret`, `privacy`, `acceptpms`, `ip`, `class`, `avatar`, `uploaded`, `downloaded`, `title`, `country`, `notifs`, `modcomment`, `enabled`, `avatars`, `donor`, `warneduntil`, `warn`, `torrentsperpage`, `deletepms`, `savepms`, `torrent_pass`, `tzoffset`, `user_dst`, `hiddentorrents`, `parked`, `invites`, `invited_by`, `download`, `upload`, `icq`, `msn`, `aim`, `yahoo`, `skype`, `commentpm`, `gender`, `birthday`, `autodemote`, `language`, `total_seed_time`, `user_reputation`, `user_reputation_level`, `user_session_time`, `user_session_page`, `user_level`, `user_posts`, `user_lastvisit`, `user_sig`, `user_style`, `can_leech`, `torrents_limit`, `user_unread_pms`, `user_rank_id`, `user_lastmark`, `user_bans`, `user_torrents_uploaded`, `user_requests_created`, `user_offers_created`, `user_requests_filled`, `user_offers_filled`) VALUES
(0, 'Anonymous', '', '', '', '', 1, 943909200, '', 1, 1, '0.0.0.0', 1, '', 0, 0, '', 0, '[forum]', '', 1, 1, 0, 0, 0, 0, 1, 0, 'fbc807cec4a079dd5add35845ec9d059', '0.00', 0, 0, 0, 0, 0, 65536, 65536, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'russian', 3600000, 0, 0, 943909200, '0', 0, 0, 0, '', 1, 0, 0, 0, 0, 0, '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0', 0, 0, 0, 0, 0),
(1, 'admin', '', 'd41d8cd98f00b204e9800998ecf8427e', '', 'EMAIL@ADDRESS.COM', 1, UNIX_TIMESTAMP(NOW()), '', 3, 1, '127.0.0.1', 7, '', 0, 0, '', 3, '[forum]', '', 1, 1, 0, 0, 0, 60, 1, 1, '57154e78ba0de787487576ae87207371', '3.00', 1, 0, 0, 0, 0, 10485760, 10485760, '', '', '', '', '', 1, 0, '0000-00-00', 1, 'english', 0, 0, 0, 1296214242, 'login.php', 1, 0, 1277214025, '', 1, 0, 0, 0, 0, 0, '0:0:0:0:0:0:0:0:0:0:0:0:0:0:0', 0, 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Структура таблицы `vote_desc`
--

DROP TABLE IF EXISTS `vote_desc`;
CREATE TABLE IF NOT EXISTS `vote_desc` (
  `vote_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `topic_id` mediumint(8) unsigned DEFAULT '0',
  `vote_text` text,
  `vote_start` int(11) DEFAULT '0',
  `vote_length` int(11) DEFAULT '0',
  PRIMARY KEY (`vote_id`),
  KEY `topic_id` (`topic_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `vote_desc`
--


-- --------------------------------------------------------

--
-- Структура таблицы `vote_results`
--

DROP TABLE IF EXISTS `vote_results`;
CREATE TABLE IF NOT EXISTS `vote_results` (
  `vote_id` mediumint(8) unsigned DEFAULT '0',
  `vote_option_id` tinyint(4) unsigned DEFAULT '0',
  `vote_option_text` varchar(255) DEFAULT NULL,
  `vote_result` int(11) DEFAULT '0',
  KEY `vote_option_id` (`vote_option_id`),
  KEY `vote_id` (`vote_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `vote_results`
--


-- --------------------------------------------------------

--
-- Структура таблицы `vote_voters`
--

DROP TABLE IF EXISTS `vote_voters`;
CREATE TABLE IF NOT EXISTS `vote_voters` (
  `vote_id` mediumint(8) unsigned DEFAULT '0',
  `vote_user_id` mediumint(8) DEFAULT '0',
  `vote_user_ip` varchar(16) DEFAULT NULL,
  `vote_cast` tinyint(4) unsigned DEFAULT '0',
  KEY `vote_id` (`vote_id`),
  KEY `vote_user_id` (`vote_user_id`),
  KEY `vote_user_ip` (`vote_user_ip`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `vote_voters`
--


-- --------------------------------------------------------

--
-- Структура таблицы `words`
--

DROP TABLE IF EXISTS `words`;
CREATE TABLE IF NOT EXISTS `words` (
  `word_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `word` char(100) DEFAULT NULL,
  `replacement` char(100) DEFAULT NULL,
  PRIMARY KEY (`word_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Дамп данных таблицы `words`
--


-- --------------------------------------------------------

--
-- Структура таблицы `xbt_deleted_hashes`
--

DROP TABLE IF EXISTS `xbt_deleted_hashes`;
CREATE TABLE IF NOT EXISTS `xbt_deleted_hashes` (
  `fid` int(10) NOT NULL DEFAULT '0',
  `info_hash` blob NOT NULL,
  KEY `fid` (`fid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Дамп данных таблицы `xbt_deleted_hashes`
--