Skip to content

Exported SQL broken syntax with MySQL 8 #103

@splatterb0y

Description

@splatterb0y

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions