Repository navigation
Expand file tree
/
Copy path055_workflow_purge.sql
More file actions
21 lines (20 loc) · 1.76 KB
/
Copy path055_workflow_purge.sql
File metadata and controls
21 lines (20 loc) · 1.76 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
-- +migrate Up
ALTER TABLE workflow_run ADD COLUMN to_delete BOOLEAN DEFAULT false;
ALTER TABLE workflow ADD COLUMN history_length BIGINT DEFAULT 20;
ALTER TABLE workflow ADD COLUMN purge_tags JSONB;
ALTER TABLE workflow_node_run DROP CONSTRAINT fk_workflow_node_run_workflow_run;
SELECT create_foreign_key_idx_cascade('FK_WORKFLOW_NODE_RUN_WORKFLOW_RUN', 'workflow_node_run', 'workflow_run', 'workflow_run_id', 'id');
ALTER TABLE workflow_node_run_job_logs DROP CONSTRAINT fk_workflow_node_run_jogs_workflow_node_run;
SELECT create_foreign_key_idx_cascade('FK_WORKFLOW_NODE_RUN_JOBS_WORKFLOW_NODE_RUN', 'workflow_node_run_job_logs', 'workflow_node_run', 'workflow_node_run_id', 'id');
ALTER TABLE workflow_node_run_job DROP CONSTRAINT fk_workflow_node_run_job_workflow_node_run;
SELECT create_foreign_key_idx_cascade('FK_WORKFLOW_NODE_RUN_JOB_WORKFLOW_NODE_RUN', 'workflow_node_run_job', 'workflow_node_run', 'workflow_node_run_id', 'id');
-- +migrate Down
ALTER TABLE workflow_run DROP COLUMN to_delete;
ALTER TABLE workflow DROP COLUMN history_length;
ALTER TABLE workflow DROP COLUMN purge_tags;
ALTER TABLE workflow_node_run DROP CONSTRAINT fk_workflow_node_run_workflow_run;
SELECT create_foreign_key('FK_WORKFLOW_NODE_RUN_WORKFLOW_RUN', 'workflow_node_run', 'workflow_run', 'workflow_run_id', 'id');
ALTER TABLE workflow_node_run_job_logs DROP CONSTRAINT fk_workflow_node_run_jobs_workflow_node_run;
SELECT create_foreign_key('FK_WORKFLOW_NODE_RUN_JOGS_WORKFLOW_NODE_RUN', 'workflow_node_run_job_logs', 'workflow_node_run', 'workflow_node_run_id', 'id');
ALTER TABLE workflow_node_run_job DROP CONSTRAINT fk_workflow_node_run_job_workflow_node_run;
SELECT create_foreign_key('FK_WORKFLOW_NODE_RUN_JOB_WORKFLOW_NODE_RUN', 'workflow_node_run_job', 'workflow_node_run', 'workflow_node_run_id', 'id');