I tried to create the following table with the ERROR 1005 returned
CREATE TABLE goal_measure_type
(
goal_measure_type_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (goal_measure_type_id),
name VARCHAR(60) NOT NULL,
description VARCHAR(200),
success_factor FLOAT,
task_measure_id INT,
FOREIGN KEY (task_measure_id) REFERENCES task_measure_type (task_measure_type_id)
)ENGINE = InnoDB;
I already have the task_measure_type table defined as:
CREATE TABLE task_measure_type
(
task_measure_type_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (task_measure_type_id),
name VARCHAR(60) NOT NULL,
description VARCHAR(200),
success_factor FLOAT
)ENGINE = InnoDB;