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.
21 lines
716 B
SQL
21 lines
716 B
SQL
CREATE TABLE workspace_proxies (
|
|
id uuid NOT NULL,
|
|
name text NOT NULL,
|
|
display_name text NOT NULL,
|
|
icon text NOT NULL,
|
|
url text NOT NULL,
|
|
wildcard_hostname text NOT NULL,
|
|
created_at timestamp with time zone NOT NULL,
|
|
updated_at timestamp with time zone NOT NULL,
|
|
deleted boolean NOT NULL,
|
|
|
|
PRIMARY KEY (id)
|
|
);
|
|
|
|
COMMENT ON COLUMN workspace_proxies.url IS 'Full url including scheme of the proxy api url: https://us.example.com';
|
|
COMMENT ON COLUMN workspace_proxies.wildcard_hostname IS 'Hostname with the wildcard for subdomain based app hosting: *.us.example.com';
|
|
|
|
|
|
-- Enforces no active proxies have the same name.
|
|
CREATE UNIQUE INDEX ON workspace_proxies (name) WHERE deleted = FALSE;
|