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