Hi!! I am trying create the following tables:- CREATE TABLE Scenario ( Scenario CHAR(10) NOT NULL PRIMARY KEY, CopyFromScenario CHAR(10)) TYPE = InnoDB;
CREATE TABLE Attribute( Attribute CHAR(25) NOT NULL PRIMARY KEY, Type CHAR(25)) TYPE = InnoDB; CREATE TABLE AttributeValue( Attribute CHAR(25) NOT NULL, INDEX par_ind(Attribute), FOREIGN KEY (Attribute) REFERENCES Attribute(Attribute) , Value VARCHAR(150) NOT NULL, Scenario CHAR(10) NOT NULL, INDEX sce_ind(Scenario), FOREIGN KEY (Scenario) REFERENCES Scenario(Scenario) ) TYPE = INNODB; But for the third table AttributeValue it is giving the error as:- ERROR 1005: Can't create table '.\netaps\AttributeValue.frm' (errno: 150) Please help Urgent Thanks Amit Lonkar. Amit __________________________________________________ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php