27 lines
853 B
SQL
27 lines
853 B
SQL
-- Add up migration script here
|
|
ALTER TYPE JOB_KIND ADD VALUE IF NOT EXISTS 'appscript';
|
|
|
|
-- Same as `app_version` but with a "lite" value (w/ `inlineScript.{code,lock}`).
|
|
CREATE TABLE app_version_lite (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
value JSONB,
|
|
FOREIGN KEY (id) REFERENCES app_version (id) ON DELETE CASCADE
|
|
);
|
|
|
|
GRANT ALL ON app_version_lite TO windmill_user;
|
|
GRANT ALL ON app_version_lite TO windmill_admin;
|
|
|
|
-- App `inlineScript`.
|
|
CREATE TABLE app_script (
|
|
id BIGSERIAL PRIMARY KEY,
|
|
app BIGSERIAL NOT NULL,
|
|
hash CHAR(64) NOT NULL UNIQUE, -- sha256 of `app`, `lock`, `code`.
|
|
lock TEXT,
|
|
code TEXT NOT NULL,
|
|
code_sha256 CHAR(64) NOT NULL, -- used to retrieve the policy.
|
|
FOREIGN KEY (app) REFERENCES app (id) ON DELETE CASCADE
|
|
);
|
|
|
|
GRANT ALL ON app_script TO windmill_user;
|
|
GRANT ALL ON app_script TO windmill_admin;
|