CREATE TABLE "torrent_addedrequests" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=6 ;



CREATE TABLE "torrent_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'
);

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

-- 
-- Table structure for table `torrent_avps`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_bans`
-- 

CREATE TABLE "torrent_bans" (
  "id" int(11) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `torrent_blackjack`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_bonus`
-- 

CREATE TABLE "torrent_bonus" (
  "id" int(5) NOT NULL,
  "bonusname" varchar(50) NOT NULL default '',
  "points" decimal(4,1) NOT NULL default '0.0',
  "description" text NOT NULL,
  "art" varchar(10) NOT NULL default 'traffic',
  "menge" bigint(20) unsigned NOT NULL default '0',
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=11 ;

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

-- 
-- Table structure for table `torrent_cards`
-- 

CREATE TABLE "torrent_cards" (
  "id" int(11) NOT NULL,
  "points" int(11) NOT NULL default '0',
  "pic" text NOT NULL,
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=53 ;

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

-- 
-- Table structure for table `torrent_casino`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_casino_bets`
-- 

CREATE TABLE "torrent_casino_bets" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `torrent_casino_config`
-- 

CREATE TABLE "torrent_casino_config" (
  "name" varchar(255) NOT NULL default '',
  "value" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("name")
);

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

-- 
-- Table structure for table `torrent_categories`
-- 

CREATE TABLE "torrent_categories" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=19 ;

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

-- 
-- Table structure for table `torrent_comments`
-- 

CREATE TABLE "torrent_comments" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=269 ;

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

-- 
-- Table structure for table `torrent_comments_notify`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_complaints`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_config`
-- 

CREATE TABLE "torrent_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 '',
  "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'
);

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

-- 
-- Table structure for table `torrent_countries`
-- 

CREATE TABLE "torrent_countries" (
  "id" int(10) unsigned NOT NULL,
  "name" varchar(50) default NULL,
  "flagpic" varchar(50) default NULL,
  "domain" char(3) default NULL,
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=100 ;

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

-- 
-- Table structure for table `torrent_download_completed`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_faq`
-- 

CREATE TABLE "torrent_faq" (
  "id" int(10) NOT NULL,
  "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")
) AUTO_INCREMENT=70 ;

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

-- 
-- Table structure for table `torrent_files`
-- 

CREATE TABLE "torrent_files" (
  "id" int(20) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=4009 ;

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

-- 
-- Table structure for table `torrent_filter`
-- 

CREATE TABLE "torrent_filter" (
  "id" int(10) unsigned NOT NULL,
  "keyword" varchar(50) NOT NULL default '',
  "reason" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("id"),
  UNIQUE KEY "keyword" ("keyword")
) AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `torrent_flashscores`
-- 

CREATE TABLE "torrent_flashscores" (
  "ID" int(11) NOT NULL,
  "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")
) AUTO_INCREMENT=50 ;

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

-- 
-- Table structure for table `torrent_lottery_config`
-- 

CREATE TABLE "torrent_lottery_config" (
  "name" varchar(255) NOT NULL default '',
  "value" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("name")
);

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

-- 
-- Table structure for table `torrent_offers`
-- 

CREATE TABLE "torrent_offers" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `torrent_offervotes`
-- 

CREATE TABLE "torrent_offervotes" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=5 ;

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

-- 
-- Table structure for table `torrent_offres_config`
-- 

CREATE TABLE "torrent_offres_config" (
  "name" varchar(255) NOT NULL default '',
  "value" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("name")
);

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

-- 
-- Table structure for table `torrent_online_users`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_paypal`
-- 

CREATE TABLE "torrent_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'
);

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

-- 
-- Table structure for table `torrent_peers`
-- 

CREATE TABLE "torrent_peers" (
  "id" int(10) unsigned NOT NULL,
  "uid" int(11) unsigned NOT NULL default '0',
  "torrent" int(10) unsigned NOT NULL default '0',
  "peer_id" varchar(20) character set latin1 collate latin1_bin 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")
) AUTO_INCREMENT=6741 ;

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

-- 
-- Table structure for table `torrent_pollanswers`
-- 

CREATE TABLE "torrent_pollanswers" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=232 ;

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

-- 
-- Table structure for table `torrent_polls`
-- 

CREATE TABLE "torrent_polls" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=2 ;

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

-- 
-- Table structure for table `torrent_privacy_backup`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_privacy_file`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_privacy_global`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_private_messages`
-- 

CREATE TABLE "torrent_private_messages" (
  "id" int(20) unsigned zerofill NOT NULL,
  "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")
) AUTO_INCREMENT=287 ;

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

