Changeset 56795 in vbox for trunk/src/VBox/ValidationKit/testmanager
- Timestamp:
- Jul 3, 2015 5:19:57 PM (10 years ago)
- svn:sync-xref-src-repo-rev:
- 101445
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/src/VBox/ValidationKit/testmanager/db/tmdb-r15-index-sorting.pgsql
r56789 r56795 29 29 -- Reordered, modified and new indexes. 30 30 -- 31 \d UsersLoginNameIdx 31 \d UsersLoginNameIdx; 32 32 DROP INDEX UsersLoginNameIdx; 33 33 CREATE INDEX UsersLoginNameIdx ON Users (sLoginName, tsExpire DESC); 34 \d UsersLoginNameIdx 34 \d UsersLoginNameIdx; 35 35 ANALYZE VERBOSE Users; 36 36 37 37 38 \d TestCaseArgsLookupIdx 38 \d TestCaseArgsLookupIdx; 39 39 DROP INDEX TestCaseArgsLookupIdx; 40 40 CREATE INDEX TestCaseArgsLookupIdx ON TestCaseArgs (idTestCase, tsExpire DESC, tsEffective ASC); 41 \d TestCaseArgsLookupIdx 41 \d TestCaseArgsLookupIdx; 42 42 ANALYZE VERBOSE TestCaseArgs; 43 43 44 44 45 \d TestGroups_id_index 46 DROP INDEX TestGroups_id_index 45 \d TestGroups_id_index; 46 DROP INDEX TestGroups_id_index; 47 47 CREATE INDEX TestGroups_id_index ON TestGroups (idTestGroup, tsExpire DESC, tsEffective ASC); 48 \d TestGroups_id_index 49 ANALYZE VERBOSE TestGroups_id_index 48 \d TestGroups_id_index; 49 ANALYZE VERBOSE TestGroups_id_index; 50 50 51 51 52 \d TestBoxesUuidIdx 52 \d TestBoxesUuidIdx; 53 53 DROP INDEX TestBoxesUuidIdx; 54 54 CREATE UNIQUE INDEX TestBoxesUuidIdx ON TestBoxes (uuidSystem, tsExpire DESC); 55 \d TestBoxesUuidIdx 55 \d TestBoxesUuidIdx; 56 56 DROP INDEX IF EXISTS TestBoxesExpireEffectiveIdx; 57 57 CREATE INDEX TestBoxesExpireEffectiveIdx ON TestBoxes (tsExpire DESC, tsEffective ASC); 58 \d TestBoxesExpireEffectiveIdx 58 \d TestBoxesExpireEffectiveIdx; 59 59 ANALYZE VERBOSE TestBoxes; 60 60 … … 67 67 68 68 69 \d TestResultsNameIdx 69 \d TestResultsNameIdx; 70 70 DROP INDEX TestResultsNameIdx; 71 71 CREATE INDEX TestResultsNameIdx ON TestResults (idStrName, tsCreated DESC); 72 \d TestResultsNameIdx 72 \d TestResultsNameIdx; 73 73 DROP INDEX IF EXISTS TestResultsNameIdx2; 74 74 CREATE INDEX TestResultsNameIdx2 ON TestResults (idTestResult, idStrName); 75 \d TestResultsNameIdx2 75 \d TestResultsNameIdx2; 76 76 ANALYZE VERBOSE TestResults; 77 77
Note:
See TracChangeset
for help on using the changeset viewer.
