[rygel] media-export: Fix upgrade from rygel 0.6
- From: Jens Georg <jensgeorg src gnome org>
- To: commits-list gnome org
- Cc:
- Subject: [rygel] media-export: Fix upgrade from rygel 0.6
- Date: Thu, 14 Jun 2012 06:48:20 +0000 (UTC)
commit 6e0cde13e2778f4d5342e3d29244e98d21068e9a
Author: Jens Georg <mail jensge org>
Date: Wed Jun 13 23:26:56 2012 +0200
media-export: Fix upgrade from rygel 0.6
.../rygel-media-export-media-cache-upgrader.vala | 6 +++---
1 files changed, 3 insertions(+), 3 deletions(-)
---
diff --git a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala
index 192d159..c2c109d 100644
--- a/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala
+++ b/src/plugins/media-export/rygel-media-export-media-cache-upgrader.vala
@@ -200,10 +200,10 @@ internal class Rygel.MediaExport.MediaCacheUpgrader {
try {
database.begin ();
database.exec ("DROP TABLE object_type");
+ database.exec ("DROP TRIGGER IF EXISTS trgr_delete_uris");
database.exec ("ALTER TABLE Object ADD COLUMN uri TEXT");
database.exec ("UPDATE Object SET uri = (SELECT uri " +
"FROM uri WHERE Uri.object_fk == Object.upnp_id LIMIT 1)");
- database.exec ("DROP TRIGGER IF EXISTS trgr_delete_uris");
database.exec ("DROP INDEX IF EXISTS idx_uri_fk");
database.exec ("DROP TABLE Uri");
database.exec ("UPDATE schema_info SET version = '6'");
@@ -284,13 +284,13 @@ internal class Rygel.MediaExport.MediaCacheUpgrader {
this.database.exec ("DROP TRIGGER trgr_delete_closure");
this.database.exec ("DROP INDEX idx_parent");
this.database.exec ("DROP INDEX idx_meta_data_fk");
- this.database.exec ("DROP INDEX idx_closure");
+ this.database.exec ("DROP INDEX IF EXISTS idx_closure");
this.database.exec ("DROP TABLE Closure");
// keep meta-data although we're deleting loads of objects
this.database.exec ("DROP TRIGGER trgr_delete_metadata");
- this.database.exec ("INSERT INTO Object (parent, upnp_id, " +
+ this.database.exec ("INSERT OR REPLACE INTO Object (parent, upnp_id, " +
"type_fk, title, timestamp) VALUES " +
"('0', '" +
RootContainer.FILESYSTEM_FOLDER_ID +
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]