sqlite - Android DBHelper Upgrade -

i have mozilla sqlite android app. in sqlite manager on firefox, i'm add row table.and when run program, database not updated.

so change oncreate , upgrade method bellow:

   @override public void oncreate(sqlitedatabase db) {       db.execsql("create table db_city");  }  @override public void onupgrade(sqlitedatabase db, int oldversion, int newversion) {      db.execsql("drop table if exist db_city");     oncreate(db);  } 

and change version of database.

but when run program again of data in app missing.

can me do? tanks.

dropping table deletes data in table.

1. you need copy data somewhere (probably best rename it).
2. delete database (probably best rename it).
3. create new database.
4. re-load (and convert) data.