INTERNAL REFERENCE

Database Overview

129Tables

1279Columns

5873Rows

wp Tables Overview

shop2_attribute_groups¹ shop2_attribute_groups_info² shop2_attribute_values² shop2_attribute_values_info⁴ shop2_cart_items⁷ shop2_categories⁴ shop2_categories_filters⁰ shop2_categories_info⁸ shop2_countries²⁴³ shop2_currencies² shop2_customers¹ shop2_delivery_statuses² shop2_delivery_statuses_info⁴ shop2_emails² shop2_geo_zones³ shop2_languages² shop2_manufacturers³ shop2_manufacturers_info⁶ shop2_modules⁹ shop2_newsletter_recipients⁰ shop2_order_statuses¹⁴ shop2_order_statuses_info²⁸ shop2_orders¹ shop2_orders_comments⁰ shop2_orders_items¹ shop2_orders_totals² shop2_pages⁷ shop2_pages_info¹⁴ shop2_products¹² shop2_products_attributes³ shop2_products_campaigns⁰ shop2_products_images¹² shop2_products_info²⁴ shop2_products_options⁰ shop2_products_options_stock⁰ shop2_products_options_values⁰ shop2_products_prices¹² shop2_products_to_categories¹² shop2_quantity_units¹ shop2_quantity_units_info² shop2_settings⁹⁰ shop2_settings_groups¹⁰ shop2_slides¹ shop2_slides_info² shop2_sold_out_statuses⁴ shop2_sold_out_statuses_info⁸ shop2_suppliers⁰ shop2_tax_classes² shop2_tax_rates⁴ shop2_translations¹⁶⁰⁵ shop2_users¹ shop2_zones⁷¹ shop2_zones_to_geo_zones⁵⁵ shop_attribute_groups¹ shop_attribute_groups_info² shop_attribute_values⁵ shop_attribute_values_info¹⁰ shop_cart_items⁰ shop_categories¹ shop_categories_filters¹ shop_categories_info² shop_countries²⁴³ shop_currencies² shop_customers¹ shop_delivery_statuses² shop_delivery_statuses_info⁴ shop_emails¹ shop_geo_zones³ shop_languages² shop_manufacturers¹ shop_manufacturers_info² shop_modules⁹ shop_newsletter_recipients⁰ shop_order_statuses¹⁴ shop_order_statuses_info²⁸ shop_orders⁰ shop_orders_comments⁰ shop_orders_items⁰ shop_orders_totals⁰ shop_pages⁷ shop_pages_info¹⁴ shop_products³ shop_products_attributes⁶ shop_products_campaigns⁰ shop_products_images⁶ shop_products_info⁶ shop_products_options⁰ shop_products_options_stock⁰ shop_products_options_values⁰ shop_products_prices³ shop_products_to_categories³ shop_quantity_units¹ shop_quantity_units_info² shop_settings⁹⁰ shop_settings_groups¹⁰ shop_slides² shop_slides_info⁴ shop_sold_out_statuses³ shop_sold_out_statuses_info⁶ shop_suppliers⁰ shop_tax_classes² shop_tax_rates⁴ shop_translations¹⁶⁰⁵ shop_users¹ shop_zones⁷¹ shop_zones_to_geo_zones⁵⁵ wp_actionscheduler_actions⁷⁹ wp_actionscheduler_claims⁰ wp_actionscheduler_groups² wp_actionscheduler_logs²²⁹ wp_commentmeta⁰ wp_comments⁰ wp_links⁰ wp_options²⁷² wp_pmxi_files¹ wp_pmxi_hash⁰ wp_pmxi_history¹ wp_pmxi_images¹⁵ wp_pmxi_imports¹ wp_pmxi_posts¹ wp_pmxi_templates⁰ wp_postmeta³⁹⁶ wp_posts¹²⁹ wp_term_relationships⁷⁰ wp_term_taxonomy³⁴ wp_termmeta²² wp_terms³⁴ wp_usermeta⁴⁵ wp_users¹

shop2_attribute_groups

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
code	varchar(32)	NO	MUL
sort	enum('alphabetical','priority')	NO		alphabetical
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
code	NO	code

