chore: remove ALTER TYPE .. ADD VALUE from migration 46 (#10997)

coadler · web-flow · commit cbcf7561e540 · 2023-12-02T11:38:12.000-06:00
Follow up of #10966
diff --git a/coderd/database/migrations/000046_more_resource_types.up.sql b/coderd/database/migrations/000046_more_resource_types.up.sql
@@ -1,2 +1,15 @@
-ALTER TYPE resource_type ADD VALUE IF NOT EXISTS 'git_ssh_key';
-ALTER TYPE resource_type ADD VALUE IF NOT EXISTS 'api_key';
+CREATE TYPE new_resource_type AS ENUM (
+    'organization',
+    'template',
+    'template_version',
+    'user',
+    'workspace',
+    'git_ssh_key',
+    'api_key'
+);
+
+ALTER TABLE audit_logs
+	ALTER COLUMN resource_type TYPE new_resource_type USING(resource_type::text::new_resource_type);
+
+DROP TYPE resource_type;
+ALTER TYPE new_resource_type RENAME TO resource_type;
