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).
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.