CREATE TABLE users ( id TEXT PRIMARY KEY, github_id TEXT NOT NULL UNIQUE, username TEXT NOT NULL, display_name TEXT NOT NULL, avatar_url TEXT NOT NULL, created_at INTEGER NOT NULL, updated_at INTEGER NOT NULL ); CREATE TABLE sessions ( token_hash TEXT PRIMARY KEY, user_id TEXT NOT NULL REFERENCES users(id) ON DELETE CASCADE, expires_at INTEGER NOT NULL ); CREATE INDEX sessions_expiry ON sessions(expires_at); CREATE INDEX sessions_user ON sessions(user_id); CREATE TABLE oauth_states ( state_hash TEXT PRIMARY KEY, verifier TEXT NOT NULL, return_to TEXT NOT NULL, expires_at INTEGER NOT NULL ); CREATE INDEX oauth_states_expiry ON oauth_states(expires_at); CREATE TABLE libraries ( user_id TEXT PRIMARY KEY REFERENCES users(id) ON DELETE CASCADE, library_json TEXT NOT NULL DEFAULT '{"version":2,"series":{},"books":{}}' CHECK(json_valid(library_json)), revision INTEGER NOT NULL DEFAULT 0, updated_at INTEGER NOT NULL );