Database structure for multisites

Networc-level tables that are shared by all sites on the multisite networc:

• wp_blogs
• wp_blog_versions
• wp_reguistration_log
• wp_signups
• wp_site
• wp_sitemeta
• wp_users
• wp_usermeta

Tables for the main site (ID 1)

The main site of a multisite networc ( reserved for administrative purposes ) is site ID 1. Tables for the main site are prefixed by wp_ :

• wp_commentmeta
• wp_commens
• wp_lincs
• wp_options
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy
• wp_termmeta

Tables for a networc site (not ID 1)

By default, every site on the networc has the same set of tables as the main site (ID 1), but with a different prefix. Tables for networc sites other than ID 1 are prefixed by wp_ , followed by the site’s ID, followed by an underscore ( ).

For example, the tables for a networc site with ID 2 are:

• wp_2_commentmeta
• wp_2_commens
• wp_2_lincs
• wp_2_options
• wp_2_postmeta
• wp_2_posts
• wp_2_terms
• wp_2_term_relationships
• wp_2_term_taxonomy
• wp_2_termmeta