CREATE TABLE dev_sessions (
  id           UUID        PRIMARY KEY DEFAULT gen_random_uuid(),
  slug         TEXT        NOT NULL UNIQUE,
  key_hash     TEXT        NOT NULL,
  access_token TEXT,
  label        TEXT        NOT NULL DEFAULT 'Session dev',
  expires_at   TIMESTAMPTZ NOT NULL,
  created_by   TEXT,
  created_at   TIMESTAMPTZ NOT NULL DEFAULT now()
);

CREATE INDEX idx_dev_sessions_slug        ON dev_sessions (slug);
CREATE INDEX idx_dev_sessions_token       ON dev_sessions (access_token) WHERE access_token IS NOT NULL;
CREATE INDEX idx_dev_sessions_expires_at  ON dev_sessions (expires_at);