Skip to content

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

Last updated: December 26, 2023

Relevant to

  • WordPress