title: Android: upgrading DB version and adding new table
body: <p>I've already created sqlite tables for my app, but now I want to add a new table to the database.</p>
  
  <p>I changed the DB version as below</p>
  
  <pre><code>private static final int DATABASE_VERSION = 2;
  </code></pre>
  
  <p>and Added string to create table</p>
  
  <pre><code>private static final String DATABASE_CREATE_color = 
     "CREATE TABLE IF NOT EXISTS files(color text, incident_id text)";
  </code></pre>
  
  <p><code>onCreate</code> and <code>onUpgrade</code> as below:</p>
  
  <pre><code>@Override
      public void onCreate(SQLiteDatabase database) {
          database.execSQL(DATABASE_CREATE_incident);
          database.execSQL(DATABASE_CREATE_audio);
          database.execSQL(DATABASE_CREATE_video);
          database.execSQL(DATABASE_CREATE_image);
  
      }
  
      @Override
      public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
          //drop table and add new tables when version 2 released.
          db.execSQL(DATABASE_CREATE_color);
  
      }
  </code></pre>
  
  <p>But for some reason the new table is not being created. What am I doing wrong?</p>