Changeset 84884 in vbox for trunk

Timestamp:

Jun 20, 2020 9:53:12 PM (5 years ago)

Author:

vboxsync

Message:

testmanager/db: Add an index on VcsRevisions(tsCreated). bugref:9778

Location:

trunk/src/VBox/ValidationKit/testmanager/db

Files:

• TestManagerDatabaseInit.pgsql (modified) (1 diff)
• tmdb-r25-vcsrevisions-2.pgsql (added)

trunk/src/VBox/ValidationKit/testmanager/db/TestManagerDatabaseInit.pgsql

@@ -1313 +1313 @@
     UNIQUE (sRepository, iRevision)
 );
+CREATE INDEX VcsRevisionsByDate ON VcsRevisions (tsCreated DESC);