Instead, simply have a function for each upgrade step, ie
current_version = upgrade_step_10( current_version );

And one master function that calls ALL of those functions in order.
The trick is that each function checks the current_version parameter to see if this step should be performed. If not, then it just returns current_version.

Something like that.

You can put all the functions in a nice big array of function pointers (yes it was in C++) and for loop through them.

An additional trick is to ensure that after each step, you also write back to the DB what the new version number is.

That way if the upgrade breaks half way through, it is possible to continue the upgrade later (although hand-fixing may be required if a step breaks halfway through).

I’m having to deal with changing my schema for the first time.

Do I just:
1) Change this var: public static final int DB_VERSION = 1; which is fed into SQLiteOpenHelper’s constructor
2) Add some code in onUpgrade() like you have here

Do I also change my onCreate() to reflect the new schema OR do I leave it as is (the version 1 schema)?

Thanks for any help!

public void onUpgrade(
final SQLiteDatabase db, final int oldVersion,
final int newVersion)
{
int upgradeTo = oldVersion + 1;
switch (upgradeTo)
{
case 5:
db.execSQL(SQLiteSet.V5_ADD_LAST_CARD);
db.execSQL(SQLiteCard.V5_ADD_FAILED);
case 6:
db.execSQL(SQLiteSet.V6_ADD_IMPORT_TYPE);
case 7:
db.execSQL(SQLiteSet.V7_ADD_SHORT_FNAME);
break;
}
}

So if upgradeTo is 6, it will do both case 6 & 7