Why does Orchard not use foreign keys?
For example, the
Orchard_Roles_RolesPermissionsRecord table is related to the
Orchard_Roles_PermissionRecord table, yet there are no foreign keys. In fact, after a default install, there are no foreign keys at all in the entire database. I know that foreign keys can be created in
the migration methods and that everything will work fine without them, but there must be a reason they aren't used...