|Subject:||SQLT deployment on MySQL attempts to create a self-referencing foreign key constraint|
MySQL does not support foreign keys pointing to itself:MySQL supports foreign key references between one column and another within a table. (A column cannot have a foreign key reference to itself.) When SQLT tries to deploy my schema, I get the following error: "Can't create table 'foo.bar' (errno: 150)..." which contains the following SQL: CONSTRAINT `foo_fk_root_id` FOREIGN KEY (`root_id`) REFERENCES `foo` (`root_id`) Adding "is_foreign_key_constraint => 0" to each of the generated relationships seems to remove the problem and allows my schema to be auto-deployed. I'm unsure if this issue is problematic against other DBs. I know for sure that SQLite is not affected.