zentao/db/update2.3.sql

ALTER TABLE `zt_bug` ADD `toStory` MEDIUMINT( 8 ) NOT NULL DEFAULT '0' AFTER `toTask`;
ALTER TABLE `zt_testResult` ADD `lastRunner` VARCHAR( 30 ) NOT NULL AFTER `stepResults`;
ALTER TABLE `zt_testRun` ADD `lastRunner` VARCHAR( 30 ) NOT NULL AFTER `assignedTo`;
ALTER TABLE `zt_case` ADD `lastRunner` VARCHAR( 30 ) NOT NULL AFTER `deleted`;

-- adjust the working hours.
ALTER TABLE `zt_project` ADD `days` SMALLINT UNSIGNED NOT NULL AFTER `end`;
ALTER TABLE `zt_team` CHANGE `joinDate` `join` DATE NOT NULL DEFAULT '0000-00-00';
ALTER TABLE `zt_team` CHANGE `workingHour` `hours` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `zt_team` ADD `days` SMALLINT UNSIGNED NOT NULL AFTER `join`;

ALTER TABLE `zt_case` CHANGE `lastRun` `lastRunDate` DATETIME NOT NULL,
CHANGE `lastResult` `lastRunResult` CHAR( 30 ) NOT NULL;
ALTER TABLE `zt_testRun` CHANGE `lastRun` `lastRunDate` DATETIME NOT NULL,
CHANGE `lastResult` `lastRunResult` CHAR( 30 ) NOT NULL;

update `zt_task` set `storyVersion` = 1  WHERE `storyVersion` = 0;