So once a creator->fk object is used (which creates the relation in the def file) the foreign key is set though, right? If this is true, then these tests should hold true:
1. If I delete a record, its foreign key record should delete automatically from the original primary key.
2. I should not be able to add a record to the relationship table that does not have a corresponding primary key to its foreign key.
I'm pretty sure I remember testing these things in the past with failed results.
If links automatically handles this, then the InnoDB db type should not have to be present in the mySQL.?.? Does links ever actually use the SQL command 'references table(column)' into SQL?
Are foreign keys REALLY only supported with Select types, and what does that mean to a person creating a new db?
Thanks,
- Jonathan
1. If I delete a record, its foreign key record should delete automatically from the original primary key.
2. I should not be able to add a record to the relationship table that does not have a corresponding primary key to its foreign key.
I'm pretty sure I remember testing these things in the past with failed results.
If links automatically handles this, then the InnoDB db type should not have to be present in the mySQL.?.? Does links ever actually use the SQL command 'references table(column)' into SQL?
Are foreign keys REALLY only supported with Select types, and what does that mean to a person creating a new db?
Thanks,
- Jonathan
