tracker r3088 - in trunk: . data/db

[carlosg svn gnome org]

Author: carlosg
Date: Mon Mar 16 15:33:30 2009
New Revision: 3088
URL: http://svn.gnome.org/viewvc/tracker?rev=3088&view=rev

Log:
2009-03-16  Carlos Garnacho  <carlos imendio com>

        * data/db/sqlite-tracker.sql: Set primary key on the Options table, so
        the 'Replace' statement in the SetOption stored procedure actually
        replaces the setting value. Fixes #570232

Modified:
   trunk/ChangeLog
   trunk/data/db/sqlite-tracker.sql

Modified: trunk/data/db/sqlite-tracker.sql
==============================================================================
--- trunk/data/db/sqlite-tracker.sql	(original)
+++ trunk/data/db/sqlite-tracker.sql	Mon Mar 16 15:33:30 2009
@@ -1,6 +1,6 @@
 
 CREATE TABLE Options (	
-	OptionKey 	Text COLLATE NOCASE not null,	
+	OptionKey 	Text COLLATE NOCASE PRIMARY KEY not null,
 	OptionValue	Text COLLATE NOCASE
 );