Title: Database structure for multisites
Author: WordPress VIP Documentation
Published: September 2, 2022
Last modified: December 26, 2023

---

 1. [WordPress on VIP](https://docs.wpvip.com/wordpress-on-vip/)
 2. [WordPress multisite](https://docs.wpvip.com/wordpress-on-vip/multisites/)
 3. Database structure for multisites

#  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](https://docs.wpvip.com/multisites/order-of-launch/))
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