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