zentaopms/db/update12.2.sql
2023-05-16 10:47:08 +08:00

13 lines
1020 B
SQL

ALTER TABLE `zt_job` ADD `frame` varchar(20) COLLATE 'utf8_general_ci' 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) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'no' AFTER `type`;
ALTER TABLE `zt_case` ADD `frame` varchar(10) COLLATE 'utf8_general_ci' 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) COLLATE 'utf8_general_ci' NOT NULL DEFAULT 'no' AFTER `status`;
UPDATE `zt_cron` SET `command` = 'moduleName=ci&methodName=checkCompileStatus' WHERE `command` = 'moduleName=ci&methodName=checkBuildStatus';