I seem to have trouble getting DBD4 to create ActiveRecord-compatible
DDL statements. I have a database with a series of 1:n relationships
which should be easy to model. But, depending on the relationship type
I use, when I connect them in the ERD it either:
- starts cascading foreign keys like an avalanche, or
- fails to add ‘contraint fk_xxx foreign key (yyy) references (zzz)’ to
the DDL
Is there some setting in DBD4 which will allow it to output RoR-friendly
DDL statements and structure? (yes I know the product is unsupported
but MySQL Workbench is unusable)