title: AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY - android
body: <p>I'm trying to create a table in my DB with an ID that is autoincrement itself but whenever I try to add the AUTOINCREMENT keyword to my query it tells me that :</p>
  
  <blockquote>
    <p>AUTOINCREMENT is only allowed on an INTEGER PRIMARY KEY</p>
  </blockquote>
  
  <p>Here is my query:</p>
  
  <pre><code>@Override
  public void onCreate(SQLiteDatabase db) {
      String sql = "CREATE TABLE IF NOT EXISTS " + TABLE_TASKS + " ( "
              + KEY_ID + "INTEGER PRIMARY KEY AUTOINCREMENT, "
              + KEY_NOTETITLE + " TEXT, " + KEY_NOTECONTENT + " Text, "
              + KEY_STATUS + " INTEGER)";
      db.execSQL(sql);
  }
  </code></pre>
  
  <p>I have also tried to write AUTO_INCREMENT but then I got syntax error.</p>
  
  <p>I found out that this is the source of the problem because whenever I try to remove the AUTOINCREMENT word it works fine.</p>
  
  <p>So... what do you think is the problem?</p>