Issue Bug Closed

#14354MySQL gt 4.1 no default value for auto inc

Stefan Kreisberg 10/12/04, 11:19 updated 08/12/06, 14:25

Description

In MySQL > 4.0 default values for auto_inc columns are ignored, in MySQL > 4.1 they produce an error. Many extensions (perhaps created with the extrepwiz?) create sql schemas with auto_inc wich have default values …

example:
replace the line uid int(11) NOT NULL default ‘0’ auto_increment with uid int(11) unsigned NOT NULL auto_increment – I’d like to fix all extensions but do not know howto :D
(issue imported from #M416)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.