The linktarget text DEFAULT '' NOT NULL definition in ext_tables.sql (line 52) fails on MySQL 8.0, which prohibits non-NULL defaults for TEXT columns, while MariaDB 10.4 accepts it. Removing DEFAULT '' would make it compatible with both database systems.
Environment: brofix 6.3.1, TYPO3 12.4.42, MySQL 8.0.43 (fails) vs MariaDB 10.4.34 (works)