MySQL #1005 error regarding foreign keys?

[harold kumar]

I'm trying to create this table

 

CREATE TABLE Message (

message_id INT UNSIGNED NOT NULL,

owner_id INT UNSIGNED NULL,

subject VARCHAR(255) NULL,

body TEXT NULL,

posted DATETIME NULL,

is_public TINYINT NULL DEFAULT false,

PRIMARY KEY (message_id),

INDEX ix_message_owner_id (owner_id),

CONSTRAINT cs_message_owner_id

FOREIGN KEY (owner_id)

REFERENCES `User` (user_id)

ON DELETE NO ACTION

ON UPDATE NO ACTION

)

ENGINE = InnoDB;

 

 

 

but i keep on getting this error

error messege: #1005 - Can't create table './pca/Message.frm' (errno: 150)

im guessing it has to do something with the foreign keys?!?

 

 

I am on phpMyAdmin 3.3.9.2

[fenway]

Are you sure the columns are identical?