create table attendee
(
    id           int auto_increment
        primary key,
    event_id     int          not null,
    prename      varchar(255) not null,
    lastname     varchar(255) not null,
    email        varchar(255) null,
    phone        varchar(255) not null,
    company_name varchar(255) not null,
    buffet       tinyint(1)   not null,
    constraint FK_1150D56771F7E88B
        foreign key (event_id) references event (id)
)
    collate = utf8mb4_unicode_ci;

create index IDX_1150D56771F7E88B
    on attendee (event_id);

INSERT INTO zedach.attendee (id, event_id, prename, lastname, email, phone, company_name, buffet) VALUES (7, 5, 'Tjark', 'Rasche', 't.rasche@rrooaarr.com', 'phone', '', 0);
INSERT INTO zedach.attendee (id, event_id, prename, lastname, email, phone, company_name, buffet) VALUES (8, 5, 'Valentin', 'Burkhardt', 'v.burkhardt@rrooaarr.com', 'phone', '', 0);
INSERT INTO zedach.attendee (id, event_id, prename, lastname, email, phone, company_name, buffet) VALUES (9, 5, 'Phillip', 'Schlichter', 'p.schlichter@rrooaarr.com', 'phone', '', 0);