shop2_attribute_groups_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
group_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(128)	NO

Name	Unique	Columns
PRIMARY	YES	id
attribute_group	YES	group_id, language_code
group_id	NO	group_id
language_code	NO	language_code

shop2_attribute_values

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
group_id	int(11) unsigned	NO	MUL	0
priority	int(11)	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
group_id	NO	group_id

shop2_attribute_values_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
value_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(128)	NO

Name	Unique	Columns
PRIMARY	YES	id
attribute_value	YES	value_id, language_code
value_id	NO	value_id
language_code	NO	language_code

shop2_cart_items

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
customer_id	int(11) unsigned	NO	MUL	0
cart_uid	varchar(13)	NO	MUL
key	varchar(32)	NO
product_id	int(11) unsigned	NO		0
options	varchar(2048)	NO
quantity	float(11,4)	NO		0.0000
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
customer_id	NO	customer_id
cart_uid	NO	cart_uid

shop2_categories

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
parent_id	int(11) unsigned	NO	MUL	0
google_taxonomy_id	int(11) unsigned	NO		0
status	tinyint(1)	NO	MUL	0
code	varchar(64)	NO	MUL
list_style	varchar(32)	NO
keywords	varchar(256)	NO
image	varchar(256)	NO
priority	int(11)	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
code	NO	code
parent_id	NO	parent_id
status	NO	status

shop2_categories_filters

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
category_id	int(11) unsigned	NO	MUL	0
attribute_group_id	int(11) unsigned	NO		0
select_multiple	tinyint(1) unsigned	NO		0
priority	int(11)	NO		0

Name	Unique	Columns
PRIMARY	YES	id
attribute_filter	YES	category_id, attribute_group_id
category_id	NO	category_id

shop2_categories_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
category_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(128)	NO
short_description	varchar(256)	NO
description	text	NO
head_title	varchar(128)	NO
h1_title	varchar(128)	NO
meta_description	varchar(512)	NO

Name	Unique	Columns
PRIMARY	YES	id
category	YES	category_id, language_code
category_id	NO	category_id
language_code	NO	language_code

shop2_countries

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
status	tinyint(1)	NO	MUL	0
name	varchar(64)	NO
domestic_name	varchar(64)	NO
iso_code_1	varchar(3)	NO	UNI
iso_code_2	varchar(2)	NO	UNI
iso_code_3	varchar(3)	NO	UNI
tax_id_format	varchar(64)	NO
address_format	varchar(128)	NO
postcode_format	varchar(512)	NO
postcode_required	tinyint(1) unsigned	NO		0
language_code	varchar(2)	NO
currency_code	varchar(3)	NO
phone_code	varchar(3)	NO
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
iso_code_1	YES	iso_code_1
iso_code_2	YES	iso_code_2
iso_code_3	YES	iso_code_3
status	NO	status

shop2_currencies

Name	Type	Null	Key	Default	Extra
id	tinyint(2) unsigned	NO	PRI		auto_increment
status	tinyint(1)	NO	MUL	0
code	varchar(3)	NO
number	varchar(3)	NO
name	varchar(32)	NO
value	float(11,6) unsigned	NO		0.000000
decimals	tinyint(1) unsigned	NO		0
prefix	varchar(8)	NO
suffix	varchar(8)	NO
priority	int(11)	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
status	NO	status

shop2_customers

Name	Unique	Columns
PRIMARY	YES	id
email	YES	email

shop2_delivery_statuses

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id

shop2_delivery_statuses_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
delivery_status_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(64)	NO
description	varchar(256)	NO

Name	Unique	Columns
PRIMARY	YES	id
delivery_status	YES	delivery_status_id, language_code
delivery_status_id	NO	delivery_status_id
language_code	NO	language_code

shop2_emails

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
status	enum('draft','scheduled','sent','error')	NO		draft
code	varchar(256)	NO	MUL
charset	varchar(16)	NO
sender	varchar(256)	NO	MUL
recipients	text	NO
ccs	text	NO
bccs	text	NO
subject	varchar(256)	NO
multiparts	mediumtext	NO
date_scheduled	timestamp	YES	MUL
date_sent	timestamp	YES
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO	MUL	CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
date_scheduled	NO	date_scheduled
code	NO	code
date_created	NO	date_created
sender_email	NO	sender

