science-ation/db/db.update.178.sql

11 lines
334 B
SQL

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;