SQLITE insert
How do I create an AUTOINCREMENT field? : A column declared INTEGER PRIMARY KEY will autoincrement.
http://www.sqlite.org/faq.html#q1
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.
http://www.sqlite.org/autoinc.html
Inserting, updating, and deleting data in SQLite : http://zetcode.com/db/sqlite/datamanipulation/