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