This project is read-only.

Why no foreign keys?

Topics: General
Jan 4, 2015 at 9:11 PM
Why does Orchard not use foreign keys?

For example, the Orchard_Roles_RolesPermissionsRecord table is related to the Orchard_Roles_RoleRecord and 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...