new migration

coder · f0ssel · Oct 6, 2022 · Oct 5, 2022 · Oct 5, 2022 · Oct 5, 2022
commit 8b10c269e06b494e4bdceec2770e58a379836bf2
diff --git a/coderd/database/migrations/000057_api_key_application.down.sql b/coderd/database/migrations/000057_api_key_application.down.sql
@@ -0,0 +1,2 @@
+-- You cannot safely remove values from enums https://www.postgresql.org/docs/current/datatype-enum.html
+-- You cannot create a new type and do a rename because objects depend on this type now.
diff --git a/coderd/database/migrations/000057_api_key_application.up.sql b/coderd/database/migrations/000057_api_key_application.up.sql
@@ -0,0 +1 @@
+ALTER TYPE login_type ADD VALUE IF NOT EXISTS 'machine';
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1,2 @@
		-- You cannot safely remove values from enums https://www.postgresql.org/docs/current/datatype-enum.html
		-- You cannot create a new type and do a rename because objects depend on this type now.
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TYPE login_type ADD VALUE IF NOT EXISTS 'machine';