[rygel-gst-0-10-plugins] Revert SQL strings to schema version 11.
- From: Krzesimir Nowak <krnowak src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [rygel-gst-0-10-plugins] Revert SQL strings to schema version 11.
- Date: Tue, 5 Feb 2013 15:22:01 +0000 (UTC)
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 "'); "
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]