Unanswered: order of tables in DDL statement
Am I correct that a parent table must precede a child table (in a DDL statement) or get a errno150?
That's my conclusion after several rounds of isolate and substitute.
BTW -- I had no problems (no errno 150) with a child table preceding a parent when building MyISAM tables. Is that because ref. integrity isn't forced with the MyISAM engine, or because something else was different?
In theory, there is no difference between theory and practice. In practice there is.
Ninety-three percent of all statistics are made-up on the spot.