mirror of
https://gitee.com/goploy/goploy.git
synced 2024-12-01 19:57:34 +08:00
16 lines
911 B
SQL
16 lines
911 B
SQL
ALTER TABLE `project`
|
|
MODIFY COLUMN `after_deploy_script_mode` varchar(20) NOT NULL DEFAULT '' COMMENT 'deprecated after v1.15.0' AFTER `review_url`,
|
|
MODIFY COLUMN `after_deploy_script` text COMMENT 'deprecated after v1.15.0' AFTER `after_deploy_script_mode`,
|
|
MODIFY COLUMN `after_pull_script_mode` varchar(20) NOT NULL DEFAULT '' COMMENT 'deprecated after v1.15.0' AFTER `after_deploy_script`,
|
|
MODIFY COLUMN `after_pull_script` text COMMENT 'deprecated after v1.15.0' AFTER `after_pull_script_mode`,
|
|
ADD COLUMN `script` json NOT NULL COMMENT 'script' AFTER `review_url`;
|
|
|
|
UPDATE project
|
|
SET script = JSON_OBJECT(
|
|
'afterPull',
|
|
JSON_OBJECT( 'mode', after_pull_script_mode, 'content', after_pull_script ),
|
|
'afterDeploy',
|
|
JSON_OBJECT( 'mode', after_deploy_script_mode, 'content', after_deploy_script ),
|
|
'deployFinish',
|
|
JSON_OBJECT( 'mode', '', 'content', '' )
|
|
), `update_time` = update_time |