f-spot r4343 - in trunk: . src

[sdelcroix svn gnome org]

Author: sdelcroix
Date: Mon Sep 15 11:45:30 2008
New Revision: 4343
URL: http://svn.gnome.org/viewvc/f-spot?rev=4343&view=rev

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

	* src/PhotoStore.cs: add the index on new db creation too;


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

Modified: trunk/src/PhotoStore.cs
==============================================================================
--- trunk/src/PhotoStore.cs	(original)
+++ trunk/src/PhotoStore.cs	Mon Sep 15 11:45:30 2008
@@ -146,6 +146,8 @@
 			"	protected	BOOLEAN,	" +
 			"	UNIQUE (photo_id, version_id)	" +
 			")");
+
+		Database.ExecuteNonQuery ("CREATE INDEX idx_photo_versions_id ON photo_versions(photo_id)");
 	}
 
 	public Photo CheckForDuplicate (System.Uri uri) {