Skip to:
Content
Pages
Categories
Search
Top
Bottom

No Foreign Key Relationships?


  • dqj
    Participant

    @dqj

    11 years, 2 months ago

    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)

  • dqj
    Participant

    @dqj

    11 years, 2 months ago

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


    shanebp
    Moderator

    @shanebp

    11 years, 2 months ago

    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)
  • The topic ‘No Foreign Key Relationships?’ is closed to new replies.

Topic Info

Skip to toolbar