title: Create a table without rowid with peewee
body: <p>I'm creating a small python program and i use the ORM peewee to manage my Sqlite database. I want to create a table without primary key using peewee. The problem is that peewee is adding a primary key if i dont specify one. After read the docs, i found the parameter without_rowid supposed to prevent peewee to create this primary key. But it doesnt works.</p>
  
  <p>Here is a small example of code : </p>
  
  <pre><code>#!/usr/bin/python
  import peewee
  import traceback
  
  db_proxy = peewee.Proxy()
  class BaseModel(peewee.Model):
      class Meta:
          database = db_proxy
  
  class table1(BaseModel):
      id = peewee.IntegerField(primary_key=True)
      field1 = peewee.CharField()
      field2 = peewee.IntegerField()
  
  class table2(BaseModel):
      table1_id = peewee.IntegerField()
      field1 = peewee.CharField()
      class Meta:
          without_rowid = True
  
  try:
      # create database
      db = peewee.SqliteDatabase("test.db")
      db_proxy.initialize(db)
      db.create_tables([table1, table2])
  except Exception as e:
      traceback.print_exc(e)
  
  </code></pre>
  
  <p>Same with the without_rowid, peewee automatically add an id primary key to my table2 table. Here is the schema of the created database :</p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS "table1"(
    "id" INTEGER NOT NULL PRIMARY KEY,
    "field1" VARCHAR(255) NOT NULL,
    "field2" INTEGER NOT NULL
  );
  CREATE TABLE IF NOT EXISTS "table2"(
    "id" INTEGER NOT NULL PRIMARY KEY,
    "table1_id" INTEGER NOT NULL,
    "field1" VARCHAR(255) NOT NULL
  ) WITHOUT ROWID;
  </code></pre>
  
  <p>Do you know a way to solve this problem and permit me to create a table without rowid ? </p>
  
  <p>ps : if you're asking why i want to create a table without primary key, it's because i need to insert data from a csv file. (sqlite3 database.db ".mode csv" ".import file.csv table1"). As i have an AUTO INCREMENT PRIAMRY KEY on my table, i need to trick a little bit by importing the csv file in a temporary table without primary key as explained here : <a href="http://objectiveme.com/populating-a-sqlite-database-using-csv/" rel="nofollow noreferrer">http://objectiveme.com/populating-a-sqlite-database-using-csv/</a></p>
  
  <p>Thx ! :)</p>