[tracker/tracker-0.6] Add index to Volumes table

[Ivan Frade <ifrade src gnome org>]

commit fd45864ecfc5e5f08bd9a4fb40efdcc14157ecfd
Author: Ivan Frade <ivan frade nokia com>
Date:   Mon May 11 15:19:46 2009 +0300

    Add index to Volumes table
    
    New index for Volumes table. This speed up the GetVolumeId query in
    indexing time.
---
 data/db/sqlite-tracker.sql |    1 +
 1 files changed, 1 insertions(+), 0 deletions(-)

diff --git a/data/db/sqlite-tracker.sql b/data/db/sqlite-tracker.sql
index e41ba4a..82e471c 100644
--- a/data/db/sqlite-tracker.sql
+++ b/data/db/sqlite-tracker.sql
@@ -25,6 +25,7 @@ CREATE TABLE  Volumes
 );
 
 INSERT INTO Volumes (Enabled) VALUES ('1');
+CREATE INDEX VolumesIndex1 ON Volumes (VolumeID, UDI, MountPath, Enabled);
 
 /* provides links from one service entity to another (entities can be in different databases) */
 CREATE TABLE  ServiceLinks