mirror of https://github.com/coder/coder.git
35 lines
1.3 KiB
SQL
35 lines
1.3 KiB
SQL
CREATE TABLE workspace_agent_log_sources (
|
|
workspace_agent_id uuid NOT NULL REFERENCES workspace_agents(id) ON DELETE CASCADE,
|
|
id uuid NOT NULL,
|
|
created_at timestamptz NOT NULL,
|
|
display_name varchar(127) NOT NULL,
|
|
icon text NOT NULL,
|
|
PRIMARY KEY (workspace_agent_id, id)
|
|
);
|
|
|
|
CREATE TABLE workspace_agent_scripts (
|
|
workspace_agent_id uuid NOT NULL REFERENCES workspace_agents(id) ON DELETE CASCADE,
|
|
log_source_id uuid NOT NULL,
|
|
log_path text NOT NULL,
|
|
created_at timestamptz NOT NULL,
|
|
script text NOT NULL,
|
|
cron text NOT NULL,
|
|
start_blocks_login boolean NOT NULL,
|
|
run_on_start boolean NOT NULL,
|
|
run_on_stop boolean NOT NULL,
|
|
timeout_seconds integer NOT NULL
|
|
);
|
|
|
|
ALTER TABLE workspace_agent_logs ADD COLUMN log_source_id uuid NOT NULL DEFAULT '00000000-0000-0000-0000-000000000000'::uuid;
|
|
ALTER TABLE workspace_agent_logs DROP COLUMN source;
|
|
DROP TYPE workspace_agent_log_source;
|
|
|
|
ALTER TABLE workspace_agents DROP COLUMN startup_script_timeout_seconds;
|
|
ALTER TABLE workspace_agents DROP COLUMN shutdown_script;
|
|
ALTER TABLE workspace_agents DROP COLUMN shutdown_script_timeout_seconds;
|
|
ALTER TABLE workspace_agents DROP COLUMN startup_script_behavior;
|
|
ALTER TABLE workspace_agents DROP COLUMN startup_script;
|
|
|
|
-- Set the table to unlogged to speed up the inserts
|
|
ALTER TABLE workspace_agent_logs SET UNLOGGED;
|