title: How to create multiple tables in a database in sqflite?
body: <p>Im building and app with flutter that uses SQLite database. I have created first table using this piece of code:</p>
  
  <pre><code> void _createDb(Database db, int newVersion) async {
      await db.execute('''CREATE TABLE cards (id_card INTEGER PRIMARY KEY, 
           color TEXT, type TEXT, rarity TEXT, name TEXT UNIQUE, goldCost INTEGER,
           manaCost INTEGER, armor INTEGER, attack INTEGER, health INTEGER, description TEXT)''');
  }
  </code></pre>
  
  <p>Table gets created and I can access it without problems.</p>
  
  <p>Unfortunately I cannot include more than 1 table that i just created. I tried adding another SQL CREATE TABLE clause in the same method, and repeating method <code>db.execute</code> with a different SQL clause just in the next line.</p>
  
  <p>I'm mimicing code from this tutorial: <a href="https://www.youtube.com/watch?v=xke5_yGL0uk" rel="noreferrer">https://www.youtube.com/watch?v=xke5_yGL0uk</a></p>
  
  <p>How to add another table within the same database?</p>