diff options
author | daniel oeh <daniel.oeh@gmail.com> | 2015-02-01 14:12:40 +0100 |
---|---|---|
committer | daniel oeh <daniel.oeh@gmail.com> | 2015-02-01 14:12:40 +0100 |
commit | c9e8af52c24b405c65fc9220a6c5c573574df672 (patch) | |
tree | 2ac0c4b5a4bc5b3f2ffbccc6a6de878aed7e9840 /app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java | |
parent | 9659c18d899349d9be1573fb9520defc7d3a19cd (diff) | |
parent | 12f70ca7fcc4e651af25acca51d68ef3275ba780 (diff) | |
download | AntennaPod-c9e8af52c24b405c65fc9220a6c5c573574df672.zip |
Merge branch 'develop'1.0
Diffstat (limited to 'app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java')
-rw-r--r-- | app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java | 19 |
1 files changed, 17 insertions, 2 deletions
diff --git a/app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java b/app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java index ebb3780b7..10a3c1b32 100644 --- a/app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java +++ b/app/src/main/java/de/danoeh/antennapod/config/StorageCallbacksImpl.java @@ -13,7 +13,7 @@ public class StorageCallbacksImpl implements StorageCallbacks { @Override public int getDatabaseVersion() { - return 13; + return 14; } @Override @@ -105,9 +105,24 @@ public class StorageCallbacksImpl implements StorageCallbacks { } if (oldVersion <= 12) { db.execSQL("ALTER TABLE " + PodDBAdapter.TABLE_NAME_FEEDS - + " ADD COLUMN " + PodDBAdapter.KEY_IS_PAGED + " INTEGER DEFAULT 0"); + + " ADD COLUMN " + PodDBAdapter.KEY_IS_PAGED + " INTEGER DEFAULT 0"); db.execSQL("ALTER TABLE " + PodDBAdapter.TABLE_NAME_FEEDS + " ADD COLUMN " + PodDBAdapter.KEY_NEXT_PAGE_LINK + " TEXT"); } + if (oldVersion <= 13) { + // remove duplicate rows in "Chapters" table that were created because of a bug. + db.execSQL(String.format("DELETE FROM %s WHERE %s NOT IN " + + "(SELECT MIN(%s) as %s FROM %s GROUP BY %s,%s,%s,%s,%s)", + PodDBAdapter.TABLE_NAME_SIMPLECHAPTERS, + PodDBAdapter.KEY_ID, + PodDBAdapter.KEY_ID, + PodDBAdapter.KEY_ID, + PodDBAdapter.TABLE_NAME_SIMPLECHAPTERS, + PodDBAdapter.KEY_TITLE, + PodDBAdapter.KEY_START, + PodDBAdapter.KEY_FEEDITEM, + PodDBAdapter.KEY_LINK, + PodDBAdapter.KEY_CHAPTER_TYPE)); + } } } |