Oganes, > I have the following create table, and I get the following error when I create it. > It used to work before. Can anyone help? > > CREATE TABLE PROTOCOL_GROUPING( > PROTOCOL_GROUPING_ID MEDIUMINT(20), > GROUP_NAME VARCHAR(50) NOT NULL, > PROTOCOL_ID MEDIUMINT(20) NOT NULL, > PROTOCOL_STEP_NO MEDIUMINT(10) NOT NULL, > foreign key (PROTOCOL_ID, PROTOCOL_STEP_NO) REFERENCES PROTOCOL_STEP(PROTOCOL_ID, >PROTOCOL_STEP_NO), UNIQUE INDEX PROTOCOL_GROUPING_PK (PROTOCOL_GROUPING_ID))Type=InnoDB; > > I get the following error: can't create table .\test\protocol_grouping.frm (errno >150)
=it works perfectly for me... =did you remove the existing tbl before attempting to re-run the CREATE? (I try to remember to put: DROP TABLE IF EXISTS tblNm; in every create .sql) =dn --------------------------------------------------------------------- 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