Something went wrong. Try again.
A social pastebin built on atproto. morsels.blue
Something went wrong. Try again.
1234567891011121314151617181920212223242526272829-- Temporary state during the OAuth authorization flow.-- Each row represents an in-progress login attempt.-- Deleted after the callback completes (or on expiry).CREATE TABLE IF NOT EXISTS oauth_auth_request ( state TEXT NOT NULL PRIMARY KEY, authserver_iss TEXT NOT NULL, did TEXT, handle TEXT, pds_url TEXT, pkce_verifier TEXT NOT NULL, scope TEXT NOT NULL, dpop_authserver_nonce TEXT NOT NULL, dpop_private_jwk TEXT NOT NULL);
-- Active authenticated sessions.-- One row per logged-in user. Tokens are refreshed in place.CREATE TABLE IF NOT EXISTS oauth_session ( did TEXT NOT NULL PRIMARY KEY, handle TEXT, pds_url TEXT NOT NULL, authserver_iss TEXT NOT NULL, access_token TEXT, refresh_token TEXT, dpop_authserver_nonce TEXT NOT NULL, dpop_pds_nonce TEXT, dpop_private_jwk TEXT NOT NULL);