17 lines
450 B
PL/PgSQL
17 lines
450 B
PL/PgSQL
BEGIN;
|
|
SET ROLE continuity_role;
|
|
CREATE TABLE IF NOT EXISTS continuity.prospective_items (
|
|
prospective_item_id TEXT PRIMARY KEY,
|
|
commitment_id TEXT NOT NULL,
|
|
owner_principal_id TEXT NOT NULL,
|
|
scope_id TEXT NOT NULL,
|
|
goal_id TEXT NOT NULL,
|
|
trigger_at_unix_millis BIGINT NOT NULL,
|
|
state TEXT NOT NULL,
|
|
revision BIGINT NOT NULL,
|
|
recorded_at TIMESTAMPTZ NOT NULL DEFAULT CURRENT_TIMESTAMP,
|
|
CHECK (revision > 0)
|
|
);
|
|
RESET ROLE;
|
|
COMMIT;
|