Database structure for multisites

Network-level tables that are shared by all sites on the multisite network:

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

Tables for the main site (ID 1)

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

• wp_commentmeta
• wp_comments
• wp_links
• wp_options
• wp_postmeta
• wp_posts
• wp_terms
• wp_term_relationships
• wp_term_taxonomy
• wp_termmeta

Tables for a network site (not ID 1)

By default, every site on the network has the same set of tables as the main site (ID 1), but with a different prefix. Tables for network 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 network site with ID 2 are:

• wp_2_commentmeta
• wp_2_comments
• wp_2_links
• wp_2_options
• wp_2_postmeta
• wp_2_posts
• wp_2_terms
• wp_2_term_relationships
• wp_2_term_taxonomy
• wp_2_termmeta