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
