From 6e47992608a74031f9477d84d3c640fa852146d0 Mon Sep 17 00:00:00 2001 From: Dongwon Kang Date: Tue, 18 Apr 2017 14:08:47 -0700 Subject: Bump the DB version and refresh the preview tables Test: build and apps start Bug: 37473184 Change-Id: Ia82c5dedc5eb08eeb2cd1f212e0aa371284a4a09 --- src/com/android/providers/tv/TvProvider.java | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'src') 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 @@ public class TvProvider extends ContentProvider { 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 @@ public class TvProvider extends ContentProvider { + 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."); } -- cgit v1.2.3