title: Android Sqlite table has more than one primary key
body: <p>this below code is my database schema and after run <code>onCreate</code> method i get this error:</p>
  
  <pre><code>08-28 08:13:23.984    3214-3214/ir.tsms E/Database﹕ Failure 1 (table "ReceiveFields" has more than one primary key) on 0x1175f8 when preparing 'CREATE TABLE ReceiveFields(id INTEGER PRIMARY KEY   AUTOINCREMENT, lastId INTEGER  , smsNumber VARCHAR  , mobileNumber VARCHAR , senderName VARCHAR , smsBody TEXT , receiveDate VARCHAR , PRIMARY KEY (id));'.
  </code></pre>
  
  <p>DataBase create Schema Variable:</p>
  
  <pre><code>private static final String DATABASE_CREATE = "CREATE TABLE " + RECEIVE_FIELDS_TABLE + "("
          + COLUMN_ID +            " INTEGER PRIMARY KEY   AUTOINCREMENT, "
          + COLUMN_LASTID +        " INTEGER  , "
          + COLUMN_SMSNUMBER +     " VARCHAR  , "
          + COLUMN_MOBILENUMBER +  " VARCHAR , "
          + COLUMN_SENDERNAME +    " VARCHAR , "
          + COLUMN_SMSBODY +       " TEXT , "
          + COLUMN_RECEIVEDATE +   " VARCHAR , PRIMARY KEY (" + COLUMN_ID + "));";
  </code></pre>
  
  <p><code>Log.i</code> Result of <code>DATABASE_CREATE</code>:</p>
  
  <pre><code>CREATE TABLE ReceiveFields(
  
      id INTEGER PRIMARY KEY   AUTOINCREMENT, 
      lastId INTEGER  , 
      smsNumber VARCHAR  , 
      mobileNumber VARCHAR , 
      senderName VARCHAR , 
      smsBody TEXT , 
      receiveDate VARCHAR , 
      PRIMARY KEY (id)
  
  );
  </code></pre>
  
  <p>whats my create table problem? thanks</p>