Skip to content

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

Relevant to

  • WordPress