re:FOREIGN KEY{ERROR:1005/150}

[email protected] (mrfroasty)
Newsgroups php.db
Message-ID <[email protected]>
Hello,
I have been browsing on mysql manual
<http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html>
with not much of success.I am trying to put 2 foreign keys(from
different external table) on my table, but if I put the 2nd one it
fails.....here is my table

CREATE TABLE pack_accomodation (
                id int(16) NOT NULL auto_increment,
                pack_id int(16) NOT NULL ,
                hotel_id int(16) NOT NULL ,
                PRIMARY KEY (id),
                INDEX (pack_id),
                FOREIGN KEY (pack_id) REFERENCES pack(items_no)
                ON DELETE CASCADE
                ON UPDATE CASCADE,
                INDEX (hotel_id),
                FOREIGN KEY (hotel_id) REFERENCES hotel(items_no)
)ENGINE=INNODB;


I can get rid of the 2nd foreign key with programming, but I think it
should be possible to have them both...I just I cant figure out why it
fails with this error:
ERROR 1005 (HY000): Can't create table './tabasam/pack_accomodation.frm'
(errno: 150) For description of the error
<http://dev.mysql.com/doc/refman/5.0/en/innodb-error-codes.html>

Thanks guys, any help would really appreciate it.



-- 
Extra details:
OSS:Gentoo Linux-2.6.25-r8
profile:x86
Hardware:msi geforce 8600GT asus p5k-se
location:/home/muhsin
language(s):C/C++,VB,VHDL,bash
Typo:40WPM
url:http://mambo-tech.net
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.