[BUGFIX] sys_collection_entries column too small 71/31571/3
authorWouter Wolters <typo3@wouterwolters.nl>
Thu, 10 Jul 2014 18:37:44 +0000 (20:37 +0200)
committerStefan Neufeind <typo3.neufeind@speedpartner.de>
Sun, 20 Jul 2014 21:20:24 +0000 (23:20 +0200)
Set sys_collection_entries to varchar(64). This is the max
table name length on MySQL.

Resolves: #60180
Releases: 6.3,6.2
Change-Id: I253e6eb6cb35db9e6d13a716bfc5c8d89db4ca7e
Reviewed-on: https://review.typo3.org/31571
Reviewed-by: Markus Klein <klein.t3@reelworx.at>
Tested-by: Markus Klein <klein.t3@reelworx.at>
Reviewed-by: Oliver Klee <typo3-coding@oliverklee.de>
Reviewed-by: Ernesto Baschny <ernst@cron-it.de>
Reviewed-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
Tested-by: Stefan Neufeind <typo3.neufeind@speedpartner.de>
typo3/sysext/core/ext_tables.sql

index 071705e..b72bcfa 100644 (file)
@@ -530,7 +530,7 @@ CREATE TABLE sys_collection_entries (
        uid int(11) NOT NULL auto_increment,
        uid_local int(11) DEFAULT '0' NOT NULL,
        uid_foreign int(11) DEFAULT '0' NOT NULL,
-       tablenames varchar(30) DEFAULT '' NOT NULL,
+       tablenames varchar(64) DEFAULT '' NOT NULL,
        sorting int(11) DEFAULT '0' NOT NULL,
 
        KEY uid_local (uid_local),