I have an app deployed on play store. I use SQLite database. The app that is on play store have db version 3. Now for the upcoming update I want to add another column to the table in the database, so I am going to increase db version to 4. I have made that logic inside my onUpgrade() method. I am just wondering how you find it, how you get around this kind of situation, for even further updates like the one with db version 5. I just want to get your opinions. Thanks a lot.

```
@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        //when deployed to play store version was 3
        //update db table. And increase db version on top

        String queryForDBVersion4 = "ALTER TABLE " + TABLE_NAME + " ADD noteColor TEXT";
//        String queryForDBVersion5;

        switch (newVersion){
            case 4:
                db.execSQL(queryForDBVersion4);
                break;
//            case 5:       //FOR FUTURE USE
//                if(oldVersion==4){db.execSQL(queryForDBVersion5);}
//                else{
//                    db.execSQL(queryForDBVersion4);
//                    db.execSQL(queryForDBVersion5);
//                }
//                break;
//            case 6: SO ON...  
        } 
}

```