[rygel-gst-0-10-plugins] Revert SQL strings to schema version 11.

[Krzesimir Nowak <krnowak src gnome org>]

commit f7d03ebbf57198e4927e795d136f3af991c94bce
Author: Krzesimir Nowak <krnowak openismus com>
Date:   Tue Feb 5 16:05:17 2013 +0100

    Revert SQL strings to schema version 11.

 src/media-export/rygel-media-export-sql-factory.c |   16 +++++-----------
 1 files changed, 5 insertions(+), 11 deletions(-)
---
diff --git a/src/media-export/rygel-media-export-sql-factory.c b/src/media-export/rygel-media-export-sql-factory.c
index 9cdff66..265dbfb 100644
--- a/src/media-export/rygel-media-export-sql-factory.c
+++ b/src/media-export/rygel-media-export-sql-factory.c
@@ -36,9 +36,8 @@ G_DEFINE_TYPE (RygelMediaExportSQLFactory, rygel_media_export_sql_factory, G_TYP
 
 #define RYGEL_MEDIA_EXPORT_SQL_FACTORY_INSERT_OBJECT_STRING \
   "INSERT OR REPLACE INTO Object " \
-  "(upnp_id, title, type_fk, parent, timestamp, uri, " \
-  " object_update_id, deleted_child_count, container_update_id) " \
-  "VALUES (?,?,?,?,?,?,?,?,?)"
+  "(upnp_id, title, type_fk, parent, timestamp, uri) " \
+  "VALUES (?,?,?,?,?,?)"
 
 #define RYGEL_MEDIA_EXPORT_SQL_FACTORY_DELETE_BY_ID_STRING \
   "DELETE FROM Object WHERE upnp_id IN " \
@@ -49,8 +48,7 @@ G_DEFINE_TYPE (RygelMediaExportSQLFactory, rygel_media_export_sql_factory, G_TYP
   "m.height, m.class, m.author, m.album, m.date, m.bitrate, " \
   "m.sample_freq, m.bits_per_sample, m.channels, m.track, " \
   "m.color_depth, m.duration, o.upnp_id, o.parent, o.timestamp, " \
-  "o.uri, m.dlna_profile, m.genre, m.disc, o.object_update_id, " \
-   "o.deleted_child_count, o.container_update_id "
+  "o.uri, m.dlna_profile, m.genre, m.disc "
 
 #define RYGEL_MEDIA_EXPORT_SQL_FACTORY_GET_OBJECT_WITH_PATH \
   "SELECT DISTINCT " RYGEL_MEDIA_EXPORT_SQL_FACTORY_ALL_DETAILS_STRING \
@@ -142,8 +140,7 @@ G_DEFINE_TYPE (RygelMediaExportSQLFactory, rygel_media_export_sql_factory, G_TYP
   "ON DELETE CASCADE);"
 
 #define RYGEL_MEDIA_EXPORT_SQL_FACTORY_SCHEMA_STRING \
-  "CREATE TABLE schema_info (version TEXT NOT NULL, " \
-  "reset_token TEXT); " \
+  "CREATE TABLE schema_info (version TEXT NOT NULL); " \
   RYGEL_MEDIA_EXPORT_SQL_FACTORY_CREATE_META_DATA_TABLE_STRING \
   "CREATE TABLE object (parent TEXT CONSTRAINT parent_fk_id " \
   "REFERENCES Object(upnp_id), " \
@@ -152,10 +149,7 @@ G_DEFINE_TYPE (RygelMediaExportSQLFactory, rygel_media_export_sql_factory, G_TYP
   "title TEXT NOT NULL, " \
   "timestamp INTEGER NOT NULL, " \
   "uri TEXT, " \
-  "flags TEXT, " \
-  "object_update_id INTEGER, " \
-  "deleted_child_count INTEGER, " \
-  "container_update_id INTEGER);" \
+  "flags TEXT);" \
   "INSERT INTO schema_info (version) VALUES ('" \
   RYGEL_MEDIA_EXPORT_SQL_FACTORY_SCHEMA_VERSION "'); "