How do I create an AUTOINCREMENT field? : A column declared INTEGER PRIMARY KEY will autoincrement.
In SQLite, table rows normally have a 64-bit signed integer ROWID which is unique among all rows in the same table.
If a table contains a column of type INTEGER PRIMARY KEY, then that column becomes an alias for the ROWID.
Inserting, updating, and deleting data in SQLite : http://zetcode.com/db/sqlite/datamanipulation/