public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) { //kiteworks starts with version 6 switch (oldVersion) { case 6: case 7: db.execSQL(String.format("ALTER TABLE %s ADD COLUMN %s TEXT DEFAULT ''", tableName, COLUMN_FILETYPE)); case 8: db.execSQL(String.format("ALTER TABLE %s ADD COLUMN %s INTEGER DEFAULT 0", tableName, COLUMN_QUARANTINE)); case 9: db.execSQL(String.format("ALTER TABLE %s ADD COLUMN %s INTEGER DEFAULT 0", tableName, COLUMN_SECURE)); case 12: db.execSQL(String.format("ALTER TABLE %s ADD COLUMN %s INTEGER DEFAULT 0", tableName, COLUMN_DLP_LOCK)); } }