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

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;
Added locations table and editor 2010-06-10 18:09:16 +00:00			CREATE TABLE `locations` (
			`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
correcting field name 2010-06-10 18:25:26 +00:00			`conferences_id` INT NOT NULL ,
Added locations table and editor 2010-06-10 18:09:16 +00:00			`name` VARCHAR( 128 ) NOT NULL
Always create new tables with UTF8 2010-06-10 18:36:10 +00:00			`) ENGINE = MYISAM CHARACTER SET utf8 COLLATE utf8_general_ci;`