Advertisement
Guest User

Life SQL

a guest
Nov 18th, 2017
733
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 93.38 KB | None | 0 0
  1. DROP TABLE IF EXISTS `files`;
  2. CREATE TABLE `files` (
  3. `id` BIGINT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  4. `torrent` INT( 10 ) UNSIGNED NOT NULL ,
  5. `path` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ,
  6. `filesize` BIGINT( 20 ) UNSIGNED NOT NULL ,
  7. INDEX ( `torrent` )
  8. ) ENGINE = MYISAM ;
  9.  
  10. DROP TABLE IF EXISTS `announce`;
  11. CREATE TABLE `announce` (
  12. `id` INT( 20 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
  13. `url` VARCHAR( 255 ) NOT NULL ,
  14. `torrent` INT( 10 ) UNSIGNED NOT NULL ,
  15. `seeders` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
  16. `leechers` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
  17. `times_completed` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0',
  18. `online` ENUM( 'yes', 'no' ) NOT NULL DEFAULT 'yes',
  19. INDEX ( `torrent` )
  20. ) ENGINE = MYISAM ;
  21.  
  22.  
  23. DROP TABLE IF EXISTS `bans`;
  24. CREATE TABLE `bans` (
  25. `id` int(10) unsigned NOT NULL auto_increment,
  26. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  27. `addedby` int(10) unsigned NOT NULL default '0',
  28. `comment` varchar(255) NOT NULL default '',
  29. `first` varchar(39) default NULL,
  30. `last` varchar(39) default NULL,
  31. PRIMARY KEY (`id`),
  32. KEY `first_last` (`first`,`last`)
  33. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  34.  
  35. DROP TABLE IF EXISTS `blocks`;
  36. CREATE TABLE `blocks` (
  37. `id` int(11) NOT NULL auto_increment,
  38. `named` varchar(255) NOT NULL default '',
  39. `name` varchar(255) NOT NULL default '',
  40. `position` varchar(10) NOT NULL default '',
  41. `description` varchar(255) NOT NULL default '',
  42. `enabled` tinyint(3) NOT NULL default '0',
  43. `sort` int(11) NOT NULL default '0',
  44. PRIMARY KEY (`id`),
  45. KEY `position_enabled` (`position`,`enabled`)
  46. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  47.  
  48. INSERT INTO `blocks` VALUES
  49. (1, 'donate', 'donate', 'left', 'Description here...', 0, 0),
  50. (2, 'invite', 'invite', 'right', 'Description here...', 1, 2),
  51. (3, 'Main Navigation', 'navigate', 'left', 'Description here...', 1, 4),
  52. (4, 'Login Block', 'login', 'left', 'Description here...', 1, 1),
  53. (5, 'rss', 'rss', 'right', 'Description here...', 0, 0),
  54. (6, 'latestuploads', 'latestuploads', 'right', 'Description here...', 1, 1),
  55. (7, 'advancestats', 'advancestats', 'left', 'Description here...', 1, 5),
  56. (8, 'serverload', 'serverload', 'right', 'Description here...', 1, 3),
  57. (9, 'usersonline', 'usersonline', 'right', 'Description here...', 1, 5),
  58. (10, 'Main Category', 'maincats', 'left', 'Description here...', 1, 3),
  59. (11, 'simplesearch', 'simplesearch', 'right', 'Description here...', 1, 4),
  60. (12, 'advancesearch', 'advancesearch', 'right', 'Description here...', 0, 0),
  61. (13, 'latestimages', 'latestimages', 'right', 'Description here...', 0, 0),
  62. (14, 'mostactivetorrents', 'mostactivetorrents', 'left', 'Description here...', 0, 0),
  63. (15, 'scrollingnews', 'scrollingnews', 'left', 'Description here...', 0, 0),
  64. (16, 'newestmember', 'newestmember', 'left', 'Description here...', 0, 0),
  65. (17, 'polls', 'polls', 'left', 'Description here...', 1, 6),
  66. (18, 'seedwanted', 'seedwanted', 'left', 'Description here...', 0, 0),
  67. (19, 'Theme & Language', 'themelang', 'left', 'Description here...', 1, 2),
  68. (20, 'Powered By', 'poweredby', 'right', 'Description here...', 1, 2);
  69.  
  70. DROP TABLE IF EXISTS `categories`;
  71. CREATE TABLE `categories` (
  72. `id` int(10) unsigned NOT NULL auto_increment,
  73. `name` varchar(30) NOT NULL default '',
  74. `sort_index` int(10) unsigned NOT NULL default '0',
  75. `image` varchar(255) NOT NULL default '',
  76. `subcat` char(3) NOT NULL default 'no',
  77. `parent_cat` varchar(15) NOT NULL default '',
  78. `sub_sort` char(3) NOT NULL default '',
  79. PRIMARY KEY (`id`),
  80. UNIQUE KEY `parent_cat-name` (`parent_cat`, `name` )
  81. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  82.  
  83. INSERT INTO `categories` (`id`, `name`, `sort_index`, `image`, `subcat`, `parent_cat`, `sub_sort`) VALUES
  84. (1, 'DVD', 1, '', 'yes', 'Movies', '1'),
  85. (2, 'Divx/Xvid', 2, '', 'yes', 'Movies', '2'),
  86. (3, 'SVCD/VCD', 3, '', 'yes', 'Movies', '3'),
  87. (4, 'Other', 4, '', 'no', 'Movies', '4'),
  88. (5, 'DVD', 5, '', 'yes', 'TV', '5'),
  89. (6, 'Divx/Xvid', 6, '', 'yes', 'TV', '6'),
  90. (7, 'SVCD/VCD', 7, '', 'yes', 'TV', '7'),
  91. (9, 'All', 9, '', 'yes', 'Documentaries', '9'),
  92. (10, 'PC', 10, '', 'yes', 'Games', '10'),
  93. (11, 'PS2', 11, '', 'yes', 'Games', '11'),
  94. (12, 'PSP', 12, '', 'yes', 'Games', '12'),
  95. (13, 'Xbox', 13, '', 'yes', 'Games', '13'),
  96. (14, 'Xbox360', 14, '', 'yes', 'Games', '14'),
  97. (15, 'PS1', 15, '', 'yes', 'Games', '15'),
  98. (16, 'Dreamcast', 16, '', 'yes', 'Games', '16'),
  99. (17, 'Other', 20, '', 'yes', 'Games', '20'),
  100. (18, 'PC', 18, '', 'yes', 'Apps', '18'),
  101. (19, 'Mac', 19, '', 'yes', 'Apps', '19'),
  102. (20, 'Linux', 20, '', 'yes', 'Apps', '20'),
  103. (21, 'Other', 21, '', 'yes', 'Apps', '21'),
  104. (22, 'MP3', 22, '', 'yes', 'Music', '22'),
  105. (23, 'Lossless', 23, '', 'yes', 'Music', '23'),
  106. (24, 'DVD', 24, '', 'yes', 'Music', '24'),
  107. (25, 'Video', 25, '', 'yes', 'Music', '25'),
  108. (26, 'Radio', 26, '', 'yes', 'Music', '26'),
  109. (27, 'Other', 27, '', 'yes', 'Music', '27'),
  110. (28, 'All', 0, 'anime.jpg', 'yes', 'Anime', '28'),
  111. (33, 'Emulation', 33, '', 'yes', 'Other', '33'),
  112. (34, 'PPC/PDA', 34, '', 'yes', 'Other', '34'),
  113. (35, 'Sounds', 35, '', 'yes', 'Other', '35'),
  114. (36, 'E-Books', 36, '', 'yes', 'Other', '36'),
  115. (37, 'Images', 37, '', 'yes', 'Other', '37'),
  116. (38, 'Mobile Phone', 38, '', 'yes', 'Other', '38'),
  117. (39, 'Extra Pars/Fills', 39, '', 'yes', 'Other', '39'),
  118. (40, 'Other', 40, '', 'yes', 'Other', '40'),
  119. (41, 'HD', 6, '', 'yes', 'TV', '6'),
  120. (42, 'HD', 3, '', 'yes', 'Movies', '3'),
  121. (43, 'PS3', 12, '', 'yes', 'Games', '12'),
  122. (44, 'Wii', 17, '', 'yes', 'Games', '17'),
  123. (45, 'DS', 18, '', 'yes', 'Games', '18'),
  124. (46, 'GameCube', 19, '', 'yes', 'Games', '19');
  125.  
  126. DROP TABLE IF EXISTS `comments`;
  127. CREATE TABLE `comments` (
  128. `id` int(10) unsigned NOT NULL auto_increment,
  129. `user` int(10) unsigned NOT NULL default '0',
  130. `torrent` int(10) unsigned NOT NULL default '0',
  131. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  132. `text` text NOT NULL,
  133. `news` int(10) unsigned NOT NULL default '0',
  134. PRIMARY KEY (`id`),
  135. KEY `user` (`user`),
  136. KEY `torrent` (`torrent`)
  137. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  138.  
  139. DROP TABLE IF EXISTS `completed`;
  140. CREATE TABLE `completed` (
  141. `id` int(10) unsigned NOT NULL auto_increment,
  142. `userid` int(10) NOT NULL default '0',
  143. `torrentid` int(10) NOT NULL default '0',
  144. `date` datetime NOT NULL default '0000-00-00 00:00:00',
  145. PRIMARY KEY (`id`),
  146. UNIQUE `userid_torrentid` (`userid`, `torrentid`)
  147. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  148.  
  149. DROP TABLE IF EXISTS `countries`;
  150. CREATE TABLE `countries` (
  151. `id` int(10) unsigned NOT NULL auto_increment,
  152. `name` varchar(50) default NULL,
  153. `flagpic` varchar(50) default NULL,
  154. `domain` char(3) default NULL,
  155. PRIMARY KEY (`id`)
  156. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  157.  
  158. INSERT INTO `countries` (`id`, `name`, `flagpic`, `domain`) VALUES
  159. (1, 'Sweden', 'sweden.gif', 'SE'),
  160. (2, 'United States of America', 'usa.gif', 'US'),
  161. (3, 'Russia', 'russia.gif', 'RU'),
  162. (4, 'Finland', 'finland.gif', 'FI'),
  163. (5, 'Canada', 'canada.gif', 'CA'),
  164. (6, 'France', 'france.gif', 'FR'),
  165. (7, 'Germany', 'germany.gif', 'DE'),
  166. (8, 'China', 'china.gif', 'CN'),
  167. (9, 'Italy', 'italy.gif', 'IT'),
  168. (10, 'Denmark', 'denmark.gif', 'DK'),
  169. (11, 'Norway', 'norway.gif', 'NO'),
  170. (12, 'United Kingdom', 'uk.gif', 'UK'),
  171. (13, 'Ireland', 'ireland.gif', 'IE'),
  172. (14, 'Poland', 'poland.gif', 'PL'),
  173. (15, 'Netherlands', 'netherlands.gif', 'NL'),
  174. (16, 'Belgium', 'belgium.gif', 'BE'),
  175. (17, 'Japan', 'japan.gif', 'JP'),
  176. (18, 'Brazil', 'brazil.gif', 'BR'),
  177. (19, 'Argentina', 'argentina.gif', 'AR'),
  178. (20, 'Australia', 'australia.gif', 'AU'),
  179. (21, 'New Zealand', 'newzealand.gif', 'NZ'),
  180. (23, 'Spain', 'spain.gif', 'ES'),
  181. (24, 'Portugal', 'portugal.gif', 'PT'),
  182. (25, 'Mexico', 'mexico.gif', 'MX'),
  183. (26, 'Singapore', 'singapore.gif', 'SG'),
  184. (29, 'South Africa', 'southafrica.gif', 'ZA'),
  185. (30, 'South Korea', 'southkorea.gif', 'KR'),
  186. (31, 'Jamaica', 'jamaica.gif', 'JM'),
  187. (32, 'Luxembourg', 'luxembourg.gif', 'LU'),
  188. (33, 'Hong Kong', 'hongkong.gif', 'HK'),
  189. (34, 'Belize', 'belize.gif', 'BZ'),
  190. (35, 'Algeria', 'algeria.gif', 'DZ'),
  191. (36, 'Angola', 'angola.gif', 'AO'),
  192. (37, 'Austria', 'austria.gif', 'AT'),
  193. (38, 'Yugoslavia', 'yugoslavia.gif', 'YU'),
  194. (39, 'Western Samoa', 'westernsamoa.gif', 'WS'),
  195. (40, 'Malaysia', 'malaysia.gif', 'MY'),
  196. (41, 'Dominican Republic', 'dominicanrep.gif', 'DO'),
  197. (42, 'Greece', 'greece.gif', 'GR'),
  198. (43, 'Guatemala', 'guatemala.gif', 'GT'),
  199. (44, 'Israel', 'israel.gif', 'IL'),
  200. (45, 'Pakistan', 'pakistan.gif', 'PK'),
  201. (46, 'Czech Republic', 'czechrep.gif', 'CZ'),
  202. (47, 'Serbia', 'serbia.gif', 'YU'),
  203. (48, 'Seychelles', 'seychelles.gif', 'SC'),
  204. (49, 'Taiwan', 'taiwan.gif', 'TW'),
  205. (50, 'Puerto Rico', 'puertorico.gif', 'PR'),
  206. (51, 'Chile', 'chile.gif', 'CL'),
  207. (52, 'Cuba', 'cuba.gif', 'CU'),
  208. (53, 'Congo', 'congo.gif', 'CG'),
  209. (54, 'Afghanistan', 'afghanistan.gif', 'AF'),
  210. (55, 'Turkey', 'turkey.gif', 'TR'),
  211. (56, 'Uzbekistan', 'uzbekistan.gif', 'UZ'),
  212. (57, 'Switzerland', 'switzerland.gif', 'CH'),
  213. (58, 'Kiribati', 'kiribati.gif', 'KI'),
  214. (59, 'Philippines', 'philippines.gif', 'PH'),
  215. (60, 'Burkina Faso', 'burkinafaso.gif', 'BF'),
  216. (61, 'Nigeria', 'nigeria.gif', 'NG'),
  217. (62, 'Iceland', 'iceland.gif', 'IS'),
  218. (63, 'Nauru', 'nauru.gif', 'NR'),
  219. (64, 'Slovenia', 'slovenia.gif', 'SI'),
  220. (65, 'Albania', 'albania.gif', 'AL'),
  221. (66, 'Turkmenistan', 'turkmenistan.gif', 'TM'),
  222. (67, 'Bosnia Herzegovina', 'bosniaherzegovina.gif', 'BA'),
  223. (68, 'Andorra', 'andorra.gif', 'AD'),
  224. (69, 'Lithuania', 'lithuania.gif', 'LT'),
  225. (70, 'India', 'india.gif', 'IN'),
  226. (71, 'Netherlands Antilles', 'nethantilles.gif', 'AN'),
  227. (72, 'Ukraine', 'ukraine.gif', 'UA'),
  228. (73, 'Venezuela', 'venezuela.gif', 'VE'),
  229. (74, 'Hungary', 'hungary.gif', 'HU'),
  230. (75, 'Romania', 'romania.gif', 'RO'),
  231. (76, 'Vanuatu', 'vanuatu.gif', 'VU'),
  232. (77, 'Vietnam', 'vietnam.gif', 'VN'),
  233. (78, 'Trinidad & Tobago', 'trinidadandtobago.gif', 'TT'),
  234. (79, 'Honduras', 'honduras.gif', 'HN'),
  235. (80, 'Kyrgyzstan', 'kyrgyzstan.gif', 'KG'),
  236. (81, 'Ecuador', 'ecuador.gif', 'EC'),
  237. (82, 'Bahamas', 'bahamas.gif', 'BS'),
  238. (83, 'Peru', 'peru.gif', 'PE'),
  239. (84, 'Cambodia', 'cambodia.gif', 'KH'),
  240. (85, 'Barbados', 'barbados.gif', 'BB'),
  241. (86, 'Bangladesh', 'bangladesh.gif', 'BD'),
  242. (87, 'Laos', 'laos.gif', 'LA'),
  243. (88, 'Uruguay', 'uruguay.gif', 'UY'),
  244. (89, 'Antigua Barbuda', 'antiguabarbuda.gif', 'AG'),
  245. (90, 'Paraguay', 'paraguay.gif', 'PY'),
  246. (92, 'Union of Soviet Socialist Republics', 'ussr.gif', 'SU'),
  247. (93, 'Thailand', 'thailand.gif', 'TH'),
  248. (94, 'Senegal', 'senegal.gif', 'SN'),
  249. (95, 'Togo', 'togo.gif', 'TG'),
  250. (96, 'North Korea', 'northkorea.gif', 'KP'),
  251. (97, 'Croatia', 'croatia.gif', 'HR'),
  252. (98, 'Estonia', 'estonia.gif', 'EE'),
  253. (99, 'Colombia', 'colombia.gif', 'CO'),
  254. (100, 'England', 'england.gif', 'GB'),
  255. (101, 'Egypt', 'egypt.gif', 'EG');
  256.  
  257. --
  258. -- Table structure for table `tsue_plugins`
  259. --
  260.  
  261. DROP TABLE IF EXISTS `tsue_plugins`;
  262. /*!40101 SET @saved_cs_client = @@character_set_client */;
  263. /*!40101 SET character_set_client = utf8 */;
  264. CREATE TABLE `tsue_plugins` (
  265. `pluginid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  266. `name` tinyblob,
  267. `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  268. `contents` longblob,
  269. `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  270. `viewpermissions` mediumblob NOT NULL COMMENT 'Select which membergroups will be allowed to use this plugin. Leave empty=ALL',
  271. `pluginOptions` longblob,
  272. PRIMARY KEY (`pluginid`),
  273. KEY `active` (`active`),
  274. KEY `filename` (`filename`)
  275. ) ENGINE=InnoDB AUTO_INCREMENT=213 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  276. /*!40101 SET character_set_client = @saved_cs_client */;
  277.  
  278. --
  279. -- Dumping data for table `tsue_plugins`
  280. --
  281.  
  282. DROP TABLE IF EXISTS `email_bans`;
  283. CREATE TABLE `email_bans` (
  284. `id` int(10) unsigned NOT NULL auto_increment,
  285. `userid` int(11) default '0',
  286. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  287. `addedby` int(10) unsigned NOT NULL default '0',
  288. `comment` varchar(255) NOT NULL default '',
  289. `mail_domain` varchar(255) default NULL,
  290. PRIMARY KEY (`id`)
  291. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  292.  
  293. DROP TABLE IF EXISTS `faq`;
  294. CREATE TABLE `faq` (
  295. `id` int(10) NOT NULL auto_increment,
  296. `type` set('categ','item') NOT NULL default 'item',
  297. `question` text NOT NULL,
  298. `answer` text NOT NULL,
  299. `flag` set('0','1','2','3') NOT NULL default '1',
  300. `categ` int(10) NOT NULL default '0',
  301. `order` int(10) NOT NULL default '0',
  302. PRIMARY KEY (`id`)
  303. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  304.  
  305. INSERT INTO `faq` (`id`, `type`, `question`, `answer`, `flag`, `categ`, `order`) VALUES
  306. (1, 'categ', 'Site information', '', '1', 0, 1),
  307. (2, 'categ', 'User information', '', '1', 0, 2),
  308. (3, 'categ', 'Stats', '', '1', 0, 3),
  309. (4, 'categ', 'Uploading', '', '1', 0, 4),
  310. (5, 'categ', 'Downloading', '', '1', 0, 5),
  311. (6, 'categ', 'How can I improve my download speed?', '', '1', 0, 6),
  312. (7, 'categ', 'My ISP uses a transparent proxy. What should I do?', '', '1', 0, 7),
  313. (8, 'categ', 'Why can''t I connect? Is the site blocking me?', '', '1', 0, 8),
  314. (9, 'categ', 'What if I can''t find the answer to my problem here?', '', '1', 0, 9),
  315. (10, 'item', 'What is this bittorrent all about anyway? How do I get the files?', 'Check out <a href="http://www.btfaq.com/">Brian''s BitTorrent FAQ and Guide</a>', '1', 1, 1),
  316. (13, 'item', 'I registered an account but did not receive the confirmation e-mail!', 'You can use <a href="account-delete.php">this form</a> to delete the account so you can re-register.\r\nNote though that if you didn''t receive the email the first time it will probably not\r\nsucceed the second time either so you should really try another email address.', '1', 2, 1),
  317. (14, 'item', 'I''ve lost my user name or password! Can you send it to me?', 'Please use <a href="account-recover.php">this form</a> to have the login details mailed back to you.', '1', 2, 2),
  318. (16, 'item', 'Can you delete my account?', 'You cannot delete your own account, please ask a member of staff', '1', 2, 4),
  319. (17, 'item', 'So, what''s MY ratio?', 'Click on your <a href="account.php">profile</a>, then on your user name (at the top).<br />\r\n<br />\r\nIt''s important to distinguish between your overall ratio and the individual ratio on each torrent\r\nyou may be seeding or leeching. The overall ratio takes into account the total uploaded and downloaded\r\nfrom your account since you joined the site. The individual ratio takes into account those values for each torrent.<br />\r\n<br />\r\nYou may see two symbols instead of a number: &quot;Inf.&quot;, which is just an abbreviation for Infinity, and\r\nmeans that you have downloaded 0 bytes while uploading a non-zero amount (ul/dl becomes infinity); &quot;---&quot;,\r\nwhich should be read as &quot;non-available&quot;, and shows up when you have both downloaded and uploaded 0 bytes\r\n(ul/dl = 0/0 which is an indeterminate amount).', '1', 2, 5),
  320. (18, 'item', 'Why is my IP displayed on my details page?', 'Only you and the site moderators can view your IP address and email. Regular users do not see that information.', '1', 2, 6),
  321. (19, 'item', 'Help! I cannot login!?', 'This problem sometimes occurs with MSIE. Close all Internet Explorer windows and open Internet Options in the control panel. Click the Delete Cookies button. You should now be able to login.\r\n', '1', 2, 7),
  322. (20, 'item', 'My IP address is dynamic. How do I stay logged in?', 'You do not have to anymore. All you have to do is make sure you are logged in with your actual\r\nIP when starting a torrent session. After that, even if the IP changes mid-session,\r\nthe seeding or leeching will continue and the statistics will update without any problem.', '1', 2, 8),
  323. (21, 'item', 'Why is my port number reported as "---"? (And why should I care?)', 'The tracker has determined that you are firewalled or NATed and cannot accept incoming connections.\r\n<br />\r\n<br />\r\nThis means that other peers in the swarm will be unable to connect to you, only you to them. Even worse,\r\nif two peers are both in this state they will not be able to connect at all. This has obviously a\r\ndetrimental effect on the overall speed.\r\n<br />\r\n<br />\r\nThe way to solve the problem involves opening the ports used for incoming connections\r\n(the same range you defined in your client) on the firewall and/or configuring your\r\nNAT server to use a basic form of NAT\r\nfor that range instead of NAPT (the actual process differs widely between different router models.\r\nCheck your router documentation and/or support forum. You will also find lots of information on the\r\nsubject at <a href="http://portforward.com/">PortForward</a>).', '1', 2, 1),
  324. (27, 'item', 'Most common reason for stats not updating', '<ul>\r\n<li>The user is cheating. (a.k.a. &quot;Summary Ban&quot;)</li>\r\n<li>The server is overloaded and unresponsive. Just try to keep the session open until the server responds again. (Flooding the server with consecutive manual updates is not recommended.)</li>\r\n</ul>', '1', 3, 1),
  325. (28, 'item', 'Best practices', '<ul>\r\n<li>If a torrent you are currently leeching/seeding is not listed on your profile, just wait or force a manual update.</li>\r\n<li>Make sure you exit your client properly, so that the tracker receives &quot;event=completed&quot;.</li>\r\n<li>If the tracker is down, do not stop seeding. As long as the tracker is back up before you exit the client the stats should update properly.</li>\r\n</ul>', '1', 3, 2),
  326. (29, 'item', 'May I use any bittorrent client?', 'Yes. The tracker now updates the stats correctly for all bittorrent clients. However, we still recommend\r\nthat you <b>avoid</b> the following clients:<br />\r\n<br />\r\n\r\n<ul>\r\n<li>BitTorrent++</li>\r\n<li>Nova Torrent</li>\r\n<li>TorrentStorm</li>\r\n</ul>\r\n\r\n<br />\r\nThese clients do not report correctly to the tracker when canceling/finishing a torrent session.\r\nIf you use them then a few MB may not be counted towards\r\nthe stats near the end, and torrents may still be listed in your profile for some time after you have closed the client.<br />\r\n<br />\r\nAlso, clients in alpha or beta version should be avoided.', '1', 3, 3),
  327. (30, 'item', 'Why is a torrent I''m leeching/seeding listed several times in my profile?', 'If for some reason (e.g. pc crash, or frozen client) your client exits improperly and you restart it,\r\nit will have a new peer_id, so it will show as a new torrent. The old one will never receive a &quot;event=completed&quot;\r\nor &quot;event=stopped&quot; and will be listed until some tracker timeout. Just ignore it, it will eventually go away.', '1', 3, 4),
  328. (31, 'item', 'I''ve finished or cancelled a torrent. Why is it still listed in my profile?', 'Some clients, notably TorrentStorm and Nova Torrent, do not report properly to the tracker when canceling or finishing a torrent.\r\nIn that case the tracker will keep waiting for some message - and thus listing the torrent as seeding or leeching - until some\r\ntimeout occurs. Just ignore it, it will eventually go away.', '1', 3, 5),
  329. (32, 'item', 'Why do I sometimes see torrents I''m not leeching in my profile!?', 'When a torrent is first started, the tracker uses the IP to identify the user. Therefore the torrent will\r\nbecome associated with the user <i>who last accessed the site</i> from that IP. If you share your IP in some\r\nway (you are behind NAT/ICS, or using a proxy), and some of the persons you share it with are also users,\r\nyou may occasionally see their torrents listed in your profile. (If they start a torrent session from that\r\nIP and you were the last one to visit the site the torrent will be associated with you). Note that now\r\ntorrents listed in your profile will always count towards your total stats.', '2', 3, 6),
  330. (34, 'item', 'How does NAT/ICS change the picture?', 'This is a very particular case in that all computers in the LAN will appear to the outside world as having the same IP. We must distinguish\r\nbetween two cases:<br />\r\n<br />\r\n<b>1.</b> <i>You are the single user in the LAN</i><br />\r\n<br />\r\nYou should use the same account in all the computers.<br />\r\n<br />\r\nNote also that in the ICS case it is preferable to run the BT client on the ICS gateway. Clients running on the other computers\r\nwill be unconnectable (their ports will be listed as &quot;---&quot;, as explained elsewhere in the FAQ) unless you specify\r\nthe appropriate services in your ICS configuration (a good explanation of how to do this for Windows XP can be found\r\n<a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=1dcff3ce-f50f-4a34-ae67-cac31ccd7bc9&amp;displaylang=en">here</a>).\r\nIn the NAT case you should configure different ranges for clients on different computers and create appropriate NAT rules in the router. (Details vary widely from router to router and are outside the scope of this FAQ. Check your router documentation and/or support forum.)<br />\r\n<br />\r\n<br />\r\n<b>2.</b> <i>There are multiple users in the LAN</i><br />\r\n<br />\r\nAt present there is no way of making this setup always work properly.\r\nEach torrent will be associated with the user who last accessed the site from within\r\nthe LAN before the torrent was started.\r\nUnless there is cooperation between the users mixing of statistics is possible.\r\n(User A accesses the site, downloads a .torrent file, but does not start the torrent immediately.\r\nMeanwhile, user B accesses the site. User A then starts the torrent. The torrent will count\r\ntowards user B''s statistics, not user A''s.)\r\n<br />\r\n<br />\r\nIt is your LAN, the responsibility is yours. Do not ask us to ban other users\r\nwith the same IP, we will not do that. (Why should we ban <i>him</i> instead of <i>you</i>?)', '1', 3, 1),
  331. (36, 'item', 'Why can''t I upload torrents?', 'Only specially authorized users (<font color="#4040c0"><b>Uploaders</b></font>) have permission to upload torrents.', '1', 4, 1),
  332. (37, 'item', 'What criteria must I meet before I can join the <font color="#4040c0">Uploader</font> team?', 'You must be able to provide releases that:<br />\r\n<ul>\r\n<li>include a proper NFO</li>\r\n<li>are genuine scene releases. If it''s not on <a href="http://www.nforce.nl">NFOrce</a> then forget it! (except music).</li>\r\n<li>are not older than seven (7) days.</li>\r\n<li>have all files in original format (usually 14.3 MB RARs)</li>\r\n<li>you''ll be able to seed, or make sure are well-seeded, for at least 24 hours.</li>\r\n<li>you should have atleast 2MBit upload bandwith.</li>\r\n</ul>\r\n\r\n<br />\r\nIf you think you can match these criteria do not hesitate to <a href="staff.php">contact</a> one of the administrators.<br />\r\n<b>Remember!</b> Write your application carefully! Be sure to include your UL speed and what kind of stuff you''re planning to upload.<br />\r\nOnly well written letters with serious intent will be considered.', '1', 4, 2),
  333. (39, 'item', 'How do I use the files I''ve downloaded?', 'Check out <a href="videoformats.php">this guide</a>.', '1', 5, 1),
  334. (40, 'item', 'Downloaded a movie and don''t know what CAM/TS/TC/SCR means?', 'Check out <a href="videoformats.php">this guide.</a>', '1', 5, 2),
  335. (41, 'item', 'Why did an active torrent suddenly disappear?', 'There may be three reasons for this:<br />\r\n(<b>1</b>) The torrent may have been out-of-sync with the site\r\n<a href="rules.php">rules</a>.<br />\r\n(<b>2</b>) The uploader may have deleted it because it was a bad release.\r\nA replacement will probably be uploaded to take its place.<br />\r\n(<b>3</b>) Torrents are automatically deleted after 28 days.', '2', 5, 3),
  336. (42, 'item', 'How do I resume a broken download or reseed something?', 'Open the .torrent file. When your client asks you for a location, choose the location of the existing file(s) and it will resume/reseed the torrent.\r\n', '1', 5, 4),
  337. (43, 'item', 'Why do my downloads sometimes stall at 99%?', 'The more pieces you have, the harder it becomes to find peers who have pieces you are missing. That is why downloads sometimes slow down or even stall when there are just a few percent remaining. Just be patient and you will, sooner or later, get the remaining pieces.\r\n', '1', 5, 5),
  338. (44, 'item', 'What are these "a piece has failed an hash check" messages?', 'Bittorrent clients check the data they receive for integrity. When a piece fails this check it is\r\nautomatically re-downloaded. Occasional hash fails are a common occurrence, and you shouldn''t worry.<br />\r\n<br />\r\nSome clients have an (advanced) option/preference to ''kick/ban clients that send you bad data'' or\r\nsimilar. It should be turned on, since it makes sure that if a peer repeatedly sends you pieces that\r\nfail the hash check it will be ignored in the future.', '1', 5, 6),
  339. (45, 'item', 'The torrent is supposed to be 100MB. How come I downloaded 120MB?', 'See the hash fails topic. If your client receives bad data it will have to redownload it, therefore\r\nthe total downloaded may be larger than the torrent size. Make sure the &quot;kick/ban&quot; option is turned on\r\nto minimize the extra downloads.', '1', 5, 7),
  340. (46, 'item', 'Why do I get a "Not authorized (xx h) - READ THE FAQ" error?', 'From the time that each <b>new</b> torrent is uploaded to the tracker, there is a period of time that\r\nsome users must wait before they can download it.<br />\r\nThis delay in downloading will only affect users with a low ratio, and users with low upload amounts.<br />\r\n<br />\r\n<table class="table_table" cellspacing="3" cellpadding="5" align="center">\r\n <tr>\r\n <td class="table_col1"><b>Ratio below</b></td>\r\n <td class="table_col2" align="center"><font color="#bb0000">0.50</font></td>\r\n <td class="table_col2">and/or upload below</td>\r\n <td class="table_col1" align="center">5.0GB</td>\r\n <td class="table_col2">delay of</td>\r\n <td class="table_col1" align="center">48h</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Ratio below</b></td>\r\n <td class="table_col2"><font color="#A10000">0.65</font></td>\r\n <td class="table_col1">and/or upload below</td>\r\n <td class="table_col2">6.5GB</td>\r\n <td class="table_col1">delay of</td>\r\n <td class="table_col2">24h</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Ratio below</b></td>\r\n <td class="table_col2"><font color="#880000">0.80</font></td>\r\n <td class="table_col1">and/or upload below</td>\r\n <td class="table_col2">8.0GB</td>\r\n <td class="table_col1">delay of</td>\r\n <td class="table_col2">12h</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Ratio below</b></td>\r\n <td class="table_col2"><font color="#6E0000">0.95</font></td>\r\n <td class="table_col1">and/or upload below</td>\r\n <td class="table_col2">9.5GB</td>\r\n <td class="table_col1">delay of</td>\r\n <td class="table_col2">06h</td>\r\n </tr>\r\n</table>\r\n<br />\r\n"<b>And/or</b>" means any or both. Your delay will be the <b>largest</b> one for which you meet <b>at least</b> one condition.<br />\r\n<br />\r\nThis applies to new users as well, so opening a new account will not help. Note also that this\r\nworks at tracker level, you will be able to grab the .torrent file itself at any time.<br />\r\n<br />\r\n<!--The delay applies only to leeching, not to seeding. If you got the files from any other source and\r\nwish to seed them you may do so at any time irrespectively of your ratio or total uploaded.<br />-->\r\nN.B. Due to some users exploiting the ''no-delay-for-seeders'' policy we had to change it. The delay\r\nnow applies to both seeding and leeching. So if you are subject to a delay and get the files from\r\nsome other source you will not be able to seed them until the delay has elapsed.', '3', 5, 8),
  341. (47, 'item', 'Why do I get a "rejected by tracker - Port xxxx is blacklisted" error?', 'Your client is reporting to the tracker that it uses one of the default bittorrent ports\r\n(6881-6889) or any other common p2p port for incoming connections.<br />\r\n<br />\r\nThis tracker does not allow clients to use ports commonly associated with p2p protocols.\r\nThe reason for this is that it is a common practice for ISPs to throttle those ports\r\n(that is, limit the bandwidth, hence the speed). <br />\r\n<br />\r\nThe blocked ports list include, but is not neccessarily limited to, the following:<br />\r\n<br />\r\n <table border="0" cellspacing="3" cellpadding="5" class="table_table" align="center">\r\n <tr>\r\n <td class="table_col1"><b>Direct Connect</b></td>\r\n <td class="table_col2">411 - 413</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Kazaa</b></td>\r\n <td class="table_col2">1214</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>eDonkey</b></td>\r\n <td class="table_col2">4662</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Gnutella</b></td>\r\n <td class="table_col2">6346 - 6347</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>BitTorrent</b></td>\r\n <td class="table_col2">6881 - 6889</td>\r\n </tr>\r\n</table>\r\n<br />\r\nIn order to use use our tracker you must configure your client to use\r\nany port range that does not contain those ports (a range within the region 49152 through 65535 is preferable,\r\ncf. <a href="http://www.iana.org/assignments/port-numbers">IANA</a>). Notice that some clients,\r\nlike Azureus 2.0.7.0 or higher, use a single port for all torrents, while most others use one port per open torrent. The size\r\nof the range you choose should take this into account (typically less than 10 ports wide. There\r\nis no benefit whatsoever in choosing a wide range, and there are possible security implications). <br />\r\n<br />\r\nThese ports are used for connections between peers, not client to tracker.\r\nTherefore this change will not interfere with your ability to use other trackers (in fact it\r\nshould <i>increase</i> your speed with torrents from any tracker, not just ours). Your client\r\nwill also still be able to connect to peers that are using the standard ports.\r\nIf your client does not allow custom ports to be used, you will have to switch to one that does.<br />\r\n<br />\r\nDo not ask us, or in the forums, which ports you should choose. The more random the choice is the harder\r\nit will be for ISPs to catch on to us and start limiting speeds on the ports we use.\r\nIf we simply define another range ISPs will start throttling that range also. <br />\r\n<br />\r\nFinally, remember to forward the chosen ports in your router and/or open them in your\r\nfirewall, should you have them.', '3', 5, 9),
  342. (48, 'item', 'What''s this "IOError - [Errno13] Permission denied" error?', 'If you just want to fix it reboot your computer, it should solve the problem.\r\nOtherwise read on.<br />\r\n<br />\r\nIOError means Input-Output Error, and that is a file system error, not a tracker one.\r\nIt shows up when your client is for some reason unable to open the partially downloaded\r\ntorrent files. The most common cause is two instances of the client to be running\r\nsimultaneously:\r\nthe last time the client was closed it somehow didn''t really close but kept running in the\r\nbackground, and is therefore still\r\nlocking the files, making it impossible for the new instance to open them.<br />\r\n<br />\r\nA more uncommon occurrence is a corrupted FAT. A crash may result in corruption\r\nthat makes the partially downloaded files unreadable, and the error ensues. Running\r\nscandisk should solve the problem. (Note that this may happen only if you''re running\r\nWindows 9x - which only support FAT - or NT/2000/XP with FAT formatted hard drives.\r\nNTFS is much more robust and should never permit this problem.)', '3', 5, 10),
  343. (49, 'item', 'What''s this "TTL" in the browse page?', 'The torrent''s Time To Live, in hours. It means the torrent will be deleted\r\nfrom the tracker after that many hours have elapsed (yes, even if it is still active).\r\nNote that this a maximum value, the torrent may be deleted at any time if it''s inactive.', '3', 5, 11),
  344. (50, 'item', 'Do not immediately jump on new torrents', 'The download speed mostly depends on the seeder-to-leecher ratio (SLR). Poor download speed is\r\nmainly a problem with new and very popular torrents where the SLR is low.<br />\r\n<br />\r\n(Proselytising sidenote: make sure you remember that you did not enjoy the low speed.\r\n<b>Seed</b> so that others will not endure the same.)<br />\r\n<br />\r\nThere are a couple of things that you can try on your end to improve your speed:<br />\r\n<br />In particular, do not do it if you have a slow connection. The best speeds will be found around the\r\nhalf-life of a torrent, when the SLR will be at its highest. (The downside is that you will not be able to seed\r\nso much. It''s up to you to balance the pros and cons of this.)', '1', 6, 1),
  345. (51, 'item', 'Limit your upload speed', 'The upload speed affects the download speed in essentially two ways:<br />\r\n<ul>\r\n <li>Bittorrent peers tend to favour those other peers that upload to them. This means that if A and B\r\n are leeching the same torrent and A is sending data to B at high speed then B will try to reciprocate.\r\n So due to this effect high upload speeds lead to high download speeds.</li>\r\n\r\n <li>Due to the way TCP works, when A is downloading something from B it has to keep telling B that\r\n it received the data sent to him. (These are called acknowledgements - ACKs -, a sort of &quot;got it!&quot; messages).\r\n If A fails to do this then B will stop sending data and wait. If A is uploading at full speed there may be no\r\n bandwidth left for the ACKs and they will be delayed. So due to this effect excessively high upload speeds lead\r\n to low download speeds.</li>\r\n</ul>\r\n\r\nThe full effect is a combination of the two. The upload should be kept as high as possible while allowing the\r\nACKs to get through without delay. <b>A good thumb rule is keeping the upload at about 80% of the theoretical\r\nupload speed.</b> You will have to fine tune yours to find out what works best for you. (Remember that keeping the\r\nupload high has the additional benefit of helping with your ratio.) <br />\r\n<br />\r\nIf you are running more than one instance of a client it is the overall upload speed that you must take into account.\r\nSome clients (e.g. Azureus) limit global upload speed, others (e.g. Shad0w''s) do it on a per torrent basis.\r\nKnow your client. The same applies if you are using your connection for anything else (e.g. browsing or ftp),\r\nalways think of the overall upload speed.', '1', 6, 2),
  346. (52, 'item', 'Limit the number of simultaneous connections', 'Some operating systems (like Windows 9x) do not deal well with a large number of connections, and may even crash.\r\nAlso some home routers (particularly when running NAT and/or firewall with stateful inspection services) tend to become\r\nslow or crash when having to deal with too many connections. There are no fixed values for this, you may try 60 or 100\r\nand experiment with the value. Note that these numbers are additive, if you have two instances of\r\na client running the numbers add up.', '1', 6, 3),
  347. (53, 'item', 'Limit the number of simultaneous uploads', 'Isn''t this the same as above? No. Connections limit the number of peers your client is talking to and/or\r\ndownloading from. Uploads limit the number of peers your client is actually uploading to. The ideal number is\r\ntypically much lower than the number of connections, and highly dependent on your (physical) connection.', '1', 6, 4),
  348. (54, 'item', 'Just give it some time', 'As explained above peers favour other peers that upload to them. When you start leeching a new torrent you have\r\nnothing to offer to other peers and they will tend to ignore you. This makes the starts slow, in particular if,\r\nby change, the peers you are connected to include few or no seeders. The download speed should increase as soon\r\nas you have some pieces to share.', '1', 6, 5),
  349. (55, 'item', 'Why is my browsing so slow while leeching?', 'Your download speed is always finite. If you are a peer in a fast torrent it will almost certainly saturate your\r\ndownload bandwidth, and your browsing will suffer. At the moment there is no client that allows you to limit the\r\ndownload speed, only the upload. You will have to use a third-party solution,\r\nsuch as <a href="http://www.netlimiter.com/">NetLimiter</a>.<br />\r\n<br />\r\nBrowsing was used just as an example, the same would apply to gaming, IMing, etc...', '1', 6, 6),
  350. (56, 'item', 'What is a proxy?', 'Basically a middleman. When you are browsing a site through a proxy your requests are sent to the proxy and the proxy\r\nforwards them to the site instead of you connecting directly to the site. There are several classifications\r\n(the terminology is far from standard):<br />\r\n<br />\r\n\r\n\r\n<table cellspacing="3" cellpadding="3" class="table_table" align="center">\r\n <tr>\r\n <td class="table_col1"><b>Transparent</b></td>\r\n <td class="table_col2">A transparent proxy is one that needs no configuration on the clients. It works by automatically redirecting all port 80 traffic to the proxy. (Sometimes used as synonymous for non-anonymous.)</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Explicit/Voluntary</b></td>\r\n <td class="table_col2">Clients must configure their browsers to use them.</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Anonymous</b></td>\r\n <td class="table_col2">The proxy sends no client identification to the server. (HTTP_X_FORWARDED_FOR header is not sent; the server does not see your IP.)</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Highly Anonymous</b></td>\r\n <td class="table_col2">The proxy sends no client nor proxy identification to the server. (HTTP_X_FORWARDED_FOR, HTTP_VIA and HTTP_PROXY_CONNECTION headers are not sent; the server doesn''t see your IP and doesn''t even know you''re using a proxy.)</td>\r\n </tr>\r\n <tr>\r\n <td class="table_col1"><b>Public</b></td>\r\n <td class="table_col2">(Self explanatory)</td>\r\n </tr>\r\n</table>\r\n<br />\r\nA transparent proxy may or may not be anonymous, and there are several levels of anonymity.', '1', 7, 1),
  351. (57, 'item', 'How do I find out if I''m behind a (transparent/anonymous) proxy?', 'Try <a href="http://proxyjudge.org">ProxyJudge</a>. It lists the HTTP headers that the server where it is running\r\nreceived from you. The relevant ones are HTTP_CLIENT_IP, HTTP_X_FORWARDED_FOR and REMOTE_ADDR.<br />\r\n<br />\r\n<br />\r\n<b>Why is my port listed as &quot;---&quot; even though I''m not NAT/Firewalled?</b><a name="prox3"></a><br />\r\n<br />\r\nThe tracker is quite smart at finding your real IP, but it does need the proxy to send the HTTP header\r\nHTTP_X_FORWARDED_FOR. If your ISP''s proxy does not then what happens is that the tracker will interpret the proxy''s IP\r\naddress as the client''s IP address. So when you login and the tracker tries to connect to your client to see if you are\r\nNAT/firewalled it will actually try to connect to the proxy on the port your client reports to be using for\r\nincoming connections. Naturally the proxy will not be listening on that port, the connection will fail and the\r\ntracker will think you are NAT/firewalled.', '1', 7, 2),
  352. (58, 'item', 'Can I bypass my ISP''s proxy?', 'If your ISP only allows HTTP traffic through port 80 or blocks the usual proxy ports then you would need to use something\r\nlike <a href="http://www.socks.permeo.com">socks</a> and that is outside the scope of this FAQ.<br />\r\n<br />\r\nOtherwise you may try the following:<br />\r\n<ul>\r\n <li>Choose any public <b>non-anonymous</b> proxy that does <b>not</b> use port 80\r\n (e.g. from <a href="http://tools.rosinstrument.com/proxy">this</a>,\r\n <a href="http://www.proxy4free.com/index.html">this</a> or\r\n <a href="http://www.samair.ru/proxy">this</a> list).</li>\r\n\r\n <li>Configure your computer to use that proxy. For Windows XP, do <i>Start</i>, <i>Control Panel</i>, <i>Internet Options</i>,\r\n <i>Connections</i>, <i>LAN Settings</i>, <i>Use a Proxy server</i>, <i>Advanced</i> and type in the IP and port of your chosen\r\n proxy. Or from Internet Explorer use <i>Tools</i>, <i>Internet Options</i>, ...<br /></li>\r\n\r\n <li>(Facultative) Visit <a href="http://proxyjudge.org">ProxyJudge</a>. If you see an HTTP_X_FORWARDED_FOR in\r\n the list followed by your IP then everything should be ok, otherwise choose another proxy and try again.<br /></li>\r\n\r\n <li>Visit this site. Hopefully the tracker will now pickup your real IP (check your profile to make sure).</li>\r\n</ul>\r\n<br />\r\nNotice that now you will be doing all your browsing through a public proxy, which are typically quite slow.\r\nCommunications between peers do not use port 80 so their speed will not be affected by this, and should be better than when\r\nyou were &quot;unconnectable&quot;.', '1', 7, 3),
  353. (59, 'item', 'How do I make my bittorrent client use a proxy?', 'Just configure Windows XP as above. When you configure a proxy for Internet Explorer you\r\nre actually configuring a proxy for\r\nall HTTP traffic (thank Microsoft and their &quot;IE as part of the OS policy&quot; ). On the other hand if you use another\r\nbrowser (Opera/Mozilla/Firefox) and configure a proxy there you''ll be configuring a proxy just for that browser. We don''t\r\nknow of any BT client that allows a proxy to be specified explicitly.', '1', 7, 4),
  354. (60, 'item', 'Why can''t I signup from behind a proxy?', 'It is our policy not to allow new accounts to be opened from behind a proxy.', '1', 7, 5),
  355. (62, 'item', 'Maybe my address is blacklisted?', 'The site blocks addresses listed in the (former) <a href="http://methlabs.org/">PeerGuardian</a>\r\ndatabase, as well as addresses of banned users. This works at Apache/PHP level, it''s just a script that\r\nblocks <i>logins</i> from those addresses. It should not stop you from reaching the site. In particular\r\nit does not block lower level protocols, you should be able to ping/traceroute the server even if your\r\naddress is blacklisted. If you cannot then the reason for the problem lies elsewhere.<br />\r\n<br />\r\nIf somehow your address is indeed blocked in the PG database do not contact us about it, it is not our\r\npolicy to open <i>ad hoc</i> exceptions. You should clear your IP with the database maintainers instead.', '1', 8, 1),
  356. (63, 'item', 'Your ISP blocks the site''s address', '(In first place, it''s unlikely your ISP is doing so. DNS name resolution and/or network problems are the usual culprits.)\r\n<br />\r\nThere''s nothing we can do.\r\nYou should contact your ISP (or get a new one). Note that you can still visit the site via a proxy, follow the instructions\r\nin the relevant section. In this case it doesn''t matter if the proxy is anonymous or not, or which port it listens to.<br />\r\n<br />\r\nNotice that you will always be listed as an &quot;unconnectable&quot; client because the tracker will be unable to\r\ncheck that you''re capable of accepting incoming connections.', '1', 8, 2),
  357. (65, 'item', 'You can try these:', 'Post in the <a href="forums.php">Forums</a>, by all means. You''ll find they\r\nare usually a friendly and helpful place,\r\nprovided you follow a few basic guidelines:\r\n<ul>\r\n<li>Make sure your problem is not really in this FAQ. There''s no point in posting just to be sent\r\nback here.</li>\r\n<li>Before posting read the sticky topics (the ones at the top). Many times new information that\r\nstill hasn''t been incorporated in the FAQ can be found there.</li>\r\n<li>Help us in helping you. Do not just say "it doesn''t work!". Provide details so that we don''t\r\nhave to guess or waste time asking. What client do you use? What''s your OS? What''s your network setup? What''s the exact\r\nerror message you get, if any? What are the torrents you are having problems with? The more\r\nyou tell the easiest it will be for us, and the more probable your post will get a reply.</li>\r\n<li>And needless to say: be polite. Demanding help rarely works, asking for it usually does\r\nthe trick.</li></ul>', '1', 9, 1);
  358.  
  359.  
  360. DROP TABLE IF EXISTS `groups`;
  361. CREATE TABLE `groups` (
  362. `group_id` int(10) NOT NULL AUTO_INCREMENT,
  363. `level` varchar(50) NOT NULL DEFAULT '',
  364. `view_torrents` enum('yes','no') NOT NULL DEFAULT 'yes',
  365. `edit_torrents` enum('yes','no') NOT NULL DEFAULT 'no',
  366. `delete_torrents` enum('yes','no') NOT NULL DEFAULT 'no',
  367. `view_users` enum('yes','no') NOT NULL DEFAULT 'yes',
  368. `edit_users` enum('yes','no') NOT NULL DEFAULT 'no',
  369. `delete_users` enum('yes','no') NOT NULL DEFAULT 'no',
  370. `view_news` enum('yes','no') NOT NULL DEFAULT 'yes',
  371. `edit_news` enum('yes','no') NOT NULL DEFAULT 'no',
  372. `delete_news` enum('yes','no') NOT NULL DEFAULT 'no',
  373. `can_upload` enum('yes','no') NOT NULL DEFAULT 'no',
  374. `can_download` enum('yes','no') NOT NULL DEFAULT 'yes',
  375. `view_forum` enum('yes','no') NOT NULL DEFAULT 'yes',
  376. `edit_forum` enum('yes','no') NOT NULL DEFAULT 'yes',
  377. `delete_forum` enum('yes','no') NOT NULL DEFAULT 'no',
  378. `control_panel` enum('yes','no') NOT NULL DEFAULT 'no',
  379. `staff_page` enum('yes','no') NOT NULL DEFAULT 'no',
  380. `staff_public` enum('yes','no') NOT NULL DEFAULT 'no',
  381. `staff_sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  382. UNIQUE KEY `base` (`group_id`)
  383. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  384.  
  385.  
  386. INSERT INTO `groups` (`group_id`, `level`, `view_torrents`, `edit_torrents`, `delete_torrents`, `view_users`, `edit_users`, `delete_users`, `view_news`, `edit_news`, `delete_news`, `can_upload`, `can_download`, `view_forum`, `edit_forum`, `delete_forum`, `control_panel`, `staff_page`, `staff_public`, `staff_sort`) VALUES
  387. (1, 'Member', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 7),
  388. (2, 'Power User', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 6),
  389. (3, 'VIP', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'no', 'no', 5),
  390. (4, 'Uploader', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'no', 'no', 'no', 'yes', 'no', 4),
  391. (5, 'Moderator', 'yes', 'yes', 'no', 'yes', 'yes', 'no', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 3),
  392. (6, 'Super Moderator', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 2),
  393. (7, 'Administrator', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 1);
  394.  
  395. DROP TABLE IF EXISTS `guests`;
  396. CREATE TABLE `guests` (
  397. `ip` varchar(39) NOT NULL default '',
  398. `time` decimal(20,0) unsigned NOT NULL default '0',
  399. UNIQUE KEY `IP` (`ip`)
  400. ) ENGINE=MyISAM;
  401.  
  402. DROP TABLE IF EXISTS `languages`;
  403. CREATE TABLE `languages` (
  404. `id` int(10) unsigned NOT NULL auto_increment,
  405. `uri` varchar(255) NOT NULL default '',
  406. `name` varchar(64) NOT NULL default '',
  407. PRIMARY KEY (`id`)
  408. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  409.  
  410. INSERT INTO `languages` (`id`, `uri`, `name`) VALUES
  411. (1, 'english.php', 'English');
  412.  
  413.  
  414. DROP TABLE IF EXISTS `log`;
  415. CREATE TABLE `log` (
  416. `id` int(10) unsigned NOT NULL auto_increment,
  417. `added` datetime default NULL,
  418. `txt` text,
  419. PRIMARY KEY (`id`),
  420. KEY `added` (`added`)
  421. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  422.  
  423. DROP TABLE IF EXISTS `messages`;
  424. CREATE TABLE `messages` (
  425. `id` int(10) unsigned NOT NULL auto_increment,
  426. `sender` int(10) unsigned NOT NULL default '0',
  427. `receiver` int(10) unsigned NOT NULL default '0',
  428. `added` datetime default NULL,
  429. `msg` text,
  430. `unread` enum('yes','no') NOT NULL default 'yes',
  431. `poster` bigint(20) unsigned NOT NULL default '0',
  432. `subject` text NOT NULL DEFAULT '',
  433. `location` enum('in','out','both','draft','template') NOT NULL default 'in',
  434. PRIMARY KEY (`id`),
  435. KEY `receiver` (`receiver`)
  436. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  437.  
  438. DROP TABLE IF EXISTS `news`;
  439. CREATE TABLE `news` (
  440. `id` int(10) unsigned NOT NULL auto_increment,
  441. `userid` int(11) NOT NULL default '0',
  442. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  443. `title` varchar(255) NOT NULL default '',
  444. `body` text NOT NULL,
  445. PRIMARY KEY (`id`),
  446. KEY `added` (`added`)
  447. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  448.  
  449. INSERT INTO `news` (`id`, `userid`, `added`, `title`, `body`) VALUES
  450. (1, 1, '2011-07-27 09:29:22', 'Welcome', 'Welcome To TorrentTrader v2');
  451.  
  452. --
  453. -- Table structure for table `news`
  454. --
  455.  
  456. CREATE TABLE IF NOT EXISTS `news` (
  457. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  458. `userid` int(11) NOT NULL DEFAULT '0',
  459. `added` int(11) NOT NULL DEFAULT '0',
  460. `body` text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  461. `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  462. `sticky` enum('yes','no') CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT 'no',
  463. PRIMARY KEY (`id`),
  464. KEY `added` (`added`)
  465. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  466.  
  467. --
  468. -- Dumping data for table `news`
  469. --
  470.  
  471. --
  472. -- Table structure for table `tsue_news`
  473. --
  474.  
  475. DROP TABLE IF EXISTS `tsue_news`;
  476. /*!40101 SET @saved_cs_client = @@character_set_client */;
  477. /*!40101 SET character_set_client = utf8 */;
  478. CREATE TABLE `tsue_news` (
  479. `nid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  480. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  481. `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  482. `date` int(10) unsigned NOT NULL DEFAULT '0',
  483. `title` tinyblob,
  484. `content` blob,
  485. PRIMARY KEY (`nid`),
  486. KEY `active` (`active`)
  487. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  488. /*!40101 SET character_set_client = @saved_cs_client */;
  489.  
  490. CREATE TABLE `tsue_member_alerts` (
  491. `alert_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  492. `alerted_memberid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member being alerted',
  493. `memberid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Member who did the action that caused the alert',
  494. `membername` varchar(100) COLLATE utf8_unicode_ci NOT NULL COMMENT 'Corresponds to memberid',
  495. `content_type` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'eg: trophy',
  496. `content_id` int(10) unsigned NOT NULL DEFAULT '0',
  497. `action` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'eg: edit',
  498. `event_date` int(10) unsigned NOT NULL DEFAULT '0',
  499. `read_date` int(10) unsigned NOT NULL DEFAULT '0',
  500. `extra` bigint(20) unsigned NOT NULL DEFAULT '0',
  501. PRIMARY KEY (`alert_id`),
  502. KEY `alerted_memberid` (`alerted_memberid`,`read_date`),
  503. KEY `event_date` (`event_date`,`read_date`)
  504. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  505. /*!40101 SET character_set_client = @saved_cs_client */;
  506.  
  507. DROP TABLE IF EXISTS `peers`;
  508. CREATE TABLE `peers` (
  509. `id` int(10) unsigned NOT NULL auto_increment,
  510. `torrent` int(10) unsigned NOT NULL default '0',
  511. `peer_id` varchar(40) NOT NULL default '',
  512. `ip` varchar(64) NOT NULL default '',
  513. `port` smallint(5) unsigned NOT NULL default '0',
  514. `uploaded` bigint(20) unsigned NOT NULL default '0',
  515. `downloaded` bigint(20) unsigned NOT NULL default '0',
  516. `to_go` bigint(20) unsigned NOT NULL default '0',
  517. `seeder` enum('yes','no') NOT NULL default 'no',
  518. `started` datetime NOT NULL default '0000-00-00 00:00:00',
  519. `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  520. `connectable` enum('yes','no') NOT NULL default 'yes',
  521. `client` varchar(60) NOT NULL default '',
  522. `userid` varchar(32) NOT NULL default '',
  523. `passkey` varchar(32) NOT NULL default '',
  524. PRIMARY KEY (`id`),
  525. UNIQUE KEY `torrent_peer_id` (`torrent`,`peer_id`),
  526. KEY `torrent` (`torrent`),
  527. KEY `torrent_seeder` (`torrent`,`seeder`),
  528. KEY `last_action` (`last_action`)
  529. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  530.  
  531. DROP TABLE IF EXISTS `pollanswers`;
  532. CREATE TABLE `pollanswers` (
  533. `id` int(10) unsigned NOT NULL auto_increment,
  534. `pollid` int(10) unsigned NOT NULL default '0',
  535. `userid` int(10) unsigned NOT NULL default '0',
  536. `selection` tinyint(3) unsigned NOT NULL default '0',
  537. PRIMARY KEY (`id`),
  538. KEY `pollid` (`pollid`),
  539. KEY `selection` (`selection`),
  540. KEY `userid` (`userid`)
  541. ) ENGINE=MyISAM AUTO_INCREMENT=1;
  542.  
  543. DROP TABLE IF EXISTS `polls`;
  544. CREATE TABLE `polls` (
  545. `id` int(10) unsigned NOT NULL auto_increment,
  546. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  547. `question` varchar(255) NOT NULL default '',
  548. `option0` varchar(40) NOT NULL default '',
  549. `option1` varchar(40) NOT NULL default '',
  550. `option2` varchar(40) NOT NULL default '',
  551. `option3` varchar(40) NOT NULL default '',
  552. `option4` varchar(40) NOT NULL default '',
  553. `option5` varchar(40) NOT NULL default '',
  554. `option6` varchar(40) NOT NULL default '',
  555. `option7` varchar(40) NOT NULL default '',
  556. `option8` varchar(40) NOT NULL default '',
  557. `option9` varchar(40) NOT NULL default '',
  558. `option10` varchar(40) NOT NULL default '',
  559. `option11` varchar(40) NOT NULL default '',
  560. `option12` varchar(40) NOT NULL default '',
  561. `option13` varchar(40) NOT NULL default '',
  562. `option14` varchar(40) NOT NULL default '',
  563. `option15` varchar(40) NOT NULL default '',
  564. `option16` varchar(40) NOT NULL default '',
  565. `option17` varchar(40) NOT NULL default '',
  566. `option18` varchar(40) NOT NULL default '',
  567. `option19` varchar(40) NOT NULL default '',
  568. `sort` enum('yes','no') NOT NULL default 'yes',
  569. PRIMARY KEY (`id`)
  570. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  571.  
  572. INSERT INTO `polls` (`id`, `added`, `question`, `option0`, `option1`, `option2`, `option3`, `option4`, `option5`, `option6`, `option7`, `option8`, `option9`, `option10`, `option11`, `option12`, `option13`, `option14`, `option15`, `option16`, `option17`, `option18`, `option19`, `sort`) VALUES
  573. (1, '0000-00-00 00:00:00', 'Do You Like This Site', 'Excellent!', 'Its OK', 'Its my first visit', 'Don''t Like It', 'Im Off', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'yes');
  574.  
  575. DROP TABLE IF EXISTS `ratings`;
  576. CREATE TABLE `ratings` (
  577. `torrent` int(10) unsigned NOT NULL default '0',
  578. `user` int(10) unsigned NOT NULL default '0',
  579. `rating` tinyint(3) unsigned NOT NULL default '0',
  580. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  581. PRIMARY KEY (`torrent`,`user`),
  582. KEY `user` (`user`)
  583. ) ENGINE=MyISAM;
  584.  
  585. DROP TABLE IF EXISTS `reports`;
  586. CREATE TABLE `reports` (
  587. `id` int(10) unsigned NOT NULL auto_increment,
  588. `addedby` int(10) unsigned NOT NULL default '0',
  589. `votedfor` int(10) unsigned NOT NULL default '0',
  590. `votedfor_xtra` int(10) unsigned NOT NULL default '0',
  591. `type` enum('torrent','user','forum','comment','other') NOT NULL default 'torrent',
  592. `reason` varchar(255) NOT NULL default '',
  593. `dealtby` int(10) unsigned NOT NULL default '0',
  594. `dealtwith` tinyint(1) NOT NULL default '0',
  595. `complete` tinyint(1) NOT NULL default '0',
  596. PRIMARY KEY (`id`)
  597. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  598.  
  599. DROP TABLE IF EXISTS `rules`;
  600. CREATE TABLE `rules` (
  601. `id` int(11) NOT NULL auto_increment,
  602. `title` varchar(255) NOT NULL default '',
  603. `text` text NOT NULL,
  604. `public` enum('yes','no') NOT NULL default 'yes',
  605. `class` int(11) NOT NULL default '0',
  606. PRIMARY KEY (`id`)
  607. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  608.  
  609. INSERT INTO `rules` (`id`, `title`, `text`, `public`, `class`) VALUES
  610. (1, 'General rules - Breaking these rules can and will get you banned!', '- We are a English only site, so please only talk in english! \r\n\r\n- Keep your overall ratio at or above 0.5 at all times! \r\n\r\n- Do not defy the moderators expressed wishes! ', 'yes', 0),
  611. (2, 'General Forum Guidelines', '- No aggressive behaviour or flaming in the forums. \r\n- No trashing of other peoples topics (i.e. SPAM). \r\n- No language other than English in the forums. \r\n- No links to warez or crack sites in the forums. \r\n- No serials, CD keys, passwords or cracks in the forums. \r\n- No requesting if the release is over 7 days old. \r\n- No bumping... (All bumped threads will be deleted.) \r\n- No double posting. If you wish to post again, and yours is the last post in the thread please use the EDIT function,instead of posting a double.\r\n- Please ensure all questions are posted in the correct section!', 'yes', 0),
  612. (3, 'Moderating Rules', '- The most important rule!; Use your better judgement! \r\n- Don''t defy another mod in public, instead send a PM or make a post in the "Site admin". \r\n- Be tolerant! give the user(s) a chance to reform. \r\n- Don''t act prematurely, Let the users make their mistake and THEN correct them. \r\n- Try correcting any "off topics" rather then closing the thread. \r\n- Move topics rather than locking / deleting them. \r\n- Be tolerant when moderating the Chit-chat section. (give them some slack) \r\n- If you lock a topic, Give a brief explanation as to why you''re locking it. \r\n- Before banning a user, Send him/her a PM and If they reply, put them on a 2 week trial. \r\n- Don''t ban a user until he or she has been a member for at least 4 weeks. \r\n- Always state a reason (in the user comment box) as to why the user is being banned. \r\n', 'no', 5);
  613.  
  614. DROP TABLE IF EXISTS `shoutbox`;
  615. CREATE TABLE `shoutbox` (
  616. `msgid` int(10) unsigned NOT NULL auto_increment,
  617. `user` varchar(50) NOT NULL default '0',
  618. `message` text,
  619. `date` datetime NOT NULL default '0000-00-00 00:00:00',
  620. `userid` int(8) unsigned NOT NULL default '0',
  621. PRIMARY KEY (`msgid`)
  622. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  623.  
  624. DROP TABLE IF EXISTS `stylesheets`;
  625. CREATE TABLE `stylesheets` (
  626. `id` int(10) unsigned NOT NULL auto_increment,
  627. `uri` varchar(255) NOT NULL default '',
  628. `name` varchar(64) NOT NULL default '',
  629. PRIMARY KEY (`id`)
  630. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  631.  
  632. INSERT INTO `stylesheets` (`id`, `uri`, `name`) VALUES
  633. (1, 'default', 'Default');
  634.  
  635. DROP TABLE IF EXISTS `tasks`;
  636. CREATE TABLE `tasks` (
  637. `task` varchar(20) NOT NULL default '',
  638. `last_time` int(10) NOT NULL default '0',
  639. PRIMARY KEY (`task`)
  640. ) ENGINE=MyISAM;
  641.  
  642. INSERT INTO `tasks` (`task`, `last_time`) VALUES
  643. ('cleanup', 1189677270);
  644.  
  645. DROP TABLE IF EXISTS `teams`;
  646. CREATE TABLE `teams` (
  647. `id` int(10) NOT NULL auto_increment,
  648. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  649. `owner` int(10) NOT NULL default '0',
  650. `info` text,
  651. `name` varchar(255) default NULL,
  652. `image` varchar(255) default NULL,
  653. UNIQUE KEY `id` (`id`)
  654. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  655.  
  656. DROP TABLE IF EXISTS `torrentlang`;
  657. CREATE TABLE `torrentlang` (
  658. `id` int(10) unsigned NOT NULL auto_increment,
  659. `name` varchar(30) NOT NULL default '',
  660. `image` varchar(255) NOT NULL default '',
  661. `sort_index` int(10) unsigned NOT NULL default '0',
  662. PRIMARY KEY (`id`)
  663. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  664.  
  665. INSERT INTO `torrentlang` (`id`, `name`, `image`, `sort_index`) VALUES
  666. (1, 'English', 'english.gif', 1),
  667. (2, 'French', 'french.jpg', 1),
  668. (3, 'German', 'german.jpg', 1),
  669. (4, 'Italian', 'italian.jpg', 1),
  670. (5, 'Japanese', 'japanese.jpg', 1),
  671. (6, 'Spanish', 'spanish.jpg', 1),
  672. (7, 'Russian', 'russian.jpg', 1);
  673.  
  674. DROP TABLE IF EXISTS `torrents`;
  675. CREATE TABLE `torrents` (
  676. `id` int(10) unsigned NOT NULL auto_increment,
  677. `info_hash` varchar(40) default NULL,
  678. `name` varchar(255) NOT NULL default '',
  679. `filename` varchar(255) NOT NULL default '',
  680. `save_as` varchar(255) NOT NULL default '',
  681. `descr` text NOT NULL,
  682. `image1` text NOT NULL,
  683. `image2` text NOT NULL,
  684. `category` int(10) unsigned NOT NULL default '0',
  685. `size` bigint(20) unsigned NOT NULL default '0',
  686. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  687. `type` enum('single','multi') NOT NULL default 'single',
  688. `numfiles` int(10) unsigned NOT NULL default '0',
  689. `comments` int(10) unsigned NOT NULL default '0',
  690. `views` int(10) unsigned NOT NULL default '0',
  691. `hits` int(10) unsigned NOT NULL default '0',
  692. `times_completed` int(10) unsigned NOT NULL default '0',
  693. `leechers` int(10) unsigned NOT NULL default '0',
  694. `seeders` int(10) unsigned NOT NULL default '0',
  695. `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  696. `visible` enum('yes','no') NOT NULL default 'yes',
  697. `banned` enum('yes','no') NOT NULL default 'no',
  698. `owner` int(10) unsigned NOT NULL default '0',
  699. `anon` enum('yes','no') NOT NULL default 'no',
  700. `numratings` int(10) unsigned NOT NULL default '0',
  701. `ratingsum` int(10) unsigned NOT NULL default '0',
  702. `nfo` enum('yes','no') NOT NULL default 'no',
  703. `announce` varchar(255) NOT NULL default '',
  704. `external` enum('yes', 'no') NOT NULL DEFAULT 'no',
  705. `torrentlang` int(10) unsigned NOT NULL default '1',
  706. `freeleech` enum('0','1') NOT NULL default '0',
  707. PRIMARY KEY (`id`),
  708. UNIQUE KEY `info_hash` (`info_hash`(20)),
  709. KEY `owner` (`owner`),
  710. KEY `visible` (`visible`),
  711. KEY `category_visible` (`category`,`visible`),
  712. FULLTEXT KEY `name` (`name`)
  713. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  714.  
  715. DROP TABLE IF EXISTS `tsue_torrents`;
  716. /*!40101 SET @saved_cs_client = @@character_set_client */;
  717. /*!40101 SET character_set_client = utf8 */;
  718. CREATE TABLE `tsue_torrents` (
  719. `tid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  720. `info_hash` binary(20) NOT NULL DEFAULT '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0',
  721. `name` tinytext COLLATE utf8_unicode_ci,
  722. `description` longtext COLLATE utf8_unicode_ci,
  723. `cid` int(10) unsigned NOT NULL DEFAULT '0',
  724. `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  725. `added` int(10) unsigned NOT NULL DEFAULT '0',
  726. `leechers` int(10) unsigned NOT NULL DEFAULT '0',
  727. `seeders` int(10) unsigned NOT NULL DEFAULT '0',
  728. `times_completed` int(10) unsigned NOT NULL DEFAULT '0',
  729. `owner` int(10) unsigned NOT NULL DEFAULT '0',
  730. `options` mediumblob,
  731. `nfo` longblob,
  732. `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  733. `flags` tinyint(1) unsigned NOT NULL DEFAULT '2',
  734. `mtime` int(10) unsigned NOT NULL DEFAULT '0',
  735. `ctime` int(10) unsigned NOT NULL DEFAULT '0',
  736. `download_multiplier` float NOT NULL DEFAULT '1',
  737. `upload_multiplier` float NOT NULL DEFAULT '1',
  738. `external` tinyint(1) unsigned NOT NULL DEFAULT '0',
  739. `tags` longtext COLLATE utf8_unicode_ci,
  740. `awaitingModeration` tinyint(1) unsigned NOT NULL DEFAULT '0',
  741. `gids` longtext COLLATE utf8_unicode_ci,
  742. PRIMARY KEY (`tid`),
  743. UNIQUE KEY `info_hash` (`info_hash`),
  744. KEY `added` (`added`),
  745. KEY `times_completed` (`times_completed`),
  746. KEY `owner` (`owner`),
  747. KEY `awaitingModeration` (`awaitingModeration`,`seeders`),
  748. FULLTEXT KEY `name` (`name`),
  749. FULLTEXT KEY `description` (`description`),
  750. FULLTEXT KEY `name_description` (`name`,`description`),
  751. FULLTEXT KEY `tags` (`tags`),
  752. FULLTEXT KEY `gids` (`gids`)
  753. ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  754. /*!40101 SET character_set_client = @saved_cs_client */;
  755.  
  756. --
  757. -- Dumping data for table `tsue_torrents`
  758. --
  759.  
  760. --
  761. -- Table structure for table `torrents`
  762. --
  763.  
  764. CREATE TABLE `torrents` (
  765. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  766. `info_hash` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  767. `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  768. `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  769. `save_as` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  770. `search_text` text COLLATE utf8_unicode_ci NOT NULL,
  771. `descr` text COLLATE utf8_unicode_ci NOT NULL,
  772. `ori_descr` text COLLATE utf8_unicode_ci NOT NULL,
  773. `category` int(10) unsigned NOT NULL DEFAULT '0',
  774. `size` bigint(20) unsigned NOT NULL DEFAULT '0',
  775. `added` int(11) NOT NULL,
  776. `type` enum('single','multi') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'single',
  777. `numfiles` int(10) unsigned NOT NULL DEFAULT '0',
  778. `comments` int(10) unsigned NOT NULL DEFAULT '0',
  779. `views` int(10) unsigned NOT NULL DEFAULT '0',
  780. `hits` int(10) unsigned NOT NULL DEFAULT '0',
  781. `times_completed` int(10) unsigned NOT NULL DEFAULT '0',
  782. `leechers` int(10) unsigned NOT NULL DEFAULT '0',
  783. `seeders` int(10) unsigned NOT NULL DEFAULT '0',
  784. `last_action` int(11) NOT NULL,
  785. `visible` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  786. `banned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  787. `owner` int(10) unsigned NOT NULL DEFAULT '0',
  788. `numratings` int(10) unsigned NOT NULL DEFAULT '0',
  789. `ratingsum` int(10) unsigned NOT NULL DEFAULT '0',
  790. `nfo` text COLLATE utf8_unicode_ci NOT NULL,
  791. `client_created_by` char(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'unknown',
  792. PRIMARY KEY (`id`),
  793. UNIQUE KEY `info_hash` (`info_hash`),
  794. KEY `owner` (`owner`),
  795. KEY `visible` (`visible`),
  796. KEY `category_visible` (`category`,`visible`),
  797. FULLTEXT KEY `ft_search` (`search_text`,`ori_descr`)
  798. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  799.  
  800. -- --------------------------------------------------------
  801. DROP TABLE IF EXISTS `users`;
  802. CREATE TABLE `users` (
  803. `id` int(10) unsigned NOT NULL auto_increment,
  804. `username` varchar(40) NOT NULL default '',
  805. `password` varchar(40) NOT NULL default '',
  806. `secret` varchar(20) binary NOT NULL default '' COLLATE latin1_bin,
  807. `email` varchar(80) NOT NULL default '',
  808. `status` enum('pending','confirmed') NOT NULL default 'pending',
  809. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  810. `last_login` datetime NOT NULL default '0000-00-00 00:00:00',
  811. `last_access` datetime NOT NULL default '0000-00-00 00:00:00',
  812. `editsecret` varchar(20) binary NOT NULL default '' COLLATE latin1_bin,
  813. `privacy` enum('strong','normal','low') NOT NULL default 'normal',
  814. `stylesheet` int(10) default '1',
  815. `language` varchar(20) NOT NULL default '1',
  816. `info` text,
  817. `acceptpms` enum('yes','no') NOT NULL default 'yes',
  818. `ip` varchar(39) NOT NULL default '',
  819. `class` tinyint(3) unsigned NOT NULL default '1',
  820. `avatar` varchar(100) NOT NULL default '',
  821. `uploaded` bigint(20) unsigned NOT NULL default '0',
  822. `downloaded` bigint(20) unsigned NOT NULL default '0',
  823. `title` varchar(30) NOT NULL default '',
  824. `donated` int(5) unsigned NOT NULL default '0',
  825. `country` int(10) unsigned NOT NULL default '0',
  826. `notifs` varchar(100) NOT NULL default '',
  827. `enabled` varchar(10) NOT NULL default 'yes',
  828. `modcomment` text default NULL,
  829. `gender` varchar(6) NOT NULL default '',
  830. `client` varchar(25) NOT NULL default '',
  831. `age` int(3) NOT NULL default '0',
  832. `warned` char(3) NOT NULL default 'no',
  833. `signature` varchar(200) NOT NULL default '',
  834. `last_browse` int(11) NOT NULL default '0',
  835. `forumbanned` char(3) NOT NULL default 'no',
  836. `invited_by` int(10) NOT NULL default '0',
  837. `invitees` varchar(100) NOT NULL default '',
  838. `invites` smallint(5) NOT NULL default '0',
  839. `invitedate` datetime NOT NULL default '0000-00-00 00:00:00',
  840. `commentpm` enum('yes','no') NOT NULL default 'yes',
  841. `passkey` varchar(32) NOT NULL default '',
  842. `page` text,
  843. `team` int(10) unsigned NOT NULL default '0',
  844. `tzoffset` int(4) default 0,
  845. `hideshoutbox` enum('yes', 'no') NOT NULL DEFAULT 'no',
  846. PRIMARY KEY (`id`),
  847. UNIQUE KEY `username` (`username`),
  848. KEY `status_added` (`status`,`added`),
  849. KEY `ip` (`ip`),
  850. KEY `uploaded` (`uploaded`),
  851. KEY `downloaded` (`downloaded`),
  852. KEY `country` (`country`)
  853. ) ENGINE=MyISAM PACK_KEYS=0 AUTO_INCREMENT=1 ;
  854.  
  855. CREATE TABLE `tsue_members` (
  856. `memberid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  857. `membergroupid` smallint(5) unsigned NOT NULL DEFAULT '0',
  858. `membername` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  859. `password` char(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  860. `password_date` int(10) unsigned NOT NULL DEFAULT '0',
  861. `passkey` char(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  862. `email` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  863. `themeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  864. `languageid` smallint(5) unsigned NOT NULL DEFAULT '0',
  865. `joindate` int(10) unsigned NOT NULL DEFAULT '0',
  866. `lastvisit` int(10) unsigned NOT NULL DEFAULT '0',
  867. `lastactivity` int(10) unsigned NOT NULL DEFAULT '0',
  868. `lastforumvisit` int(10) unsigned NOT NULL DEFAULT '0',
  869. `lastforumactivity` int(10) unsigned NOT NULL DEFAULT '0',
  870. `timezone` char(4) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  871. `dst` tinyint(1) unsigned NOT NULL DEFAULT '0',
  872. `ipaddress` char(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  873. `gender` char(1) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
  874. `visible` tinyint(1) unsigned NOT NULL DEFAULT '1',
  875. `unread_alerts` smallint(5) unsigned NOT NULL DEFAULT '0',
  876. `unread_messages` smallint(5) unsigned NOT NULL DEFAULT '0',
  877. `inactivitytag` int(10) unsigned NOT NULL DEFAULT '0',
  878. `accountParked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  879. PRIMARY KEY (`memberid`),
  880. UNIQUE KEY `membername` (`membername`),
  881. UNIQUE KEY `passkey` (`passkey`),
  882. KEY `email` (`email`),
  883. KEY `membergroupid` (`membergroupid`),
  884. KEY `ipaddress` (`ipaddress`),
  885. KEY `inactivitytag` (`inactivitytag`)
  886. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  887. /*!40101 SET character_set_client = @saved_cs_client */;
  888.  
  889. --
  890. -- Table structure for table `users`
  891. --
  892.  
  893. CREATE TABLE `users` (
  894. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  895. `username` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
  896. `passhash` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  897. `secret` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  898. `passkey` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  899. `email` varchar(80) COLLATE utf8_unicode_ci NOT NULL,
  900. `status` enum('pending','confirmed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending',
  901. `added` int(11) NOT NULL,
  902. `last_login` int(11) NOT NULL,
  903. `last_access` int(11) NOT NULL,
  904. `editsecret` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
  905. `privacy` enum('strong','normal','low') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'normal',
  906. `stylesheet` int(10) DEFAULT '1',
  907. `info` text COLLATE utf8_unicode_ci,
  908. `acceptpms` enum('yes','friends','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  909. `ip` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  910. `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
  911. `language` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT 'en',
  912. `avatar` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  913. `av_w` smallint(3) unsigned NOT NULL DEFAULT '0',
  914. `av_h` smallint(3) unsigned NOT NULL DEFAULT '0',
  915. `uploaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  916. `downloaded` bigint(20) unsigned NOT NULL DEFAULT '0',
  917. `title` varchar(30) COLLATE utf8_unicode_ci NOT NULL,
  918. `country` int(10) unsigned NOT NULL DEFAULT '0',
  919. `notifs` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  920. `modcomment` text COLLATE utf8_unicode_ci NOT NULL,
  921. `enabled` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  922. `avatars` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  923. `donor` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  924. `warned` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  925. `warneduntil` int(11) NOT NULL DEFAULT '0',
  926. `torrentsperpage` int(3) unsigned NOT NULL DEFAULT '0',
  927. `topicsperpage` int(3) unsigned NOT NULL DEFAULT '0',
  928. `postsperpage` int(3) unsigned NOT NULL DEFAULT '0',
  929. `deletepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'yes',
  930. `savepms` enum('yes','no') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'no',
  931. `reputation` int(10) NOT NULL DEFAULT '10',
  932. `time_offset` varchar(5) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  933. `dst_in_use` tinyint(1) NOT NULL DEFAULT '0',
  934. `auto_correct_dst` tinyint(1) NOT NULL DEFAULT '1',
  935. PRIMARY KEY (`id`),
  936. UNIQUE KEY `username` (`username`),
  937. KEY `ip` (`ip`),
  938. KEY `uploaded` (`uploaded`),
  939. KEY `downloaded` (`downloaded`),
  940. KEY `country` (`country`),
  941. KEY `last_access` (`last_access`),
  942. KEY `enabled` (`enabled`),
  943. KEY `warned` (`warned`),
  944. KEY `pkey` (`passkey`)
  945. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  946.  
  947. DROP TABLE IF EXISTS `warnings`;
  948. CREATE TABLE `warnings` (
  949. `id` int(10) NOT NULL auto_increment,
  950. `userid` int(10) NOT NULL default '0',
  951. `reason` varchar(255) NOT NULL default '',
  952. `added` datetime NOT NULL default '0000-00-00 00:00:00',
  953. `expiry` datetime NOT NULL default '0000-00-00 00:00:00',
  954. `warnedby` int(10) NOT NULL default '0',
  955. `type` varchar(10) NOT NULL default '',
  956. `active` ENUM('yes', 'no') DEFAULT 'yes',
  957. PRIMARY KEY (`id`)
  958. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  959.  
  960. DROP TABLE IF EXISTS `censor`;
  961. CREATE TABLE `censor` (
  962. `word` varchar(25) NOT NULL default '',
  963. `censor` varchar(25) NOT NULL default ''
  964. ) ENGINE=MyISAM;
  965.  
  966. INSERT INTO `censor` VALUES ('fuck', 'f**k');
  967.  
  968. DROP TABLE IF EXISTS `forum_forums`;
  969. CREATE TABLE `forum_forums` (
  970. `sort` tinyint(3) unsigned NOT NULL default '0',
  971. `id` int(10) unsigned NOT NULL auto_increment,
  972. `name` varchar(60) NOT NULL default '',
  973. `description` varchar(200) default NULL,
  974. `minclassread` tinyint(3) unsigned NOT NULL default '1',
  975. `minclasswrite` tinyint(3) unsigned NOT NULL default '1',
  976. `guest_read` enum('yes', 'no') default 'yes',
  977. `category` tinyint(2) NOT NULL default '0',
  978. PRIMARY KEY (`id`)
  979. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  980.  
  981. DROP TABLE IF EXISTS `forum_posts`;
  982. CREATE TABLE `forum_posts` (
  983. `id` int(10) unsigned NOT NULL auto_increment,
  984. `topicid` int(10) unsigned NOT NULL default '0',
  985. `userid` int(10) unsigned NOT NULL default '0',
  986. `added` datetime default NULL,
  987. `body` longtext,
  988. `editedby` int(10) unsigned NOT NULL default '0',
  989. `editedat` datetime NOT NULL default '0000-00-00 00:00:00',
  990. PRIMARY KEY (`id`),
  991. KEY `topicid` (`topicid`),
  992. KEY `userid` (`userid`),
  993. FULLTEXT KEY `body` (`body`)
  994. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  995.  
  996. DROP TABLE IF EXISTS `tsue_forums_posts`;
  997. /*!40101 SET @saved_cs_client = @@character_set_client */;
  998. /*!40101 SET character_set_client = utf8 */;
  999. CREATE TABLE `tsue_forums_posts` (
  1000. `postid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1001. `threadid` int(10) unsigned NOT NULL DEFAULT '0',
  1002. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1003. `post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1004. `message` longtext COLLATE utf8_unicode_ci,
  1005. `edited_membername` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1006. `edited_memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1007. `edited_date` int(10) unsigned NOT NULL DEFAULT '0',
  1008. `edit_reason` blob,
  1009. PRIMARY KEY (`postid`),
  1010. KEY `threadid` (`threadid`),
  1011. KEY `post_date` (`post_date`),
  1012. FULLTEXT KEY `message` (`message`)
  1013. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1014. /*!40101 SET character_set_client = @saved_cs_client */;
  1015.  
  1016. DROP TABLE IF EXISTS `forum_readposts`;
  1017. CREATE TABLE `forum_readposts` (
  1018. `id` int(10) unsigned NOT NULL auto_increment,
  1019. `userid` int(10) unsigned NOT NULL default '0',
  1020. `topicid` int(10) unsigned NOT NULL default '0',
  1021. `lastpostread` int(10) unsigned NOT NULL default '0',
  1022. PRIMARY KEY (`id`),
  1023. KEY `userid` (`id`),
  1024. KEY `topicid` (`topicid`)
  1025. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  1026.  
  1027. DROP TABLE IF EXISTS `forum_topics`;
  1028. CREATE TABLE `forum_topics` (
  1029. `id` int(10) unsigned NOT NULL auto_increment,
  1030. `userid` int(10) unsigned NOT NULL default '0',
  1031. `subject` varchar(40) default NULL,
  1032. `locked` enum('yes','no') NOT NULL default 'no',
  1033. `forumid` int(10) unsigned NOT NULL default '0',
  1034. `lastpost` int(10) unsigned NOT NULL default '0',
  1035. `moved` enum('yes','no') NOT NULL default 'no',
  1036. `sticky` enum('yes','no') NOT NULL default 'no',
  1037. `views` int(10) NOT NULL default '0',
  1038. PRIMARY KEY (`id`),
  1039. KEY `userid` (`userid`),
  1040. KEY `subject` (`subject`),
  1041. KEY `lastpost` (`lastpost`)
  1042. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  1043.  
  1044. CREATE TABLE `tsue_forums_threads` (
  1045. `threadid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1046. `forumid` int(10) unsigned NOT NULL DEFAULT '0',
  1047. `title` tinytext COLLATE utf8_unicode_ci,
  1048. `reply_count` int(10) unsigned NOT NULL DEFAULT '0',
  1049. `view_count` int(10) unsigned NOT NULL DEFAULT '0',
  1050. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1051. `post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1052. `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1053. `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1054. `last_post_info` tinyblob,
  1055. `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'prefix_id',
  1056. `last_post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1057. PRIMARY KEY (`threadid`),
  1058. KEY `forumid` (`forumid`),
  1059. KEY `pid` (`pid`),
  1060. KEY `last_post_date` (`last_post_date`),
  1061. FULLTEXT KEY `title` (`title`)
  1062. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1063. /*!40101 SET character_set_client = @saved_cs_client */;
  1064.  
  1065. DROP TABLE IF EXISTS `forumcats`;
  1066. CREATE TABLE `forumcats` (
  1067. `id` int(10) unsigned NOT NULL auto_increment,
  1068. `name` varchar(60) NOT NULL default '',
  1069. `sort` int(10) unsigned NOT NULL default '0',
  1070. PRIMARY KEY (`id`)
  1071. ) ENGINE=MyISAM AUTO_INCREMENT=1 ;
  1072.  
  1073. CREATE TABLE `forums` (
  1074. `id` int(10) unsigned NOT NULL auto_increment,
  1075. `name` varchar(60) NOT NULL default '',
  1076. `description` varchar(200) default NULL,
  1077. `sort` tinyint(3) unsigned NOT NULL default '0',
  1078. `forid` tinyint(4) default '0',
  1079. `postcount` int(10) unsigned NOT NULL default '0',
  1080. `topiccount` int(10) unsigned NOT NULL default '0',
  1081. `minclassread` tinyint(3) unsigned NOT NULL default '0',
  1082. `minclasswrite` tinyint(3) unsigned NOT NULL default '0',
  1083. `minclasscreate` tinyint(3) unsigned NOT NULL default '0',
  1084. `place` int(10) NOT NULL default '-1',
  1085. PRIMARY KEY (`id`)
  1086. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1087.  
  1088. --
  1089. -- Table structure for table `tsue_forums`
  1090. --
  1091.  
  1092. DROP TABLE IF EXISTS `tsue_forums`;
  1093. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1094. /*!40101 SET character_set_client = utf8 */;
  1095. CREATE TABLE `tsue_forums` (
  1096. `forumid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1097. `parentid` smallint(5) NOT NULL DEFAULT '-1',
  1098. `title` tinyblob,
  1099. `description` blob,
  1100. `icon` tinyblob,
  1101. `displayorder` smallint(5) unsigned NOT NULL DEFAULT '0',
  1102. `replycount` int(10) unsigned NOT NULL DEFAULT '0',
  1103. `threadcount` int(10) unsigned NOT NULL DEFAULT '0',
  1104. `password` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1105. `external_link` tinyblob,
  1106. `last_post_info` tinyblob,
  1107. `last_post_threadid` int(10) unsigned NOT NULL DEFAULT '0',
  1108. PRIMARY KEY (`forumid`),
  1109. KEY `displayorder` (`displayorder`)
  1110. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1111. /*!40101 SET character_set_client = @saved_cs_client */;
  1112.  
  1113. --
  1114. -- Dumping data for table `tsue_forums`
  1115. --
  1116.  
  1117. LOCK TABLES `tsue_forums` WRITE;
  1118. /*!40000 ALTER TABLE `tsue_forums` DISABLE KEYS */;
  1119. /*!40000 ALTER TABLE `tsue_forums` ENABLE KEYS */;
  1120. UNLOCK TABLES;
  1121.  
  1122. --
  1123. -- Table structure for table `tsue_forums_permissions`
  1124. --
  1125.  
  1126. DROP TABLE IF EXISTS `tsue_forums_permissions`;
  1127. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1128. /*!40101 SET character_set_client = utf8 */;
  1129. CREATE TABLE `tsue_forums_permissions` (
  1130. `forumid` int(10) unsigned NOT NULL DEFAULT '0',
  1131. `membergroupid` int(10) unsigned NOT NULL DEFAULT '0',
  1132. `permissions` longblob,
  1133. UNIQUE KEY `forumid` (`forumid`,`membergroupid`)
  1134. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1135. /*!40101 SET character_set_client = @saved_cs_client */;
  1136.  
  1137. --
  1138. -- Dumping data for table `tsue_forums_permissions`
  1139. --
  1140.  
  1141. LOCK TABLES `tsue_forums_permissions` WRITE;
  1142. /*!40000 ALTER TABLE `tsue_forums_permissions` DISABLE KEYS */;
  1143. /*!40000 ALTER TABLE `tsue_forums_permissions` ENABLE KEYS */;
  1144. UNLOCK TABLES;
  1145.  
  1146. --
  1147. -- Table structure for table `tsue_forums_posts`
  1148. --
  1149.  
  1150. DROP TABLE IF EXISTS `tsue_forums_posts`;
  1151. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1152. /*!40101 SET character_set_client = utf8 */;
  1153. CREATE TABLE `tsue_forums_posts` (
  1154. `postid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1155. `threadid` int(10) unsigned NOT NULL DEFAULT '0',
  1156. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1157. `post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1158. `message` longtext COLLATE utf8_unicode_ci,
  1159. `edited_membername` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1160. `edited_memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1161. `edited_date` int(10) unsigned NOT NULL DEFAULT '0',
  1162. `edit_reason` blob,
  1163. PRIMARY KEY (`postid`),
  1164. KEY `threadid` (`threadid`),
  1165. KEY `post_date` (`post_date`),
  1166. FULLTEXT KEY `message` (`message`)
  1167. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1168. /*!40101 SET character_set_client = @saved_cs_client */;
  1169.  
  1170. --
  1171. -- Dumping data for table `tsue_forums_posts`
  1172. --
  1173.  
  1174. LOCK TABLES `tsue_forums_posts` WRITE;
  1175. /*!40000 ALTER TABLE `tsue_forums_posts` DISABLE KEYS */;
  1176. /*!40000 ALTER TABLE `tsue_forums_posts` ENABLE KEYS */;
  1177. UNLOCK TABLES;
  1178.  
  1179. --
  1180. -- Table structure for table `tsue_forums_thread_prefixes`
  1181. --
  1182.  
  1183. DROP TABLE IF EXISTS `tsue_forums_thread_prefixes`;
  1184. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1185. /*!40101 SET character_set_client = utf8 */;
  1186. CREATE TABLE `tsue_forums_thread_prefixes` (
  1187. `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1188. `pname` text COLLATE utf8_unicode_ci,
  1189. `cssname` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1190. `viewpermissions` mediumblob,
  1191. PRIMARY KEY (`pid`)
  1192. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1193. /*!40101 SET character_set_client = @saved_cs_client */;
  1194.  
  1195. --
  1196. -- Dumping data for table `tsue_forums_thread_prefixes`
  1197. --
  1198.  
  1199. LOCK TABLES `tsue_forums_thread_prefixes` WRITE;
  1200. /*!40000 ALTER TABLE `tsue_forums_thread_prefixes` DISABLE KEYS */;
  1201. /*!40000 ALTER TABLE `tsue_forums_thread_prefixes` ENABLE KEYS */;
  1202. UNLOCK TABLES;
  1203.  
  1204. --
  1205. -- Table structure for table `tsue_forums_thread_subscribe`
  1206. --
  1207.  
  1208. DROP TABLE IF EXISTS `tsue_forums_thread_subscribe`;
  1209. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1210. /*!40101 SET character_set_client = utf8 */;
  1211. CREATE TABLE `tsue_forums_thread_subscribe` (
  1212. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1213. `threadid` int(10) unsigned NOT NULL DEFAULT '0',
  1214. `email_notification` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1215. UNIQUE KEY `memberid` (`memberid`,`threadid`),
  1216. KEY `email_notification` (`email_notification`)
  1217. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1218. /*!40101 SET character_set_client = @saved_cs_client */;
  1219.  
  1220. --
  1221. -- Dumping data for table `tsue_forums_thread_subscribe`
  1222. --
  1223.  
  1224. LOCK TABLES `tsue_forums_thread_subscribe` WRITE;
  1225. /*!40000 ALTER TABLE `tsue_forums_thread_subscribe` DISABLE KEYS */;
  1226. /*!40000 ALTER TABLE `tsue_forums_thread_subscribe` ENABLE KEYS */;
  1227. UNLOCK TABLES;
  1228.  
  1229. --
  1230. -- Table structure for table `tsue_forums_threads`
  1231. --
  1232.  
  1233. DROP TABLE IF EXISTS `tsue_forums_threads`;
  1234. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1235. /*!40101 SET character_set_client = utf8 */;
  1236. CREATE TABLE `tsue_forums_threads` (
  1237. `threadid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1238. `forumid` int(10) unsigned NOT NULL DEFAULT '0',
  1239. `title` tinytext COLLATE utf8_unicode_ci,
  1240. `reply_count` int(10) unsigned NOT NULL DEFAULT '0',
  1241. `view_count` int(10) unsigned NOT NULL DEFAULT '0',
  1242. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1243. `post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1244. `sticky` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1245. `locked` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1246. `last_post_info` tinyblob,
  1247. `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'prefix_id',
  1248. `last_post_date` int(10) unsigned NOT NULL DEFAULT '0',
  1249. PRIMARY KEY (`threadid`),
  1250. KEY `forumid` (`forumid`),
  1251. KEY `pid` (`pid`),
  1252. KEY `last_post_date` (`last_post_date`),
  1253. FULLTEXT KEY `title` (`title`)
  1254. ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1255. /*!40101 SET character_set_client = @saved_cs_client */;
  1256.  
  1257. --
  1258. -- Dumping data for table `tsue_forums_threads`
  1259. --
  1260.  
  1261. LOCK TABLES `tsue_forums_threads` WRITE;
  1262. /*!40000 ALTER TABLE `tsue_forums_threads` DISABLE KEYS */;
  1263. /*!40000 ALTER TABLE `tsue_forums_threads` ENABLE KEYS */;
  1264. UNLOCK TABLES;
  1265.  
  1266. CREATE TABLE `forum_config` (
  1267. `id` smallint(1) NOT NULL default '1',
  1268. `delete_for_real` smallint(6) NOT NULL default '0',
  1269. `min_delete_view_class` smallint(2) unsigned NOT NULL default '7',
  1270. `readpost_expiry` smallint(3) NOT NULL default '14',
  1271. `min_upload_class` smallint(2) unsigned NOT NULL default '2',
  1272. `accepted_file_extension` varchar(80) NOT NULL,
  1273. `accepted_file_types` varchar(280) NOT NULL,
  1274. `max_file_size` int(10) unsigned NOT NULL default '2097152',
  1275. `upload_folder` varchar(80) NOT NULL default 'uploads/',
  1276. PRIMARY KEY (`readpost_expiry`),
  1277. KEY `delete_for_real` (`delete_for_real`)
  1278. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1279.  
  1280. --
  1281. -- Dumping data for table `forum_config`
  1282. --
  1283.  
  1284. INSERT INTO `forum_config` VALUES (13, 0, 4, 7, 0, 'a:5:{i:0;s:3:"zip";i:1;s:3:"rar";i:2;s:3:"gif";i:3;s:3:"png";i:4;s:0:"";}', 'a:3:{i:0;s:15:"application/zip";i:1;s:15:"application/rar";i:2;s:0:"";}', 2097152, 'uploads/');
  1285.  
  1286. -- --------------------------------------------------------
  1287.  
  1288. --
  1289. -- Table structure for table `forum_poll`
  1290. --
  1291.  
  1292. CREATE TABLE `forum_poll` (
  1293. `id` int(10) unsigned NOT NULL auto_increment,
  1294. `user_id` int(10) unsigned NOT NULL default '0',
  1295. `question` varchar(280) NOT NULL,
  1296. `poll_answers` text,
  1297. `number_of_options` smallint(2) unsigned NOT NULL default '0',
  1298. `poll_starts` int(11) NOT NULL default '0',
  1299. `poll_ends` int(11) NOT NULL default '0',
  1300. `change_vote` enum('yes','no') NOT NULL default 'no',
  1301. `multi_options` smallint(2) unsigned NOT NULL default '1',
  1302. `poll_closed` enum('yes','no') default 'no',
  1303. PRIMARY KEY (`id`),
  1304. KEY `user_id` (`user_id`)
  1305. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1306.  
  1307. --
  1308. -- Dumping data for table `forum_poll`
  1309. --
  1310.  
  1311.  
  1312. -- --------------------------------------------------------
  1313.  
  1314. --
  1315. -- Table structure for table `forum_poll_votes`
  1316. --
  1317.  
  1318. CREATE TABLE `forum_poll_votes` (
  1319. `id` int(10) unsigned NOT NULL auto_increment,
  1320. `poll_id` int(10) unsigned NOT NULL default '0',
  1321. `user_id` int(10) unsigned NOT NULL default '0',
  1322. `option` tinyint(3) unsigned NOT NULL default '0',
  1323. `ip` varchar(15) NOT NULL default '',
  1324. `added` int(11) NOT NULL default '0',
  1325. PRIMARY KEY (`id`),
  1326. KEY `poll_id` (`poll_id`)
  1327. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1328.  
  1329. --
  1330. -- Dumping data for table `forum_poll_votes`
  1331. --
  1332.  
  1333. DROP TABLE IF EXISTS `forums`;
  1334. CREATE TABLE `forums` (
  1335. `sort` tinyint(3) unsigned NOT NULL default '0',
  1336. `id` int(10) unsigned NOT NULL auto_increment,
  1337. `name` varchar(60) NOT NULL default '',
  1338. `description` varchar(200) default NULL,
  1339. `minclassread` tinyint(3) unsigned NOT NULL default '0',
  1340. `minclasswrite` tinyint(3) unsigned NOT NULL default '0',
  1341. `postcount` int(10) unsigned NOT NULL default '0',
  1342. `topiccount` int(10) unsigned NOT NULL default '0',
  1343. `minclasscreate` tinyint(3) unsigned NOT NULL default '0',
  1344. `forid` tinyint(4) default '0',
  1345. PRIMARY KEY (`id`)
  1346. ) TYPE=MyISAM AUTO_INCREMENT=1;
  1347.  
  1348. --
  1349. -- Dumping data for table `forums`
  1350. --
  1351.  
  1352. INSERT INTO `forums` (`sort`, `id`, `name`, `description`, `minclassread`, `minclasswrite`, `postcount`, `topiccount`, `minclasscreate`, `forid`) VALUES (2, 1, 'General chat & discussion', 'Talk about anything here...', 0, 0, 0, 0, 0, 1),
  1353. (1, 2, 'Announcements & News ', 'News and upcoming events', 0, 0, 0, 0, 0, 2),
  1354. (3, 3, 'General Support & Help', 'Got any questions? Need help? Ask here!', 0, 0, 0, 0, 0, 1),
  1355. (4, 4, 'Request to be Uploader', 'Uploader Requests', 4, 4, 0, 0, 4, 3);
  1356.  
  1357. -- --------------------------------------------------------
  1358.  
  1359. DROP TABLE IF EXISTS `overforums`;
  1360. CREATE TABLE `overforums` (
  1361. `id` int(10) unsigned NOT NULL auto_increment,
  1362. `name` varchar(60) NOT NULL default '',
  1363. `description` varchar(200) default NULL,
  1364. `minclassview` tinyint(3) unsigned NOT NULL default '0',
  1365. `forid` tinyint(3) unsigned NOT NULL default '1',
  1366. `sort` tinyint(3) unsigned NOT NULL default '0',
  1367. PRIMARY KEY (`id`)
  1368. ) TYPE=MyISAM AUTO_INCREMENT=1;
  1369.  
  1370. --
  1371. -- Dumping data for table `overforums`
  1372. --
  1373.  
  1374. INSERT INTO `overforums` (`id`, `name`, `description`, `minclassview`, `forid`, `sort`) VALUES (1, 'General', '', 0, 1, 1),
  1375. (2, 'Guidelines', '', 0, 1, 0),
  1376. (3, 'Staff Forums', '', 4, 0, 3);
  1377.  
  1378. --
  1379. -- Table structure for table `over_forums`
  1380. --
  1381.  
  1382. CREATE TABLE IF NOT EXISTS `over_forums` (
  1383. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1384. `name` varchar(60) NOT NULL DEFAULT '',
  1385. `description` varchar(200) DEFAULT NULL,
  1386. `min_class_view` tinyint(3) unsigned NOT NULL DEFAULT '0',
  1387. `sort` tinyint(3) unsigned NOT NULL DEFAULT '0',
  1388. PRIMARY KEY (`id`)
  1389. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  1390.  
  1391. --
  1392. -- Dumping data for table `over_forums`
  1393. --
  1394.  
  1395. -- --------------------------------------------------------
  1396.  
  1397. --
  1398. -- Table structure for table `paypal_config`
  1399. --
  1400.  
  1401. CREATE TABLE IF NOT EXISTS `paypal_config` (
  1402. `name` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  1403. `value` varchar(255) CHARACTER SET latin1 NOT NULL DEFAULT '',
  1404. UNIQUE KEY `name` (`name`)
  1405. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1406.  
  1407. --
  1408. -- Dumping data for table `paypal_config`
  1409. --
  1410.  
  1411. --
  1412. -- Table structure for table `friends`
  1413. --
  1414.  
  1415. CREATE TABLE IF NOT EXISTS `friends` (
  1416. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1417. `userid` int(10) unsigned NOT NULL DEFAULT '0',
  1418. `friendid` int(10) unsigned NOT NULL DEFAULT '0',
  1419. `confirmed` enum('yes','no') COLLATE utf8_bin NOT NULL DEFAULT 'no',
  1420. PRIMARY KEY (`id`),
  1421. UNIQUE KEY `userfriend` (`userid`,`friendid`)
  1422. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
  1423.  
  1424. --
  1425. -- Dumping data for table `friends`
  1426. --
  1427. -- --------------------------------------------------------
  1428.  
  1429. --
  1430. -- Table structure for table `funds`
  1431. --
  1432.  
  1433. CREATE TABLE IF NOT EXISTS `funds` (
  1434. `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1435. `cash` decimal(8,2) NOT NULL DEFAULT '0.00',
  1436. `user` int(10) unsigned NOT NULL DEFAULT '0',
  1437. `added` int(11) NOT NULL,
  1438. PRIMARY KEY (`id`)
  1439. ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1440.  
  1441. -- --------------------------------------------------------
  1442.  
  1443. DROP TABLE IF EXISTS `sqlerr`;
  1444. CREATE TABLE `sqlerr` (
  1445. `id` int(10) unsigned NOT NULL auto_increment,
  1446. `txt` text NOT NULL DEFAULT '',
  1447. `time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  1448. PRIMARY KEY (`id`)
  1449. ) ENGINE = MyISAM AUTO_INCREMENT = 1;
  1450.  
  1451. -- --------------------------------------------------------
  1452.  
  1453. DROP TABLE IF EXISTS `tsue_poll`;
  1454. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1455. /*!40101 SET character_set_client = utf8 */;
  1456. CREATE TABLE `tsue_poll` (
  1457. `pid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1458. `date` int(10) unsigned NOT NULL DEFAULT '0',
  1459. `active` tinyint(1) unsigned NOT NULL DEFAULT '1',
  1460. `question` blob,
  1461. `options` blob,
  1462. `votes` longblob,
  1463. `voters` longblob,
  1464. `multiple` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1465. `closeDaysAfter` smallint(5) unsigned NOT NULL DEFAULT '0',
  1466. `closed` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1467. `threadid` int(10) unsigned NOT NULL DEFAULT '0',
  1468. `createdinThread` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1469. PRIMARY KEY (`pid`),
  1470. KEY `active` (`active`),
  1471. KEY `threadid` (`threadid`),
  1472. KEY `date` (`date`),
  1473. KEY `createdinThread` (`createdinThread`)
  1474. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1475. /*!40101 SET character_set_client = @saved_cs_client */;
  1476.  
  1477. --
  1478. -- Table structure for table `tsue_reports`
  1479. --
  1480.  
  1481. DROP TABLE IF EXISTS `tsue_reports`;
  1482. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1483. /*!40101 SET character_set_client = utf8 */;
  1484. CREATE TABLE `tsue_reports` (
  1485. `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1486. `content_type` varchar(25) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1487. `content_id` int(10) unsigned NOT NULL DEFAULT '0',
  1488. `reported_by_memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1489. `first_report_date` int(10) unsigned NOT NULL DEFAULT '0',
  1490. `report_state` enum('open','resolved','rejected') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open',
  1491. `assigned_memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1492. `comment_count` int(10) unsigned NOT NULL DEFAULT '0',
  1493. `last_modified_date` int(10) unsigned NOT NULL DEFAULT '0',
  1494. `last_modified_memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1495. PRIMARY KEY (`report_id`),
  1496. UNIQUE KEY `content_type_content_id` (`content_type`,`content_id`),
  1497. KEY `report_state` (`report_state`),
  1498. KEY `assigned_memberid_state` (`assigned_memberid`,`report_state`),
  1499. KEY `last_modified_date` (`last_modified_date`)
  1500. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1501. /*!40101 SET character_set_client = @saved_cs_client */;
  1502.  
  1503. --
  1504. -- Dumping data for table `tsue_reports`
  1505. --
  1506.  
  1507. --
  1508. -- Table structure for table `tsue_shoutbox`
  1509. --
  1510.  
  1511. DROP TABLE IF EXISTS `tsue_shoutbox`;
  1512. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1513. /*!40101 SET character_set_client = utf8 */;
  1514. CREATE TABLE `tsue_shoutbox` (
  1515. `sid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1516. `memberid` int(10) unsigned NOT NULL DEFAULT '0',
  1517. `system` tinyint(1) unsigned NOT NULL DEFAULT '0',
  1518. `sdate` int(10) unsigned NOT NULL DEFAULT '0',
  1519. `smessage` mediumblob,
  1520. `cid` int(10) unsigned NOT NULL DEFAULT '0',
  1521. PRIMARY KEY (`sid`),
  1522. KEY `sdate` (`sdate`),
  1523. KEY `memberid` (`memberid`),
  1524. KEY `cid` (`cid`)
  1525. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1526. /*!40101 SET character_set_client = @saved_cs_client */;
  1527.  
  1528.  
  1529. --
  1530. -- Table structure for table `tsue_shoutbox_channels`
  1531. --
  1532.  
  1533. DROP TABLE IF EXISTS `tsue_shoutbox_channels`;
  1534. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1535. /*!40101 SET character_set_client = utf8 */;
  1536. CREATE TABLE `tsue_shoutbox_channels` (
  1537. `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  1538. `pid` int(10) unsigned NOT NULL DEFAULT '0',
  1539. `sort` int(10) unsigned NOT NULL DEFAULT '0',
  1540. `cname` tinyblob,
  1541. `cviewpermissions` blob,
  1542. `cshoutpermissions` blob,
  1543. PRIMARY KEY (`cid`)
  1544. ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1545. /*!40101 SET character_set_client = @saved_cs_client */;
  1546.  
  1547. --
  1548. -- Table structure for table `tsue_styles`
  1549. --
  1550.  
  1551. DROP TABLE IF EXISTS `tsue_styles`;
  1552. /*!40101 SET @saved_cs_client = @@character_set_client */;
  1553. /*!40101 SET character_set_client = utf8 */;
  1554. CREATE TABLE `tsue_styles` (
  1555. `styleid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  1556. `stylename` varchar(100) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  1557. `themeid` smallint(5) unsigned NOT NULL DEFAULT '0',
  1558. `css` longtext COLLATE utf8_unicode_ci,
  1559. `last_updated` int(10) unsigned NOT NULL DEFAULT '0',
  1560. `orj_css` longblob,
  1561. PRIMARY KEY (`styleid`),
  1562. KEY `stylename_themeid` (`stylename`,`themeid`)
  1563. ) ENGINE=InnoDB AUTO_INCREMENT=515 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1564. /*!40101 SET character_set_client = @saved_cs_client */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement