title: SQLite auto increment not working
body: <p>ok this isn't spamming and it's supposed to be simple I don't know why it's not working
  this is my code:</p>
  
  <pre><code>gamesdatabase = openOrCreateDatabase("GamesDatabase", MODE_PRIVATE, null);
  gamesdatabase.execSQL("CREATE TABLE IF NOT EXISTS Games (ID INTEGER PRIMARY KEY, Name
  VARACHAR, NPlayers INT(1), NRounds INT(2), WinScore INT(2));");
  
  gamesdatabase.execSQL("INSERT INTO Games 
  (ID, Name, NPlayers, NRounds, WinScore ) VALUES ( NULL, 'TAWLA',2,0,0 );");
  
  gamesdatabase.execSQL("INSERT INTO Games 
  (ID, Name, NPlayers, NRounds, WinScore ) VALUES ( NULL, 'DOMANA',4,0,0 );");
  
  
  Cursor c = gamesdatabase.rawQuery("SELECT * FROM Games", null);
  c.moveToFirst();
  while (c.isAfterLast() == false) {
  Log.d("BEZRA", String.valueOf(c.getInt(c.getColumnIndex("ID"))));
  c.moveToNext();
  }
  </code></pre>
  
  <p>what's wrong with this ? the log displays 0 for all records</p>