This table holds the user that have registered for a site via the login registration process. User registration is enable in Administration > Super Admin > Options.
Each site features information called the site data and it is stored in wp_sitemeta. Various option information, including the site admin is kept in this table.
The following describe the tables and fields created during the network installation. Note that a global set of tables is created upon creation of the network, and site-specific tables are established as each site is created.
Table: wp_blogs
Field
Type
Null
Key
Default
Extra
blog_id
bigint(20) unsigned
PRI
NULL
auto_increment
site_id
bigint(20) unsigned
IND
0
domain
varchar(200)
NO
0
path
varchar(100)
NO
registered
datetime
NO
0000-00-00 00:00:00
last_updated
datetime
NO
0000-00-00 00:00:00
public
tinyint(2)
NO
0
archived
enum('0','1')
NO
0
mature
tinyint(2)
NO
0
spam
tinyint(2)
NO
0
deleted
tinyint(2)
NO
0
lang_id
int(11)
NO
0
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
2
blog_id
domain
INDEX
none
domain(50),path(5)
lang_id
INDEX
none
lang_id
Table: wp_blog_versions
Field
Type
Null
Key
Default
Extra
blog_id
bigint(20) unsigned
PRI
0
FK->wp_blogs.blog_id
db_version
varchar(20)
NO
last_updated
datetime
NO
0000-00-00 00:00:00
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
2
blog_id
db_version
INDEX
none
db_version
Table: wp_registration_log
Field
Type
Null
Key
Default
Extra
ID
bigint(20) unsigned
PRI
NULL
auto_increment
email
varchar(255)
NO
IP
varchar(30)
NO
blog_id
bigint(20) unsigned
PRI
0
FK->wp_blogs.blog_id
date_registered
datetime
NO
0000-00-00 00:00:00
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
1
ID
IP
INDEX
none
IP
Table: wp_signups
Field
Type
Null
Key
Default
Extra
domain
varchar(200)
NO
0
path
varchar(100)
NO
title
longtext
NO
user_login
varchar(60)
NO
IND
user_email
varchar(100)
NO
registered_date
datetime
NO
0000-00-00 00:00:00
activated
datetime
NO
0000-00-00 00:00:00
active
tinyint(1)
NO
activation_key
varchar(50)
NO
meta
longtext
Indexes
Keyname
Type
Cardinality
Field
activation_key
INDEX
None
activation_key
domain
INDEX
None
domain
Table: wp_site
Field
Type
Null
Key
Default
Extra
id
bigint(20) unsigned
PRI
NULL
auto_increment
domain
varchar(200)
NO
0
path
varchar(100)
NO
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
1
id
domain
INDEX
none
domain,path
Table: wp_sitecategories
Field
Type
Null
Key
Default
Extra
cat_id
bigint(20) unsigned
NO
PRI
NULL
auto_increment
cat_name
carchar(55)
NO
category_nicename
varchar(200)
NO
last_updated
timestamp
NO
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
9
cat_id
category_nicename
INDEX
None
category_nicename
last_updated
INDEX
None
last_updated
Table: wp_sitemeta
Field
Type
Null
Key
Default
Extra
meta_id
bigint(20) unsigned
PRI
NULL
auto_increment
site_id
bigint(20) unsigned
'0'
FK->wp_site.site_id
meta_key
varchar(255)
Yes
IND
NULL
meta_value
longtext
Yes
IND
NULL
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
9
meta_id
meta_key
INDEX
None
meta_key
site_id
INDEX
None
site_id
Table: wp_users
Field
Type
Null
Key
Default
Extra
ID
bigint(20) unsigned
PRI
NULL
auto_increment
user_login
varchar(60)
IND
user_pass
varchar(64)
user_nicename
varchar(50)
IND
user_email
varchar(100)
user_url
varchar(100)
user_registered
datetime
0000-00-00 00:00:00
user_activation_key
varchar(60)
user_status
int(11)
0
display_name
varchar(250)
spam
tinyint(2)
NO
0
deleted
tinyint(2)
NO
0
Indexes
Keyname
Type
Cardinality
Field
PRIMARY
PRIMARY
1
ID
user_login_key
INDEX
None
user_login
user_nicename
INDEX
None
user_nicename
Site Specific Tables
When a new additional site is created, the site-specific tables, similar to the stand-alone tables above, are created. Each set of tables for a site are created with the site ID (blog_id) as part of the table name. These are the tables that would be created for site ID 2 and table_prefixwp:
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】博客园携手 AI 驱动开发工具商 Chat2DB 推出联合终身会员
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步