mirror of
https://github.com/buddypress/buddypress.git
synced 2026-07-23 21:06:56 +08:00
8f0a23595b
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
29 lines
1.2 KiB
Markdown
29 lines
1.2 KiB
Markdown
# 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](https://developer.wordpress.org/advanced-administration/wordpress/wp-config/#table-prefix).
|
|
|
|
## `{$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.
|
