add missing migration file

coder · defelmnq · Mar 5, 2025 · Mar 3, 2025 · Mar 3, 2025 · Mar 3, 2025
commit 10276a5ed73e0715d6f9aaccff56a073b0e7ef4b
diff --git a/coderd/database/migrations/000298_notifications_method_inbox.down.sql b/coderd/database/migrations/000298_notifications_method_inbox.down.sql
@@ -0,0 +1,3 @@
+-- The migration is about an enum value change
+-- As we can not remove a value from an enum, we can let the down migration empty
+-- In order to avoid any failure, we use ADD VALUE IF NOT EXISTS to add the value
diff --git a/coderd/database/migrations/000298_notifications_method_inbox.up.sql b/coderd/database/migrations/000298_notifications_method_inbox.up.sql
@@ -0,0 +1 @@
+ALTER TYPE notification_method ADD VALUE IF NOT EXISTS 'inbox';
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TYPE notification_method ADD VALUE IF NOT EXISTS 'inbox';