mtgsqlive icon indicating copy to clipboard operation
mtgsqlive copied to clipboard

Exported SQL broken syntax with MySQL 8

Open splatterb0y opened this issue 3 months ago • 0 comments

Import from console prints: ERROR 1170 (42000) at line 254: BLOB/TEXT column 'uuid' used in key specification without a key length

CREATE TABLE cardForeignData ( id INTEGER PRIMARY KEY AUTO_INCREMENT, faceName TEXT, flavorText TEXT, identifiers TEXT, language TEXT, multiverseId INTEGER, name TEXT, text TEXT, type TEXT, uuid TEXT )ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

The syntax for the uuid field does not match the syntax of the uuid field in other tables which is: uuid VARCHAR(36) NOT NULL

splatterb0y avatar Sep 28 '25 22:09 splatterb0y