tracker r2951 - in trunk: . data/db

[mottela svn gnome org]

Author: mottela
Date: Fri Feb 20 16:45:57 2009
New Revision: 2951
URL: http://svn.gnome.org/viewvc/tracker?rev=2951&view=rev

Log:
Added Collation column to ServiceMetadata

Modified:
   trunk/ChangeLog
   trunk/data/db/sqlite-service.sql
   trunk/data/db/sqlite-stored-procs.sql

Modified: trunk/data/db/sqlite-service.sql
==============================================================================
--- trunk/data/db/sqlite-service.sql	(original)
+++ trunk/data/db/sqlite-service.sql	Fri Feb 20 16:45:57 2009
@@ -57,8 +57,8 @@
 	ServiceID		Integer not null,
 	MetaDataID 		Integer  not null,
 	MetaDataValue     	Text,
-	MetaDataDisplay		Text
-
+	MetaDataDisplay		Text,
+	MetaDataCollation	Text
 );
 
 CREATE INDEX ServiceMetaDataCompoundIndex ON ServiceMetaData (ServiceID, MetaDataID, MetaDataDisplay);

Modified: trunk/data/db/sqlite-stored-procs.sql
==============================================================================
--- trunk/data/db/sqlite-stored-procs.sql	(original)
+++ trunk/data/db/sqlite-stored-procs.sql	Fri Feb 20 16:45:57 2009
@@ -72,7 +72,7 @@
 GetMetadataNumeric             SELECT MetaDataValue FROM ServiceNumericMetaData WHERE ServiceID = ? AND MetaDataID = ?;
 GetMetadataTypes               SELECT ID, MetaName, DataTypeID, FieldName, Weight, Embedded, MultipleValues, Delimited, Filtered, Abstract FROM MetaDataTypes;
 
-SetMetadata                    INSERT INTO ServiceMetaData (ServiceID, MetaDataID, MetaDataValue, MetaDataDisplay) VALUES (?,?,?,?);
+SetMetadata                    INSERT INTO ServiceMetaData (ServiceID, MetaDataID, MetaDataValue, MetaDataDisplay, MetaDataCollation) VALUES (?,?,?,?,'');
 SetMetadataKeyword             INSERT INTO ServiceKeywordMetaData (ServiceID, MetaDataID, MetaDataValue) VALUES (?,?,?);
 SetMetadataNumeric             INSERT INTO ServiceNumericMetaData (ServiceID, MetaDataID, MetaDataValue) VALUES (?,?,?);