this repo has no description
1CREATE INDEX IF NOT EXISTS idx_records_repo_collection
2 ON records(repo_id, collection);
3CREATE INDEX IF NOT EXISTS idx_records_repo_collection_created
4 ON records(repo_id, collection, created_at DESC);
5CREATE INDEX IF NOT EXISTS idx_users_email
6 ON users(email)
7 WHERE email IS NOT NULL;
8CREATE INDEX IF NOT EXISTS idx_blobs_created_by_user
9 ON blobs(created_by_user, created_at DESC);
10CREATE INDEX IF NOT EXISTS idx_repo_seq_did_seq
11 ON repo_seq(did, seq DESC);
12CREATE INDEX IF NOT EXISTS idx_app_passwords_user_id
13 ON app_passwords(user_id);
14CREATE INDEX IF NOT EXISTS idx_invite_codes_created_by
15 ON invite_codes(created_by_user);