id summary reporter owner description type status component version severity resolution keywords cc stage has_patch needs_docs needs_tests needs_better_patch easy ui_ux 13852 Add AUTOINCREMENT on Sqlite table creation Maurizio Totti nobody "When i select sdlite3 db engine, id field on objects are converted in: {{{ ""id"" integer NOT NULL PRIMARY KEY }}} but this definition cause the reuse of canceled ""id"" on table (see [http://www.sqlite.org/faq.html#q1] )[[BR]] Adding [http://www.sqlite.org/autoinc.html AUTOINCREMENT] in ""id"" definition statement, will make the same behavior on pgsql, mysql and sqlite engine." closed Database layer (models, ORM) 1.2 duplicate sqlite Unreviewed 0 0 0 0 0 0