title: Confusion: How does SQLiteOpenHelper onUpgrade() behave? And together with import of an old database backup?
body: <p>let's assume I have a database table test_table with 2 columns and a corresponding create script in the SQLiteOpenHelper:</p>
  
  <pre><code>DB_VERSION = 1:
  public void onCreate(SQLiteDatabase db)
  {
  db.execSql("CREATE table test_table (COL_A, COL_B);
  }
  </code></pre>
  
  <p>This is the initial app version 1, which is published in the Play Store.</p>
  
  <p>After a while there's an update to the app and the utilized database.
  I guess the SQLiteOpenHelper class has to be adapted like this:</p>
  
  <pre><code>DB_VERSION = 2:
  public void onCreate(SQLiteDatabase db)
  {
  db.execSql("CREATE table test_table (COL_A, COL_B, COL_C)");
  }
  
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  {
  db.execSql("ALTER TABLE test_table ADD Column COL_C");
  }
  </code></pre>
  
  <p>After some time, another app update:</p>
  
  <pre><code>DB_VERSION = 3:
  public void onCreate(SQLiteDatabase db)
  {
  db.execSql("CREATE table test_table (COL_A, COL_B, COL_C, COL_D)");
  }
  
  public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  {
  db.execSql("ALTER TABLE test_table ADD Column COL_D");
  }
  </code></pre>
  
  <p>--> This is where I need advice.
  If the user installs app version 1, he has Columns A and B. 
  If he then updates to version 2, onUpgrade fires and adds a column C. 
  New users who install from scratch get the 3 columns via the create statement.
  If the user then updates to version 3, onUpgrade fires again and a column D is added.
  But WHAT IF the user installs app version 1, then skips the update of version 2 and updates version 3? Then he would have missed the</p>
  
  <pre><code>public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  
      {
      db.execSql("ALTER TABLE test_table ADD Column COL_C");
      }
  </code></pre>
  
  <p>part and only </p>
  
  <pre><code>public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion)
  
      {
      db.execSql("ALTER TABLE test_table ADD Column COL_D");
      }
  </code></pre>
  
  <p>would be called, which leads to a table test_table(COL_A, COL_B, COL_D)??</p>
  
  <p>What's the correct way of handling database upgrades of a live app, so the user doesn't lose his data? 
  Do you have to check all possible (old) versions in the onUpgrade() method and execute different alter table statements based on that version?</p>
  
  <p>I am asking because in my app, the user has the possibility to export and import the data, which is nothing more than export: copy the whole database away and import: replace the app database with the backup copy database.</p>
  
  <p>What happens if the user has app version 1, exports the database, upgrades the app (new database structure) and imports the old version 1 backup? 
  --> How will SQLiteOpenHelper behave? 
  --> What is the correct way to handle db upgrades together with import/export functionality?</p>