Table intraacl_badlinks cannot be created in MariadB 10.1.26

[karstengit]

The primary key including bl_title is to long!
It only works with
PRIMARY KEY (bl_from, bl_namespace),
KEY (bl_namespace, bl_title)

This fails:

CREATE TABLE IF NOT EXISTS intraacl_badlinks (
bl_from INT UNSIGNED NOT NULL,
bl_namespace INT NOT NULL,
bl_title VARCHAR(255) BINARY NOT NULL,
PRIMARY KEY (bl_from, bl_namespace, bl_title),
KEY (bl_namespace, bl_title)
)

MySQL meldet: Dokumentation
#1071 - Schlüssel ist zu lang. Die maximale Schlüssellänge beträgt 767

=> maximum key length 767