create table migrations
(
    id        int unsigned auto_increment
        primary key,
    migration varchar(255) not null,
    batch     int          not null
)
    collate = utf8mb4_unicode_ci;

create table roles
(
    id   bigint unsigned auto_increment
        primary key,
    name varchar(20) not null
)
    collate = utf8mb4_unicode_ci;

create table setups
(
    id   bigint unsigned auto_increment
        primary key,
    name varchar(50) not null
)
    collate = utf8mb4_unicode_ci;

create table setup_role
(
    count    int             not null,
    setup_id bigint unsigned not null,
    role_id  bigint unsigned not null,
    primary key (setup_id, role_id),
    constraint setup_role_role_id_foreign
        foreign key (role_id) references roles (id)
            on delete cascade,
    constraint setup_role_setup_id_foreign
        foreign key (setup_id) references setups (id)
            on delete cascade
)
    collate = utf8mb4_unicode_ci;

create index setup_role_role_id_index
    on setup_role (role_id);

create index setup_role_setup_id_index
    on setup_role (setup_id);