Skip to:
Content
Pages
Categories
Search
Top
Bottom

No Foreign Key Relationships?

  • Avatar of dqj
    dqj
    Participant

    @dqj

    I was just looking through the tables for my BuddyPress installation and noticed there are no foreign key relationships specified between some tables — wp_bp_groups and wp_bp_groups_members, for example.

    Am I correct that there are no integrity constraints? If so, what possible possible justification could there be for that, how can you ensure data integrity, and is there a script or plugin available that will add all the proper integrity constraints?

Viewing 2 replies - 1 through 2 (of 2 total)
  • Avatar of dqj
    dqj
    Participant

    @dqj

    I just read somewhere that WordPress uses no foreign constraints in general, and it appears that is true. Wow.

    Avatar of shanebp
    shanebp
    Moderator

    @shanebp

    Default WP uses MyISAM – so no foreign keys.
    BP follows WP.

    For large and busy BP sites, I have switched to Inno for some tables because it uses row locking instead of table locking. While Inno supports foreign keys, there is no point in using them as it would require a massive design change.

Viewing 2 replies - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.