Wrong order of table changes in update script

[GoogleCodeExporter]

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system?

SVN from 2010-03-09

Please provide any additional information below.

UpdateVersion110.php:

You must change the users table engine to InnoDB before setting the foreign
key:

ALTER TABLE pages ADD FOREIGN KEY (author_id) REFERENCES users (id) ON
UPDATE CASCADE ON DELETE CASCADE

otherwise the script will fail with an error 1005: can't create table
(errno: 150)

Original issue reported on code.google.com by kwut...@web.de on 9 Mar 2010 at 9:28

[GoogleCodeExporter]

Original comment by lowtower1974@gmail.com on 6 Apr 2010 at 9:38

• Changed state: Fixed