Skip to content

Commit 4275721

Browse files
authored
chore: remove ALTER TYPE .. ADD VALUE from migration 18 (#10996)
Follow up of #10966
1 parent c82e878 commit 4275721

File tree

1 file changed

+11
-2
lines changed

1 file changed

+11
-2
lines changed
Lines changed: 11 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,2 +1,11 @@
1-
ALTER TYPE provisioner_job_type
2-
ADD VALUE IF NOT EXISTS 'template_version_dry_run';
1+
CREATE TYPE new_provisioner_job_type AS ENUM (
2+
'template_version_import',
3+
'workspace_build',
4+
'template_version_dry_run'
5+
);
6+
7+
ALTER TABLE provisioner_jobs
8+
ALTER COLUMN "type" TYPE new_provisioner_job_type USING ("type"::text::new_provisioner_job_type);
9+
10+
DROP TYPE provisioner_job_type;
11+
ALTER TYPE new_provisioner_job_type RENAME TO provisioner_job_type;

0 commit comments

Comments
 (0)