CREATE TABLE rooms (
	id INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
	name VARCHAR(255) NOT NULL UNIQUE
) ENGINE=InnoDB;

CREATE TABLE room_activities (
	room_id INT NOT NULL,
	activity_date DATE NOT NULL,
	activity_name VARCHAR(255) NOT NULL,
	created TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
	updated TIMESTAMP,
	PRIMARY KEY (room_id, activity_date),
	FOREIGN KEY fk_room (room_id) REFERENCES rooms (id)
) ENGINE=InnoDB;