Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
4.2.0, 4.3.0, 4.4.0
-
None
Description
In eZ Publish it is quite common to always map integers as INT(11). This is bad database design. See the attached script for test and patch.You need to keep the key lengthz of all keys as short as possible. e.g. ezcontentobject.is_published should be 1 not 11. ezcontentobject.id should be 8 not 11 and so on. This pathc is quite important for larger databases.
Attachments
Issue Links
- duplicates
-
EZP-15534 Field types declaration should be more relevant
- Closed