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;