0.14 Mysql Fix

ALTER TABLE `users` CHANGE `inverted_added` `inverted_added` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'


0.16 Thanksby fix, saves a query to see if user already voted ;)

ALTER TABLE `thanks` ADD UNIQUE (
`torrentid` ,
`userid`
);

0.20 Poll Mysql change

ALTER TABLE `pollanswers` ADD UNIQUE (
`pollid` ,
`userid`
);

0.20 Messages mysql change

ALTER TABLE `messages` ADD `inverted_added` INT( 10 ) UNSIGNED NOT NULL ;
ALTER TABLE `messages` ADD INDEX `inbox_inbox` ( `receiver` , `location` ) 

UPDATE messages SET inverted_added =4294967295 - UNIX_TIMESTAMP( added ) 

0.20 Forum mysql change

ALTER TABLE `topics` ADD `lastpost_txt` VARCHAR( 255 ) NOT NULL ;

0.20 User class changes
ALTER TABLE `users` CHANGE `class` `class` TINYINT( 3 ) NOT NULL DEFAULT '10'
UPDATE users SET class=class*10;

0.20 Timezones

ALTER TABLE `users`
  DROP `timezone`,
  DROP `tzoffset`;
  
0.20 Anonymous upload

ALTER TABLE `users` ADD `anonymous` ENUM( 'yes', 'no' ) DEFAULT 'no' NOT NULL AFTER `savepms` ;

0.22 Forum optimizing

ALTER TABLE `forums` ADD `lastpost_txt` TEXT NOT NULL ;
ALTER TABLE `topics` ADD `lastpost_txt` TEXT NOT NULL ;
ALTER TABLE `topics` ADD `replies` INT( 10 ) UNSIGNED NOT NULL;


0.25
ALTER TABLE `users` ADD `language` VARCHAR( 6 ) DEFAULT 'en' NOT NULL ;

CREATE TABLE `snatched` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `torrentid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `torrent_name` varchar(255) collate latin1_general_ci NOT NULL default '',
  `torrent_category` int(10) unsigned NOT NULL default '0',
  `port` smallint(5) unsigned NOT NULL default '0',
  `uploaded` bigint(20) unsigned NOT NULL default '0',
  `downloaded` bigint(20) unsigned NOT NULL default '0',
  `to_go` bigint(20) unsigned NOT NULL default '0',
  `seeder` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  `last_action` datetime NOT NULL default '0000-00-00 00:00:00',
  `startdat` datetime NOT NULL default '0000-00-00 00:00:00',
  `completedat` datetime NOT NULL default '0000-00-00 00:00:00',
  `connectable` enum('yes','no') collate latin1_general_ci NOT NULL default 'yes',
  `agent` varchar(60) collate latin1_general_ci NOT NULL default '',
  `finished` enum('yes','no') collate latin1_general_ci NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `torrentid_3` (`torrentid`,`userid`),
  KEY `finished` (`finished`,`torrentid`),
  KEY `torrentid` (`userid`),
  KEY `torrentid_2` (`torrentid`),
  KEY `userid` (`userid`,`torrentid`)
) ENGINE=MyISAM

CREATE TABLE `completed_by` (
  `torrentid` int(10) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`torrentid`,`uid`)
) ENGINE=MyISAM;