InnoDB in Contao3

If you want to use InnoDB instead of MyISAM in Contao 3, you can just add „engine“ => „InnoDB“ to the specific DCA. Sadly this „feature“ is not documentated as of writing this.

I’ve found it here . That will look like this:

$GLOBALS['TL_DCA']['tl_shn_catalogs'] = array
(

    // Config
    'config' => array
    (
        'dataContainer' => 'Table',
        'enableVersioning' => true,
        'sql' => array
        (
            'keys' => array
            (
                'id' => 'primary'
            ),
            'engine' => 'InnoDB'
        )
    ),

However, you need to manually convert or delete your table – Contao won’t update it for you for existing tables.

No Comments

Post a Comment