foreign keys are no longer visible in the "foreign keys" tab of the table description, nor in the "Code CREATE" tab while a "SHOW CREATE TABLE" query displays them correctly
Thanks for the details. Can confirm that!
Reason is that MySQL 5.0 did not have the
REFERENTIAL_CONSTRAINTS view in
information_schema. The query for the detection shows an error in the log panel:
SELECT * FROM `information_schema`.`COLUMNS` WHERE TABLE_SCHEMA='test' AND TABLE_NAME='t_child_foo' ORDER BY ORDINAL_POSITION; SHOW INDEXES FROM `t_child_foo` FROM `test`; SELECT * FROM information_schema.REFERENTIAL_CONSTRAINTS WHERE CONSTRAINT_SCHEMA='test' AND TABLE_NAME='t_child_foo' AND REFERENCED_TABLE_NAME IS NOT NULL; /* SQL Error (1109): Unknown table 'referential_constraints' in information_schema */
That view was introduced later (in MySQL 5.1 I think).
I would anyway highly recommend updating MySQL here. MySQL 5.0 is from 2008.
Please login to leave a reply, or register at first.