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.

Change History (1)

comment:1 by Ramiro Morales, 14 years ago

Resolution: duplicate
Status: newclosed

Duplicate of #10164.

Note: See TracTickets for help on using tickets.
Back to Top