add missing migrations

Emyrk · Emyrk · commit 712f81a9916d · 2023-07-26T13:13:49.000-04:00
diff --git a/coderd/database/migrations/000142_group_display_name.down.sql b/coderd/database/migrations/000142_group_display_name.down.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE groups
+	DROP COLUMN display_name;
+
+COMMIT;
diff --git a/coderd/database/migrations/000142_group_display_name.up.sql b/coderd/database/migrations/000142_group_display_name.up.sql
@@ -0,0 +1,11 @@
+BEGIN;
+
+ALTER TABLE groups
+	ADD COLUMN display_name TEXT NOT NULL DEFAULT '';
+
+COMMENT ON COLUMN groups.display_name IS 'Display name is a custom, human-friendly group name that user can set. This is not required to be unique.';
+
+-- Use the name as the display name for all existing groups
+UPDATE groups SET display_name = name;
+
+COMMIT;

-Original file line number
+Diff line change
@@ @@ -0,0 +1,6 @@ @@
 +BEGIN;
++
 +ALTER TABLE groups
 +	DROP COLUMN display_name;
++
 +COMMIT;