shop2_geo_zones

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
code	varchar(32)	NO
name	varchar(64)	NO
description	varchar(256)	NO
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id

shop2_languages

Name	Unique	Columns
PRIMARY	YES	id
status	NO	status

shop2_manufacturers

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
status	tinyint(1)	NO	MUL	0
featured	tinyint(1) unsigned	NO		0
code	varchar(32)	NO	MUL
name	varchar(64)	NO
keywords	varchar(256)	NO
image	varchar(256)	NO
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
code	NO	code
status	NO	status

shop2_manufacturers_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
manufacturer_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
short_description	varchar(256)	NO
description	text	NO
h1_title	varchar(128)	NO
head_title	varchar(128)	NO
meta_description	varchar(512)	NO
link	varchar(256)	NO

Name	Unique	Columns
PRIMARY	YES	id
brand_info	YES	manufacturer_id, language_code
manufacturer_id	NO	manufacturer_id
language_code	NO	language_code

shop2_modules

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
module_id	varchar(64)	NO	UNI
type	varchar(16)	NO	MUL
status	tinyint(1)	NO	MUL	0
priority	int(11)	NO		0
settings	text	NO
last_log	text	NO
date_pushed	timestamp	YES
date_processed	timestamp	YES
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
module_id	YES	module_id
type	NO	type
status	NO	status

shop2_newsletter_recipients

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
lastname	varchar(64)	NO
firstname	varchar(64)	NO
email	varchar(128)	NO	UNI
client_ip	varchar(64)	NO
hostname	varchar(128)	NO
user_agent	varchar(256)	NO
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
email	YES	email

shop2_order_statuses

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
state	enum('','created','on_hold','ready','delayed','processing','completed','dispatched','in_transit','delivered','returning','returned','cancelled','fraud','other')	NO
icon	varchar(24)	NO
color	varchar(7)	NO
is_sale	tinyint(1) unsigned	NO	MUL	0
is_archived	tinyint(1) unsigned	NO	MUL	0
is_trackable	tinyint(1) unsigned	NO		0
stock_action	enum('none','reserve','commit')	NO		none
notify	tinyint(1) unsigned	NO		0
priority	int(11)	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
is_sale	NO	is_sale
is_archived	NO	is_archived

shop2_order_statuses_info

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
order_status_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(64)	NO
description	varchar(256)	NO
email_subject	varchar(128)	NO
email_message	text	NO

Name	Unique	Columns
PRIMARY	YES	id
order_status_info	YES	order_status_id, language_code
order_status_id	NO	order_status_id
language_code	NO	language_code

shop2_orders

Name	Unique	Columns
PRIMARY	YES	id
order_status_id	NO	order_status_id
starred	NO	starred
unread	NO	unread

shop2_orders_comments

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
order_id	int(11) unsigned	NO	MUL	0
author_id	int(11)	NO		0
author	enum('system','staff','customer')	NO		system
text	varchar(512)	NO
hidden	tinyint(1) unsigned	NO		0
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
order_id	NO	order_id

shop2_orders_items

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
order_id	int(11) unsigned	NO	MUL	0
product_id	int(11) unsigned	NO		0
option_stock_combination	varchar(32)	NO
options	varchar(4096)	NO
name	varchar(128)	NO
sku	varchar(32)	NO
gtin	varchar(32)	NO
taric	varchar(32)	NO
quantity	float(11,4)	NO		0.0000
price	float(11,4)	NO		0.0000
tax	float(11,4)	NO		0.0000
weight	float(11,4) unsigned	NO		0.0000
weight_class	varchar(2)	NO
dim_x	float(11,4) unsigned	NO		0.0000
dim_y	float(11,4) unsigned	NO		0.0000
dim_z	float(11,4) unsigned	NO		0.0000
dim_class	varchar(2)	NO
priority	int(11)	NO		0

Name	Unique	Columns
PRIMARY	YES	id
order_id	NO	order_id

shop2_orders_totals

shop2_pages

shop2_pages_info

