Message

create table message
(
    id           bigint auto_increment
        primary key,
    contents     text         not null,
    created_at   datetime     null,
    message_type varchar(255) not null,
		room_id      bigint       null,
)
    engine = MyISAM;

create index FKl1kg5a2471cv6pkew0gdgjrmo
    on message (room_id);

Room

create table room
(
    id    bigint auto_increment
        primary key,
    title varchar(20) not null
)
    engine = MyISAM;