0004-shomei-sessions.sql

SET LOCAL search_path = pg_catalog, pg_temp;

CREATE TABLE IF NOT EXISTS shomei.shomei_sessions (
  session_id uuid PRIMARY KEY,
  user_id    uuid NOT NULL REFERENCES shomei.shomei_users(user_id),
  status     text NOT NULL,
  created_at timestamptz NOT NULL,
  expires_at timestamptz NOT NULL,
  revoked_at timestamptz NULL
);

CREATE INDEX IF NOT EXISTS shomei_sessions_user_id_idx ON shomei.shomei_sessions (user_id);
CREATE INDEX IF NOT EXISTS shomei_sessions_status_idx  ON shomei.shomei_sessions (status);