shop2_products

shop2_products_attributes

shop2_products_campaigns

shop2_products_images

shop2_products_info

shop2_products_options

shop2_products_options_stock

shop2_products_options_values

shop2_products_prices

shop2_products_to_categories

shop2_quantity_units

shop2_quantity_units_info

shop2_settings

shop2_settings_groups

shop2_slides

shop2_slides_info

shop2_sold_out_statuses

shop2_sold_out_statuses_info

shop2_suppliers

shop2_tax_classes

shop2_tax_rates

shop2_translations

shop2_users

shop2_zones

shop2_zones_to_geo_zones

shop_attribute_groups

shop_attribute_groups_info

shop_attribute_values

shop_attribute_values_info

shop_cart_items

shop_categories

shop_categories_filters

shop_categories_info

shop_countries

shop_currencies

shop_customers

shop_delivery_statuses

shop_delivery_statuses_info

shop_emails

shop_geo_zones

shop_languages

shop_manufacturers

shop_manufacturers_info

shop_modules

shop_newsletter_recipients

shop_order_statuses

shop_order_statuses_info

shop_orders

shop_orders_comments

shop_orders_items

shop_orders_totals

shop_pages

shop_pages_info

shop_products

shop_products_attributes

shop_products_campaigns

shop_products_images

shop_products_info

shop_products_options

shop_products_options_stock

shop_products_options_values

shop_products_prices

shop_products_to_categories

shop_quantity_units

shop_quantity_units_info

shop_settings

shop_settings_groups

shop_slides

shop_slides_info

shop_sold_out_statuses

shop_sold_out_statuses_info

shop_suppliers

shop_tax_classes

shop_tax_rates

shop_translations

shop_users

shop_zones

shop_zones_to_geo_zones

wp_actionscheduler_actions

wp_actionscheduler_claims

wp_actionscheduler_groups

wp_actionscheduler_logs

wp_commentmeta

wp_comments

wp_links

wp_options

wp_pmxi_files

wp_pmxi_hash

wp_pmxi_history

wp_pmxi_images

wp_pmxi_imports

wp_pmxi_posts

wp_pmxi_templates

wp_postmeta

wp_posts

wp_term_relationships

wp_term_taxonomy

wp_termmeta

wp_terms

wp_usermeta

wp_users

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
page_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
title	varchar(256)	NO
content	mediumtext	NO
head_title	varchar(128)	NO
meta_description	varchar(512)	NO

Name	Unique	Columns
PRIMARY	YES	id
page_info	YES	page_id, language_code
page_id	NO	page_id
language_code	NO	language_code

Name	Unique	Columns
PRIMARY	YES	id
id	YES	id, product_id, group_id, value_id
product_id	NO	product_id
group_id	NO	group_id
value_id	NO	value_id

Name	Unique	Columns
PRIMARY	YES	id
product_info	YES	product_id, language_code
product_id	NO	product_id
language_code	NO	language_code
name	NO	name
short_description	NO	short_description
description	NO	description

Name	Unique	Columns
PRIMARY	YES	id
product_option	YES	product_id, group_id
product_id	NO	product_id
priority	NO	priority

Name	Unique	Columns
PRIMARY	YES	id
product_option_stock	YES	product_id, combination
product_id	NO	product_id

Name	Unique	Columns
PRIMARY	YES	id
product_option_value	YES	product_id, group_id, value_id, custom_value
product_id	NO	product_id
priority	NO	priority

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
quantity_unit_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(32)	NO
description	varchar(512)	YES

Name	Unique	Columns
PRIMARY	YES	id
quantity_unit_info	YES	quantity_unit_id, language_code
quantity_unit_id	NO	quantity_unit_id
language_code	NO	language_code

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
setting_group_key	varchar(64)	NO	MUL
type	enum('global','local')	NO		local
key	varchar(64)	NO	UNI
value	varchar(8192)	NO
title	varchar(128)	NO
description	varchar(512)	NO
function	varchar(128)	NO
priority	int(11)	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
slide_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
caption	text	NO
link	varchar(256)	NO

