Error "Foreign key constraint incorrectly formed" when updating plugin about oc-redirect-plugin HOT 2 CLOSED

create table vdlp_redirect_redirects
(
    id                      int unsigned auto_increment
        primary key,
    category_id             int unsigned                       null,
    match_type              varchar(12)                        null,
    target_type             varchar(12)  default 'path_or_url' not null,
    from_scheme             varchar(5)   default 'auto'        not null,
    from_url                mediumtext                         null,
    to_scheme               varchar(5)   default 'auto'        not null,
    to_url                  mediumtext                         null,
    test_url                mediumtext                         null,
    cms_page                varchar(255)                       null,
    static_page             varchar(255)                       null,
    requirements            text                               null,
    status_code             varchar(3)   default ''            not null,
    hits                    int unsigned default 0             not null,
    from_date               date                               null,
    to_date                 date                               null,
    sort_order              int unsigned default 0             not null,
    ignore_query_parameters tinyint(1)   default 0             not null,
    ignore_case             tinyint(1)   default 0             not null,
    ignore_trailing_slash   tinyint(1)   default 0             not null,
    is_enabled              tinyint(1)   default 0             not null,
    test_lab                tinyint(1)   default 0             not null,
    test_lab_path           mediumtext                         null,
    `system`                tinyint(1)   default 0             not null,
    description             varchar(255)                       null,
    last_used_at            timestamp                          null,
    created_at              timestamp                          null,
    updated_at              timestamp                          null,
    constraint vdlp_redirect_redirects_category_id_foreign
        foreign key (category_id) references vdlp_redirect_categories (id)
            on delete set null
)
    collate = utf8mb4_unicode_ci;

create index vdlp_redirect_redirects_is_enabled_index
    on vdlp_redirect_redirects (is_enabled);

create index vdlp_redirect_redirects_sort_order_index
    on vdlp_redirect_redirects (sort_order);

create table vdlp_redirect_redirect_logs
(
    id          int unsigned auto_increment
        primary key,
    redirect_id int unsigned          not null,
    from_url    mediumtext            not null,
    to_url      mediumtext            not null,
    status_code varchar(3) default '' not null,
    day         tinyint unsigned      not null,
    month       tinyint unsigned      not null,
    year        smallint unsigned     not null,
    date_time   datetime              not null,
    constraint vdlp_redirect_log
        foreign key (redirect_id) references vdlp_redirect_redirects (id)
            on delete cascade
)
    collate = utf8mb4_unicode_ci;

create index redirect_log_dmy
    on vdlp_redirect_redirect_logs (redirect_id, day, month, year);

create index redirect_log_my
    on vdlp_redirect_redirect_logs (redirect_id, month, year);