CREATE TABLE `schedule` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `conferences_id` INT NOT NULL , `locations_id` INT NOT NULL , `events_id` INT NOT NULL , `hour` INT NOT NULL , `minute` INT NOT NULL , `duration` INT NOT NULL , `date` DATE NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;