title: autoincrement column remembers its last value in SQLite table
body: <p>In one table I have a column that's an auto-incrementing primary key. </p>
  
  <p>The problem is this scenario:</p>
  
  <ul>
  <li>4 rows are inserted</li>
  <li>those 4 are then subsequently deleted</li>
  <li>insert a new row, and the the auto-increment column value is <code>5</code></li>
  </ul>
  
  <p>How can I get this auto-increment column to have value of <code>1</code>?</p>