Something went wrong. Try again.
Bring your e-reader into the Atmosphere headway.page
Something went wrong. Try again.
1.3 kB · 36 lines
SQL
at main
12345678910111213141516171819202122232425262728293031323334353637CREATE TABLE users ( id INTEGER PRIMARY KEY AUTOINCREMENT, atproto_did TEXT NOT NULL UNIQUE, atproto_handle TEXT, kosync_username TEXT NOT NULL UNIQUE, -- bcrypt hash of the generated password kosync_key_hash TEXT NOT NULL, email TEXT, notify_new_doc INTEGER NOT NULL DEFAULT 1, created_at INTEGER NOT NULL DEFAULT (unixepoch()), updated_at INTEGER NOT NULL DEFAULT (unixepoch()));
-- OAuth state for jacquard-oauth ClientAuthStore
CREATE TABLE oauth_auth_requests ( state TEXT PRIMARY KEY, -- serialised JSON blob: code_verifier, nonce, iss, dpop_key, etc. payload TEXT NOT NULL, created_at INTEGER NOT NULL DEFAULT (unixepoch()), -- requests expire after 10 minutes expires_at INTEGER NOT NULL DEFAULT (unixepoch() + 600));
CREATE TABLE oauth_sessions ( id INTEGER PRIMARY KEY AUTOINCREMENT, did TEXT NOT NULL, session_id TEXT NOT NULL, -- serialised JSON blob: access_token, refresh_token, dpop_key, etc. payload TEXT NOT NULL, created_at INTEGER NOT NULL DEFAULT (unixepoch()), updated_at INTEGER NOT NULL DEFAULT (unixepoch()), UNIQUE (did, session_id));
CREATE INDEX oauth_sessions_did ON oauth_sessions (did);