A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
451 B · 11 lines
SQL
123456789101112CREATE TABLE IF NOT EXISTS admin_api_keys ( id UUID PRIMARY KEY DEFAULT gen_random_uuid(), admin_id UUID NOT NULL REFERENCES admins(id) ON DELETE CASCADE, name TEXT NOT NULL, key_hash TEXT NOT NULL, key_prefix TEXT NOT NULL, created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), last_used_at TIMESTAMPTZ, revoked_at TIMESTAMPTZ);CREATE INDEX idx_admin_api_keys_key_hash ON admin_api_keys(key_hash) WHERE revoked_at IS NULL;