znt/db/update12.2.sql

13 lines
916 B
MySQL
Raw Permalink Normal View History

ALTER TABLE `zt_job` ADD `frame` varchar(20) NOT NULL AFTER `repo`;
ALTER TABLE `zt_job` ADD `product` mediumint(8) unsigned NOT NULL AFTER `repo`;
ALTER TABLE `zt_compile` ADD `testtask` mediumint unsigned NULL AFTER `atTime`;
ALTER TABLE `zt_case` ADD `auto` varchar(10) NOT NULL DEFAULT 'no' AFTER `type`;
ALTER TABLE `zt_case` ADD `frame` varchar(10) NOT NULL AFTER `auto`;
ALTER TABLE `zt_testresult` ADD `job` mediumint unsigned NOT NULL AFTER `version`;
ALTER TABLE `zt_testresult` ADD `compile` mediumint unsigned NOT NULL AFTER `job`;
ALTER TABLE `zt_testresult` ADD `duration` float NOT NULL AFTER `date`;
ALTER TABLE `zt_testresult` ADD `xml` text NOT NULL AFTER `duration`;
ALTER TABLE `zt_testtask` ADD `auto` varchar(10) NOT NULL DEFAULT 'no' AFTER `status`;
UPDATE `zt_cron` SET `command` = 'moduleName=ci&methodName=checkCompileStatus' WHERE `command` = 'moduleName=ci&methodName=checkBuildStatus';