Name	Unique	Columns
PRIMARY	YES	id
slide_info	YES	slide_id, language_code
slide_id	NO	slide_id
language_code	NO	language_code

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
sold_out_status_id	int(11) unsigned	NO	MUL	0
language_code	varchar(2)	NO	MUL
name	varchar(64)	NO
description	varchar(256)	NO

Name	Unique	Columns
PRIMARY	YES	id
sold_out_status_info	YES	sold_out_status_id, language_code
sold_out_status_id	NO	sold_out_status_id
language_code	NO	language_code

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
tax_class_id	int(11) unsigned	NO	MUL	0
geo_zone_id	int(11) unsigned	NO	MUL	0
code	varchar(32)	NO
name	varchar(64)	NO
description	varchar(128)	NO
rate	float(10,4)	NO		0.0000
type	enum('fixed','percent')	NO		percent
address_type	enum('shipping','payment')	NO		shipping
rule_companies_with_tax_id	tinyint(1) unsigned	NO		0
rule_companies_without_tax_id	tinyint(1) unsigned	NO		0
rule_individuals_with_tax_id	tinyint(1) unsigned	NO		0
rule_individuals_without_tax_id	tinyint(1) unsigned	NO		0
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Type	Null	Key	Default	Extra
id	int(11) unsigned	NO	PRI		auto_increment
country_code	varchar(4)	NO	MUL
code	varchar(8)	NO	MUL
name	varchar(64)	NO
date_updated	timestamp	NO		CURRENT_TIMESTAMP
date_created	timestamp	NO		CURRENT_TIMESTAMP

Name	Unique	Columns
PRIMARY	YES	id
region	YES	geo_zone_id, country_code, zone_code, city
geo_zone_id	NO	geo_zone_id
country_code	NO	country_code
zone_code	NO	zone_code
city	NO	city

Name	Type	Null	Key	Default	Extra
action_id	bigint(20) unsigned	NO	PRI		auto_increment
hook	varchar(191)	NO	MUL
status	varchar(20)	NO	MUL
scheduled_date_gmt	datetime	YES	MUL	0000-00-00 00:00:00
scheduled_date_local	datetime	YES		0000-00-00 00:00:00
priority	tinyint(3) unsigned	NO		10
args	varchar(191)	YES	MUL
schedule	longtext	YES
group_id	bigint(20) unsigned	NO	MUL	0
attempts	int(11)	NO		0
last_attempt_gmt	datetime	YES	MUL	0000-00-00 00:00:00
last_attempt_local	datetime	YES		0000-00-00 00:00:00
claim_id	bigint(20) unsigned	NO	MUL	0
extended_args	varchar(8000)	YES

Name	Unique	Columns
PRIMARY	YES	action_id
hook_status_scheduled_date_gmt	NO	hook, status, scheduled_date_gmt
status_scheduled_date_gmt	NO	status, scheduled_date_gmt
scheduled_date_gmt	NO	scheduled_date_gmt
args	NO	args
group_id	NO	group_id
last_attempt_gmt	NO	last_attempt_gmt
claim_id_status_scheduled_date_gmt	NO	claim_id, status, scheduled_date_gmt

Name	Type	Null	Key	Default	Extra
log_id	bigint(20) unsigned	NO	PRI		auto_increment
action_id	bigint(20) unsigned	NO	MUL
message	text	NO
log_date_gmt	datetime	YES	MUL	0000-00-00 00:00:00
log_date_local	datetime	YES		0000-00-00 00:00:00

🐡 MySQL db Docu

INTERNAL REFERENCE

Database Overview

wp Tables Overview

shop2_attribute_groups

Columns

Indexes

shop2_attribute_groups_info

Columns

Indexes

shop2_attribute_values

Columns

Indexes

shop2_attribute_values_info

Columns

Indexes

shop2_cart_items

Columns

Indexes

shop2_categories

Columns

Indexes

shop2_categories_filters

Columns

Indexes

shop2_categories_info

Columns

Indexes

shop2_countries

Columns

Indexes

shop2_currencies

Columns

Indexes

shop2_customers

Columns

Indexes

shop2_delivery_statuses

Columns

Indexes

shop2_delivery_statuses_info

Columns

Indexes

shop2_emails

