Issues with 3.00.26 upgrade

[Hiren]

Any client experiencing any issues with v3.00.26 CVS build upgrade must run the following MySQL queries:

CREATE TABLE swticketlabels (ticketlabelid INT UNSIGNED NOT NULL AUTO_INCREMENT,title VARCHAR(255) NOT NULL DEFAULT '',dateline INT UNSIGNED NOT NULL DEFAULT '0',labeltype ENUM('public', 'private') NOT NULL DEFAULT 'public',staffid INT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (ticketlabelid),KEY ticketlabels1 (labeltype, staffid));

CREATE TABLE swticketlabellinks (ticketlabellinkid INT UNSIGNED NOT NULL AUTO_INCREMENT,ticketlabelid INT UNSIGNED NOT NULL DEFAULT '0',ticketid INT UNSIGNED NOT NULL DEFAULT '0',PRIMARY KEY (ticketlabellinkid),UNIQUE KEY ticketlabellinks1 (ticketlabelid, ticketid),KEY ticketlabellinks2 (ticketid));

ALTER TABLE `swticketposts` DROP INDEX `ticketposts3`; ALTER TABLE `swticketposts` ADD INDEX ticketposts3 (`creator`, `staffid`, `dateline`); ALTER TABLE `swtickets` ADD (islabeled SMALLINT(1) UNSIGNED NOT NULL DEFAULT '0', lastuserreplytime INT UNSIGNED NOT NULL DEFAULT '0'); ALTER TABLE `swtickets` DROP INDEX `tickets8`; ALTER TABLE `swtickets` ADD INDEX tickets8 (`departmentid`, `ticketstatusid`, `lastuserreplytime`);

Please ignore any errors which result from these queries.

Regards,

Hiren Mehta