Upgrade phpbtrk1.5e => phpbtrk+2.2 Corrected

[Nobody/Anonymous]

Upgrade phpbtrk1.5e => phpbtrk+2.2 correct version

$query_list[1]['query'] = "CREATE TABLE `ipbans` (`ban_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR (16) NOT NULL, `iplong` INT(10)  DEFAULT '0' NOT NULL, `bandate` DATE DEFAULT '0000-00-00' NOT NULL, `reason` VARCHAR (50) NOT NULL, `autoban` ENUM ('Y','N') DEFAULT 'N' NOT NULL, `banlength` TINYINT (3) UNSIGNED DEFAULT '0' NOT NULL, `banexpiry` DATE DEFAULT '0000-00-00' NOT NULL, `banautoexpires` ENUM ('Y','N') DEFAULT 'N' NOT NULL, PRIMARY KEY(`ban_id`), INDEX(`bandate`,`autoban`,`banexpiry`,`banautoexpires`, `iplong`))";
               
and

$query_list[6]['query'] = "ALTER TABLE `namemap` ADD `mirrorurl` VARCHAR (250) NOT NULL, ADD `size` FLOAT DEFAULT '0' NOT NULL, ADD `crc32` VARCHAR (254) NOT NULL, ADD `DateAdded` DATE DEFAULT '0000-00-00' NOT NULL, ADD `category` VARCHAR (10) DEFAULT 'main' NOT NULL, ADD `sfvlink` VARCHAR (250), ADD `md5link` VARCHAR (250), ADD `infolink` VARCHAR (250), ADD `DateToRemoveURL` DATE DEFAULT '0000-00-00' NOT NULL, ADD `DateToHideTorrent` DATE DEFAULT '0000-00-00' NOT NULL, ADD `addedby` VARCHAR (32) DEFAULT 'root' NOT NULL, ADD `grouping` INT (5) UNSIGNED NOT NULL DEFAULT 0, ADD `sorting` INT (5) UNSIGNED NOT NULL DEFAULT 0, ADD `comment` VARCHAR (255) NOT NULL DEFAULT '', ADD `tsAdded` BIGINT (20) NOT NULL DEFAULT 0, ADD `torrent_size` BIGINT(10) NOT NULL DEFAULT 0, ADD INDEX(`category`, `DateToHideTorrent`)";
               

[Dan]

I'll update the tarball later. Thanks for pointing this out.