Following CREATE TABLE conversion fails because of multiple problems

[avibrazil]

CREATE TABLE folder(
        id varchar not null
                primary key,
        library_id integer not null
                        references library (id)
                                on delete cascade,
        path varchar default '' not null,
        name varchar default '' not null,
        missing boolean default false not null,
        parent_id varchar default '' not null,
        num_audio_files integer default 0 not null,
        num_playlists integer default 0 not null,
        image_files jsonb default '[]' not null,
        images_updated_at datetime default '0000-00-00 00:00:00' not null,
        updated_at datetime default (datetime(current_timestamp, 'localtime')) not null,
        created_at datetime default (datetime(current_timestamp, 'localtime')) not null,
        hash varchar default '' not null
);

I think it fails because of jsonb that needs to be converted to MariaDB's json type. And because of date fields and their defaults.

[techouse]

@avibrazil, could you please be more descriptive? I’m not sure how to interpret your message. Also, why mention it’s a MariaDB error? Have you tried it with MySQL and found no issues? Details like this would help me pinpoint the problem and save time.

[techouse]

@avibrazil the master branch now successfully converts the above SQLite DDL to MySQL

[avibrazil]

It’s not me. This is Navidrome’s SQLite DB.

Thanks for fixing it