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
26730	Make AutoField consistent between postgresql and mysql	Veit Heller	nobody	"'''The problem'''
Currently, (Big)*AutoField becomes an `integer AUTO_INCREMENT` field in MySQL whereas it becomes a `serial` in PostgreSQL (which is a positive integer).

'''The resolution?'''
Update the MySQL version to use the `serial` datatype (which is just a macro for `bigint unsigned not null auto_increment unique`).

'''Caveats'''
The MySQL serial datatype might introduce too many unwanted restrictions. If the community thinks this might break too much code, I would suggest to at least make the MySQL version unsigned too, to increase the consistency between the DB adapters."	Cleanup/optimization	closed	Database layer (models, ORM)	1.9	Normal	duplicate			Unreviewed	0	0	0	0	0	0