title: After deleting a row in SQLite, _ID of a new entry is not consecutive
body: <p>I use this method to delete a row in my sqlite db:</p>
  
  <pre><code>db.execSQL("delete from "+TABLE_NUMS+" where _ID = '" + this.rowID + "'");
  </code></pre>
  
  <p>and then I update the rest of Ids to make my entries consecutive:</p>
  
  <pre><code>db.execSQL("UPDATE "+TABLE_NUMS+" set _ID = (_ID - 1) WHERE _ID &gt; "+this.rowID);
  </code></pre>
  
  <p>And it works fine, but when I add new entries to my DB, the ID of the new entries still add as if the deleted entries existed, say I have 10 rows with IDs starting from 1 to 10, and then I delete number 5 and 6, the rows become 1 to 8, but the new entry's ID will be 11. So my IDs sequence would be 1 to 8 and 11. How can I fix this?</p>