Database structure for multisites

Network-level tables shared by all network sites:

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

The main site of a multisite network (reserved for administrative purposes) is site ID 1. Tables for the main site are prefixed by wp_. Tables for all other sites on the network are prefixed by wp_, followed by the site’s ID, followed by an underscore (_). For example, all tables for site ID 2 will be prefixed by wp_2_. By default, every site on the network has its own set of the following tables:

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