Columns

Indexes

shop2_geo_zones

Columns

Indexes

shop2_languages

Columns

Indexes

shop2_manufacturers

Columns

Indexes

shop2_manufacturers_info

Columns

Indexes

shop2_modules

Columns

Indexes

shop2_newsletter_recipients

Columns

Indexes

shop2_order_statuses

Columns

Indexes

shop2_order_statuses_info

Columns

Indexes

shop2_orders

Columns

Indexes

shop2_orders_comments

Columns

Indexes

shop2_orders_items

Columns

Indexes

shop2_orders_totals

Name	Type	Null	Key	Default	Extra
meta_id	bigint(20) unsigned	NO	PRI		auto_increment
comment_id	bigint(20) unsigned	NO	MUL	0
meta_key	varchar(255)	YES	MUL
meta_value	longtext	YES

Name	Unique	Columns
PRIMARY	YES	comment_ID
comment_post_ID	NO	comment_post_ID
comment_approved_date_gmt	NO	comment_approved, comment_date_gmt
comment_date_gmt	NO	comment_date_gmt
comment_parent	NO	comment_parent
comment_author_email	NO	comment_author_email

Name	Type	Null	Key	Default	Extra
link_id	bigint(20) unsigned	NO	PRI		auto_increment
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	MUL	Y
link_owner	bigint(20) unsigned	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

Name	Type	Null	Key	Default	Extra
option_id	bigint(20) unsigned	NO	PRI		auto_increment
option_name	varchar(191)	NO	UNI
option_value	longtext	NO
autoload	varchar(20)	NO	MUL	yes

Name	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
import_id	bigint(20) unsigned	NO
name	text	YES
path	text	YES
registered_on	datetime	NO		0000-00-00 00:00:00

Name	Type	Null	Key
hash	binary(16)	NO	PRI
post_id	bigint(20) unsigned	NO
import_id	smallint(5) unsigned	NO
post_type	varchar(32)	NO

Name	Type	Null	Key	Extra
id	bigint(20) unsigned	NO	PRI	auto_increment
attachment_id	bigint(20) unsigned	NO
image_url	text	NO
image_filename	text	NO

Name	Type	Null	Key	Default	Extra
id	bigint(20) unsigned	NO	PRI		auto_increment
parent_import_id	bigint(20)	NO		0
name	text	YES
friendly_name	varchar(255)	NO
type	varchar(32)	NO
feed_type	enum('xml','csv','zip','gz','')	NO
path	text	YES
xpath	text	YES
options	longtext	YES
registered_on	datetime	NO		0000-00-00 00:00:00
root_element	varchar(255)	YES
processing	tinyint(1)	NO		0
executing	tinyint(1)	NO		0
triggered	tinyint(1)	NO		0
queue_chunk_number	bigint(20)	NO		0
first_import	timestamp	NO		CURRENT_TIMESTAMP
count	bigint(20)	NO		0
imported	bigint(20)	NO		0
created	bigint(20)	NO		0
updated	bigint(20)	NO		0
skipped	bigint(20)	NO		0
deleted	bigint(20)	NO		0
changed_missing	bigint(20)	NO		0
canceled	tinyint(1)	NO		0
canceled_on	datetime	NO		0000-00-00 00:00:00
failed	tinyint(1)	NO		0
failed_on	datetime	NO		0000-00-00 00:00:00
settings_update_on	datetime	NO		0000-00-00 00:00:00
last_activity	datetime	NO		0000-00-00 00:00:00
iteration	bigint(20)	NO		0

Name	Type	Null	Key	Default	Extra
ID	bigint(20) unsigned	NO	PRI		auto_increment
post_author	bigint(20) unsigned	NO	MUL	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	MUL
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) unsigned	NO	MUL	0
guid	varchar(255)	NO
menu_order	int(11)	NO		0
post_type	varchar(20)	NO	MUL	post
post_mime_type	varchar(100)	NO
comment_count	bigint(20)	NO		0

Name	Type	Null	Key
object_id	bigint(20) unsigned	NO	PRI
term_taxonomy_id	bigint(20) unsigned	NO	PRI
term_order	int(11)	NO