Fresh DB [=

[xblade]

Why put useless threads on..the same with bvlist

[BamBam0077]

Code Select Expand


-- -----------------------------------------------
CREATE TABLE `announce` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`domain` varchar(255) NOT NULL DEFAULT 'https://localhost',
`torrent` int(10) unsigned NOT NULL,
`leechers` int(10) unsigned NOT NULL DEFAULT '0',
`seeders` int(10) unsigned NOT NULL DEFAULT '0',
`times_completed` int(10) unsigned NOT NULL DEFAULT '0',
`torrent_online` enum('yes', 'no') NOT NULL DEFAULT 'yes',
PRIMARY KEY (`id`),
KEY `torrent` (`torrent`),
KEY `torrent_active`  (`torrent_online`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `attachments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`topic_id` int(10) unsigned NOT NULL DEFAULT '0',
`post_id` int(10) unsigned NOT NULL DEFAULT '0',
`filename` varchar(255) NOT NULL DEFAULT '',
`size` int(20) unsigned NOT NULL DEFAULT '0',
`owner` int(10) unsigned NOT NULL DEFAULT '0',
`downloads` int(10) unsigned NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` varchar(255) NOT NULL,
PRIMARY KEY (`id`),
KEY `topicid` (`topic_id`),
KEY `postid` (`post_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `attachments_downloads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`fileid` int(10) NOT NULL DEFAULT '0',
`username` varchar(255) NOT NULL DEFAULT '',
`userid` int(10) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`downloads` int(10) unsigned NOT NULL,
PRIMARY KEY (`id`),
KEY `fileid_userid` (`fileid`,`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `bans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ban_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`added_by` int(10) unsigned NOT NULL DEFAULT '0',
`reason` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`first` varchar(40) DEFAULT NULL,
`last` varchar(40) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `first_last` (`first`,`last`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `email_bans` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) NOT NULL DEFAULT '',
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`added_by` blob,
`comments` varchar(255) NOT NULL DEFAULT '',
`email` varchar(255) NOT NULL DEFAULT 'admin@localhost',
PRIMARY KEY (`id`),
KEY `memberid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `blocks` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL DEFAULT '',
`named` varchar(255) NOT NULL DEFAULT '',
`position` varchar(10) NOT NULL DEFAULT '',
`description` varchar(255) NOT NULL DEFAULT '',
`sort` int(11) NOT NULL DEFAULT '0',
`enabled` tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `enabled_pos` (`position`, `enabled`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `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) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`cat_desc` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'No Description',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `comments` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`torrent` int(10) unsigned NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`text` blob,
`news` int(10) unsigned NOT NULL DEFAULT '0',
`edited_by` int(10) unsigned NOT NULL DEFAULT '0',
`edited_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`request` int(10) unsigned NOT NULL DEFAULT '0',
`anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`),
KEY `memberid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `groups` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`groupname` blob,
`control_panel` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`view_news` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`view_profiles` tinyint(2) unsigned NOT NULL DEFAULT '0',
`view_threads` tinyint(2) unsigned NOT NULL DEFAULT '0',
`view_torrents` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`view_birthday_list` tinyint(2) unsigned NOT NULL DEFAULT '0',
`view_members_list` tinyint(2) unsigned NOT NULL DEFAULT '0',
`edit_torrent_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`edit_news_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`edit_threads_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`delete_torrent_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`delete_news_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`delete_threads_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`override_group_class` tinyint(2) unsigned NOT NULL DEFAULT '0',
`upload_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`download_permission` enum('yes','no') unsigned NOT NULL DEFAULT 'no',
`sort` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `birthday_list` (`view_birthday_list`),
KEY `members_list` (`view_members_list`),
KEY `edit_torrent` (`edit_torrent_permission`),
KEY `edit_news` (`edit_torrent_permission`),
KEY `edit_threads` (`edit_threads_permission`),
KEY `delete_torrent` (`delete_torrent_permission`),
KEY `delete_news` (`delete_news_permission`),
KEY `delete_threads` (`delete_threads_permission`),
KEY `override_group` (`override_group_class`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `teams` (
`id` int(10) unsigned NOT NULL DEFAULT AUTO_INCREMENT,
`owner` int(10) unsigned NOT NULL DEFAULT '0',
`name` blob,
`info` blob,
`image` blob,
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
UNIQUE KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `completed` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`userid` int(10) NOT NULL DEFAULT '0',
`torrentid` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
UNIQUE `userid_torrentid` (`userid`, `torrentid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `guest_cache` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`ip` varchar(39) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`date_visited` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `countries` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
`flagpic` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `invites` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender` int(10) unsigned NOT NULL DEFAULT '0',
`reciever` int(10) unsigned NOT NULL DEFAULT '0',
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`hash` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`invite_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`status` enum('pending','confirmed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
PRIMARY KEY (`id`),
UNIQUE KEY (`hash`),
KEY `username` (`username`),
KEY `email` (`email`),
KEY `sender` (`sender`),
KEY `datestamps` (`invite_added`),
KEY `recieverid` (`reciever`,`status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `faq` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` blob,
`question` blob,
`answer` blob,
`sort` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `rules` (
`id` int(10) unsigned NOT NULL DEFAULT AUTO_INCREMENT,
`class` int(11) unsigned NOT NULL DEFAULT '0',
`title` blob,
`content` blob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `files` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`torrent` int(10) unsigned NOT NULL DEFAULT '0',
`filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`size` int(20) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `torrent` (`torrent`),
FULLTEXT KEY `filename` (`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `forums` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`order` smallint(5) unsigned NOT NULL DEFAULT '0',
`title` tinyblob,
`description` blob,
`icon` enum('star.png','staff.png','member.png') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member.png',
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `forums_permissions` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`groupid` int(10) unsigned NOT NULL DEFAULT '1',
`permissons` enum('member','staff','owner','anonymous') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member',
`minreadclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
`mincreateclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
`minwriteclass` tinyint(3) unsigned NOT NULL DEFAULT '0',
`min_view_class` tinyint(3) unsigned NOT NULL DEFAULT '0',
UNIQUE KEY `forumid` (`id`, `groupid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `forums_settings` (
`id` smallint(1) NOT NULL DEFAULT '1',
`delete` smallint(6) NOT NULL DEFAULT '0',
`min_delete_class` smallint(2) unsigned NOT NULL DEFAULT '7',
`read_post_expiry` smallint(3) unsigned NOT NULL DEFAULT '14',
`min_upload_class` smallint(2) unsigned NOT NULL DEFAULT '2',
`file_accepted_extension` varchar(80) NOT NULL,
`file_accepted_types` varchar(280) NOT NULL, 
`file_max_size` int(10) unsigned NOT NULL DEFAULT '2097152',
`upload_dir_path` varchar(80) NOT NULL DEFAULT 'uploads/',
PRIMARY KEY (`read_post_expiry`),
KEY `delete` (`delete`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `forums_posts` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`thread_id` int(10) unsigned NOT NULL DEFAULT '0',
`date_post` datetime COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00',
`message_body` longtext COLLATE utf8_unicode_ci,
`date_edited` datetime COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00',
`reason` blob,
`last_post_read` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `memberid` (`userid`),
KEY `threadid` (`thread_id`),
KEY `posted` (`date_post`),
FULLTEXT KEY `body_message` (`message_body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `forums_threads` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`forum_id` int(10) unsigned NOT NULL DEFAULT '0',
`title` tinytext COLLATE utf8_unicode_ci,
`locked` enum('yes','no') NOT NULL DEFAULT 'no',
`moved` enum('yes','no') NOT NULL DEFAULT 'no',
`sticky` enum('yes','no') NOT NULL DEFAULT 'no',
`reply_count` int(10) unsigned NOT NULL DEFAULT '0',
`views_count` int(10) unsigned NOT NULL DEFAULT '0',
`last_post_date` datetime COLLATE utf8_unicode_ci NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`),
KEY `forumid` (`forum_id`),
KEY `memberid` (`userid`),
KEY `last_post_date` (`last_post_date`),
FULLTEXT KEY `subject` (`title`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `overfourms` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
`name` tinyblob,
`description` blob,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `friends` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`friendsid` int(10) unsigned NOT NULL DEFAULT '0',
`confirmed` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`),
UNIQUE KEY `userfriend` (`userid`, `friendsid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `warnings` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`warning_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`active_warning` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`firstwarning` tinyint(2) unsigned NOT NULL DEFAULT '0',
`secondwarning` tinyint(3) unsigned NOT NULL DEFAULT '0',
`thirdwarning` tinyint(4) unsigned NOT NULL DEFAULT '0',
`fourthwarning` tinyint(5) unsigned NOT NULL DEFAULT '0',
`finalwarning` tinyint(6) unsigned NOT NULL DEFAULT '0',
`strikes_against` tinyint(7) unsigned NOT NULL DEFAULT '0',
`expiry_timeout` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`reasons` blob,
`notes` blob,
`warned_by` blob,
PRIMARY KEY (`id`),
KEY `memberid` (`userid`),
KEY `expired_warning` (`expiry_timeout`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `requests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`request` blob,
`description` blob,
`timestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`comments` int(10) unsigned NOT NULL DEFAULT '0',
`category` blob,
`uploaded_by` blob,
`fileid` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `memberid` (`userid`),
KEY `idtimestamp` (`id`,`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
-- -----------------------------------------------
CREATE TABLE `voted_requests` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`requestid` int(10) unsigned NOT NULL DEFAULT '0',
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`anonymous` blob,
PRIMARY KEY (`id`),
KEY `pollid` (`id`),
KEY `memberid` (`userid`),
KEY `memberid_requestedid` (`userid`,`requestid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `languages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` blob,
`charset` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'UTF-8',
`languages` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'english',
`datestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `staff_notes` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`staffid` int(10) unsigned NOT NULL DEFAULT '0',
`datestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`notes` blob,
PRIMARY KEY (`id`),
KEY `membersid` (`userid`)
)ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- ----------------------------------------------
CREATE TABLE `messages` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`sender` int(10) unsigned NOT NULL DEFAULT '',
`reciever` int(10) unsigned NOT NULL DEFAULT '',
`datestamps` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`subject` blob,
`message_body` blob,
`unread` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`location` enum('inbox','outbox','draft') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'inbox',
`poster` int(10) unsigned NOT NULL DEFAULT '0',
`signature` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Approved Site Message',
PRIMARY KEY (`id`),
KEY (`message`) (`message_body`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ----------------------------------------------
CREATE TABLE `news` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`userid` int(10) unsigned NOT NULL DEFAULT '1',
`date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`news_title` tinyblob,
`content_body` blob,
PRIMARY KEY (`id`),
KEY `memberid` (`userid`),
KEY `news_date` (`date_added`)   
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `peers` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`torrent` int(10) unsigned NOT NULL DEFAULT '0',
`peerid` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`ip` varchar(64) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`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',
`seeder` enum('yes','no') COLLATE utf8_unicode_ci 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') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`client` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`userid` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`passkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY `torrent_peer_id` (`torrent`, `peerid`),
KEY `torrent_seeder` (`torrent`,`seeder`),
) ENGINE=MyISAM DEFAULT CHARSET COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `torrents` (
`id` int(10) unsigned NOT NULL DEFAULT AUTO_INCREMENT,
`info_hash` blob,
`name` blob,
`filename` blob,
`save_as` blob,
`search_text` blob,
`description` blob,
`category` int(10) unsigned NOT NULL DEFAULT '0',
`size` bigint(20) unsigned NOT NULL DEFAULT '0',
`added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`type` enum('single','multi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'single',
`numfiles` int(10) unsigned NOT NULL DEFAULT '0',
`comments` int(10) unsigned NOT NULL DEFAULT '0',
`views` int(10) unsigned NOT NULL DEFAULT '0',
`hits` int(10) unsigned NOT NULL DEFAULT '0',
`times_completed` int(10) unsigned NOT NULL DEFAULT '0',
`seeders` int(10) unsigned NOT NULL DEFAULT '0',
`leechers` int(10) unsigned NOT NULL DEFAULT '0',
`last_action` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`visible` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`banned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`owner` int(10) unsigned NOT NULL DEFAULT '0',
`numratings` int(10) unsigned NOT NULL DEFAULT '0',
`nfo` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`announce` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`freeleech` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
PRIMARY KEY (`id`),
KEY `info_hash` (`info_hash`),
KEY `category_visible` (`category`, `visible`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
CREATE TABLE `users` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`username` varchar(60) COLLATE utf8_unicode_ci NOT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'noreply@localhost',
`passkey` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`secret` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
`age` int(3) unsigned NOT NULL DEFAULT '0',
`client` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`customtitle` blob,
`pending_account` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`approved_account` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`approval_needed_on_thread` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`approval_needed_on_chat` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`approval_needed_before_msg` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`approval_needed_after_msg` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`approval_waiting` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`downloaded` int(20) unsigned NOT NULL DEFAULT '0',
`uploaded` int(20) unsigned NOT NULL DEFAULT '0',
`invites` smallint(5) unsigned NOT NULL DEFAULT '3',
`invitedby` blob,
`invitedtimestamp` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`subscribe` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`friendship` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`anonymous` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no'
`timezone` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
`autocorrectdst` tinyint(1) unsigned NOT NULL DEFAULT '1',
`Parked` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`reputation` int(10) unsigned NOT NULL DEFAULT '5'
`skins` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default',
`language` smallint(5) unsigned NOT NULL DEFAULT '1',
`skinid` int(10) unsigned NOT NULL DEFAULT '1',
`languageid` int(10) unsigned NOT NULL DEFAULT '1',
`obtainip` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '127.0.0.1',
`datejoined` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`invisible_switch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`visible_switch` tinyint(1) unsigned NOT NULL DEFAULT '0',
`inactivity` int(10) unsigned NOT NULL DEFAULT '0',
`lastforumvisit` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastforumactivity` int(10) unsigned NOT NULL DEFAULT '0',
`snow_effect` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`rain_effect` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`browserOS` blob,
`gender` blob,
`stickynotes` blob,
`privacy` enum('low','normal','high') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal',
`acceptpms` enum('yes','ignored','friends','staff','owner','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
`unread_balloon_alerts` smallint(5) unsigned NOT NULL DEFAULT '0',
`unread_msgs` smallint(5) unsigned NOT NULL DEFAULT '0',
`barred` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`warnings` int(10) unsigned NOT NULL DEFAULT '0',
`cain_marks` int(10) unsigned NOT NULL DEFAULT '0',
`total_cain_marks` blob,
`warned_until` int(10) unsigned NOT NULL DEFAULT '0',
`admincp` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`avatar` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'images/anonymous_mask.png',
`avatar_height` smallint(5) unsigned NOT NULL DEFAULT '100',
`avatar_width` smallint(5) unsigned NOT NULL DEFAULT '130',
`classranks` enum('Jailed','Member','Scene','Trustee','Moderator','Administrator') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Member',
`badges` enum('Badge1','Badge2','Badge3','Badge4','Badge5','Badge6','NoBadge') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NoBadge',
-- https://bulbapedia.bulbagarden.net/wiki/Badge#Indigo_League
`paypal_payment` decimal(8,2) NOT NULL DEFAULT '1.00',
`bitcoin_payment` decimal(8,2) NOT NULL DEFAULT '',
`transaction_approved` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`country` int(10) unsigned NOT NULL DEFAULT '0',
`country_flag` blob,
`lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
`approval_required` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`captcha_plugin` blob,
`account_confirmed` enum('Waiting','Pending','Accepted') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Pending',
`settings` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`signature` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT ''
PRIMARY KEY (`id`),
-- once they figure out I demostrate against myself for aliving,
-- throw me a pokemon ball I will catch ya a magikarp
-- https://bulbapedia.bulbagarden.net/wiki/Magikarp_(Pok%C3%A9mon)
KEY `passkey` (`passkey`),
KEY `browserOS` (`browserOS`),
KEY `myanonip` (`obtainip`),
-- https://www.expressvpn.com/internet-security/proxy?refID=AU_SE&creative=73879934476&targetid=kwd-17540229664&matchtype=e&device=c&campaignid=269653036&adgroupid=7635099796&feeditemid=&loc_physical_ms=9072113&loc_interest_ms=&network=g&devicemodel=&placement=&keyword=proxy%20vpn&target=&aceid=&adposition=1t2&gclid=Cj0KCQiAus_QBRDgARIsAIRGNGiV0bWol-jae6zptWlLPjCkq3VkgqByxs6mQheARimWGcS_McnSJ2MaAuhlEALw_wcB
KEY `account_parked` (`Parked`),
KEY `snakeskins` (`skins`),
KEY `anonymity` (`anonymous`),
KEY `captcha_plugin` (`captcha_plugin`),
KEY `datejoined` (`datejoined`),
KEY `jailedacc` (`barred`),
KEY `inactive` (`inactivity`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- ------------------------------------------------
CREATE TABLE `sqlerr` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`text` blob,
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `censoredwords` (
`id` int(10) unsigned NOT NULL DEFAULT AUTO_INCREMENT,
`default_text` varchar(255) NOT NULL DEFAULT '',
`text_protected` varchar(255) NOT NULL DEFAULT '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
-- -----------------------------------------------
CREATE TABLE `plugins` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`title` blob,
`filename` blob,
`active` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
`permissions` enum('member','moderator','admin') COLLATE utf8_unicode_ci NOT NULL 'members',
`options` enum('member','moderator','admin') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member',
-- member being default does not mean that members can access control panel
PRIMARY KEY (`id`),
KEY `active` (`active`),
KEY `filename` (`filename`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- -----------------------------------------------
-- https://purecss.io/buttons/
-- https://purecss.io/tables/
-- https://u-232-forum.duckdns.org/index.php?topic=1252.0.html
-- https://u-232-forum.duckdns.org/index.php?topic=1337.0.html
-- https://u-232-forum.duckdns.org/index.php?topic=1245.0.html
-- http://www.backtrack-linux.org/


you will notice memberid rather then userid has been utilized for my own happiness and stolen from templateshare concepts thought it was pretty sweet yo anyway cipher through
Enjoy  :)