SQL

coder · mtojek · Feb 12, 2024 · Feb 9, 2024 · Feb 9, 2024 · Feb 9, 2024
commit a8d02bfab4f80ef92f757401f29bf9784ca7c15f
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000189_workspace_app_order.down.sql b/coderd/database/migrations/000189_workspace_app_order.down.sql
@@ -0,0 +1 @@
+ALTER TABLE workspace_apps DROP COLUMN display_order;
diff --git a/coderd/database/migrations/000189_workspace_app_order.up.sql b/coderd/database/migrations/000189_workspace_app_order.up.sql
@@ -0,0 +1,4 @@
+ALTER TABLE workspace_apps ADD COLUMN display_order integer NOT NULL DEFAULT 0;
+
+COMMENT ON COLUMN workspace_apps.display_order
+IS 'Specifies the order in which to display agent app in user interfaces.';
diff --git a/coderd/database/models.go b/coderd/database/models.go
diff --git a/coderd/database/queries.sql.go b/coderd/database/queries.sql.go
Original file line number	Diff line number	Diff line change
		@@ -0,0 +1 @@
		ALTER TABLE workspace_apps DROP COLUMN display_order;