February 8, 2012

Database structure – updated for 1.3

As an addendum to this post, there’s a few extra tables in WPMU 1.3, which should officially be released any day now.

wp_1_terms
wp_1_term_relationships
wp_1_term_taxonomy

There are all related to the internal tag system now available in WordPress 2.3. You may also have noted that MU is now following a similar version number. No official word on how this can be used for sitewide tags, but I know some smart people are in the middle of figuring this out.

I am also working on a database diagram for the next post in this series. My skills are a bit rusty, but the good thing about database theory is that not much changes in twenty years. :D Just the programs involved.

Get 3 for the price of 2 in the Network Home Bundle

Includes 3 ebooks with plugins -
Network Home Pages: aggregate global content, set up sitewide tags, create a huge tags cloud like the one seen on WordPress.com, global footers and menus, setting defaults & more
Custom Registration: sign up on sub sites, multilingual signup pages, stop spam blogs
WP Curator: pick and choose posts from sub sites to feature on the main home page of your network

Network Home Pages, Custom Registration & WP Curator – $35.90 for all three. Purchase

Trackbacks

  1. [...] WPMu Tutorials site has two posts about the basic structure of the WPMu database. It is a useful overview that explains how the [...]