ALTER TABLE `taskitem` ADD `RMAItemId` INT(10) NULL DEFAULT NULL AFTER `hireItemInstanceId`,
ADD `partInstanceForHireStatusId` INT(10) NULL DEFAULT NULL AFTER `RMAItemId`;

ALTER TABLE `taskitem` CHANGE `hireItemInstanceId` `hireItemInstanceId` INT(10) NULL DEFAULT NULL;

ALTER TABLE `taskitem` ADD INDEX( `RMAItemId`);
ALTER TABLE `taskitem` ADD INDEX( `partInstanceForHireStatusId`);

ALTER TABLE `task` CHANGE `type` `type` VARCHAR(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '';