Upgrade TS v1.3.7 to v1.3.8

Template Shares Forums / Guidelines / Announcements & News / Upgrade TS v1.3.7 to v1.3.8

Thread Options

Thread Options

Subscribe to this Thread

Email This Thread

Print This Thread

Search this Thread

Search this Thread

Go Advanced

Post: #1

01-12-2006 02:52 AM (This post was last modified: 12-12-2006 20:27 PM by xam)

xam
Team Leader

Joined: 01-02-2006
Posts: 11,515
Country:

Awards:

Upgrade TS v1.3.7 to v1.3.8

Before you attempt to upgrade, ensure you have a database backup and a copy of the files currently in use on your tracker. This is so you can revert back to your earlier version if you need to or something goes horribly wrong with the upgrade process.

Upgrading from 1.3.7
[list=1]
[*]Download TS v1.3.8
[*]Upload all the new files (see change log)
[*]Run sql using phpMyAdmin. (see below)
[/list]

CODE:

CREATE TABLE `addedrequests` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `requestid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`id`),
  KEY `pollid` (`id`),
  KEY `userid` (`userid`),
  KEY `requestid_userid` (`requestid`,`userid`)
) TYPE=MyISAM;

CREATE TABLE `requests` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `request` varchar(225) default NULL,
  `descr` text NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `hits` int(10) unsigned NOT NULL default '0',
  `cat` int(10) unsigned NOT NULL default '0',
  `filledby` int(10) unsigned NOT NULL default '0',
  `filledurl` varchar(70) default NULL,
  `filled` enum('yes','no') NOT NULL default 'no',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`),
  KEY `id_added` (`id`,`added`)
) TYPE=MyISAM;

CREATE TABLE `offers` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `userid` int(10) unsigned NOT NULL default '0',
  `name` varchar(225) default NULL,
  `descr` text NOT NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `yeah` int(10) unsigned NOT NULL default '0',
  `against` int(10) unsigned NOT NULL default '0',
  `category` int(11) NOT NULL default '0',
  `comments` int(11) NOT NULL default '0',
  `allowed` enum('allowed','pending','denied') NOT NULL default 'pending',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM;
    
CREATE TABLE `offervotes` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `offerid` int(10) unsigned NOT NULL default '0',
  `userid` int(10) unsigned NOT NULL default '0',
  `vote` enum('yeah','against') NOT NULL default 'yeah',
  PRIMARY KEY  (`id`),
  KEY `userid` (`userid`)
) TYPE=MyISAM;

ALTER TABLE `comments` ADD `request` int(11) NOT NULL default '0';
ALTER TABLE `comments` ADD `offer` int(11) NOT NULL default '0';
ALTER TABLE `reports` CHANGE `type` `type` ENUM( 'torrent', 'user', 'forum', 'comment', 'request', 'reqcomment', 'offer', 'offercomment' ) NOT NULL DEFAULT 'torrent';

We recommend that all users upgrade to v1.3.8 so their tracker is running a more stable version of the TS v1.3 series.

Quick Reply

« Previous Thread | Next Thread »