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_terms
wp_term_relationships
wp_term_taxonomy
wp_termmeta
Last updated: August 03, 2023