mirror of
https://github.com/coder/coder.git
synced 2025-07-03 16:13:58 +00:00
8e684c8195
Updates coder/customers#365 This PR updates our migration framework to run all migrations in a single transaction. This is the same behavior we had in v1 and ensures that failed migrations don't bring the whole deployment down. If a migration fails now, it will automatically be rolled back to the previous version, allowing the deployment to continue functioning.
14 lines
651 B
SQL
14 lines
651 B
SQL
-- Bring back the subsystem column.
|
|
ALTER TABLE workspace_agents ADD COLUMN subsystem workspace_agent_subsystem NOT NULL DEFAULT 'none';
|
|
|
|
-- Update all existing workspace_agents to have subsystem = subsystems[0] unless
|
|
-- subsystems is empty.
|
|
UPDATE workspace_agents SET subsystem = subsystems[1] WHERE cardinality(subsystems) > 0;
|
|
|
|
-- Drop the subsystems column from workspace_agents.
|
|
ALTER TABLE workspace_agents DROP COLUMN subsystems;
|
|
|
|
-- We cannot drop the "exectrace" value from the workspace_agent_subsystem type
|
|
-- because you cannot drop values from an enum type.
|
|
UPDATE workspace_agents SET subsystem = 'none' WHERE subsystem = 'exectrace';
|