Welcome to Dagon Design. In addition to free scripts, WordPress plugins, and articles, we offer a variety of services including custom theme design, plugin creation, and PHP scripting. Contact me for more information.

Updated Saturday, August 30th, 2008 at 5:17pm

WordPress 2.3+ Database Structure for Categories

With the release of WordPress 2.3, there were several major changes to the database structure. Most notably was the new taxonomy schema, which replaced the categories, post2cat, and link2cat tables in favor of a new term based system with three new tables – terms, term_taxonomy, and term_relationships. While there are plenty of guides on the new structure, this is a simple visual guide to the relationships of these tables – specifically for category handling. This information is really only useful for those who are writing plugins or other code that interface with the database directly, and want a handy reminder of the table relationships.

Notes

The descriptions of the table fields in the reference image below just apply to categories. The taxonomy schema is also used to handle several other objects.

When writing queries to link the tables together, be sure to use the following statement so that the results are limited to category objects:

(table_prefix)_term_taxonomy.taxnomy = 'category'

WordPress 2.3+ Database Structure for Categories

Just right-click to save the image.

  If you have found this page useful, please consider donating. Thanks!

Pages: [4] 3 2 1 » Show All

  1. rooms the exercise of which can be allowed only to the territory of the states exactly where gambling business is prohibited. Therefore, on the territory of California successfully work

  2. Your blog is great. Your thoughts are also very good and i am very inspired from your post. http://brevillereview.net/reviews/breville-800jexl-juice-fountain-elite-1000-watt-juice-extractor/

  3. Your article captures the interest of your readers. Thanks for sharing this interesting topic.http://brevillereview.net/reviews/breville-bje510xl-ikon-900-watt-variable-speed-juice-extractor/

  4. I hope you have a nice day! Very good article, well written and very thought out. http://brevillereview.net/reviews/breville-bje510xl-ikon-900-watt-variable-speed-juice-extractor/

  5. Interesting writing. A new information for me. Glad to find a blog like this. Thank You.
    http://brevillereview.net/reviews/breville-je98xl-juice-fountain-plus-850-watt-juicing-machine/

  6. thank you for sharing,this information is useful to me.good quality
    http://brevillereview.net/reviews/breville-je98xl-juice-fountain-plus-850-watt-juicing-machine/

  7. This post is really very interesting. I like this type of post.
    breville je98xl juice fountain plus

  8. The great way to explain the structure of the new wordpress update . I like it

  9. oakley sunglasses prescription
    hank you for an additional fantastic blog. Where else might one get that sort of

    information written in such a perfect way? I actually have a presentation that i am

    presently working on, and that i are looking for such information instead
    Cheap Oakley Glasses .

  10. Thank you for an additional fantastic blog. Where else might one get that sort of information written in such a perfect way? I actually have a presentation that i am presently working on, and that i are looking for such information instead

  11. It really admire the idea. Very clearly explain concept.

Pages: [4] 3 2 1 » Show All

Leave a Comment

Before you comment: If you are having an issue with a script, please make sure you have read the entire article. Also, please read through the comments because most common issues have already been discussed many times. Thanks.


Be sure to wrap all code in <code></code> tags.