mirror of
https://github.com/windmill-labs/windmill.git
synced 2026-09-12 00:06:14 +00:00
11 lines
642 B
SQL
11 lines
642 B
SQL
-- Add down migration script here
|
|
LOCK TABLE v2_job_completed IN ACCESS EXCLUSIVE MODE;
|
|
UPDATE v2_job_completed SET started_at = completed_at WHERE started_at IS NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN status DROP NOT NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN completed_at DROP DEFAULT;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN completed_at DROP NOT NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN started_at SET NOT NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN __created_at SET NOT NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN __created_by SET NOT NULL;
|
|
ALTER TABLE v2_job_completed ALTER COLUMN __success SET NOT NULL;
|