WIP SQL

coder · mtojek · Feb 15, 2024 · Feb 13, 2024 · Feb 13, 2024 · Feb 14, 2024
commit 60167dbe2adfc835356e0abf801dfed2cbf6eb59
diff --git a/coderd/database/dump.sql b/coderd/database/dump.sql
diff --git a/coderd/database/migrations/000191_workspace_agent_order.down.sql b/coderd/database/migrations/000191_workspace_agent_order.down.sql
@@ -0,0 +1 @@
+ALTER TABLE workspace_agents DROP COLUMN display_order;
diff --git a/coderd/database/migrations/000191_workspace_agent_order.up.sql b/coderd/database/migrations/000191_workspace_agent_order.up.sql
@@ -0,0 +1,4 @@
+ALTER TABLE workspace_agents ADD COLUMN display_order integer NOT NULL DEFAULT 0;
+
+COMMENT ON COLUMN workspace_agents.display_order
+IS 'Specifies the order in which to display agents 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_agents DROP COLUMN display_order;