CREATE TABLE `locations` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `conferences_id` INT NOT NULL , `name` VARCHAR( 128 ) NOT NULL ) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;