How to implement DBHelper upgrade method for SQLite
<p>I have a Content Provider that is backed by a SQLite database. Say I need to add a new column called goodTimes to the database. Say further that I cannot simply do </p>

<pre><code>@Override
public void onUpgrade(SQLiteDatabase sqLiteDatabase, int oldVersion, int newVersion) {
    sqLiteDatabase.execSQL("DROP TABLE IF EXISTS " + Dog.TABLE_NAME);
    onCreate(sqLiteDatabase);
}
</code></pre>

<p>as my user may have tasks in progress. So how do I upgrade the database? I also cannot simply not implement <code>onUpgrade</code> as I would end up with a SQLiteException when I try to query concerning <code>goodTimes</code>. So how do I implement <code>onUpgrade</code>?</p>