I have used a database creation script for months under 3.23.53a. Now, I want to upgrade to version 4.0.5 and the script doesn't work. The first table is created but mysql complains with:
Error 1005 at line 10 Can't create table ./dbdir/tblbasestados.frm (errno:150) CREATE TABLE tblbasregiones( intregion INTEGER PRIMARY KEY, strregion VARCHAR(30) NOT NULL ) TYPE=InnoDB ; CREATE TABLE tblbasestados( // this is line 10 intestado INTEGER PRIMARY KEY, strestado VARCHAR(50) NOT NULL, intregion INTEGER NOT NULL, INDEX(intregion), FOREIGN KEY (intregion) REFERENCES tblbasregiones(intregion) ON DELETE RESTRICT ON UPDATE CASCADE ) TYPE=InnoDB ; MySQL-MAX running under Mandrake 9.0 I just can't spot what's wrong. Any help will be truly appreciated. Adolfo --------------------------------------------------------------------- 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