this repo has no description
lewis.moe
1CREATE INDEX IF NOT EXISTS idx_session_tokens_did_created_at
2ON session_tokens(did, created_at DESC);
3
4CREATE INDEX IF NOT EXISTS idx_oauth_token_did_expires_at
5ON oauth_token(did, expires_at DESC);
6
7CREATE INDEX IF NOT EXISTS idx_oauth_token_did_created_at
8ON oauth_token(did, created_at DESC);
9
10CREATE INDEX IF NOT EXISTS idx_session_tokens_did_refresh_expires
11ON session_tokens(did, refresh_expires_at DESC);
12
13CREATE INDEX IF NOT EXISTS idx_app_passwords_user_created
14ON app_passwords(user_id, created_at DESC);
15
16CREATE INDEX IF NOT EXISTS idx_records_repo_collection_rkey
17ON records(repo_id, collection, rkey);
18
19CREATE INDEX IF NOT EXISTS idx_passkeys_did_created
20ON passkeys(did, created_at DESC);
21
22CREATE INDEX IF NOT EXISTS idx_backup_codes_did_unused
23ON backup_codes(did) WHERE used_at IS NULL;