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

CREATE TABLE `torrent_rules` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default '',
  `text` text NOT NULL,
  `public` enum('yes','no') NOT NULL default 'yes',
  `level` enum('user','premium','moderator','admin') NOT NULL default 'user',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;
CREATE TABLE `torrent_paypal` (
  `siteurl` varchar(255) NOT NULL default '',
  `paypal_email` varchar(60) NOT NULL default '',
  `sitecost` varchar(60) NOT NULL default '',
  `reseaved_donations` varchar(60) NOT NULL default '',
  `donatepage` longtext NOT NULL,
  `donation_block` enum('true','false') NOT NULL default 'true',
  `nodonate` enum('EU','UK','US') NOT NULL default 'US'
) ENGINE=MyISAM;
ALTER TABLE `torrent_privacy_global` ADD `torrent` INT( 11 ) NOT NULL ;
ALTER TABLE `torrent_configs` ADD `upload_dead` ENUM( 'true', 'false' ) NOT NULL DEFAULT 'true' ;
INSERT INTO `torrent_paypal` VALUES('http://www.yoursite.net','you@youraddy.com','0','0','0','','');
INSERT INTO `torrent_rules` VALUES (14, 'how do you get files', 'You must be a member Of this site to do any thing......', 'yes', 'user');
INSERT INTO `torrent_rules` VALUES (9, 'Avatar Guidelines - <font color=#CC0000>Please try to follow these guidelines</font>', '<ul>     The allowed formats are .gif, .jpg and .png.      Be considerate. Resize your images to a width of 150 px and a size of no more than 150 KB. (Browsers will rescale them anyway: smaller images will be expanded and will not look good; larger images will just waste bandwidth and CPU cycles.) For now this is just a guideline but it will be automatically enforced in the near future.      Do not use potentially offensive material involving porn, religious material, animal / human cruelty or ideologically charged images. Mods have wide discretion on what is acceptable. If in doubt PM one. 		 </ul>', 'no', 'user');
INSERT INTO `torrent_rules` VALUES (10, 'Moderating Rules - <font color=#CC0000>Use your better judgement!</font>', '<ul>     The most important rule: Use your better judgment!     Don''t be afraid to say <strong>NO</strong>! (a.k.a. &quot;Helshad''s rule&quot;.)      Don''t defy another mod in public, instead send a PM or through IM.     Be tolerant! Give the user(s) a chance to reform.     Don''t act prematurely, let the users make their mistakes and THEN correct them.     Try correcting any &quot;off topics&quot; rather then closing a thread.     Move topics rather than locking them.     Be tolerant when moderating the Chit-chat section (give them some slack).     If you lock a topic, give a brief explanation as to why you''re locking it.     Before you disable a user account, send him/her a PM and if they reply, put them on a 2 week trial.     Don''t disable a user account until he or she has been a member for at least 4 weeks.     <strong>Always</strong> state a reason (in the user comment box) as to hy
the user is being banned / warned. </ul>', 'no', 'premium');
