The Support Forums will be in read-only mode for a scheduled maintenance window on 01 September 2016 14:00 UTC - 20:00 UTC. More information.

[resolved] WordPress Database Tables and Plugins (3 posts)

  1. sylverCode
    Posted 3 years ago #

    I've noticed few plugins changing the structure of the existing WP tables by adding new columns.
    e.g. The Admin Management Xtended plugin adds "menu_order" column to wp_posts table so you can order posts manually.

    Is that wise?
    Isn't it better to create a separate table for your plugins and then link the data with WP tables data?
    Does WP overwrite its tables structure to default when updating to a newer version?

    Thanks in advance!

  2. bcworkz
    Posted 3 years ago #

    I suppose it's a matter of opinion. I agree with you, it's unwise, better to join in your own table. It does complicate queries a bit.

    WP does not normally fiddle with table structure between updates, but it has happened in the past, and could happen in the future. At which time the data in the extra columns could be lost, or the update could fail. Neither is a very desirable outcome. Your own tables is certainly the safest approach, and IMO, the only proper approach.

  3. sylverCode
    Posted 3 years ago #

    Thanks! That's the answer I was looking for.

Topic Closed

This topic has been closed to new replies.

About this Topic