joeroberts |
15th October 2008 14:16 |
replace steup/sql/install-MySQL with this
Code:
CREATE TABLE `#prefix#_addedrequests` (
`id` int(10) unsigned NOT NULL auto_increment,
`requestid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_admin_forum`
--
CREATE TABLE `#prefix#_admin_forum` (
`prefix` varchar(60) NOT NULL default '',
`cookie_name` varchar(60) NOT NULL default '',
`cookie_domain` varchar(60) NOT NULL default '',
`cookie_path` varchar(60) NOT NULL default '',
`cookie_time` varchar(60) NOT NULL default '0',
`base_folder` varchar(60) NOT NULL default '',
`forum_share` enum('true','false') NOT NULL default 'true',
`auto_post` enum('true','false') NOT NULL default 'false',
`auto_post_forum` varchar(60) NOT NULL default '0'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_avps`
--
CREATE TABLE `#prefix#_avps` (
`arg` varchar(20) NOT NULL default '',
`value_s` text NOT NULL,
`value_i` int(11) NOT NULL default '0',
`value_u` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`arg`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_bans`
--
CREATE TABLE `#prefix#_bans` (
`id` int(11) unsigned NOT NULL auto_increment,
`ipstart` int(10) unsigned NOT NULL default '0',
`ipend` int(10) unsigned NOT NULL default '0',
`reason` varchar(255) NOT NULL default '',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `ip_unique` (`ipstart`,`ipend`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_blackjack`
--
CREATE TABLE `#prefix#_blackjack` (
`userid` int(11) NOT NULL default '0',
`points` int(11) NOT NULL default '0',
`status` enum('playing','waiting') NOT NULL default 'playing',
`cards` text NOT NULL,
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_bonus`
--
CREATE TABLE `#prefix#_bonus` (
`id` int(5) NOT NULL auto_increment,
`bonusname` varchar(50) NOT NULL default '',
`points` decimal(4,1) NOT NULL default '000.0',
`description` text NOT NULL,
`art` varchar(10) NOT NULL default 'traffic',
`menge` bigint(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_cards`
--
CREATE TABLE `#prefix#_cards` (
`id` int(11) NOT NULL auto_increment,
`points` int(11) NOT NULL default '0',
`pic` text NOT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_casino`
--
CREATE TABLE `#prefix#_casino` (
`userid` int(10) NOT NULL default '0',
`win` bigint(20) default NULL,
`lost` bigint(20) default NULL,
`trys` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
`enableplay` enum('yes','no') NOT NULL default 'yes',
`deposit` bigint(20) NOT NULL default '0',
PRIMARY KEY (`userid`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_casino_bets`
--
CREATE TABLE `#prefix#_casino_bets` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`proposed` varchar(40) NOT NULL default '',
`challenged` varchar(40) NOT NULL default '',
`amount` bigint(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `userid` (`userid`,`proposed`,`challenged`,`amount`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_casino_config`
--
CREATE TABLE `#prefix#_casino_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_categories`
--
CREATE TABLE `#prefix#_categories` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(30) NOT NULL default '',
`sort_index` int(10) unsigned NOT NULL default '0',
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `sort_index` (`sort_index`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_comments`
--
CREATE TABLE `#prefix#_comments` (
`id` int(10) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`torrent` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`text` text NOT NULL,
`ori_text` text NOT NULL,
`news` int(10) NOT NULL default '0',
`nzb` int(10) NOT NULL default '0',
`offer` int(11) NOT NULL default '0',
`editedat` datetime NOT NULL default '0000-00-00 00:00:00',
`editedby` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `user` (`user`),
KEY `torrent` (`torrent`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_comments_notify`
--
CREATE TABLE `#prefix#_comments_notify` (
`torrent` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`status` enum('active','stopped') NOT NULL default 'active',
PRIMARY KEY (`torrent`,`user`),
KEY `torrent` (`torrent`,`status`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_complaints`
--
CREATE TABLE `#prefix#_complaints` (
`torrent` int(15) unsigned NOT NULL default '0',
`user` int(11) unsigned NOT NULL default '0',
`host` varchar(60) NOT NULL default '',
`datetime` datetime NOT NULL default '0000-00-00 00:00:00',
`score` smallint(1) unsigned zerofill NOT NULL default '0',
PRIMARY KEY (`torrent`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_config`
--
CREATE TABLE `#prefix#_config` (
`sitename` varchar(255) NOT NULL default '',
`siteurl` varchar(255) NOT NULL default '',
`cookiedomain` varchar(30) NOT NULL default '',
`cookiepath` varchar(60) NOT NULL default '',
`admin_email` varchar(60) NOT NULL default '',
`language` varchar(15) NOT NULL default '',
`theme` varchar(255) NOT NULL default '',
`force_passkey` enum('true','false') NOT NULL default 'false',
`welcome_message` longtext,
`announce_text` varchar(255) default NULL,
`allow_html` enum('true','false') NOT NULL default 'true',
`rewrite_engine` enum('true','false') NOT NULL default 'true',
`torrent_prefix` varchar(255) default NULL,
`torrent_per_page` int(10) unsigned NOT NULL default '10',
`onlysearch` enum('true','false') NOT NULL default 'true',
`max_torrent_size` int(11) unsigned NOT NULL default '0',
`announce_interval_min` int(10) unsigned NOT NULL default '0',
`announce_interval` int(10) unsigned NOT NULL default '0',
`dead_torrent_interval` int(10) unsigned NOT NULL default '0',
`minvotes` smallint(5) unsigned NOT NULL default '0',
`time_tracker_update` int(10) unsigned NOT NULL default '0',
`best_limit` smallint(5) unsigned NOT NULL default '0',
`down_limit` smallint(5) unsigned NOT NULL default '0',
`torrent_complaints` enum('true','false') NOT NULL default 'false',
`torrent_global_privacy` enum('true','false') NOT NULL default 'true',
`disclaimer_check` enum('true','false') NOT NULL default 'false',
`gfx_check` enum('true','false') NOT NULL default 'true',
`upload_level` enum('all','user','premium') NOT NULL default 'user',
`download_level` enum('all','user','premium') NOT NULL default 'all',
`announce_level` enum('all','user') NOT NULL default 'all',
`max_num_file` smallint(5) unsigned NOT NULL default '0',
`max_share_size` bigint(8) unsigned NOT NULL default '0',
`min_size_seed` mediumint(8) unsigned NOT NULL default '0',
`min_share_seed` bigint(8) unsigned NOT NULL default '0',
`global_min_ratio` float unsigned NOT NULL default '0',
`autoscrape` enum('true','false') NOT NULL default 'true',
`min_num_seed_e` smallint(5) unsigned NOT NULL default '0',
`min_size_seed_e` bigint(8) unsigned NOT NULL default '0',
`minupload_size_file` int(10) unsigned NOT NULL default '0',
`allow_backup_tracker` enum('true','false') NOT NULL default 'false',
`stealthmode` enum('true','false') NOT NULL default 'true',
`version` varchar(5) NOT NULL default '',
`upload_dead` enum('true','false') NOT NULL default 'false',
`invites_open` enum('true','false') NOT NULL default 'false',
`invite_only` enum('true','false') NOT NULL default 'false',
`max_members` int(10) unsigned NOT NULL default '0',
`auto_clean` int(10) unsigned NOT NULL default '0',
`free_dl` enum('true','false') NOT NULL default 'false',
`GIGSA` int(10) NOT NULL default '0',
`RATIOA` decimal(10,2) NOT NULL default '0.00',
`WAITA` int(10) NOT NULL default '0',
`GIGSB` int(10) NOT NULL default '0',
`RATIOB` decimal(10,2) NOT NULL default '0.00',
`WAITB` int(10) NOT NULL default '0',
`GIGSC` int(10) NOT NULL default '0',
`RATIOC` decimal(10,2) NOT NULL default '0.00',
`WAITC` int(10) NOT NULL default '0',
`GIGSD` int(10) NOT NULL default '0',
`RATIOD` decimal(10,2) NOT NULL default '0.00',
`WAITD` int(10) NOT NULL default '0',
`wait_time` enum('true','false') NOT NULL default 'false',
`addprivate` enum('true','false') NOT NULL default 'false',
`search_cloud_block` enum('true','false') NOT NULL default 'true',
`pivate_mode` enum('true','false') NOT NULL default 'false'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_countries`
--
CREATE TABLE `#prefix#_countries` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(50) default NULL,
`flagpic` varchar(50) default NULL,
`domain` char(3) default NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_download_completed`
--
CREATE TABLE `#prefix#_download_completed` (
`user` int(11) unsigned NOT NULL default '0',
`torrent` int(15) unsigned NOT NULL default '0',
`completed` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`user`,`torrent`),
KEY `torrent` (`torrent`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_faq`
--
CREATE TABLE `#prefix#_faq` (
`id` int(10) NOT NULL auto_increment,
`type` set('categ','item') NOT NULL default 'item',
`question` text NOT NULL,
`answer` text NOT NULL,
`flag` set('0','1','2','3') NOT NULL default '1',
`categ` int(10) NOT NULL default '0',
`order` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_files`
--
CREATE TABLE `#prefix#_files` (
`id` int(20) unsigned NOT NULL auto_increment,
`torrent` int(15) unsigned NOT NULL default '0',
`filename` varchar(255) NOT NULL default '',
`size` bigint(20) unsigned NOT NULL default '0',
`md5sum` varchar(32) default NULL,
`ed2k` varchar(255) default NULL,
`magnet` varchar(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `torrent_2` (`torrent`,`filename`),
KEY `torrent` (`torrent`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_filter`
--
CREATE TABLE `#prefix#_filter` (
`id` int(10) unsigned NOT NULL auto_increment,
`keyword` varchar(50) NOT NULL default '',
`reason` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `keyword` (`keyword`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_flashscores`
--
CREATE TABLE `#prefix#_flashscores` (
`ID` int(11) NOT NULL auto_increment,
`game` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`level` int(11) NOT NULL default '0',
`score` int(11) NOT NULL default '0',
`date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`ID`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_lottery_config`
--
CREATE TABLE `#prefix#_lottery_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_offers`
--
CREATE TABLE `#prefix#_offers` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`name` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`for` int(10) unsigned NOT NULL default '0',
`against` int(10) unsigned NOT NULL default '0',
`category` int(11) NOT NULL default '0',
`comments` int(11) NOT NULL default '0',
`allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
`votes` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_offervotes`
--
CREATE TABLE `#prefix#_offervotes` (
`id` int(10) unsigned NOT NULL auto_increment,
`offerid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`vote` enum('for','against') NOT NULL default 'for',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_offres_config`
--
CREATE TABLE `#prefix#_offres_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_online_users`
--
CREATE TABLE `#prefix#_online_users` (
`id` int(60) unsigned NOT NULL default '0',
`page` varchar(255) NOT NULL default '',
`logged_in` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_paypal`
--
CREATE TABLE `#prefix#_paypal` (
`siteurl` varchar(255) NOT NULL default '',
`paypal_email` varchar(60) NOT NULL default '',
`sitecost` varchar(60) NOT NULL default '',
`reseaved_donations` varchar(60) NOT NULL default '',
`donatepage` longtext NOT NULL,
`donation_block` enum('true','false') NOT NULL default 'true',
`nodonate` enum('EU','UK','US') NOT NULL default 'US'
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_peers`
--
CREATE TABLE `#prefix#_peers` (
`id` int(10) unsigned NOT NULL auto_increment,
`uid` int(11) unsigned NOT NULL default '0',
`torrent` int(10) unsigned NOT NULL default '0',
`peer_id` varchar(20) binary NOT NULL default '',
`unique_id` varchar(20) default NULL,
`ip` int(10) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`real_ip` int(10) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`download_speed` int(11) unsigned NOT NULL default '0',
`upload_speed` int(11) unsigned NOT NULL default '0',
`to_go` bigint(20) unsigned NOT NULL default '0',
`seeder` enum('yes','no') NOT NULL default 'no',
`started` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL default 'yes',
`client` varchar(60) default NULL,
`version` varchar(10) NOT NULL default '',
`user_agent` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
UNIQUE KEY `torrent_3` (`torrent`,`unique_id`),
KEY `torrent` (`torrent`),
KEY `last_action` (`last_action`),
KEY `torrent_2` (`torrent`,`seeder`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_pollanswers`
--
CREATE TABLE `#prefix#_pollanswers` (
`id` int(10) unsigned NOT NULL auto_increment,
`pollid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`selection` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `pollid` (`pollid`),
KEY `selection` (`selection`),
KEY `userid` (`userid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_polls`
--
CREATE TABLE `#prefix#_polls` (
`id` int(10) unsigned NOT NULL auto_increment,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`question` varchar(255) NOT NULL default '',
`option0` varchar(40) NOT NULL default '',
`option1` varchar(40) NOT NULL default '',
`option2` varchar(40) NOT NULL default '',
`option3` varchar(40) NOT NULL default '',
`option4` varchar(40) NOT NULL default '',
`option5` varchar(40) NOT NULL default '',
`option6` varchar(40) NOT NULL default '',
`option7` varchar(40) NOT NULL default '',
`option8` varchar(40) NOT NULL default '',
`option9` varchar(40) NOT NULL default '',
`sort` enum('yes','no') NOT NULL default 'yes',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_privacy_backup`
--
CREATE TABLE `#prefix#_privacy_backup` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) NOT NULL default '0',
`torrent` int(11) NOT NULL default '0',
`status` enum('pending','denied','granted') NOT NULL default 'pending',
PRIMARY KEY (`slave`,`torrent`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_privacy_file`
--
CREATE TABLE `#prefix#_privacy_file` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
`torrent` int(15) unsigned NOT NULL default '0',
`status` enum('pending','denied','granted') NOT NULL default 'pending',
PRIMARY KEY (`slave`,`torrent`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_privacy_global`
--
CREATE TABLE `#prefix#_privacy_global` (
`master` int(11) unsigned NOT NULL default '0',
`torrent` int(11) NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
`status` enum('blacklist','whitelist') NOT NULL default 'whitelist',
PRIMARY KEY (`master`,`slave`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_private_messages`
--
CREATE TABLE `#prefix#_private_messages` (
`id` int(20) unsigned zerofill NOT NULL auto_increment,
`sender` int(11) unsigned NOT NULL default '0',
`recipient` int(11) unsigned NOT NULL default '0',
`subject` varchar(255) NOT NULL default '',
`text` longtext NOT NULL,
`is_read` enum('true','false') NOT NULL default 'false',
`sent` datetime NOT NULL default '0000-00-00 00:00:00',
`sender_del` enum('true','false') NOT NULL default 'false',
`recipient_del` enum('true','false') NOT NULL default 'false',
PRIMARY KEY (`id`),
KEY `from` (`sender`),
KEY `to` (`recipient`),
FULLTEXT KEY `text` (`text`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_private_messages_blacklist`
--
CREATE TABLE `#prefix#_private_messages_blacklist` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`master`,`slave`),
KEY `master` (`master`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_private_messages_bookmarks`
--
CREATE TABLE `#prefix#_private_messages_bookmarks` (
`master` int(11) unsigned NOT NULL default '0',
`slave` int(11) unsigned NOT NULL default '0',
PRIMARY KEY (`master`,`slave`),
KEY `master` (`master`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_ratings`
--
CREATE TABLE `#prefix#_ratings` (
`torrent` int(10) unsigned NOT NULL default '0',
`user` int(10) unsigned NOT NULL default '0',
`rating` tinyint(3) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`torrent`,`user`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_ratiowarn`
--
CREATE TABLE `#prefix#_ratiowarn` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(11) NOT NULL default '0',
`warned` enum('yes','no') NOT NULL default 'no',
`banned` enum('yes','no') NOT NULL default 'no',
`ratiodate` datetime NOT NULL default '0000-00-00 00:00:00',
`warntime` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_ratiowarn_config`
--
CREATE TABLE `#prefix#_ratiowarn_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_requests`
--
CREATE TABLE `#prefix#_requests` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`request` varchar(225) default NULL,
`descr` text NOT NULL,
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`hits` int(10) unsigned NOT NULL default '0',
`cat` int(10) unsigned NOT NULL default '0',
`filled` varchar(75) NOT NULL default '',
`filledby` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_requist_config`
--
CREATE TABLE `#prefix#_requist_config` (
`name` varchar(255) NOT NULL default '',
`value` varchar(255) NOT NULL default '',
PRIMARY KEY (`name`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_rules`
--
CREATE TABLE `#prefix#_rules` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) NOT NULL default '',
`text` tinytext NOT NULL,
`public` enum('yes','no') NOT NULL default 'yes',
`level` enum('user','premium','moderator','admin') NOT NULL default 'user',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_search_text`
--
CREATE TABLE `#prefix#_search_text` (
`id` int(20) unsigned NOT NULL auto_increment,
`text` varchar(25) NOT NULL default '',
`hit` int(20) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `text` (`text`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_seeder_notify`
--
CREATE TABLE `#prefix#_seeder_notify` (
`torrent` int(11) NOT NULL default '0',
`user` int(11) NOT NULL default '0',
`status` enum('active','stopped') NOT NULL default 'active',
PRIMARY KEY (`torrent`,`user`),
KEY `contacts` (`torrent`,`status`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_shouts`
--
CREATE TABLE `#prefix#_shouts` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`user` int(10) unsigned NOT NULL default '0',
`text` varchar(255) NOT NULL default '',
`posted` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `anti_flood` (`user`,`text`),
KEY `posted` (`posted`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_smiles`
--
CREATE TABLE `#prefix#_smiles` (
`id` int(5) unsigned NOT NULL auto_increment,
`code` varchar(15) NOT NULL default '',
`file` varchar(30) NOT NULL default '',
`alt` varchar(50) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `code` (`code`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_snatched`
--
CREATE TABLE `#prefix#_snatched` (
`id` int(10) unsigned NOT NULL auto_increment,
`torrent` int(10) unsigned NOT NULL default '0',
`torrentid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`ip` bigint(20) unsigned NOT NULL default '0',
`torrent_name` varchar(255) NOT NULL default '',
`torrent_category` int(10) unsigned NOT NULL default '0',
`port` smallint(5) unsigned NOT NULL default '0',
`uploaded` bigint(20) unsigned NOT NULL default '0',
`downloaded` bigint(20) unsigned NOT NULL default '0',
`to_go` bigint(20) unsigned NOT NULL default '0',
`speedup` bigint(20) unsigned NOT NULL default '0',
`speeddown` bigint(20) unsigned NOT NULL default '0',
`seeder` enum('yes','no') NOT NULL default 'no',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`startdat` datetime NOT NULL default '0000-00-00 00:00:00',
`completedat` datetime NOT NULL default '0000-00-00 00:00:00',
`connectable` enum('yes','no') NOT NULL default 'yes',
`agent` varchar(60) NOT NULL default '',
`finished` enum('yes','no') NOT NULL default 'no',
PRIMARY KEY (`id`),
UNIQUE KEY `torrentid_3` (`torrentid`,`userid`),
KEY `finished` (`finished`,`torrentid`),
KEY `torrentid` (`userid`),
KEY `torrentid_2` (`torrentid`),
KEY `userid` (`userid`,`torrentid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_thanks`
--
CREATE TABLE `#prefix#_thanks` (
`tid` bigint(10) NOT NULL auto_increment,
`uid` bigint(10) NOT NULL default '0',
`torid` bigint(10) NOT NULL default '0',
`thank_date` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`tid`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_tickets`
--
CREATE TABLE `#prefix#_tickets` (
`id` int(4) NOT NULL auto_increment,
`user` int(11) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_torrents`
--
CREATE TABLE `#prefix#_time_offset` (
`id` smallint(4) NOT NULL auto_increment,
`name` varchar(50) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=721 ;
CREATE TABLE `#prefix#_torrents` (
`id` int(15) unsigned NOT NULL auto_increment,
`info_hash` varchar(20) character set latin1 collate latin1_bin default NULL,
`md5sum` varchar(32) default NULL,
`name` varchar(255) NOT NULL default '',
`filename` varchar(255) NOT NULL default '',
`save_as` varchar(255) NOT NULL default '',
`search_text` text NOT NULL,
`descr` text NOT NULL,
`torrent_descr` text NOT NULL,
`plen` bigint(6) unsigned NOT NULL default '0',
`size` bigint(20) unsigned NOT NULL default '0',
`category` int(10) unsigned NOT NULL default '0',
`type` enum('single','multi','link') NOT NULL default 'single',
`numfiles` int(10) unsigned NOT NULL default '0',
`added` datetime NOT NULL default '0000-00-00 00:00:00',
`exeem` varchar(250) default NULL,
`dht` enum('yes','no') NOT NULL default 'no',
`backup_tracker` enum('true','false') NOT NULL default 'false',
`views` int(10) unsigned NOT NULL default '0',
`downloaded` int(10) unsigned NOT NULL default '0',
`completed` int(10) unsigned NOT NULL default '0',
`banned` enum('yes','no') NOT NULL default 'no',
`password` varchar(255) default NULL,
`private` enum('true','false') NOT NULL default 'false',
`min_ratio` float unsigned NOT NULL default '0',
`visible` enum('yes','no') NOT NULL default 'yes',
`evidence` tinyint(1) NOT NULL default '0',
`owner` int(10) unsigned NOT NULL default '0',
`ownertype` tinyint(1) unsigned NOT NULL default '0',
`uploader_host` varchar(100) NOT NULL default '',
`numratings` int(10) unsigned NOT NULL default '0',
`ratingsum` int(10) unsigned NOT NULL default '0',
`seeders` int(10) unsigned NOT NULL default '0',
`leechers` int(10) unsigned NOT NULL default '0',
`tot_peer` int(11) unsigned NOT NULL default '0',
`speed` int(10) unsigned NOT NULL default '0',
`comments` int(10) unsigned NOT NULL default '0',
`complaints` char(3) NOT NULL default '0,0',
`tracker` varchar(250) default NULL,
`tracker_list` text,
`tracker_update` datetime NOT NULL default '0000-00-00 00:00:00',
`last_action` datetime NOT NULL default '0000-00-00 00:00:00',
`nuked` enum('yes','no','unnuked') NOT NULL default 'no',
`ratiobuild` enum('yes','no') NOT NULL default 'no',
`nukereason` varchar(225) NOT NULL default '',
`thanks` int(10) NOT NULL default '0',
`imdb` varchar(225) NOT NULL default '',
PRIMARY KEY (`id`),
UNIQUE KEY `info_hash` (`info_hash`),
KEY `owner` (`owner`),
KEY `visible` (`visible`),
KEY `added` (`added`),
KEY `seeders` (`seeders`),
KEY `leechers` (`leechers`),
KEY `tot_peer` (`tot_peer`),
KEY `banned` (`banned`),
KEY `password` (`password`),
KEY `tracker` (`tracker`),
KEY `evidence` (`evidence`),
KEY `rating` (`numratings`,`ratingsum`),
KEY `numfiles` (`numfiles`),
KEY `downloaded` (`downloaded`),
KEY `category` (`category`),
KEY `type` (`type`),
FULLTEXT KEY `ft_search` (`search_text`),
FULLTEXT KEY `filename` (`filename`),
FULLTEXT KEY `torrent_descr` (`torrent_descr`)
) TYPE=MyISAM PACK_KEYS=1 CHECKSUM=1;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_trackers`
--
CREATE TABLE `#prefix#_trackers` (
`id` tinyint(5) unsigned NOT NULL auto_increment,
`url` varchar(120) NOT NULL default '',
`support` enum('selective','global','single') NOT NULL default 'selective',
`status` enum('active','dead','blacklisted') NOT NULL default 'active',
`updated` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `url` (`url`),
KEY `update` (`updated`)
) TYPE=MyISAM ;
-- --------------------------------------------------------
--
-- Table structure for table `#prefix#_users`
--
CREATE TABLE `#prefix#_users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
`clean_username` varchar(25) character set utf8 collate utf8_bin NOT NULL default '',
`name` varchar(50) default NULL,
`email` varchar(255) character set utf8 collate utf8_bin NOT NULL default '',
`regdate` datetime NOT NULL default '0000-00-00 00:00:00',
`password` varchar(40) NOT NULL default '',
`theme` varchar(255) default NULL,
`language` varchar(15) default NULL,
`avatar` varchar(255) NOT NULL default 'blank.gif',
`accept_mail` enum('yes','no') NOT NULL default 'no',
`aim` varchar(255) default NULL,
`icq` varchar(10) default NULL,
`jabber` varchar(255) default NULL,
`msn` varchar(255) default NULL,
`skype` varchar(255) default NULL,
`yahoo` varchar(255) default NULL,
`level` enum('user','premium','moderator','admin') NOT NULL default 'user',
`uploaded` bigint(32) unsigned NOT NULL default '0',
`downloaded` bigint(32) unsigned NOT NULL default '0',
`active` tinyint(1) default '0',
`ban` int(1) unsigned NOT NULL default '0',
`act_key` varchar(32) default NULL,
`passkey` varchar(32) default NULL,
`newpasswd` varchar(40) default NULL,
`banreason` varchar(255) default NULL,
`lastip` int(10) unsigned NOT NULL default '0',
`lasthost` varchar(255) NOT NULL default '',
`lastlogin` datetime NOT NULL default '0000-00-00 00:00:00',
`rem` enum('yes','no') NOT NULL default 'no',
`modcomment` varchar(225) NOT NULL default '',
`warned` int(1) unsigned NOT NULL default '0',
`warn_kapta` int(11) NOT NULL default '0',
`warn_hossz` int(11) NOT NULL default '0',
`invited_by` int(10) NOT NULL default '0',
`invitees` varchar(100) NOT NULL default '',
`country` int(10) NOT NULL default '0',
`seedbox` int(10) unsigned NOT NULL default '0',
`tzoffset` smallint(4) NOT NULL default '0',
`can_shout` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
`Show_online` enum('true','false') character set utf8 collate utf8_bin NOT NULL default 'true',
`invites` smallint(5) NOT NULL default '0',
`invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
`seedbonus` decimal(10,1) NOT NULL default '0.0',
`donated` int(5) unsigned NOT NULL default '0',
`dondate` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),
UNIQUE KEY `email` (`email`),
UNIQUE KEY `passkey` (`passkey`),
KEY `lastip` (`lastip`),
KEY `lasthost` (`lasthost`),
KEY `date` (`regdate`)
) TYPE=MyISAM ;
|