bfb5eb27b5
* feat: Add workspace settings to sync script to git repo on deployment * track deployment callback jobs in separate table * sqlx prepare * update deployment_metadata table * Point to hub script * Add details to the settings page and restrict to EE only * cleanup unused impots * Flows and Apps are now pushed to GH as well * Ignore scripts/flows/apps located in private user folders
17 lines
852 B
SQL
17 lines
852 B
SQL
-- Add up migration script here
|
|
ALTER TYPE JOB_KIND ADD VALUE IF NOT EXISTS 'deploymentcallback';
|
|
ALTER TABLE workspace_settings ADD COLUMN IF NOT EXISTS git_sync JSONB;
|
|
|
|
CREATE TABLE deployment_metadata(
|
|
workspace_id VARCHAR(50) NOT NULL REFERENCES workspace(id),
|
|
path VARCHAR(255) NOT NULL,
|
|
script_hash BIGINT,
|
|
app_version BIGSERIAL,
|
|
callback_job_ids UUID[],
|
|
deployment_msg TEXT
|
|
);
|
|
|
|
CREATE UNIQUE INDEX IF NOT EXISTS deployment_metadata_script ON deployment_metadata (workspace_id, script_hash) WHERE script_hash IS NOT NULL;
|
|
CREATE UNIQUE INDEX IF NOT EXISTS deployment_metadata_flow ON deployment_metadata (workspace_id, path) WHERE script_hash IS NULL AND app_version IS NULL;
|
|
CREATE UNIQUE INDEX IF NOT EXISTS deployment_metadata_app ON deployment_metadata (workspace_id, path, app_version) WHERE app_version IS NOT NULL;
|