f-spot r4402 - in trunk: . src

[sdelcroix svn gnome org]

Author: sdelcroix
Date: Wed Sep 17 13:30:39 2008
New Revision: 4402
URL: http://svn.gnome.org/viewvc/f-spot?rev=4402&view=rev

Log:
2008-09-17  Stephane Delcroix  <sdelcroix novell com>

	* src/Updater.cs:
	* src/PhotoStore.cs: adding an index on roll_id. Patch by Ulf Rompe.


Modified:
   trunk/ChangeLog
   trunk/src/PhotoStore.cs
   trunk/src/Updater.cs

Modified: trunk/src/PhotoStore.cs
==============================================================================
--- trunk/src/PhotoStore.cs	(original)
+++ trunk/src/PhotoStore.cs	Wed Sep 17 13:30:39 2008
@@ -148,6 +148,7 @@
 			")");
 
 		Database.ExecuteNonQuery ("CREATE INDEX idx_photo_versions_id ON photo_versions(photo_id)");
+		Database.ExecuteNonQuery ("CREATE INDEX idx_photos_roll_id ON photos(roll_id)");
 	}
 
 	public Photo CheckForDuplicate (System.Uri uri) {

Modified: trunk/src/Updater.cs
==============================================================================
--- trunk/src/Updater.cs	(original)
+++ trunk/src/Updater.cs	Wed Sep 17 13:30:39 2008
@@ -337,6 +337,11 @@
 				 Execute ("CREATE INDEX idx_photo_versions_id ON photo_versions(photo_id)");
 			 }, false);
 
+			// Update to version 16.2
+			 AddUpdate (new Version (16,2), delegate () {
+				 Execute ("CREATE INDEX idx_photos_roll_id ON photos(roll_id)");
+			 }, false);
+
 			 // Update to version 17.0
 			//AddUpdate (new Version (14,0),delegate () {
 			//	do update here