Props vapvarun See https://github.com/buddypress/bp-documentation/issues/272 Closes https://github.com/buddypress/buddypress/pull/375 git-svn-id: https://buddypress.svn.wordpress.org/trunk@14046 cdf35c40-ae34-48e0-9cc9-0c9da1808c22
1.2 KiB
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 iswp_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 value1. |
-
Arrays or Objects are stored as serialized data. ↩︎