-- 
-- Table structure for table `torrent_private_messages_blacklist`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_private_messages_bookmarks`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_ratings`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_ratiowarn`
-- 

CREATE TABLE "torrent_ratiowarn" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `torrent_ratiowarn_config`
-- 

CREATE TABLE "torrent_ratiowarn_config" (
  "name" varchar(255) NOT NULL default '',
  "value" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("name")
);

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

-- 
-- Table structure for table `torrent_requests`
-- 

CREATE TABLE "torrent_requests" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=5 ;

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

-- 
-- Table structure for table `torrent_requist_config`
-- 

CREATE TABLE "torrent_requist_config" (
  "name" varchar(255) NOT NULL default '',
  "value" varchar(255) NOT NULL default '',
  PRIMARY KEY  ("name")
);

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

-- 
-- Table structure for table `torrent_rules`
-- 

CREATE TABLE "torrent_rules" (
  "id" int(11) NOT NULL,
  "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")
) AUTO_INCREMENT=8 ;

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

-- 
-- Table structure for table `torrent_search_text`
-- 

CREATE TABLE "torrent_search_text" (
  "id" int(20) unsigned NOT NULL,
  "text" varchar(25) NOT NULL default '',
  "hit" int(20) unsigned NOT NULL default '0',
  PRIMARY KEY  ("id"),
  UNIQUE KEY "text" ("text")
) AUTO_INCREMENT=374 ;

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

-- 
-- Table structure for table `torrent_seeder_notify`
-- 

CREATE TABLE "torrent_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")
);

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

-- 
-- Table structure for table `torrent_shouts`
-- 

CREATE TABLE "torrent_shouts" (
  "id" bigint(20) unsigned NOT NULL,
  "user" int(10) unsigned NOT NULL default '0',
  "text" varchar(255) character set utf8 collate utf8_bin 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")
) AUTO_INCREMENT=4538 ;

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

-- 
-- Table structure for table `torrent_smiles`
-- 

CREATE TABLE "torrent_smiles" (
  "id" int(5) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=73 ;

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

-- 
-- Table structure for table `torrent_snatched`
-- 

CREATE TABLE "torrent_snatched" (
  "id" int(10) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=515 ;

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

-- 
-- Table structure for table `torrent_thanks`
-- 

CREATE TABLE "torrent_thanks" (
  "tid" bigint(10) NOT NULL,
  "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")
) AUTO_INCREMENT=63 ;

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

-- 
-- Table structure for table `torrent_tickets`
-- 

CREATE TABLE "torrent_tickets" (
  "id" int(4) NOT NULL,
  "user" int(11) NOT NULL default '0',
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `torrent_time_offset`
-- 

CREATE TABLE "torrent_time_offset" (
  "id" smallint(4) NOT NULL,
  "name" varchar(50) default NULL,
  PRIMARY KEY  ("id")
) AUTO_INCREMENT=721 ;

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

-- 
-- Table structure for table `torrent_torrents`
-- 

CREATE TABLE "torrent_torrents" (
  "id" int(15) unsigned NOT NULL,
  "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',
  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")
) AUTO_INCREMENT=59 ;

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

-- 
-- Table structure for table `torrent_trackers`
-- 

CREATE TABLE "torrent_trackers" (
  "id" tinyint(5) unsigned NOT NULL,
  "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")
) AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `torrent_users`
-- 

CREATE TABLE "torrent_users" (
  "id" int(11) NOT NULL,
  "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) character set utf8 collate utf8_bin 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',
  "pm_notify" enum('true','false') NOT NULL default 'true',
  "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 '',
  "invites" smallint(5) NOT NULL default '0',
  "invitedate" datetime NOT NULL default '0000-00-00 00:00:00',
  "country" int(10) NOT NULL default '0',
  "seedbonus" decimal(10,1) NOT NULL default '0.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',
  PRIMARY KEY  ("id"),
  UNIQUE KEY "username" ("username"),
  UNIQUE KEY "email" ("email"),
  UNIQUE KEY "passkey" ("passkey"),
  KEY "lastip" ("lastip"),
  KEY "lasthost" ("lasthost"),
  KEY "date" ("regdate")
) AUTO_INCREMENT=4354 ;
