Actions
Bug #14378
closed
MySQL 4.1.7 does not tolerate DEFAULT '0' with AUTO_INCREMENT
Start date:
2004-11-08
Due date:
% Done:
0%
Estimated time:
TYPO3 Version:
3.7.0
PHP Version:
Tags:
Complexity:
Is Regression:
Sprint Focus:
Description
With MySQL 4.1.7 (at least, that's what we've tested with), MySQL does not accept "DEFAULT '0'" when used with a primary key, thus, tables that have these will not be created. Basically that means that all integer fields that are used as primary key in tables will be generated the wrong way. TYPO3 generates e.g.
uid int(11) auto_increment default '0' not null primary key
The "default '0'" is not tolerated by MySQL in this case anymore.
(issue imported from #M472)
Updated by
Actions