6 lines
208 B
PL/PgSQL
6 lines
208 B
PL/PgSQL
BEGIN;
|
|
SET ROLE work_role;
|
|
CREATE TABLE IF NOT EXISTS work.tasks (task_id TEXT PRIMARY KEY, goal_id TEXT NOT NULL, scope_id TEXT NOT NULL, revision BIGINT NOT NULL, CHECK (revision > 0));
|
|
RESET ROLE;
|
|
COMMIT;
|