Skip to content

[BUG] uuid field of MariaDB (and MySQL) throws error - currently unknown #361

Closed
@datenbank-projekt

Description

@datenbank-projekt

Describe the bug
trying to import MariaDB SQL to create the diagram fails because some definition is expected - but uuid is present.
In the current MariaDB this is a valid fieldtype: https://mariadb.com/kb/en/uuid-data-type/
This fails in Line 2 at "uuid"

CREATE TABLE IF NOT EXISTS address_book_fields (
address_book_id uuid DEFAULT NULL,
field_id uuid NOT NULL,
column_name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
name varchar(255) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL,
default_field tinyint(4) NOT NULL,
optional_default_field tinyint(4) NOT NULL,
sort_key int(11) NOT NULL,
PRIMARY KEY (field_id),
KEY IX_address_book_id (address_book_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

expected:
create a table like this

Here a screenshot of the trial to import the SQL above as MariaDB

Image

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