Blogs database tables

When first activated and if the WordPress site uses a multisite configuration, the Blogs component creates 2 tables. One to store users relationship to blogs ({$table_prefix}bp_user_blogs), the other to store metadata about blogs ({$table_prefix}bp_user_blogs_blogmeta).

[!NOTE]
The {$table_prefix} value is wp_ by default but it can be customized within the WordPress wp-config.php file.

`{$table_prefix}bp_user_blogs`

This table stores users relationship to blogs.

Name	Type	Description
`id`	`BIGINT`	The unique ID for each user/blog relationships.
`user_id`	`BIGINT`	The ID of the user who has a relationship with the blog.
`blog_id`	`BIGINT`	The ID of the blog, the user has a relationship with.

`{$table_prefix}bp_user_blogs_blogmeta`

Stores metadata associated with blog entries.

Name	Type	Description
`id`	`BIGINT`	Meta ID
`blog_id`	`BIGINT`	The ID of the associated blog.
`meta_key`	`VARCHAR`	Metadata key.
`meta_value`	`LONGTEXT`	Metadata value[^1].

[^1]: Arrays or Objects are stored as serialized data.

这篇文档对你有帮助吗？