Thanks a lot. IŽll stick to 3.23.53 until 4.0.6 appears. Adolfo
> -----Original Message----- > From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] > Sent: Sunday, December 08, 2002 4:21 PM > To: [EMAIL PROTECTED] > Subject: Re: May someone try this script under Mandrake 9 and > Mysql 4.0.5 > > > Adolfo, > > ----- Original Message ----- > From: ""Adolfo Bello"" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Sent: Sunday, December 08, 2002 12:47 AM > Subject: May someone try this script under Mandrake 9 and Mysql 4.0.5 > > > > 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) > > > > = = = SCRIPT TO TRY = = = > > 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 ; > > = = = END OF SCRIPT = = = > > > > I just can't spot what's wrong and want to know if there is > something > > wrong in my installation. > > InnoDB does not support ON UPDATE CASCADE yet, though the > support may be available already in 4.0.6. > > 3.23 just ignores the ON UPDATE clause, but 4.0.5 gives an > error 150 from it. > > > Thanks in advance, > > > > Adolfo > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at > https://order.mysql.com/ See > http://www.innodb.com for the > online manual and latest news on InnoDB > > sql query > > > > > --------------------------------------------------------------------- > 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 > > > > --------------------------------------------------------------------- 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
