A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
979 B · 31 lines
SQL
at dev
1234567891011121314151617181920212223242526272829303132CREATE TABLE happyview_linked_repos ( id TEXT PRIMARY KEY, did TEXT UNIQUE, handle TEXT, label TEXT, scopes TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'pending', last_error TEXT, last_refreshed_at TEXT, authorized_at TEXT, created_by TEXT NOT NULL, created_at TEXT NOT NULL DEFAULT (datetime('now')));
CREATE INDEX idx_happyview_linked_repos_status ON happyview_linked_repos (status);
CREATE TABLE happyview_linked_repo_sessions ( did TEXT PRIMARY KEY, session_data TEXT NOT NULL, updated_at TEXT NOT NULL DEFAULT (datetime('now')));
CREATE TABLE happyview_linked_repo_auth_state ( state TEXT PRIMARY KEY, grant_id TEXT NOT NULL, token_hash TEXT, expires_at TEXT NOT NULL);
CREATE INDEX idx_happyview_linked_repo_auth_state_grant ON happyview_linked_repo_auth_state (grant_id);