create database if not exists ChatCinema;

use ChatCinema;

create table if not exists rooms (
    roomId int not null primary key,
    roomName varchar(50) not null,
    roomHost varchar(50) not null
);

create table if not exists historys (
    historyId int not null primary key,
    username varchar(50) not null,
    message varchar(500) not null
);

create table if not exists roomHistorys(
    historyId int not null,
    roomId int not null,
    primary key (historyId, roomId),
    foreign key(roomId) references rooms(roomId),
    foreign key(historyId) references historys(historyId)
);