Opened 14 years ago
Closed 14 years ago
#13852 closed (duplicate)
Add AUTOINCREMENT on Sqlite table creation
Reported by: | Maurizio Totti | Owned by: | nobody |
---|---|---|---|
Component: | Database layer (models, ORM) | Version: | 1.2 |
Severity: | Keywords: | sqlite | |
Cc: | Triage Stage: | Unreviewed | |
Has patch: | no | Needs documentation: | no |
Needs tests: | no | Patch needs improvement: | no |
Easy pickings: | no | UI/UX: | no |
Description
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 )
Adding AUTOINCREMENT in "id" definition statement, will make the same behavior on pgsql, mysql and sqlite engine.
Note:
See TracTickets
for help on using tickets.
Duplicate of #10164.