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;