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.
20 lines
947 B
SQL
20 lines
947 B
SQL
ALTER TABLE workspace_agent_logs SET LOGGED;
|
|
|
|
-- Revert the workspace_agents table to its former state
|
|
ALTER TABLE workspace_agents ADD COLUMN startup_script text;
|
|
ALTER TABLE workspace_agents ADD COLUMN startup_script_behavior text;
|
|
ALTER TABLE workspace_agents ADD COLUMN shutdown_script_timeout_seconds integer;
|
|
ALTER TABLE workspace_agents ADD COLUMN shutdown_script text;
|
|
ALTER TABLE workspace_agents ADD COLUMN startup_script_timeout_seconds integer;
|
|
|
|
-- Reinstate the dropped type
|
|
CREATE TYPE workspace_agent_log_source AS ENUM ('startup_script', 'shutdown_script', 'kubernetes_logs', 'envbox', 'envbuilder', 'external');
|
|
|
|
-- Add old source column back with enum type and drop log_source_id
|
|
ALTER TABLE workspace_agent_logs ADD COLUMN source workspace_agent_log_source;
|
|
ALTER TABLE workspace_agent_logs DROP COLUMN log_source_id;
|
|
|
|
-- Drop the newly created tables
|
|
DROP TABLE workspace_agent_scripts;
|
|
DROP TABLE workspace_agent_log_sources;
|