commit f56031f626c2953ecba1dbc90a8b8f824937ccf4
author Dongwon Kang <dwkang@google.com> Tue Apr 18 14:08:47 2017 -0700
committer gitbuildkicker <android-build@google.com> Tue Apr 18 16:04:47 2017 -0700
tree ca884154104b5b164e0b0f1317990f94299701d9
parent 93ce40f15ea892ed8a27e9bab8b7261ccfc10757

Bump the DB version and refresh the preview tables

Test: build and apps start
Bug: 37473184
Change-Id: Ia82c5dedc5eb08eeb2cd1f212e0aa371284a4a09
(cherry picked from commit 6e47992608a74031f9477d84d3c640fa852146d0)

src/com/android/providers/tv/TvProvider.java

diff --git a/src/com/android/providers/tv/TvProvider.java b/src/com/android/providers/tv/TvProvider.java
index aa63f01..70595a6 100644
--- a/src/com/android/providers/tv/TvProvider.java
+++ b/src/com/android/providers/tv/TvProvider.java
@@ -83,7 +83,7 @@
     private static final boolean DEBUG = false;
     private static final String TAG = "TvProvider";
 
-    static final int DATABASE_VERSION = 33;
+    static final int DATABASE_VERSION = 34;
     static final String SHARED_PREF_BLOCKED_PACKAGES_KEY = "blocked_packages";
     static final String CHANNELS_TABLE = "channels";
     static final String PREVIEW_PROGRAMS_TABLE = "preview_programs";
@@ -953,12 +953,17 @@
                         + RecordedPrograms.COLUMN_REVIEW_RATING_STYLE + " INTEGER;");
                 db.execSQL("ALTER TABLE " + RECORDED_PROGRAMS_TABLE + " ADD "
                         + RecordedPrograms.COLUMN_REVIEW_RATING + " TEXT;");
+                oldVersion = 33;
+            }
+            if (oldVersion == 33) {
+                db.execSQL("DROP TABLE IF EXISTS " + PREVIEW_PROGRAMS_TABLE);
+                db.execSQL("DROP TABLE IF EXISTS " + WATCH_NEXT_PROGRAMS_TABLE);
                 db.execSQL(CREATE_PREVIEW_PROGRAMS_TABLE_SQL);
                 db.execSQL(CREATE_PREVIEW_PROGRAMS_PACKAGE_NAME_INDEX_SQL);
                 db.execSQL(CREATE_PREVIEW_PROGRAMS_CHANNEL_ID_INDEX_SQL);
                 db.execSQL(CREATE_WATCH_NEXT_PROGRAMS_TABLE_SQL);
                 db.execSQL(CREATE_WATCH_NEXT_PROGRAMS_PACKAGE_NAME_INDEX_SQL);
-                oldVersion = 33;
+                oldVersion = 34;
             }
             Log.i(TAG, "Upgrading from version " + oldVersion + " to " + newVersion + " is done.");
         }