| -- Gerrit 2 : Generic |
| -- |
| |
| -- Indexes to support @Query |
| -- |
| |
| -- ********************************************************************* |
| -- ApprovalCategoryAccess |
| -- too small to bother indexing |
| |
| |
| -- ********************************************************************* |
| -- ApprovalCategoryValueAccess |
| -- @PrimaryKey covers: byCategory |
| |
| |
| -- ********************************************************************* |
| -- BranchAccess |
| -- @PrimaryKey covers: byProject |
| |
| |
| -- ********************************************************************* |
| -- ChangeMessageAccess |
| -- @PrimaryKey covers: byChange |
| |
| -- covers: byPatchSet |
| CREATE INDEX change_messages_byPatchset |
| ON change_messages (patchset_change_id, patchset_patch_set_id); |
| |
| -- ********************************************************************* |
| -- PatchLineCommentAccess |
| -- @PrimaryKey covers: published, draft |
| CREATE INDEX patch_comment_drafts |
| ON patch_comments (status, author_id); |
| |
| |
| -- ********************************************************************* |
| -- PatchSetAccess |
| CREATE INDEX patch_sets_byRevision |
| ON patch_sets (revision); |