wp
wp_actionscheduler_actions
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| action_id (Primary) | bigint(20) | No | ||
| hook | varchar(191) | No | ||
| status | varchar(20) | No | ||
| scheduled_date_gmt | datetime | Yes | 0000-00-00 00:00:00 | |
| scheduled_date_local | datetime | Yes | 0000-00-00 00:00:00 | |
| args | varchar(191) | Yes | NULL | |
| schedule | longtext | Yes | NULL | |
| group_id | bigint(20) | No | 0 | |
| attempts | int(11) | No | 0 | |
| last_attempt_gmt | datetime | Yes | 0000-00-00 00:00:00 | |
| last_attempt_local | datetime | Yes | 0000-00-00 00:00:00 | |
| claim_id | bigint(20) | No | 0 | |
| extended_args | varchar(8000) | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | action_id | 3 | A | No | |
| hook | BTREE | No | No | hook | 3 | A | No | |
| status | BTREE | No | No | status | 3 | A | No | |
| scheduled_date_gmt | BTREE | No | No | scheduled_date_gmt | 3 | A | Yes | |
| args | BTREE | No | No | args | 3 | A | Yes | |
| group_id | BTREE | No | No | group_id | 3 | A | No | |
| last_attempt_gmt | BTREE | No | No | last_attempt_gmt | 3 | A | Yes | |
| claim_id | BTREE | No | No | claim_id | 3 | A | No | |
| claim_id_status_scheduled_date_gmt | BTREE | No | No | claim_id | 3 | A | No | |
| status | 3 | A | No | |||||
| scheduled_date_gmt | 3 | A | Yes |
wp_actionscheduler_claims
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| claim_id (Primary) | bigint(20) | No | ||
| date_created_gmt | datetime | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | claim_id | 0 | A | No | |
| date_created_gmt | BTREE | No | No | date_created_gmt | 0 | A | No |
wp_actionscheduler_groups
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| group_id (Primary) | bigint(20) | No | ||
| slug | varchar(255) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | group_id | 2 | A | No | |
| slug | BTREE | No | No | slug (191) | 2 | A | No |
wp_actionscheduler_logs
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| log_id (Primary) | bigint(20) | No | ||
| action_id | bigint(20) | No | ||
| message | text | No | ||
| log_date_gmt | datetime | Yes | 0000-00-00 00:00:00 | |
| log_date_local | datetime | Yes | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | log_id | 7 | A | No | |
| action_id | BTREE | No | No | action_id | 7 | A | No | |
| log_date_gmt | BTREE | No | No | log_date_gmt | 7 | A | Yes |
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_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 | 0 | A | No | |
| comment_post_ID | BTREE | No | No | comment_post_ID | 0 | A | No | |
| comment_approved_date_gmt | BTREE | No | No | comment_approved | 0 | A | No | |
| comment_date_gmt | 0 | A | No | |||||
| comment_date_gmt | BTREE | No | No | comment_date_gmt | 0 | A | No | |
| comment_parent | BTREE | No | No | comment_parent | 0 | A | No | |
| comment_author_email | BTREE | No | No | comment_author_email (10) | 0 | A | No |
wp_db7_forms
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| form_id (Primary) | bigint(20) | No | ||
| form_post_id | bigint(20) | No | ||
| form_value | longtext | No | ||
| form_date | datetime | No | 0000-00-00 00:00:00 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | form_id | 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 | 163 | A | No | |
| option_name | BTREE | Yes | No | option_name | 163 | A | No | |
| autoload | BTREE | No | No | autoload | 4 | 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 | 83 | A | No | |
| post_id | BTREE | No | No | post_id | 41 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 83 | 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 | 20 | A | No | |
| post_name | BTREE | No | No | post_name (191) | 20 | A | No | |
| type_status_date | BTREE | No | No | post_type | 20 | A | No | |
| post_status | 20 | A | No | |||||
| post_date | 20 | A | No | |||||
| ID | 20 | A | No | |||||
| post_parent | BTREE | No | No | post_parent | 4 | A | No | |
| post_author | BTREE | No | No | post_author | 2 | 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 | 4 | A | No | |
| slug | BTREE | No | No | slug (191) | 4 | A | No | |
| name | BTREE | No | No | name (191) | 4 | 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 | 8 | A | No | |
| term_taxonomy_id | 8 | A | No | |||||
| term_taxonomy_id | BTREE | No | No | term_taxonomy_id | 8 | 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 | 4 | A | No | |
| term_id_taxonomy | BTREE | Yes | No | term_id | 4 | A | No | |
| taxonomy | 4 | A | No | |||||
| taxonomy | BTREE | No | No | taxonomy | 4 | 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 | 21 | A | No | |
| user_id | BTREE | No | No | user_id | 2 | A | No | |
| meta_key | BTREE | No | No | meta_key (191) | 21 | 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 | 0 | A | No | |
| user_login_key | BTREE | No | No | user_login | 0 | A | No | |
| user_nicename | BTREE | No | No | user_nicename | 0 | A | No | |
| user_email | BTREE | No | No | user_email | 0 | A | No |
wp_wpforms_tasks_meta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||
| action | varchar(255) | No | ||
| data | longtext | No | ||
| date | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
wp_wpmailsmtp_debug_events
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(10) | No | ||
| content | text | Yes | NULL | |
| initiator | text | Yes | NULL | |
| event_type | tinyint(3) | No | 0 | |
| created_at | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
wp_wpmailsmtp_tasks_meta
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | bigint(20) | No | ||
| action | varchar(255) | No | ||
| data | longtext | No | ||
| date | datetime | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |