title: Why does Sqlite create a new table that I have not specified within my create_tables.py file
body: <p>So I have a file called create_tables.py with the following code:</p>
  <pre><code>import sqlite3
  
  connection = sqlite3.connect(&quot;mydata.db&quot;)
  
  cursor = connection.cursor()
  
  create_table = &quot;CREATE TABLE IF NOT EXISTS users (id INTEGER PRIMARY KEY, username text, password text)&quot;
  
  cursor.execute(create_table)
  
  create_table = &quot;CREATE TABLE IF NOT EXISTS items (id INTEGER PRIMARY KEY, name text, price real)&quot;
  cursor.execute(create_table)
  
  connection.commit()
  connection.close()
  </code></pre>
  <p>When trying to make a GET request via postman I am provided this error:</p>
  <pre><code>sqlite3.OperationalError: no such table: items
  </code></pre>
  <p>But there is a table that has been created called <code>item_model</code>.
  <a href="https://i.stack.imgur.com/59DT1.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/59DT1.png" alt="enter image description here" /></a></p>
  <p>I didn't specify the creation of this table. I am wondering why my <code>items</code> table is not being created but this <code>item_model</code> table was.</p>