title: How to add new table to sqlite?
body: <p>I need to add a new column name <code>id INTEGER AUTOINCREMENT</code> and a new table for the current database for my existing table. How to use 'onUpgrade'? Is it need to change the version number?</p>
  
  <pre><code>initDb() async {
      io.Directory documentsDirectory = await getApplicationDocumentsDirectory();
      String path = join(documentsDirectory.path, "HelperDatabase.db");
      var theDb = await openDatabase(path, version: 1, onCreate: _onCreate, onUpgrade: _onUpgrade);
      return theDb;
    }
  </code></pre>
  
  <p><strong>How to use <code>_onUpgrade</code></strong></p>
  
  <pre><code>void _onUpgrade(Database db, int oldVersion, int newVersion)async{
  
    }
  </code></pre>
  
  <p><strong>Is it need to add column also?</strong></p>
  
  <pre><code>void _onCreate(Database db, int version) async {
  
      await db.execute(
          """CREATE TABLE AssetAssemblyTable(e INTEGER, a INTEGER, c INTEGER)""");
  </code></pre>