moth11.net
tiny 88x31 lexicon for atproto
1CREATE TABLE requests (
2 state TEXT NOT NULL PRIMARY KEY,
3 authserver_url TEXT NOT NULL,
4 account_did TEXT,
5 scopes TEXT NOT NULL,
6 request_uri TEXT NOT NULL,
7 authserver_token_endpoint TEXT NOT NULL,
8 pkce_verifier TEXT NOT NULL,
9 dpop_authserver_nonce TEXT NOT NULL,
10 dpop_privatekey_multibase TEXT NOT NULL
11);
12
13CREATE TABLE sessions (
14 session_id TEXT NOT NULL PRIMARY KEY,
15 account_did TEXT NOT NULL,
16 host_url TEXT NOT NULL,
17 authserver_url TEXT NOT NULL,
18 authserver_token_endpoint TEXT NOT NULL,
19 scopes TEXT NOT NULL,
20 access_token TEXT NOT NULL,
21 refresh_token TEXT NOT NULL,
22 dpop_authserver_nonce TEXT NOT NULL,
23 dpop_host_nonce TEXT NOT NULL,
24 dpop_privatekey_multibase TEXT NOT NULL
25);