moth11.net
backend for xcvr appview
1DROP TABLE IF EXISTS sessions;
2DROP TABLE IF EXISTS requests;
3
4CREATE TABLE oauthrequests (
5 id SERIAL PRIMARY KEY,
6 authserver_iss TEXT,
7 state TEXT,
8 did TEXT,
9 pds_url TEXT,
10 pkce_verifier TEXT,
11 dpop_auth_server_nonce TEXT,
12 dpop_private_jwk TEXT
13);
14
15CREATE TABLE oauthsessions (
16 id SERIAL PRIMARY KEY,
17 authserver_iss TEXT,
18 state TEXT,
19 did TEXT,
20 pds_url TEXT,
21 pkce_verifier TEXT,
22 dpop_auth_server_nonce TEXT,
23 dpop_private_jwk TEXT,
24 dpop_pds_nonce TEXT,
25 access_token TEXT,
26 refresh_token TEXT,
27 expiration TIMESTAMPTZ
28);