shomei-migrations-0.2.0.0: migrations/shomei/0015-shomei-webauthn-pending-ceremonies.sql

SET LOCAL search_path = pg_catalog, pg_temp;

CREATE TABLE IF NOT EXISTS shomei.shomei_webauthn_pending_ceremonies (
  ceremony_id  uuid PRIMARY KEY,
  user_id      uuid NULL REFERENCES shomei.shomei_users(user_id),
  kind         text NOT NULL,
  options_blob bytea NOT NULL,
  created_at   timestamptz NOT NULL,
  expires_at   timestamptz NOT NULL
);

CREATE INDEX IF NOT EXISTS shomei_webauthn_pending_ceremonies_expires_at_idx
  ON shomei.shomei_webauthn_pending_ceremonies (expires_at);