-- MySQL dump 10.11 -- -- Host: localhost Database: what_db -- ------------------------------------------------------ -- Server version 5.0.45-log /*!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 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `artists` -- DROP TABLE IF EXISTS `artists`; CREATE TABLE `artists` ( `ID` int(10) NOT NULL auto_increment, `Name` varchar(200) NOT NULL, `RevisionID` int(12) default NULL, PRIMARY KEY (`ID`), KEY `Name` (`Name`), KEY `RevisionID` (`RevisionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `artists_similar` -- DROP TABLE IF EXISTS `artists_similar`; CREATE TABLE `artists_similar` ( `ArtistID` int(10) NOT NULL default '0', `SimilarID` int(12) NOT NULL default '0', PRIMARY KEY (`ArtistID`,`SimilarID`), KEY `ArtistID` (`ArtistID`), KEY `SimilarID` (`SimilarID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `artists_similar_scores` -- DROP TABLE IF EXISTS `artists_similar_scores`; CREATE TABLE `artists_similar_scores` ( `SimilarID` int(12) NOT NULL auto_increment, `Score` int(10) NOT NULL default '0', PRIMARY KEY (`SimilarID`), KEY `Score` (`Score`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `artists_similar_votes` -- DROP TABLE IF EXISTS `artists_similar_votes`; CREATE TABLE `artists_similar_votes` ( `SimilarID` int(12) NOT NULL, `UserID` int(10) NOT NULL, `Way` enum('up','down') NOT NULL default 'up', PRIMARY KEY (`SimilarID`,`UserID`,`Way`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `artists_tags` -- DROP TABLE IF EXISTS `artists_tags`; CREATE TABLE `artists_tags` ( `TagID` int(10) NOT NULL default '0', `ArtistID` int(10) NOT NULL default '0', `PositiveVotes` int(6) NOT NULL default '1', `NegativeVotes` int(6) NOT NULL default '1', `UserID` int(10) default NULL, PRIMARY KEY (`TagID`,`ArtistID`), KEY `TagID` (`TagID`), KEY `ArtistID` (`ArtistID`), KEY `PositiveVotes` (`PositiveVotes`), KEY `NegativeVotes` (`NegativeVotes`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `bans` -- DROP TABLE IF EXISTS `bans`; CREATE TABLE `bans` ( `IP` varchar(15) NOT NULL, PRIMARY KEY (`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `bookmarks` -- DROP TABLE IF EXISTS `bookmarks`; CREATE TABLE `bookmarks` ( `UserID` int(10) unsigned default NULL, `URI` varchar(500) character set latin1 default NULL, `Sort` enum('0','1','2','3') character set latin1 default '0', `Title` varchar(200) character set latin1 default NULL, `Added` datetime default NULL, `Note` text character set latin1 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `cheater_log` -- DROP TABLE IF EXISTS `cheater_log`; CREATE TABLE `cheater_log` ( `ID` int(5) NOT NULL auto_increment, `Client` varchar(8) default NULL, `User` int(10) default NULL, `TorrentID` int(10) default NULL, `Test` int(2) default NULL, `Time` timestamp NOT NULL default CURRENT_TIMESTAMP, `Peers` text, `GroupID` int(10) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `do_not_upload` -- DROP TABLE IF EXISTS `do_not_upload`; CREATE TABLE `do_not_upload` ( `ID` int(10) NOT NULL auto_increment, `Name` varchar(255) NOT NULL, `Comment` varchar(255) NOT NULL, `UserID` int(10) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `donations` -- DROP TABLE IF EXISTS `donations`; CREATE TABLE `donations` ( `UserID` int(10) NOT NULL, `Amount` int(10) NOT NULL, `Currency` varchar(10) NOT NULL, `Email` varchar(255) NOT NULL, `Time` datetime NOT NULL, KEY `UserID` (`UserID`), KEY `Time` (`Time`), KEY `Amount` (`Amount`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `drives` -- DROP TABLE IF EXISTS `drives`; CREATE TABLE `drives` ( `DriveID` int(10) NOT NULL auto_increment, `Name` varchar(50) NOT NULL, `Offset` varchar(10) NOT NULL, PRIMARY KEY (`DriveID`), KEY `Name` (`Name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `forums` -- DROP TABLE IF EXISTS `forums`; CREATE TABLE `forums` ( `ID` int(6) unsigned NOT NULL auto_increment, `Sort` int(6) unsigned NOT NULL, `Name` varchar(40) NOT NULL default '', `Description` varchar(255) default '', `MinClassRead` int(4) NOT NULL default '0', `MinClassWrite` int(4) NOT NULL default '0', `MinClassCreate` int(4) NOT NULL default '0', `NumTopics` int(10) NOT NULL default '0', `NumPosts` int(10) NOT NULL default '0', `LastPostID` int(10) NOT NULL default '0', `LastPostAuthorID` int(10) NOT NULL default '0', `LastPostTopicID` int(10) NOT NULL default '0', `LastPostTime` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `Sort` (`Sort`), KEY `MinClassRead` (`MinClassRead`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `forums` -- LOCK TABLES `forums` WRITE; /*!40000 ALTER TABLE `forums` DISABLE KEYS */; INSERT INTO `forums` VALUES (1,1,'Staff','Staff-only forum',700,700,700,0,0,0,0,0,'0000-00-00 00:00:00'),(2,20,'Chat','General discussion',100,100,100,0,0,0,0,0,'0000-00-00 00:00:00'),(3,100,'Trash','Because you\'re not special and we don\'t love you!',100,700,700,0,0,0,0,0,'0000-00-00 00:00:00'); /*!40000 ALTER TABLE `forums` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forums_last_read_topics` -- DROP TABLE IF EXISTS `forums_last_read_topics`; CREATE TABLE `forums_last_read_topics` ( `UserID` int(10) NOT NULL, `TopicID` int(10) NOT NULL, `PostID` int(10) NOT NULL, PRIMARY KEY (`UserID`,`TopicID`), KEY `TopicID` (`TopicID`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `forums_posts` -- DROP TABLE IF EXISTS `forums_posts`; CREATE TABLE `forums_posts` ( `ID` int(10) NOT NULL auto_increment, `TopicID` int(10) NOT NULL, `AuthorID` int(10) NOT NULL, `AddedTime` datetime NOT NULL default '0000-00-00 00:00:00', `Body` mediumtext, `EditedUserID` int(10) default NULL, `EditedTime` datetime default NULL, PRIMARY KEY (`ID`), KEY `TopicID` (`TopicID`), KEY `AuthorID` (`AuthorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `forums_topics` -- DROP TABLE IF EXISTS `forums_topics`; CREATE TABLE `forums_topics` ( `ID` int(10) NOT NULL auto_increment, `Title` varchar(150) NOT NULL, `AuthorID` int(10) NOT NULL, `IsLocked` enum('0','1') NOT NULL default '0', `IsSticky` enum('0','1') NOT NULL default '0', `ForumID` int(3) NOT NULL, `NumPosts` int(10) NOT NULL default '0', `LastPostID` int(10) NOT NULL, `LastPostTime` datetime NOT NULL default '0000-00-00 00:00:00', `LastPostAuthorID` int(10) NOT NULL, PRIMARY KEY (`ID`), KEY `AuthorID` (`AuthorID`), KEY `ForumID` (`ForumID`), KEY `IsSticky` (`IsSticky`), KEY `LastPostID` (`LastPostID`), KEY `Title` (`Title`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `friends` -- DROP TABLE IF EXISTS `friends`; CREATE TABLE `friends` ( `UserID` int(10) unsigned NOT NULL, `FriendID` int(10) unsigned NOT NULL, `Comment` text NOT NULL, PRIMARY KEY (`UserID`,`FriendID`), KEY `UserID` (`UserID`), KEY `FriendID` (`FriendID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `invite_tree` -- DROP TABLE IF EXISTS `invite_tree`; CREATE TABLE `invite_tree` ( `UserID` int(10) NOT NULL default '0', `InviterID` int(10) NOT NULL default '0', `TreePosition` int(8) NOT NULL default '1', `TreeID` int(10) NOT NULL default '1', `TreeLevel` int(3) NOT NULL default '0', PRIMARY KEY (`UserID`), KEY `InviterID` (`InviterID`), KEY `TreePosition` (`TreePosition`), KEY `TreeID` (`TreeID`), KEY `TreeLevel` (`TreeLevel`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `invites` -- DROP TABLE IF EXISTS `invites`; CREATE TABLE `invites` ( `InviterID` int(10) NOT NULL default '0', `InviteKey` char(32) NOT NULL, `Email` varchar(255) NOT NULL, `Expires` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`InviteKey`), KEY `Expires` (`Expires`), KEY `InviterID` (`InviterID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `ip_bans` -- DROP TABLE IF EXISTS `ip_bans`; CREATE TABLE `ip_bans` ( `ID` int(10) unsigned NOT NULL auto_increment, `FromIP` int(11) unsigned NOT NULL, `ToIP` int(11) unsigned NOT NULL, `Notes` text NOT NULL, `CreatedBy` int(11) NOT NULL, `Time` datetime NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `kb` -- DROP TABLE IF EXISTS `kb`; CREATE TABLE `kb` ( `ArticleID` int(10) unsigned NOT NULL auto_increment, `Title` varchar(150) NOT NULL default '', `Body` mediumtext NOT NULL, PRIMARY KEY (`ArticleID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `kb` -- LOCK TABLES `kb` WRITE; /*!40000 ALTER TABLE `kb` DISABLE KEYS */; INSERT INTO `kb` VALUES (1,'Welcome to the knowledgebase','
\n \n
\n \n
\n
\n
Welcome to the knowledgebase
\n
\nThis will be filled up with information soon \'\'\n
\n
\n
'); /*!40000 ALTER TABLE `kb` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kb_dead_links` -- DROP TABLE IF EXISTS `kb_dead_links`; CREATE TABLE `kb_dead_links` ( `ParentID` int(10) unsigned NOT NULL, `ChildName` varchar(150) NOT NULL default '', PRIMARY KEY (`ParentID`,`ChildName`), KEY `ChildName` (`ChildName`), KEY `ParentID` (`ParentID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `kb_links` -- DROP TABLE IF EXISTS `kb_links`; CREATE TABLE `kb_links` ( `ParentID` int(10) unsigned NOT NULL, `ChildID` int(10) unsigned NOT NULL, PRIMARY KEY (`ParentID`,`ChildID`), KEY `ChildID` (`ChildID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `kb_revisions` -- DROP TABLE IF EXISTS `kb_revisions`; CREATE TABLE `kb_revisions` ( `ArticleID` int(10) unsigned NOT NULL default '0', `RevisionID` smallint(5) unsigned NOT NULL default '0', `RevisionDate` datetime NOT NULL default '0000-00-00 00:00:00', `EditorID` int(10) unsigned NOT NULL default '0', `Title` varchar(150) NOT NULL default '', `Body` mediumtext NOT NULL, `AccessLevel` tinyint(3) unsigned NOT NULL default '0', `EditSummary` varchar(150) NOT NULL, PRIMARY KEY (`ArticleID`,`RevisionID`), KEY `EditorID` (`EditorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `kb_revisions` -- LOCK TABLES `kb_revisions` WRITE; /*!40000 ALTER TABLE `kb_revisions` DISABLE KEYS */; INSERT INTO `kb_revisions` VALUES (1,1,'2008-07-24 07:29:37',1,'Welcome to the knowledgebase','This will be filled up with information soon :)',0,'Created article'); /*!40000 ALTER TABLE `kb_revisions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `kb_search` -- DROP TABLE IF EXISTS `kb_search`; CREATE TABLE `kb_search` ( `ArticleID` int(10) unsigned NOT NULL default '0', `Body` mediumtext NOT NULL, PRIMARY KEY (`ArticleID`), FULLTEXT KEY `Body` (`Body`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Dumping data for table `kb_search` -- LOCK TABLES `kb_search` WRITE; /*!40000 ALTER TABLE `kb_search` DISABLE KEYS */; INSERT INTO `kb_search` VALUES (1,'Welcome to the knowledgebase This will be filled up with information soon'); /*!40000 ALTER TABLE `kb_search` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `log` -- DROP TABLE IF EXISTS `log`; CREATE TABLE `log` ( `ID` int(10) unsigned NOT NULL auto_increment, `Message` varchar(400) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `Message` (`Message`(255)), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `login_attempts` -- DROP TABLE IF EXISTS `login_attempts`; CREATE TABLE `login_attempts` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL, `IP` varchar(15) NOT NULL, `LastAttempt` datetime NOT NULL default '0000-00-00 00:00:00', `Attempts` int(10) unsigned NOT NULL, `BannedUntil` datetime NOT NULL default '0000-00-00 00:00:00', `Bans` int(10) unsigned NOT NULL, PRIMARY KEY (`ID`), KEY `UserID` (`UserID`), KEY `IP` (`IP`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `news` -- DROP TABLE IF EXISTS `news`; CREATE TABLE `news` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL, `Title` varchar(255) NOT NULL, `Body` text NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`ID`), KEY `UserID` (`UserID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `news` -- LOCK TABLES `news` WRITE; /*!40000 ALTER TABLE `news` DISABLE KEYS */; INSERT INTO `news` VALUES (1,1,'Welcome to your new Gazelle installation','Please read the documentation in /docs to find out how to complete the installation!','2008-07-24 07:29:14'); /*!40000 ALTER TABLE `news` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; CREATE TABLE `permissions` ( `ID` int(10) unsigned NOT NULL auto_increment, `Level` int(10) unsigned NOT NULL, `Name` varchar(25) character set latin1 NOT NULL, `Values` text character set latin1 NOT NULL, `DisplayStaff` enum('0','1') character set latin1 NOT NULL default '0', PRIMARY KEY (`ID`), UNIQUE KEY `Level` (`Level`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` VALUES (1,900,'Administrator','a:75:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:21:\"site_see_old_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:22:\"site_moderate_requests\";s:1:\"1\";s:18:\"site_delete_artist\";s:1:\"1\";s:20:\"site_moderate_forums\";s:1:\"1\";s:20:\"site_resolve_tickets\";s:1:\"1\";s:18:\"site_tickets_admin\";s:1:\"1\";s:14:\"site_view_flow\";s:1:\"1\";s:18:\"site_view_full_log\";s:1:\"1\";s:28:\"site_view_torrent_snatchlist\";s:1:\"1\";s:18:\"site_recommend_own\";s:1:\"1\";s:27:\"site_manage_recommendations\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";s:23:\"site_disable_ip_history\";s:1:\"1\";s:22:\"site_no_access_logging\";s:1:\"1\";s:20:\"users_edit_usernames\";s:1:\"1\";s:16:\"users_edit_ratio\";s:1:\"1\";s:20:\"users_edit_own_ratio\";s:1:\"1\";s:17:\"users_edit_titles\";s:1:\"1\";s:18:\"users_edit_avatars\";s:1:\"1\";s:18:\"users_edit_invites\";s:1:\"1\";s:22:\"users_edit_watch_hours\";s:1:\"1\";s:21:\"users_edit_reset_keys\";s:1:\"1\";s:19:\"users_edit_profiles\";s:1:\"1\";s:20:\"users_reset_own_keys\";s:1:\"1\";s:19:\"users_edit_password\";s:1:\"1\";s:19:\"users_promote_below\";s:1:\"1\";s:16:\"users_promote_to\";s:1:\"1\";s:16:\"users_give_donor\";s:1:\"1\";s:10:\"users_warn\";s:1:\"1\";s:19:\"users_disable_users\";s:1:\"1\";s:19:\"users_disable_posts\";s:1:\"1\";s:17:\"users_disable_any\";s:1:\"1\";s:18:\"users_delete_users\";s:1:\"1\";s:18:\"users_view_invites\";s:1:\"1\";s:20:\"users_view_seedleech\";s:1:\"1\";s:19:\"users_view_uploaded\";s:1:\"1\";s:15:\"users_view_keys\";s:1:\"1\";s:14:\"users_view_ips\";s:1:\"1\";s:16:\"users_view_email\";s:1:\"1\";s:14:\"users_view_pms\";s:1:\"1\";s:23:\"users_override_paranoia\";s:1:\"1\";s:9:\"users_mod\";s:1:\"1\";s:13:\"torrents_edit\";s:1:\"1\";s:15:\"torrents_delete\";s:1:\"1\";s:18:\"torrents_freeleech\";s:1:\"1\";s:17:\"admin_manage_news\";s:1:\"1\";s:18:\"admin_manage_polls\";s:1:\"1\";s:19:\"admin_manage_forums\";s:1:\"1\";s:16:\"admin_manage_fls\";s:1:\"1\";s:13:\"admin_reports\";s:1:\"1\";s:19:\"admin_watched_users\";s:1:\"1\";s:26:\"admin_advanced_user_search\";s:1:\"1\";s:18:\"admin_create_users\";s:1:\"1\";s:25:\"admin_search_duplicate_ip\";s:1:\"1\";s:15:\"admin_donor_log\";s:1:\"1\";s:19:\"admin_manage_ipbans\";s:1:\"1\";s:9:\"admin_dnu\";s:1:\"1\";s:17:\"admin_clear_cache\";s:1:\"1\";s:15:\"admin_whitelist\";s:1:\"1\";s:16:\"admin_access_log\";s:1:\"1\";s:17:\"admin_login_watch\";s:1:\"1\";}','1'),(2,100,'User','a:5:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";}',''),(3,150,'Member','a:7:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";}',''),(4,200,'Power User','a:9:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";}',''),(5,250,'Elite','a:10:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";}',''),(6,475,'VIP','a:14:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";}',''),(7,300,'TorrentMaster','a:13:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";}',''),(8,400,'Legend','a:14:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";}',''),(9,551,'Torrent Celebrity','a:15:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";}',''),(11,700,'Moderator','a:65:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:21:\"site_see_old_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:22:\"site_moderate_requests\";s:1:\"1\";s:18:\"site_delete_artist\";s:1:\"1\";s:20:\"site_moderate_forums\";s:1:\"1\";s:20:\"site_resolve_tickets\";s:1:\"1\";s:18:\"site_tickets_admin\";s:1:\"1\";s:14:\"site_view_flow\";s:1:\"1\";s:18:\"site_view_full_log\";s:1:\"1\";s:28:\"site_view_torrent_snatchlist\";s:1:\"1\";s:18:\"site_recommend_own\";s:1:\"1\";s:27:\"site_manage_recommendations\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";s:23:\"site_disable_ip_history\";s:1:\"1\";s:22:\"site_no_access_logging\";s:1:\"1\";s:20:\"users_edit_own_ratio\";s:1:\"1\";s:17:\"users_edit_titles\";s:1:\"1\";s:18:\"users_edit_avatars\";s:1:\"1\";s:18:\"users_edit_invites\";s:1:\"1\";s:22:\"users_edit_watch_hours\";s:1:\"1\";s:21:\"users_edit_reset_keys\";s:1:\"1\";s:19:\"users_edit_profiles\";s:1:\"1\";s:20:\"users_reset_own_keys\";s:1:\"1\";s:19:\"users_edit_password\";s:1:\"1\";s:19:\"users_promote_below\";s:1:\"1\";s:16:\"users_give_donor\";s:1:\"1\";s:10:\"users_warn\";s:1:\"1\";s:19:\"users_disable_users\";s:1:\"1\";s:19:\"users_disable_posts\";s:1:\"1\";s:17:\"users_disable_any\";s:1:\"1\";s:18:\"users_view_invites\";s:1:\"1\";s:20:\"users_view_seedleech\";s:1:\"1\";s:19:\"users_view_uploaded\";s:1:\"1\";s:15:\"users_view_keys\";s:1:\"1\";s:14:\"users_view_ips\";s:1:\"1\";s:16:\"users_view_email\";s:1:\"1\";s:14:\"users_view_pms\";s:1:\"1\";s:23:\"users_override_paranoia\";s:1:\"1\";s:9:\"users_mod\";s:1:\"1\";s:13:\"torrents_edit\";s:1:\"1\";s:15:\"torrents_delete\";s:1:\"1\";s:18:\"torrents_freeleech\";s:1:\"1\";s:13:\"admin_reports\";s:1:\"1\";s:19:\"admin_watched_users\";s:1:\"1\";s:26:\"admin_advanced_user_search\";s:1:\"1\";s:25:\"admin_search_duplicate_ip\";s:1:\"1\";s:15:\"admin_donor_log\";s:1:\"1\";s:19:\"admin_manage_ipbans\";s:1:\"1\";s:9:\"admin_dnu\";s:1:\"1\";s:17:\"admin_clear_cache\";s:1:\"1\";s:16:\"admin_access_log\";s:1:\"1\";s:17:\"admin_login_watch\";s:1:\"1\";}','1'),(14,800,'Developer','a:66:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:21:\"site_see_old_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:22:\"site_moderate_requests\";s:1:\"1\";s:18:\"site_delete_artist\";s:1:\"1\";s:20:\"site_moderate_forums\";s:1:\"1\";s:20:\"site_resolve_tickets\";s:1:\"1\";s:18:\"site_tickets_admin\";s:1:\"1\";s:14:\"site_view_flow\";s:1:\"1\";s:18:\"site_view_full_log\";s:1:\"1\";s:28:\"site_view_torrent_snatchlist\";s:1:\"1\";s:18:\"site_recommend_own\";s:1:\"1\";s:27:\"site_manage_recommendations\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";s:23:\"site_disable_ip_history\";s:1:\"1\";s:10:\"site_debug\";s:1:\"1\";s:16:\"users_edit_ratio\";s:1:\"1\";s:20:\"users_edit_own_ratio\";s:1:\"1\";s:17:\"users_edit_titles\";s:1:\"1\";s:18:\"users_edit_avatars\";s:1:\"1\";s:18:\"users_edit_invites\";s:1:\"1\";s:22:\"users_edit_watch_hours\";s:1:\"1\";s:21:\"users_edit_reset_keys\";s:1:\"1\";s:19:\"users_edit_profiles\";s:1:\"1\";s:20:\"users_reset_own_keys\";s:1:\"1\";s:19:\"users_edit_password\";s:1:\"1\";s:19:\"users_promote_below\";s:1:\"1\";s:10:\"users_warn\";s:1:\"1\";s:19:\"users_disable_users\";s:1:\"1\";s:17:\"users_disable_any\";s:1:\"1\";s:18:\"users_delete_users\";s:1:\"1\";s:18:\"users_view_invites\";s:1:\"1\";s:20:\"users_view_seedleech\";s:1:\"1\";s:19:\"users_view_uploaded\";s:1:\"1\";s:15:\"users_view_keys\";s:1:\"1\";s:14:\"users_view_ips\";s:1:\"1\";s:16:\"users_view_email\";s:1:\"1\";s:23:\"users_override_paranoia\";s:1:\"1\";s:9:\"users_mod\";s:1:\"1\";s:13:\"torrents_edit\";s:1:\"1\";s:15:\"torrents_delete\";s:1:\"1\";s:18:\"torrents_freeleech\";s:1:\"1\";s:17:\"admin_manage_news\";s:1:\"1\";s:13:\"admin_reports\";s:1:\"1\";s:19:\"admin_watched_users\";s:1:\"1\";s:26:\"admin_advanced_user_search\";s:1:\"1\";s:18:\"admin_create_users\";s:1:\"1\";s:25:\"admin_search_duplicate_ip\";s:1:\"1\";s:19:\"admin_manage_ipbans\";s:1:\"1\";s:17:\"admin_clear_cache\";s:1:\"1\";s:15:\"admin_whitelist\";s:1:\"1\";s:16:\"admin_access_log\";s:1:\"1\";s:14:\"admin_schedule\";s:1:\"1\";s:17:\"admin_login_watch\";s:1:\"1\";}','1'),(15,1000,'SysOp','a:78:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:21:\"site_see_old_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:22:\"site_moderate_requests\";s:1:\"1\";s:18:\"site_delete_artist\";s:1:\"1\";s:20:\"site_moderate_forums\";s:1:\"1\";s:20:\"site_resolve_tickets\";s:1:\"1\";s:18:\"site_tickets_admin\";s:1:\"1\";s:14:\"site_view_flow\";s:1:\"1\";s:18:\"site_view_full_log\";s:1:\"1\";s:28:\"site_view_torrent_snatchlist\";s:1:\"1\";s:18:\"site_recommend_own\";s:1:\"1\";s:27:\"site_manage_recommendations\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";s:23:\"site_disable_ip_history\";s:1:\"1\";s:22:\"site_no_access_logging\";s:1:\"1\";s:10:\"site_debug\";s:1:\"1\";s:20:\"users_edit_usernames\";s:1:\"1\";s:16:\"users_edit_ratio\";s:1:\"1\";s:20:\"users_edit_own_ratio\";s:1:\"1\";s:17:\"users_edit_titles\";s:1:\"1\";s:18:\"users_edit_avatars\";s:1:\"1\";s:18:\"users_edit_invites\";s:1:\"1\";s:22:\"users_edit_watch_hours\";s:1:\"1\";s:21:\"users_edit_reset_keys\";s:1:\"1\";s:19:\"users_edit_profiles\";s:1:\"1\";s:20:\"users_reset_own_keys\";s:1:\"1\";s:19:\"users_edit_password\";s:1:\"1\";s:19:\"users_promote_below\";s:1:\"1\";s:16:\"users_promote_to\";s:1:\"1\";s:16:\"users_give_donor\";s:1:\"1\";s:10:\"users_warn\";s:1:\"1\";s:19:\"users_disable_users\";s:1:\"1\";s:19:\"users_disable_posts\";s:1:\"1\";s:17:\"users_disable_any\";s:1:\"1\";s:18:\"users_delete_users\";s:1:\"1\";s:18:\"users_view_invites\";s:1:\"1\";s:20:\"users_view_seedleech\";s:1:\"1\";s:19:\"users_view_uploaded\";s:1:\"1\";s:15:\"users_view_keys\";s:1:\"1\";s:14:\"users_view_ips\";s:1:\"1\";s:16:\"users_view_email\";s:1:\"1\";s:14:\"users_view_pms\";s:1:\"1\";s:23:\"users_override_paranoia\";s:1:\"1\";s:9:\"users_mod\";s:1:\"1\";s:13:\"torrents_edit\";s:1:\"1\";s:15:\"torrents_delete\";s:1:\"1\";s:18:\"torrents_freeleech\";s:1:\"1\";s:17:\"admin_manage_news\";s:1:\"1\";s:18:\"admin_manage_polls\";s:1:\"1\";s:19:\"admin_manage_forums\";s:1:\"1\";s:16:\"admin_manage_fls\";s:1:\"1\";s:13:\"admin_reports\";s:1:\"1\";s:19:\"admin_watched_users\";s:1:\"1\";s:26:\"admin_advanced_user_search\";s:1:\"1\";s:18:\"admin_create_users\";s:1:\"1\";s:25:\"admin_search_duplicate_ip\";s:1:\"1\";s:15:\"admin_donor_log\";s:1:\"1\";s:19:\"admin_manage_ipbans\";s:1:\"1\";s:9:\"admin_dnu\";s:1:\"1\";s:17:\"admin_clear_cache\";s:1:\"1\";s:15:\"admin_whitelist\";s:1:\"1\";s:24:\"admin_manage_permissions\";s:1:\"1\";s:16:\"admin_access_log\";s:1:\"1\";s:14:\"admin_schedule\";s:1:\"1\";s:17:\"admin_login_watch\";s:1:\"1\";}','1'),(16,500,'Beta Team','a:20:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:25:\"site_submit_requests_free\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";s:19:\"site_advanced_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:23:\"site_edit_knowledgebase\";s:1:\"1\";s:22:\"site_can_invite_always\";s:1:\"1\";s:27:\"site_send_unlimited_invites\";s:1:\"1\";s:20:\"site_moderate_forums\";s:1:\"1\";s:20:\"site_resolve_tickets\";s:1:\"1\";s:18:\"site_tickets_admin\";s:1:\"1\";s:15:\"site_delete_tag\";s:1:\"1\";s:13:\"torrents_edit\";s:1:\"1\";s:17:\"admin_clear_cache\";s:1:\"1\";}',''),(19,201,'Artist','a:9:{s:10:\"site_leech\";s:1:\"1\";s:11:\"site_upload\";s:1:\"1\";s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:19:\"site_make_bookmarks\";s:1:\"1\";s:14:\"site_edit_wiki\";s:1:\"1\";s:18:\"site_recommend_own\";s:1:\"1\";}',''),(20,202,'Donor','a:5:{s:9:\"site_vote\";s:1:\"1\";s:20:\"site_submit_requests\";s:1:\"1\";s:20:\"site_advanced_search\";s:1:\"1\";s:10:\"site_top10\";s:1:\"1\";s:20:\"site_torrents_notify\";s:1:\"1\";}',''); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pm_conversations` -- DROP TABLE IF EXISTS `pm_conversations`; CREATE TABLE `pm_conversations` ( `ID` int(12) NOT NULL auto_increment, `Subject` varchar(255) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `pm_conversations_users` -- DROP TABLE IF EXISTS `pm_conversations_users`; CREATE TABLE `pm_conversations_users` ( `UserID` int(10) NOT NULL default '0', `ConvID` int(12) NOT NULL default '0', `InInbox` enum('1','0') NOT NULL, `InSentbox` enum('1','0') NOT NULL, `SentDate` datetime NOT NULL default '0000-00-00 00:00:00', `ReceivedDate` datetime NOT NULL default '0000-00-00 00:00:00', `UnRead` enum('1','0') NOT NULL default '1', `Sticky` enum('1','0') NOT NULL default '0', PRIMARY KEY (`UserID`,`ConvID`), KEY `InInbox` (`InInbox`), KEY `InSentbox` (`InSentbox`), KEY `ConvID` (`ConvID`), KEY `UserID` (`UserID`), KEY `SentDate` (`SentDate`), KEY `ReceivedDate` (`ReceivedDate`), KEY `Sticky` (`Sticky`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `pm_messages` -- DROP TABLE IF EXISTS `pm_messages`; CREATE TABLE `pm_messages` ( `ID` int(12) NOT NULL auto_increment, `ConvID` int(12) NOT NULL default '0', `SentDate` datetime NOT NULL default '0000-00-00 00:00:00', `SenderID` int(10) NOT NULL default '0', `Body` text, PRIMARY KEY (`ID`), KEY `ConvID` (`ConvID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `polls` -- DROP TABLE IF EXISTS `polls`; CREATE TABLE `polls` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL, `Question` varchar(255) NOT NULL, `Answers` text NOT NULL, `Responses` text NOT NULL, `Expires` datetime NOT NULL default '0000-00-00 00:00:00', `Time` datetime NOT NULL default '0000-00-00 00:00:00', `TopicID` int(10) default NULL, PRIMARY KEY (`ID`), KEY `UserID` (`UserID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `polls_responses` -- DROP TABLE IF EXISTS `polls_responses`; CREATE TABLE `polls_responses` ( `PollID` int(10) unsigned NOT NULL, `UserID` int(10) unsigned NOT NULL, `Response` tinyint(3) unsigned NOT NULL, PRIMARY KEY (`PollID`,`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `reports` -- DROP TABLE IF EXISTS `reports`; CREATE TABLE `reports` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL default '0', `ThingID` int(10) unsigned NOT NULL default '0', `Type` enum('Torrent','User','Comment','Request','Request_Comment','Thread') NOT NULL default 'Torrent', `Comment` text, `ResolverID` int(10) unsigned NOT NULL default '0', `Status` enum('New','InProgress','Resolved') default 'New', `ResolvedTime` datetime NOT NULL default '0000-00-00 00:00:00', `ReportedTime` datetime NOT NULL default '0000-00-00 00:00:00', `Reason` text NOT NULL, PRIMARY KEY (`ID`), KEY `Status` (`Status`), KEY `Type` (`Type`), KEY `ResolvedTime` (`ResolvedTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `requests` -- DROP TABLE IF EXISTS `requests`; CREATE TABLE `requests` ( `ID` int(10) unsigned NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL default '0', `Name` varchar(225) default NULL, `Description` text NOT NULL, `TimeAdded` datetime NOT NULL default '0000-00-00 00:00:00', `FillerID` int(10) unsigned NOT NULL default '0', `Filled` int(10) unsigned NOT NULL default '0', `Bounty` bigint(20) unsigned NOT NULL default '0', `ArtistID` int(10) unsigned NOT NULL default '0', `TimeFilled` datetime NOT NULL default '0000-00-00 00:00:00', `Visible` enum('0','1') NOT NULL default '1', PRIMARY KEY (`ID`), KEY `Userid` (`UserID`), KEY `Bounty` (`Bounty`), KEY `Name` (`Name`), KEY `ArtistID` (`ArtistID`), KEY `Filled` (`Filled`), KEY `FillerID` (`FillerID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `requests_tags` -- DROP TABLE IF EXISTS `requests_tags`; CREATE TABLE `requests_tags` ( `TagID` int(10) NOT NULL default '0', `RequestID` int(10) NOT NULL default '0', `UserID` int(10) default NULL, PRIMARY KEY (`TagID`,`RequestID`), KEY `TagID` (`TagID`), KEY `RequestID` (`RequestID`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `requests_votes` -- DROP TABLE IF EXISTS `requests_votes`; CREATE TABLE `requests_votes` ( `RequestID` int(10) NOT NULL default '0', `UserID` int(10) NOT NULL default '0', PRIMARY KEY (`RequestID`,`UserID`), KEY `RequestID` (`RequestID`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `schedule` -- DROP TABLE IF EXISTS `schedule`; CREATE TABLE `schedule` ( `NextHour` int(2) NOT NULL default '0', `NextDay` int(2) NOT NULL default '0', `NextBiWeekly` int(2) NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `schedule` -- LOCK TABLES `schedule` WRITE; /*!40000 ALTER TABLE `schedule` DISABLE KEYS */; INSERT INTO `schedule` VALUES (15,21,22); /*!40000 ALTER TABLE `schedule` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `stylesheets` -- DROP TABLE IF EXISTS `stylesheets`; CREATE TABLE `stylesheets` ( `ID` int(10) unsigned NOT NULL auto_increment, `Name` varchar(255) NOT NULL, `Description` varchar(255) NOT NULL, `Default` enum('0','1') NOT NULL default '0', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `stylesheets` -- LOCK TABLES `stylesheets` WRITE; /*!40000 ALTER TABLE `stylesheets` DISABLE KEYS */; INSERT INTO `stylesheets` VALUES (1,'Anorex','Simple and sleek stylesheet by WhatMan','1'),(2,'Layer_Cake','Very purty stylesheet by Emm','0'),(4,'Dark','Quick port of the legendary DarkSpace!','0'),(5,'Kuro','Very sleek and dark theme by Stewy, A9, and WhatMan','0'),(6,'Shiro','Pleasing white theme','0'),(7,'WhatLove','','0'),(8,'BlueBit','A port of the classic BlueBit theme to Gazelle','0'),(9,'Proton','Protieks Proton','0'),(10,'Whatnificent','Whatnificent by Paaskehare','0'),(11,'Hydro','Cooling off on a hot summer day. -A9','0'),(12,'Exec','Exec by Huevoos','0'); /*!40000 ALTER TABLE `stylesheets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `tags` -- DROP TABLE IF EXISTS `tags`; CREATE TABLE `tags` ( `ID` int(10) NOT NULL auto_increment, `Name` varchar(100) default NULL, `TagType` enum('genre','other') NOT NULL default 'other', `Uses` int(12) NOT NULL default '1', `UserID` int(10) default NULL, PRIMARY KEY (`ID`), UNIQUE KEY `Name_2` (`Name`), KEY `TagType` (`TagType`), KEY `Uses` (`Uses`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `ticket_categories` -- DROP TABLE IF EXISTS `ticket_categories`; CREATE TABLE `ticket_categories` ( `ID` tinyint(2) unsigned NOT NULL auto_increment, `Name` varchar(50) NOT NULL default '', PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `ticket_categories` -- LOCK TABLES `ticket_categories` WRITE; /*!40000 ALTER TABLE `ticket_categories` DISABLE KEYS */; INSERT INTO `ticket_categories` VALUES (1,'BitTorrent'),(2,'Encoding'),(3,'Ripping'),(4,'Windows'),(5,'Mac OS'),(6,'Linux'),(7,'IRC'),(8,'Networking'),(9,'Conflict Resolution'),(10,'Other'),(11,'Website Bugs (Style / Layout)'),(12,'Website Bugs (General)'); /*!40000 ALTER TABLE `ticket_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `ticket_comments` -- DROP TABLE IF EXISTS `ticket_comments`; CREATE TABLE `ticket_comments` ( `ID` int(12) unsigned NOT NULL auto_increment, `TicketID` int(10) unsigned NOT NULL default '0', `AuthorID` int(10) unsigned NOT NULL default '0', `AddedTime` datetime NOT NULL default '0000-00-00 00:00:00', `Body` mediumtext, PRIMARY KEY (`ID`), KEY `TicketID` (`TicketID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `tickets` -- DROP TABLE IF EXISTS `tickets`; CREATE TABLE `tickets` ( `ID` int(10) unsigned NOT NULL auto_increment, `Title` varchar(150) NOT NULL, `Body` mediumtext, `Status` tinyint(2) NOT NULL default '0', `StatusEditorID` int(10) unsigned NOT NULL default '0', `AuthorID` int(10) unsigned NOT NULL default '0', `Categories` int(20) NOT NULL default '1', `AddedTime` datetime NOT NULL default '0000-00-00 00:00:00', `LastActive` datetime NOT NULL default '0000-00-00 00:00:00', `AccessLevel` int(3) unsigned NOT NULL default '45', PRIMARY KEY (`ID`), KEY `Status` (`Status`), KEY `AuthorID` (`AuthorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrent_hash` -- DROP TABLE IF EXISTS `torrent_hash`; CREATE TABLE `torrent_hash` ( `GroupID` int(11) NOT NULL, `GroupName` varchar(300) NOT NULL, `GroupYear` int(4) NOT NULL, `GroupCategoryID` int(10) unsigned NOT NULL, `GroupTime` datetime NOT NULL, `MaxTorrentSize` bigint(20) unsigned NOT NULL, `TotalSnatches` int(10) unsigned NOT NULL, `TotalSeeders` int(10) unsigned NOT NULL, `TotalLeechers` int(10) unsigned NOT NULL, `ArtistID` int(10) unsigned NOT NULL, `ArtistName` varchar(200) NOT NULL, `TorrentIDList` varchar(500) NOT NULL, `TagList` varchar(500) NOT NULL, `MediaList` varchar(500) NOT NULL, `FormatList` varchar(500) NOT NULL, `EncodingList` varchar(500) NOT NULL, `YearList` varchar(500) NOT NULL, `RemasterList` varchar(500) NOT NULL, `RemasterTitleList` varchar(500) NOT NULL, `SceneList` varchar(500) NOT NULL, `LogList` varchar(500) NOT NULL, `CueList` varchar(500) NOT NULL, `FileCountList` varchar(500) NOT NULL, `SizeList` varchar(500) NOT NULL, `LeechersList` varchar(500) NOT NULL, `SeedersList` varchar(500) NOT NULL, `SnatchedList` varchar(500) NOT NULL, `FreeTorrentList` varchar(500) NOT NULL, `TimeList` varchar(500) NOT NULL, `SearchText` varchar(255) NOT NULL, PRIMARY KEY (`GroupID`), KEY `TotalSnatches` (`TotalSnatches`), KEY `TotalSeeders` (`TotalSeeders`), KEY `TotalLeechers` (`TotalLeechers`), KEY `ArtistID` (`ArtistID`), FULLTEXT KEY `SearchText` (`SearchText`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents` -- DROP TABLE IF EXISTS `torrents`; CREATE TABLE `torrents` ( `ID` int(10) NOT NULL auto_increment, `GroupID` int(10) NOT NULL, `UserID` int(10) default NULL, `Media` varchar(20) default NULL, `Format` varchar(10) default NULL, `Encoding` varchar(15) default NULL, `Year` int(4) default NULL, `Remastered` enum('0','1') NOT NULL default '0', `RemasterTitle` varchar(40) default NULL, `Scene` enum('0','1') NOT NULL default '0', `HasLog` enum('0','1') NOT NULL default '0', `HasCue` enum('0','1') NOT NULL default '0', `info_hash` blob NOT NULL, `InfoHash` char(40) NOT NULL default '', `FileCount` int(6) NOT NULL, `FileList` mediumtext NOT NULL, `Size` bigint(12) NOT NULL, `Leechers` int(6) NOT NULL default '0', `Seeders` int(6) NOT NULL default '0', `last_action` datetime NOT NULL default '0000-00-00 00:00:00', `FreeTorrent` enum('0','1') NOT NULL default '0', `Dupable` enum('0','1') NOT NULL default '0', `DupeReason` varchar(40) default NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', `Anonymous` enum('0','1') NOT NULL default '0', `Description` text, `Snatched` int(10) unsigned NOT NULL default '0', `completed` int(11) NOT NULL, `announced_http` int(11) NOT NULL, `announced_http_compact` int(11) NOT NULL, `announced_http_no_peer_id` int(11) NOT NULL, `announced_udp` int(11) NOT NULL, `scraped_http` int(11) NOT NULL, `scraped_udp` int(11) NOT NULL, `started` int(11) NOT NULL, `stopped` int(11) NOT NULL, `flags` int(11) NOT NULL, `mtime` int(11) NOT NULL, `ctime` int(11) NOT NULL, `balance` int(11) NOT NULL, PRIMARY KEY (`ID`), UNIQUE KEY `InfoHash` (`info_hash`(40)), KEY `GroupID` (`GroupID`), KEY `UserID` (`UserID`), KEY `Media` (`Media`), KEY `Format` (`Format`), KEY `Encoding` (`Encoding`), KEY `Year` (`Year`), KEY `FileCount` (`FileCount`), KEY `Size` (`Size`), KEY `Seeders` (`Seeders`), KEY `Leechers` (`Leechers`), KEY `Snatched` (`Snatched`), KEY `last_action` (`last_action`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents_comments` -- DROP TABLE IF EXISTS `torrents_comments`; CREATE TABLE `torrents_comments` ( `ID` int(10) NOT NULL auto_increment, `GroupID` int(10) NOT NULL, `TorrentID` int(10) unsigned NOT NULL, `AuthorID` int(10) NOT NULL, `AddedTime` datetime NOT NULL default '0000-00-00 00:00:00', `Body` mediumtext, `EditedUserID` int(10) default NULL, `EditedTime` datetime default NULL, PRIMARY KEY (`ID`), KEY `TopicID` (`GroupID`), KEY `AuthorID` (`AuthorID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents_group` -- DROP TABLE IF EXISTS `torrents_group`; CREATE TABLE `torrents_group` ( `ID` int(10) NOT NULL auto_increment, `ArtistID` int(10) default NULL, `CategoryID` int(3) default NULL, `Name` varchar(300) default NULL, `Year` int(4) default NULL, `TagList` varchar(500) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', `RevisionID` int(12) default NULL, `WikiBody` text NOT NULL, `WikiImage` varchar(255) NOT NULL, `SearchText` varchar(500) NOT NULL, PRIMARY KEY (`ID`), KEY `ArtistID` (`ArtistID`), KEY `CategoryID` (`CategoryID`), KEY `Name` (`Name`(255)), KEY `Year` (`Year`), KEY `Time` (`Time`), KEY `RevisionID` (`RevisionID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents_recommended` -- DROP TABLE IF EXISTS `torrents_recommended`; CREATE TABLE `torrents_recommended` ( `GroupID` int(10) NOT NULL, `UserID` int(10) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`GroupID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents_tags` -- DROP TABLE IF EXISTS `torrents_tags`; CREATE TABLE `torrents_tags` ( `TagID` int(10) NOT NULL default '0', `GroupID` int(10) NOT NULL default '0', `PositiveVotes` int(6) NOT NULL default '1', `NegativeVotes` int(6) NOT NULL default '1', `UserID` int(10) default NULL, PRIMARY KEY (`TagID`,`GroupID`), KEY `TagID` (`TagID`), KEY `GroupID` (`GroupID`), KEY `PositiveVotes` (`PositiveVotes`), KEY `NegativeVotes` (`NegativeVotes`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `torrents_tags_votes` -- DROP TABLE IF EXISTS `torrents_tags_votes`; CREATE TABLE `torrents_tags_votes` ( `GroupID` int(10) NOT NULL, `TagID` int(10) NOT NULL, `UserID` int(10) NOT NULL, `Way` enum('up','down') NOT NULL default 'up', PRIMARY KEY (`GroupID`,`TagID`,`UserID`,`Way`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `tracker_announce_log` -- DROP TABLE IF EXISTS `tracker_announce_log`; CREATE TABLE `tracker_announce_log` ( `ID` int(11) NOT NULL auto_increment, `UserID` int(10) unsigned NOT NULL, `TorrentID` int(10) unsigned NOT NULL, `IP` varchar(15) NOT NULL, `Port` int(5) NOT NULL, `Event` varchar(10) NOT NULL, `Uploaded` bigint(20) NOT NULL, `Downloaded` bigint(20) NOT NULL, `Left` bigint(20) NOT NULL, `PeerID` char(20) NOT NULL, `UserAgent` varchar(51) NOT NULL, `Time` datetime NOT NULL, `RequestURI` varchar(400) NOT NULL default '', `Peer_Key` varchar(51) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_exclude_reseed` -- DROP TABLE IF EXISTS `users_exclude_reseed`; CREATE TABLE `users_exclude_reseed` ( `TorrentID` int(10) NOT NULL, `UserID` int(10) NOT NULL, PRIMARY KEY (`TorrentID`,`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_history_emails` -- DROP TABLE IF EXISTS `users_history_emails`; CREATE TABLE `users_history_emails` ( `UserID` int(10) NOT NULL, `OldEmail` varchar(255) default NULL, `NewEmail` varchar(255) default NULL, `ChangeTime` datetime default NULL, `ChangerIP` varchar(15) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `users_history_ips` -- DROP TABLE IF EXISTS `users_history_ips`; CREATE TABLE `users_history_ips` ( `UserID` int(10) NOT NULL, `IP` varchar(15) NOT NULL default '0.0.0.0', `StartTime` datetime NOT NULL default '0000-00-00 00:00:00', `EndTime` datetime default NULL, PRIMARY KEY (`UserID`,`IP`,`StartTime`), KEY `UserID` (`UserID`), KEY `IP` (`IP`), KEY `StartTime` (`StartTime`), KEY `EndTime` (`EndTime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_history_passkeys` -- DROP TABLE IF EXISTS `users_history_passkeys`; CREATE TABLE `users_history_passkeys` ( `UserID` int(10) NOT NULL, `OldPassKey` varchar(32) default NULL, `NewPassKey` varchar(32) default NULL, `ChangeTime` datetime default NULL, `ChangerIP` varchar(15) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `users_history_passwords` -- DROP TABLE IF EXISTS `users_history_passwords`; CREATE TABLE `users_history_passwords` ( `UserID` int(10) NOT NULL, `ChangeTime` datetime default NULL, `ChangerIP` varchar(15) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `users_history_ratio` -- DROP TABLE IF EXISTS `users_history_ratio`; CREATE TABLE `users_history_ratio` ( `Sequence` int(10) NOT NULL, `UserID` int(10) NOT NULL, `Uploaded` bigint(20) unsigned NOT NULL, `Downloaded` bigint(20) unsigned NOT NULL, `UpChange` bigint(13) NOT NULL, `DownChange` bigint(13) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`UserID`,`Sequence`), KEY `UserID` (`UserID`), KEY `Sequence` (`Sequence`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `users_history_ratio_hourly` -- DROP TABLE IF EXISTS `users_history_ratio_hourly`; CREATE TABLE `users_history_ratio_hourly` ( `Sequence` int(10) NOT NULL, `UserID` int(10) NOT NULL, `Uploaded` bigint(20) unsigned NOT NULL, `Downloaded` bigint(20) unsigned NOT NULL, `UpChange` bigint(13) NOT NULL, `DownChange` bigint(13) NOT NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (`UserID`,`Sequence`), KEY `UserID` (`UserID`), KEY `Sequence` (`Sequence`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_info` -- DROP TABLE IF EXISTS `users_info`; CREATE TABLE `users_info` ( `UserID` int(10) unsigned NOT NULL, `StyleID` int(10) unsigned NOT NULL, `StyleURL` varchar(255) default NULL, `Info` text NOT NULL, `Avatar` varchar(255) NOT NULL, `Country` int(10) unsigned NOT NULL, `AdminComment` text NOT NULL, `SiteOptions` text NOT NULL, `ViewAvatars` enum('0','1') NOT NULL default '1', `Donor` enum('0','1') NOT NULL default '0', `Artist` enum('0','1') NOT NULL default '0', `DownloadAlt` enum('0','1') NOT NULL default '0', `Warned` datetime NOT NULL, `MessagesPerPage` tinyint(3) unsigned NOT NULL default '0', `DeletePMs` enum('0','1') NOT NULL default '1', `SaveSentPMs` enum('0','1') NOT NULL default '0', `SupportFor` varchar(255) NOT NULL, `TorrentGrouping` enum('0','1','2') NOT NULL COMMENT '0=Open,1=Closed,2=Off', `ShowTags` enum('0','1') NOT NULL default '1', `AuthKey` varchar(32) NOT NULL, `ResetKey` varchar(32) NOT NULL, `ResetExpires` datetime NOT NULL default '0000-00-00 00:00:00', `JoinDate` datetime NOT NULL default '0000-00-00 00:00:00', `Inviter` int(10) default NULL, `WarnedTimes` int(2) NOT NULL default '0', `DisableAvatar` enum('0','1') NOT NULL default '0', `DisableInvites` enum('0','1') NOT NULL default '0', `DisablePosting` enum('0','1') NOT NULL default '0', `DisableTagging` enum('0','1') NOT NULL default '0', `DisableUpload` enum('0','1') NOT NULL default '0', `DisableWiki` enum('0','1') NOT NULL default '0', `RatioWatchEnds` datetime NOT NULL default '0000-00-00 00:00:00', `RatioWatchDownload` bigint(20) unsigned NOT NULL default '0', `RatioWatchTimes` tinyint(1) unsigned NOT NULL default '0', `BanDate` datetime NOT NULL default '0000-00-00 00:00:00', `BanReason` enum('0','1','2','3','4') NOT NULL default '0', UNIQUE KEY `UserID` (`UserID`), KEY `SupportFor` (`SupportFor`), KEY `DisableInvites` (`DisableInvites`), KEY `Donor` (`Donor`), KEY `Warned` (`Warned`), KEY `JoinDate` (`JoinDate`), KEY `Inviter` (`Inviter`), KEY `RatioWatchEnds` (`RatioWatchEnds`), KEY `RatioWatchDownload` (`RatioWatchDownload`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_main` -- DROP TABLE IF EXISTS `users_main`; CREATE TABLE `users_main` ( `ID` int(10) unsigned NOT NULL auto_increment, `Username` varchar(20) NOT NULL, `Email` varchar(255) NOT NULL, `PassHash` char(40) NOT NULL, `Secret` char(32) NOT NULL, `TorrentKey` char(32) NOT NULL, `IRCKey` char(32) default NULL, `LastLogin` datetime NOT NULL default '0000-00-00 00:00:00', `LastAccess` datetime NOT NULL default '0000-00-00 00:00:00', `IP` varchar(15) NOT NULL default '0.0.0.0', `Class` tinyint(2) NOT NULL default '5', `Uploaded` bigint(20) unsigned NOT NULL default '0', `Downloaded` bigint(20) unsigned NOT NULL default '0', `Title` varchar(100) NOT NULL, `Enabled` enum('0','1','2') NOT NULL default '0', `Paranoia` enum('0','1','2','3','4','5') NOT NULL default '0', `Invites` int(10) unsigned NOT NULL default '0', `PermissionID` int(10) unsigned NOT NULL, `CustomPermissions` text, `LastSeed` datetime NOT NULL default '0000-00-00 00:00:00', `pass` blob NOT NULL COMMENT 'useless column', `can_leech` tinyint(4) NOT NULL default '1', `wait_time` int(11) NOT NULL, `peers_limit` int(11) default '1000', `torrents_limit` int(11) default '1000', `torrent_pass` char(32) NOT NULL, `torrent_pass_secret` bigint(20) NOT NULL COMMENT 'useless column', `fid_end` int(11) NOT NULL COMMENT 'useless column', `name` char(8) NOT NULL COMMENT 'useless column', `OldPassHash` char(32) default NULL, `Cursed` enum('1','0') NOT NULL default '0', `CookieID` char(32) default NULL, `SessionID` char(32) default NULL, PRIMARY KEY (`ID`), KEY `Username` (`Username`), KEY `Email` (`Email`), KEY `PassHash` (`PassHash`), KEY `LastAccess` (`LastAccess`), KEY `IP` (`IP`), KEY `Class` (`Class`), KEY `Uploaded` (`Uploaded`), KEY `Downloaded` (`Downloaded`), KEY `Enabled` (`Enabled`), KEY `Invites` (`Invites`), KEY `Cursed` (`Cursed`), KEY `torrent_pass` (`torrent_pass`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_notify_filters` -- DROP TABLE IF EXISTS `users_notify_filters`; CREATE TABLE `users_notify_filters` ( `ID` int(12) NOT NULL auto_increment, `UserID` int(10) NOT NULL, `Label` varchar(128) NOT NULL default '', `Artists` mediumtext NOT NULL, `Tags` varchar(500) NOT NULL default '', `Categories` varchar(500) NOT NULL default '', `Formats` varchar(500) NOT NULL default '', `Encodings` varchar(500) NOT NULL default '', `Media` varchar(500) NOT NULL default '', PRIMARY KEY (`ID`), KEY `UserID` (`UserID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `users_notify_torrents` -- DROP TABLE IF EXISTS `users_notify_torrents`; CREATE TABLE `users_notify_torrents` ( `UserID` int(10) NOT NULL, `GroupID` int(10) NOT NULL, `TorrentID` int(10) NOT NULL, `UnRead` enum('1','0') NOT NULL default '1', PRIMARY KEY (`UserID`,`TorrentID`), KEY `UnRead` (`UnRead`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `watchlist` -- DROP TABLE IF EXISTS `watchlist`; CREATE TABLE `watchlist` ( `UserID` int(10) unsigned NOT NULL, `Comment` text NOT NULL, `Added` datetime NOT NULL default '0000-00-00 00:00:00', `CheckedUp` datetime NOT NULL default '0000-00-00 00:00:00', `CheckedUpBy` int(10) unsigned NOT NULL, PRIMARY KEY (`UserID`), KEY `Added` (`Added`), KEY `CheckedUp` (`CheckedUp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `whitelist` -- DROP TABLE IF EXISTS `whitelist`; CREATE TABLE `whitelist` ( `ID` int(10) unsigned NOT NULL auto_increment, `Client` varchar(100) character set latin1 default NULL, `Peer_ID` varchar(20) character set latin1 default NULL, `Notes` varchar(200) character set latin1 default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `wiki_aliases` -- DROP TABLE IF EXISTS `wiki_aliases`; CREATE TABLE `wiki_aliases` ( `Alias` varchar(100) default NULL, `ArticleID` int(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `wiki_articles` -- DROP TABLE IF EXISTS `wiki_articles`; CREATE TABLE `wiki_articles` ( `ID` int(10) NOT NULL auto_increment, `Title` varchar(100) default NULL, `Body` text, `MinClassRead` int(4) default NULL, `MinClassWrite` int(4) default NULL, `Date` datetime default NULL, `Author` int(10) default NULL, PRIMARY KEY (`ID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `wiki_artists` -- DROP TABLE IF EXISTS `wiki_artists`; CREATE TABLE `wiki_artists` ( `RevisionID` int(12) NOT NULL auto_increment, `PageID` int(10) NOT NULL default '0', `Body` text, `UserID` int(10) NOT NULL default '0', `Summary` varchar(100) default NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', `Image` varchar(255) default NULL, PRIMARY KEY (`RevisionID`), KEY `PageID` (`PageID`), KEY `UserID` (`UserID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `wiki_revisions` -- DROP TABLE IF EXISTS `wiki_revisions`; CREATE TABLE `wiki_revisions` ( `ID` int(10) NOT NULL, `Revision` int(10) NOT NULL, `Title` varchar(100) default NULL, `Body` text, `Date` datetime default NULL, `Author` int(10) default NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Table structure for table `wiki_torrents` -- DROP TABLE IF EXISTS `wiki_torrents`; CREATE TABLE `wiki_torrents` ( `RevisionID` int(12) NOT NULL auto_increment, `PageID` int(10) NOT NULL default '0', `Body` text, `UserID` int(10) NOT NULL default '0', `Summary` varchar(100) default NULL, `Time` datetime NOT NULL default '0000-00-00 00:00:00', `Image` varchar(255) default NULL, PRIMARY KEY (`RevisionID`), KEY `PageID` (`PageID`), KEY `UserID` (`UserID`), KEY `Time` (`Time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_announce_log` -- DROP TABLE IF EXISTS `xbt_announce_log`; CREATE TABLE `xbt_announce_log` ( `id` int(11) NOT NULL auto_increment, `ipa` int(10) unsigned NOT NULL, `port` int(11) NOT NULL, `event` int(11) NOT NULL, `info_hash` blob NOT NULL, `peer_id` blob NOT NULL, `downloaded` bigint(20) NOT NULL, `left0` bigint(20) NOT NULL, `uploaded` bigint(20) NOT NULL, `uid` int(11) NOT NULL, `mtime` int(11) NOT NULL, `useragent` varchar(51) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_cheat` -- DROP TABLE IF EXISTS `xbt_cheat`; CREATE TABLE `xbt_cheat` ( `id` int(11) NOT NULL auto_increment, `uid` int(11) NOT NULL, `ipa` int(10) unsigned NOT NULL, `upspeed` bigint(20) NOT NULL, `tstamp` int(11) NOT NULL, `uploaded` bigint(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_client_whitelist` -- DROP TABLE IF EXISTS `xbt_client_whitelist`; CREATE TABLE `xbt_client_whitelist` ( `id` int(10) unsigned NOT NULL auto_increment, `peer_id` varchar(20) default NULL, `vstring` varchar(200) default '', PRIMARY KEY (`id`), UNIQUE KEY `peer_id` (`peer_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `xbt_client_whitelist` -- LOCK TABLES `xbt_client_whitelist` WRITE; /*!40000 ALTER TABLE `xbt_client_whitelist` DISABLE KEYS */; INSERT INTO `xbt_client_whitelist` VALUES (1,'-AZ25','Azureus 2.5.x'),(2,'-AZ30','Azureus 3.0.x'),(3,'-BG09','btgdaemon 0.9.x'),(5,'-DE05','Deluge 0.5.x'),(7,'-HL029','Halite 0.2.9.x'),(9,'-KT22','KTorrent 2.2.x'),(10,'-lt0B','libtorrent 0.11.x (rtorrent)'),(25,'-UT180B-','uTorrent 1.8 Beta (7928+)'),(26,'T03','BitTornado 0.3.x'),(28,'-KT21','KTorrent 2.1.x'),(29,'btpd/0.13','btpd 0.13'),(35,'-TR104','Transmission 1.04'),(36,'-CD0302-','Enhanced CTorrent (dnh3.2)'),(37,'-UT1610-','uTorrent 1.6.1'),(38,'-HL030','Halite 0.3.0.x'),(39,'-UT1770-','uTorrent 1.7.7'),(40,'-UT1760-','uTorrent 1.7.6'),(41,'-lt0C','libtorrent 0.12.x (rtorrent)'),(42,'-KT30','KTorrent 3.0.x'),(43,'-lt0A4','libtorrent 0.10.4 (rtorrent)'),(44,'-TR105','Transmission 1.05'),(45,'-TR106','Transmission 1.06'),(46,'-DE06','Deluge 0.6.0 (Dev Builds)'),(47,'-TR11','Transmission 1.1x'),(48,'-TR12','Transmission 1.2x'),(49,'-AZ31','Azureus 3.1'),(50,'-KT31','KT'),(51,'-HL031','Halite 3.1'),(52,'-UT1800-','uTorrent 1.8'); /*!40000 ALTER TABLE `xbt_client_whitelist` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xbt_config` -- DROP TABLE IF EXISTS `xbt_config`; CREATE TABLE `xbt_config` ( `name` varchar(255) NOT NULL, `value` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Dumping data for table `xbt_config` -- LOCK TABLES `xbt_config` WRITE; /*!40000 ALTER TABLE `xbt_config` DISABLE KEYS */; INSERT INTO `xbt_config` VALUES ('announce_interval','1800'),('anonymous_connect','0'),('anonymous_announce','0'),('anonymous_scrape','0'),('auto_register','0'),('clean_up_interval','60'),('daemon','1'),('debug','0'),('gzip_announce','1'),('gzip_debug','0'),('gzip_scrape','1'),('listen_check','1'),('listen_ipa','70.47.114.223'),('listen_port','34000'),('log_access','0'),('log_announce','0'),('log_scrape','0'),('pid_file','xbt_tracker.pid'),('read_config_interval','10'),('read_db_interval','30'),('redirect_url',''),('scrape_interval','1800'),('table_announce_log','xbt_announce_log'),('table_files','torrents'),('table_scrape_log','xbt_scrape_log'),('table_users','users_main'),('update_files_method','2'),('write_db_interval','5'),('column_files_fid','ID'),('column_files_completed','Snatched'),('column_users_uid','ID'),('column_users_torrents_limit','maxtorrents'),('column_users_pass','torrent_pass'),('column_files_seeders','seeders'),('column_files_users_fid','fid'),('column_files_leechers','leechers'),('query_log','query_log.txt'),('read_db_users_interval','1800'),('cheater_speed','26214400'),('table_client_whitelist','xbt_client_whitelist'),('client_whitelist','1'); /*!40000 ALTER TABLE `xbt_config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `xbt_deny_from_hosts` -- DROP TABLE IF EXISTS `xbt_deny_from_hosts`; CREATE TABLE `xbt_deny_from_hosts` ( `begin` int(11) NOT NULL, `end` int(11) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_files` -- DROP TABLE IF EXISTS `xbt_files`; CREATE TABLE `xbt_files` ( `fid` int(11) NOT NULL auto_increment, `info_hash` blob NOT NULL, `leechers` int(11) NOT NULL, `seeders` int(11) NOT NULL, `completed` int(11) NOT NULL, `announced_http` int(11) NOT NULL, `announced_http_compact` int(11) NOT NULL, `announced_http_no_peer_id` int(11) NOT NULL, `announced_udp` int(11) NOT NULL, `scraped_http` int(11) NOT NULL, `scraped_udp` int(11) NOT NULL, `started` int(11) NOT NULL, `stopped` int(11) NOT NULL, `flags` int(11) NOT NULL, `mtime` int(11) NOT NULL, `ctime` int(11) NOT NULL, `balance` int(11) NOT NULL, `freetorrent` int(11) NOT NULL default '0', PRIMARY KEY (`fid`), UNIQUE KEY `info_hash` (`info_hash`(20)) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_files_users` -- DROP TABLE IF EXISTS `xbt_files_users`; CREATE TABLE `xbt_files_users` ( `uid` int(11) NOT NULL, `active` tinyint(1) NOT NULL, `announced` int(11) NOT NULL, `completed` int(11) NOT NULL, `downloaded` bigint(20) NOT NULL, `remaining` bigint(20) NOT NULL, `uploaded` bigint(20) NOT NULL, `upspeed` bigint(20) NOT NULL, `downspeed` bigint(20) NOT NULL, `timespent` bigint(20) NOT NULL, `useragent` varchar(51) NOT NULL, `connectable` tinyint(4) NOT NULL default '1', `peer_id` varchar(8) NOT NULL, `fid` int(11) NOT NULL, `ipa` int(11) NOT NULL, `mtime` int(11) NOT NULL, UNIQUE KEY `uid_2` (`uid`,`fid`,`ipa`), KEY `uid` (`uid`), KEY `remaining_idx` (`remaining`), KEY `fid_idx` (`fid`), KEY `mtime_idx` (`mtime`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_scrape_log` -- DROP TABLE IF EXISTS `xbt_scrape_log`; CREATE TABLE `xbt_scrape_log` ( `id` int(11) NOT NULL auto_increment, `ipa` int(11) NOT NULL, `info_hash` blob, `uid` int(11) NOT NULL, `mtime` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_snatched` -- DROP TABLE IF EXISTS `xbt_snatched`; CREATE TABLE `xbt_snatched` ( `uid` int(11) NOT NULL default '0', `tstamp` int(11) NOT NULL, `fid` int(11) NOT NULL, KEY `fid` (`fid`), KEY `uid` (`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- -- Table structure for table `xbt_users` -- DROP TABLE IF EXISTS `xbt_users`; CREATE TABLE `xbt_users` ( `uid` int(11) NOT NULL auto_increment, `name` char(8) NOT NULL, `pass` blob NOT NULL, `can_leech` tinyint(4) NOT NULL default '1', `wait_time` int(11) NOT NULL, `peers_limit` int(11) NOT NULL, `torrents_limit` int(11) NOT NULL, `torrent_pass` char(32) NOT NULL, `torrent_pass_secret` bigint(20) NOT NULL, `downloaded` bigint(20) NOT NULL, `uploaded` bigint(20) NOT NULL, `fid_end` int(11) NOT NULL, PRIMARY KEY (`uid`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2008-08-18 13:36:17