Ticket #760 (assigned defect)
Autoincrementing primary keys for sqlite3
|Reported by:||Jonttu||Owned by:||andrew|
|Keywords:||sqlite3 autoincrement primary key||Cc:|
Sqlite3 re-uses primary keys by default. If a row is deleted, the next one will use the same id. This is bad and AFAIK other dbms always increment the primary key by default.
This can be fixed for sqlite3 by explicitely giving the autoincrement keyword for the primary key column.