#50466MySQL: Use ENGINE instead of deprecated TYPE for storage-engine
Description
CREATE-statements often still use TYPE instead of ENGINE. Since those statements are analysed already it should be possible to substitute this parameter quite easy.
I just had CREATE-statements failing (!) because of TYPE being used on MySQL 5.5.something. I can’t say exactly since when it was dropped finally but it’s definitely deprecated since 4.x
http://dev.mysql.com/doc/refman/4.1/en/create-table.html states “ENGINE was added in MySQL 4.0.18 (for 4.0) and 4.1.2 (for 4.1).” and then notes that TYPE is deprecated
Reviews 5
- TYPO3_4-5 22798[BUGFIX] MySQL: Use ENGINE (not TYPE) for storage-engine
- TYPO3_4-7 22797[BUGFIX] MySQL: Use ENGINE (not TYPE) for storage-engine
- TYPO3_6-1 22792[BUGFIX] MySQL: Use ENGINE (not TYPE) for storage-engine
- TYPO3_6-0 22793[BUGFIX] MySQL: Use ENGINE (not TYPE) for storage-engine
- main 22592[BUGFIX] MySQL: Use ENGINE (not TYPE) for storage-engine