wordpress
wp_commentmeta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| meta_id (Primary) | bigint(20) | No | ||
| comment_id | bigint(20) | No | 0 | |
| meta_key | varchar(255) | Yes | NULL | |
| meta_value | longtext | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | meta_id | 0 | A | No | |
| comment_id | BTREE | No | No | comment_id | 0 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 0 | A | Yes |
wp_comments
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| comment_ID (Primary) | bigint(20) | No | ||
| comment_post_ID | bigint(20) | No | 0 | |
| comment_author | tinytext | No | ||
| comment_author_email | varchar(100) | No | ||
| comment_author_url | varchar(200) | No | ||
| comment_author_IP | varchar(100) | No | ||
| comment_date | datetime | No | 0000-00-00 00:00:00 | |
| comment_date_gmt | datetime | No | 0000-00-00 00:00:00 | |
| comment_content | text | No | ||
| comment_karma | int(11) | No | 0 | |
| comment_approved | varchar(20) | No | 1 | |
| comment_agent | varchar(255) | No | ||
| comment_type | varchar(20) | No | comment | |
| comment_parent | bigint(20) | No | 0 | |
| user_id | bigint(20) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | comment_ID | 1 | A | No | |
| comment_post_ID | BTREE | No | No | comment_post_ID | 1 | A | No | |
| comment_approved_date_gmt | BTREE | No | No | comment_approved | 1 | A | No | |
| comment_date_gmt | 1 | A | No | |||||
| comment_date_gmt | BTREE | No | No | comment_date_gmt | 1 | A | No | |
| comment_parent | BTREE | No | No | comment_parent | 1 | A | No | |
| comment_author_email | BTREE | No | No | comment_author_email (10) | 1 | A | No |
wp_links
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| link_id (Primary) | bigint(20) | No | ||
| link_url | varchar(255) | No | ||
| link_name | varchar(255) | No | ||
| link_image | varchar(255) | No | ||
| link_target | varchar(25) | No | ||
| link_description | varchar(255) | No | ||
| link_visible | varchar(20) | No | Y | |
| link_owner | bigint(20) | No | 1 | |
| link_rating | int(11) | No | 0 | |
| link_updated | datetime | No | 0000-00-00 00:00:00 | |
| link_rel | varchar(255) | No | ||
| link_notes | mediumtext | No | ||
| link_rss | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | link_id | 0 | A | No | |
| link_visible | BTREE | No | No | link_visible | 0 | A | No |
wp_options
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| option_id (Primary) | bigint(20) | No | ||
| option_name | varchar(191) | No | ||
| option_value | longtext | No | ||
| autoload | varchar(20) | No | yes |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | option_id | 141 | A | No | |
| option_name | BTREE | Yes | No | option_name | 141 | A | No | |
| autoload | BTREE | No | No | autoload | 6 | A | No |
wp_postmeta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| meta_id (Primary) | bigint(20) | No | ||
| post_id | bigint(20) | No | 0 | |
| meta_key | varchar(255) | Yes | NULL | |
| meta_value | longtext | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | meta_id | 15 | A | No | |
| post_id | BTREE | No | No | post_id | 15 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 15 | A | Yes |
wp_posts
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| ID (Primary) | bigint(20) | No | ||
| post_author | bigint(20) | No | 0 | |
| post_date | datetime | No | 0000-00-00 00:00:00 | |
| post_date_gmt | datetime | No | 0000-00-00 00:00:00 | |
| post_content | longtext | No | ||
| post_title | text | No | ||
| post_excerpt | text | No | ||
| post_status | varchar(20) | No | publish | |
| comment_status | varchar(20) | No | open | |
| ping_status | varchar(20) | No | open | |
| post_password | varchar(255) | No | ||
| post_name | varchar(200) | No | ||
| to_ping | text | No | ||
| pinged | text | No | ||
| post_modified | datetime | No | 0000-00-00 00:00:00 | |
| post_modified_gmt | datetime | No | 0000-00-00 00:00:00 | |
| post_content_filtered | longtext | No | ||
| post_parent | bigint(20) | No | 0 | |
| guid | varchar(255) | No | ||
| menu_order | int(11) | No | 0 | |
| post_type | varchar(20) | No | post | |
| post_mime_type | varchar(100) | No | ||
| comment_count | bigint(20) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | 40 | A | No | |
| post_name | BTREE | No | No | post_name (191) | 40 | A | No | |
| type_status_date | BTREE | No | No | post_type | 20 | A | No | |
| post_status | 20 | A | No | |||||
| post_date | 40 | A | No | |||||
| ID | 40 | A | No | |||||
| post_parent | BTREE | No | No | post_parent | 20 | A | No | |
| post_author | BTREE | No | No | post_author | 4 | A | No | |
| type_status_author | BTREE | No | No | post_type | 20 | A | No | |
| post_status | 20 | A | No | |||||
| post_author | 20 | A | No |
wp_termmeta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| meta_id (Primary) | bigint(20) | No | ||
| term_id | bigint(20) | No | 0 | |
| meta_key | varchar(255) | Yes | NULL | |
| meta_value | longtext | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | meta_id | 0 | A | No | |
| term_id | BTREE | No | No | term_id | 0 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 0 | A | Yes |
wp_terms
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| term_id (Primary) | bigint(20) | No | ||
| name | varchar(200) | No | ||
| slug | varchar(200) | No | ||
| term_group | bigint(10) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | term_id | 3 | A | No | |
| slug | BTREE | No | No | slug (191) | 3 | A | No | |
| name | BTREE | No | No | name (191) | 3 | A | No |
wp_term_relationships
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| object_id (Primary) | bigint(20) | No | 0 | |
| term_taxonomy_id (Primary) | bigint(20) | No | 0 | |
| term_order | int(11) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | object_id | 5 | A | No | |
| term_taxonomy_id | 5 | A | No | |||||
| term_taxonomy_id | BTREE | No | No | term_taxonomy_id | 5 | A | No |
wp_term_taxonomy
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| term_taxonomy_id (Primary) | bigint(20) | No | ||
| term_id | bigint(20) | No | 0 | |
| taxonomy | varchar(32) | No | ||
| description | longtext | No | ||
| parent | bigint(20) | No | 0 | |
| count | bigint(20) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | term_taxonomy_id | 3 | A | No | |
| term_id_taxonomy | BTREE | Yes | No | term_id | 3 | A | No | |
| taxonomy | 3 | A | No | |||||
| taxonomy | BTREE | No | No | taxonomy | 3 | A | No |
wp_usermeta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| umeta_id (Primary) | bigint(20) | No | ||
| user_id | bigint(20) | No | 0 | |
| meta_key | varchar(255) | Yes | NULL | |
| meta_value | longtext | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | umeta_id | 20 | A | No | |
| user_id | BTREE | No | No | user_id | 2 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 20 | A | Yes |
wp_users
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| ID (Primary) | bigint(20) | No | ||
| user_login | varchar(60) | No | ||
| user_pass | varchar(255) | No | ||
| user_nicename | varchar(50) | No | ||
| user_email | varchar(100) | No | ||
| user_url | varchar(100) | No | ||
| user_registered | datetime | No | 0000-00-00 00:00:00 | |
| user_activation_key | varchar(255) | No | ||
| user_status | int(11) | No | 0 | |
| display_name | varchar(250) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | ID | 1 | A | No | |
| user_login_key | BTREE | No | No | user_login | 1 | A | No | |
| user_nicename | BTREE | No | No | user_nicename | 1 | A | No | |
| user_email | BTREE | No | No | user_email | 1 | A | No |