During an upgrade, I want to add a new table to my database, but I want also not lose the data from the other tables when upgrading the application. Can someone tell me, how can I do ? 

It is possible ?

```
@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_GROUPS_TABLE);
    db.execSQL(CREATE_A_GROUPS_TABLE);
    db.execSQL(CREATE_MESSAGES_TABLE);
    db.execSQL(CREATE_REPORTING_TABLE);
    db.execSQL(CREATE_SUCC_SENDING_TABLE);
    db.execSQL(CREATE_NOTIFICATIONS_TABLE);
    db.execSQL(CREATE_RECEIVES_TABLE); // new table
}

@Override
public void onUpgrade(SQLiteDatabase db,  final int oldVersion,
                      final int newVersion) {

    db.execSQL("DROP TABLE IF EXISTS " + GROUPS);
    db.execSQL("DROP TABLE IF EXISTS " + NOTIFICATIONS);
    db.execSQL("DROP TABLE IF EXISTS " + A_GROUP);
    db.execSQL("DROP TABLE IF EXISTS " + MESSAGES);
    db.execSQL("DROP TABLE IF EXISTS " + REPORTING);
    db.execSQL("DROP TABLE IF EXISTS " + SUCC_SENDING);
    db.execSQL("DROP TABLE IF EXISTS " + RECEIVES); //new table
    onCreate(db);
}

```

My new table is `RECEIVES`

---

**Updated**

Current version is `1`. I want to change it to `2` .

```
public MainDB(Context context) {
    super(context, DATABASE_NAME, null, 1);
}

@Override
public void onCreate(SQLiteDatabase db) {
    db.execSQL(CREATE_GROUPS_TABLE);
    db.execSQL(CREATE_A_GROUPS_TABLE);
    db.execSQL(CREATE_MESSAGES_TABLE);
    db.execSQL(CREATE_REPORTING_TABLE);
    db.execSQL(CREATE_SUCC_SENDING_TABLE);
    db.execSQL(CREATE_NOTIFICATIONS_TABLE);
    //db.execSQL(CREATE_RECEIVES_TABLE); //new table
}

@Override
public void onUpgrade(SQLiteDatabase db,  final int oldVersion,
                      final int newVersion) {

    db.execSQL("DROP TABLE IF EXISTS " + GROUPS);
    db.execSQL("DROP TABLE IF EXISTS " + NOTIFICATIONS);
    db.execSQL("DROP TABLE IF EXISTS " + A_GROUP);
    db.execSQL("DROP TABLE IF EXISTS " + MESSAGES);
    db.execSQL("DROP TABLE IF EXISTS " + REPORTING);
    db.execSQL("DROP TABLE IF EXISTS " + SUCC_SENDING);
   // db.execSQL("DROP TABLE IF EXISTS " + RECEIVES); // new table
    onCreate(db);
}

```