56 lines
1.9 KiB
SQL
56 lines
1.9 KiB
SQL
-- +goose Up
|
|
-- A workflow is a document, stored by name and version. A run pins the version
|
|
-- it started on and executes that document.
|
|
CREATE TABLE runs.workflows (
|
|
org_id text NOT NULL,
|
|
name text NOT NULL,
|
|
version integer NOT NULL,
|
|
body text NOT NULL,
|
|
created_by text NOT NULL,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
PRIMARY KEY (org_id, name, version)
|
|
);
|
|
|
|
-- A dry run judges every action and executes none that changes something. It
|
|
-- carries the unpublished document and policy it runs under in overlay, and
|
|
-- pins no stored version.
|
|
ALTER TABLE runs.runs
|
|
ADD COLUMN dry boolean NOT NULL DEFAULT false,
|
|
ADD COLUMN overlay jsonb;
|
|
|
|
-- A dry run's decisions are kept for its trail and counted toward nothing:
|
|
-- not the action budget, not a class's history.
|
|
ALTER TABLE judgement.decisions ADD COLUMN dry boolean NOT NULL DEFAULT false;
|
|
|
|
-- A draft bundles the trigger an unmatched group proposes, the workflow that
|
|
-- trigger would start and any policy it needs, with the dry run last made of
|
|
-- it. One draft per group.
|
|
CREATE SCHEMA drafts;
|
|
|
|
CREATE TABLE drafts.drafts (
|
|
id uuid PRIMARY KEY,
|
|
org_id text NOT NULL,
|
|
group_id uuid NOT NULL,
|
|
name text NOT NULL,
|
|
source text NOT NULL,
|
|
event_type text NOT NULL,
|
|
filter jsonb NOT NULL,
|
|
document text NOT NULL,
|
|
policy_kind text NOT NULL CHECK (policy_kind IN ('hard_rules', 'change_request')),
|
|
policy text NOT NULL,
|
|
dry_run_id uuid,
|
|
dry_event_id uuid,
|
|
installed_version integer,
|
|
published_at timestamptz,
|
|
created_at timestamptz NOT NULL DEFAULT now(),
|
|
updated_at timestamptz NOT NULL DEFAULT now(),
|
|
UNIQUE (org_id, group_id),
|
|
UNIQUE (org_id, name)
|
|
);
|
|
|
|
-- +goose Down
|
|
DROP SCHEMA drafts CASCADE;
|
|
ALTER TABLE judgement.decisions DROP COLUMN dry;
|
|
ALTER TABLE runs.runs DROP COLUMN overlay, DROP COLUMN dry;
|
|
DROP TABLE runs.workflows;
|