A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
392 B · 12 lines
SQL
at next
12345678910111213CREATE TABLE IF NOT EXISTS admin_api_keys ( id TEXT PRIMARY KEY, admin_id TEXT NOT NULL REFERENCES admins(id) ON DELETE CASCADE, name TEXT NOT NULL, key_hash TEXT NOT NULL, key_prefix TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')), last_used_at TEXT, revoked_at TEXT);
CREATE INDEX idx_admin_api_keys_key_hash ON admin_api_keys(key_hash);