MySQL up to 5.5 allows at maximum 64 characters for tablenames and fieldnames , thus no other DBAL implementation should use more than 64 characters.
This leads set the maximum size of the fields tablenames and fieldname to 64 chars.
The field sys_file_reference.fieldname should be varchar or char, not TINYTEXT.
since only fieldnames from the database are stored varchar(64) should be enough.
[TASK] Optimize columns in sys_file_reference
MySQL up to version 5.5 allows at maximum 64 characters for table-
and fieldnames. Other DBMS allow less. Since MySQL is our primary
database and DBAL could handle specialties.
This patch changes the fields tablenames, fieldname and table_local
to varchar(64) which currently is considered save.