Zen Cart 2.1.0 Schema

Database Schema

Legend: bolded fields are primary keys, links are foreign keys.

address_book address_format admin admin_activity_log admin_expired_tokens admin_menus admin_notifications admin_pages admin_pages_to_profiles admin_profiles authorizenet banners banners_history categories categories_description configuration configuration_group count_product_views counter counter_history countries coupon_email_track coupon_gv_customer coupon_gv_queue coupon_redeem_track coupon_referrers coupon_restrict coupons coupons_description currencies customer_groups customers customers_basket customers_basket_attributes customers_info customers_to_groups db_cache email_archive ezpages ezpages_content featured featured_categories files_uploaded geo_zones get_terms_to_filter group_pricing languages layout_boxes manufacturers manufacturers_info media_clips media_manager media_to_products media_types meta_tags_categories_description meta_tags_products_description music_genre newsletters orders orders_products orders_products_attributes orders_products_download orders_status orders_status_history orders_total paypal paypal_payment_status paypal_payment_status_history paypal_session paypal_testing plugin_control plugin_control_versions plugin_groups plugin_groups_description product_music_extra product_type_layout product_types product_types_to_category products products_attributes products_attributes_download products_description products_discount_quantity products_notifications products_options products_options_types products_options_values products_options_values_to_products_options products_to_categories project_version project_version_history query_builder record_artists record_artists_info record_company record_company_info reviews reviews_description salemaker_sales sessions specials tax_class tax_rates template_select upgrade_exceptions whos_online zones zones_to_geo_zones

address_book

Field	Type	Collation	Null	Key	Default	Extra	Comment
address_book_id	int(11)		NO	PRI		auto_increment
customers_id	int(11)		NO	MUL	0
entry_gender	char(1)	utf8mb4_general_ci	NO
entry_company	varchar(64)	utf8mb4_general_ci	YES
entry_firstname	varchar(32)	utf8mb4_general_ci	NO
entry_lastname	varchar(32)	utf8mb4_general_ci	NO
entry_street_address	varchar(128)	utf8mb4_general_ci	NO
entry_suburb	varchar(128)	utf8mb4_general_ci	YES
entry_postcode	varchar(64)	utf8mb4_general_ci	NO
entry_city	varchar(128)	utf8mb4_general_ci	NO
entry_state	varchar(128)	utf8mb4_general_ci	YES
entry_country_id	int(11)		NO		0
entry_zone_id	int(11)		NO		0

address_format

Field	Type	Collation	Null	Key	Default	Extra	Comment
address_format_id	int(11)		NO	PRI		auto_increment
address_format	varchar(128)	utf8mb4_general_ci	NO
address_summary	varchar(48)	utf8mb4_general_ci	NO

admin

Field	Type	Collation	Null	Key	Default	Extra	Comment
admin_id	int(11)		NO	PRI		auto_increment
admin_name	varchar(32)	utf8mb4_general_ci	NO	MUL
admin_email	varchar(96)	utf8mb4_general_ci	NO	MUL
admin_profile	int(11)		NO	MUL	0
admin_pass	varchar(255)	utf8mb4_general_ci	NO
prev_pass1	varchar(255)	utf8mb4_general_ci	NO
prev_pass2	varchar(255)	utf8mb4_general_ci	NO
prev_pass3	varchar(255)	utf8mb4_general_ci	NO
pwd_last_change_date	datetime		NO		0001-01-01 00:00:00
reset_token	varchar(255)	utf8mb4_general_ci	NO
last_modified	datetime		NO		0001-01-01 00:00:00
last_login_date	datetime		NO		0001-01-01 00:00:00
last_login_ip	varchar(45)	utf8mb4_general_ci	NO
failed_logins	smallint(4) unsigned		NO		0
lockout_expires	int(11)		NO		0
last_failed_attempt	datetime		NO		0001-01-01 00:00:00
last_failed_ip	varchar(45)	utf8mb4_general_ci	NO
mfa	text	utf8mb4_general_ci	YES

admin_activity_log

Field	Type	Collation	Null	Key	Default	Extra	Comment
log_id	bigint(15)		NO	PRI		auto_increment
access_date	datetime		NO	MUL	0001-01-01 00:00:00
admin_id	int(11)		NO		0
page_accessed	varchar(80)	utf8mb4_general_ci	NO	MUL
page_parameters	text	utf8mb4_general_ci	YES
ip_address	varchar(45)	utf8mb4_general_ci	NO	MUL
flagged	tinyint(4)		NO	MUL	0
attention	mediumtext	utf8mb4_general_ci	YES
gzpost	mediumblob		YES
logmessage	mediumtext	utf8mb4_general_ci	NO
severity	varchar(9)	utf8mb4_general_ci	NO		info

admin_expired_tokens

Field	Type	Collation	Null	Key	Default	Extra	Comment
admin_name	varchar(44)	utf8mb4_general_ci	NO	PRI
otp_code	varchar(32)	utf8mb4_general_ci	NO	PRI
used_date	timestamp		NO	PRI	CURRENT_TIMESTAMP

admin_menus

Field	Type	Collation	Null	Key	Default	Extra	Comment
menu_key	varchar(191)	utf8mb4_general_ci	NO	PRI
language_key	varchar(255)	utf8mb4_general_ci	NO
sort_order	int(11)		NO		0

admin_notifications

Field	Type	Collation	Null	Key	Default	Extra	Comment
notification_key	varchar(40)	utf8mb4_general_ci	NO	PRI
admin_id	int(11)		YES
dismissed	char(1)	utf8mb4_general_ci	YES

admin_pages

Field	Type	Collation	Null	Key	Default	Extra	Comment
page_key	varchar(191)	utf8mb4_general_ci	NO	PRI
language_key	varchar(255)	utf8mb4_general_ci	NO
main_page	varchar(255)	utf8mb4_general_ci	NO
page_params	varchar(255)	utf8mb4_general_ci	NO
menu_key	varchar(191)	utf8mb4_general_ci	NO
display_on_menu	char(1)	utf8mb4_general_ci	NO		N
sort_order	int(11)		NO		0

admin_pages_to_profiles

Field	Type	Collation	Null	Key	Default	Extra	Comment
profile_id	int(11)		NO	PRI	0
page_key	varchar(191)	utf8mb4_general_ci	NO	PRI

admin_profiles

Field	Type	Collation	Null	Key	Default	Extra	Comment
profile_id	int(11)		NO	PRI		auto_increment
profile_name	varchar(191)	utf8mb4_general_ci	NO	UNI

authorizenet

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int(11) unsigned		NO	PRI		auto_increment
customer_id	int(11)		NO		0
order_id	int(11)		NO		0
response_code	int(1)		NO		0
response_text	varchar(255)	utf8mb4_general_ci	NO
authorization_type	varchar(50)	utf8mb4_general_ci	NO
transaction_id	varchar(32)	utf8mb4_general_ci	YES
sent	longtext	utf8mb4_general_ci	NO
received	longtext	utf8mb4_general_ci	NO
time	varchar(50)	utf8mb4_general_ci	NO
session_id	varchar(255)	utf8mb4_general_ci	NO

banners

Field	Type	Collation	Null	Key	Default	Extra	Comment
banners_id	int(11)		NO	PRI		auto_increment
banners_title	varchar(64)	utf8mb4_general_ci	NO
banners_url	varchar(255)	utf8mb4_general_ci	NO
banners_image	varchar(255)	utf8mb4_general_ci	NO
banners_group	varchar(15)	utf8mb4_general_ci	NO
banners_html_text	text	utf8mb4_general_ci	YES
expires_impressions	int(7)		YES		0
expires_date	datetime		YES	MUL
date_scheduled	datetime		YES	MUL
date_added	datetime		NO		0001-01-01 00:00:00
date_status_change	datetime		YES
status	int(1)		NO	MUL	1
banners_open_new_windows	int(1)		NO		1
banners_on_ssl	int(1)		NO		1
banners_sort_order	int(11)		NO		0

banners_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
banners_history_id	int(11)		NO	PRI		auto_increment
banners_id	int(11)		NO	MUL	0
banners_shown	int(5)		NO		0
banners_clicked	int(5)		NO		0
banners_history_date	datetime		NO		0001-01-01 00:00:00

categories_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
categories_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	1
categories_name	varchar(32)	utf8mb4_general_ci	NO	MUL
categories_description	text	utf8mb4_general_ci	NO

configuration

Field	Type	Collation	Null	Key	Default	Extra	Comment
configuration_id	int(11)		NO	PRI		auto_increment
configuration_title	text	utf8mb4_general_ci	NO
configuration_key	varchar(180)	utf8mb4_general_ci	NO	UNI
configuration_value	text	utf8mb4_general_ci	NO
configuration_description	text	utf8mb4_general_ci	NO
configuration_group_id	int(11)		NO	MUL	0
sort_order	int(5)		YES
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00
use_function	text	utf8mb4_general_ci	YES
set_function	text	utf8mb4_general_ci	YES
val_function	text	utf8mb4_general_ci	YES

configuration_group

Field	Type	Collation	Null	Key	Default	Extra	Comment
configuration_group_id	int(11)		NO	PRI		auto_increment
configuration_group_title	varchar(64)	utf8mb4_general_ci	NO
configuration_group_description	varchar(255)	utf8mb4_general_ci	NO
sort_order	int(5)		YES
visible	int(1)		YES	MUL	1

count_product_views

Field	Type	Collation	Null	Key	Default	Extra	Comment
product_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	1
date_viewed	date		NO	PRI
views	int(11)		YES

counter

Field	Type	Collation	Null	Key	Default	Extra	Comment
startdate	char(8)	utf8mb4_general_ci	YES
counter	int(12)		YES

counter_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
startdate	char(8)	utf8mb4_general_ci	NO	PRI
counter	int(12)		YES
session_counter	int(12)		YES

countries

Field	Type	Collation	Null	Key	Default	Extra	Comment
countries_id	int(11)		NO	PRI		auto_increment
countries_name	varchar(64)	utf8mb4_general_ci	NO	MUL
countries_iso_code_2	char(2)	utf8mb4_general_ci	NO	MUL
countries_iso_code_3	char(3)	utf8mb4_general_ci	NO	MUL
address_format_id	int(11)		NO	MUL	0
status	tinyint(1)		YES		1

coupon_email_track

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_id	int(11)		NO	PRI		auto_increment
coupon_id	int(11)		NO	MUL	0
customer_id_sent	int(11)		NO		0
sent_firstname	varchar(32)	utf8mb4_general_ci	YES
sent_lastname	varchar(32)	utf8mb4_general_ci	YES
emailed_to	varchar(96)	utf8mb4_general_ci	YES
date_sent	datetime		NO		0001-01-01 00:00:00

coupon_gv_customer

Field	Type	Collation	Null	Key	Default	Extra	Comment
customer_id	int(5)		NO	PRI	0
amount	decimal(15,4)		NO		0.0000

coupon_gv_queue

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_id	int(5)		NO	PRI		auto_increment
customer_id	int(5)		NO	MUL	0
order_id	int(5)		NO		0
amount	decimal(15,4)		NO		0.0000
date_created	datetime		NO		0001-01-01 00:00:00
ipaddr	varchar(45)	utf8mb4_general_ci	NO
release_flag	char(1)	utf8mb4_general_ci	NO	MUL	N

coupon_redeem_track

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_id	int(11)		NO	PRI		auto_increment
coupon_id	int(11)		NO	MUL	0
customer_id	int(11)		NO		0
redeem_date	datetime		NO		0001-01-01 00:00:00
redeem_ip	varchar(45)	utf8mb4_general_ci	NO
order_id	int(11)		NO		0

coupon_referrers

Field	Type	Collation	Null	Key	Default	Extra	Comment
referrer_id	int(11)		NO	PRI		auto_increment
referrer_domain	varchar(64)	utf8mb4_general_ci	NO	UNI
coupon_id	int(11)		NO	MUL
date_added	timestamp		NO		CURRENT_TIMESTAMP
updated_at	timestamp		NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP

coupon_restrict

Field	Type	Collation	Null	Key	Default	Extra	Comment
restrict_id	int(11)		NO	PRI		auto_increment
coupon_id	int(11)		NO	MUL	0
product_id	int(11)		NO		0
category_id	int(11)		NO		0
coupon_restrict	char(1)	utf8mb4_general_ci	NO		N

coupons

Field	Type	Collation	Null	Key	Default	Extra	Comment
coupon_id	int(11)		NO	PRI		auto_increment
coupon_type	char(1)	utf8mb4_general_ci	NO	MUL	F
coupon_code	varchar(32)	utf8mb4_general_ci	NO	MUL
coupon_amount	decimal(15,4)		NO		0.0000
coupon_minimum_order	decimal(15,4)		NO		0.0000
coupon_start_date	datetime		NO		0001-01-01 00:00:00
coupon_expire_date	datetime		NO		0001-01-01 00:00:00
uses_per_coupon	int(5)		NO		1
uses_per_user	int(5)		NO		0
restrict_to_products	varchar(255)	utf8mb4_general_ci	YES
restrict_to_categories	varchar(255)	utf8mb4_general_ci	YES
restrict_to_customers	text	utf8mb4_general_ci	YES
coupon_active	char(1)	utf8mb4_general_ci	NO	MUL	Y
date_created	datetime		NO		0001-01-01 00:00:00
date_modified	datetime		NO		0001-01-01 00:00:00
coupon_zone_restriction	int(11)		NO		0
coupon_calc_base	tinyint(1)		NO		0
coupon_order_limit	int(4)		NO		0
coupon_is_valid_for_sales	tinyint(1)		NO		1
coupon_product_count	tinyint(1)		NO		0

coupons_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
coupon_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	0
coupon_name	varchar(64)	utf8mb4_general_ci	NO
coupon_description	text	utf8mb4_general_ci	YES

currencies

Field	Type	Collation	Null	Key	Default	Extra	Comment
currencies_id	int(11)		NO	PRI		auto_increment
title	varchar(32)	utf8mb4_general_ci	NO
code	char(3)	utf8mb4_general_ci	NO
symbol_left	varchar(32)	utf8mb4_general_ci	YES
symbol_right	varchar(32)	utf8mb4_general_ci	YES
decimal_point	char(1)	utf8mb4_general_ci	YES
thousands_point	char(1)	utf8mb4_general_ci	YES
decimal_places	char(1)	utf8mb4_general_ci	YES
value	decimal(14,6)		YES
last_updated	datetime		YES

customer_groups

Field	Type	Collation	Null	Key	Default	Extra	Comment
group_id	int(10) unsigned		NO	PRI		auto_increment
group_name	varchar(191)	utf8mb4_general_ci	NO	UNI
group_comment	varchar(255)	utf8mb4_general_ci	YES
date_added	timestamp		NO		CURRENT_TIMESTAMP
updated_at	timestamp		NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP

customers

Field	Type	Collation	Null	Key	Default	Extra	Comment
customers_id	int(11)		NO	PRI		auto_increment
customers_gender	char(1)	utf8mb4_general_ci	NO
customers_firstname	varchar(32)	utf8mb4_general_ci	NO
customers_lastname	varchar(32)	utf8mb4_general_ci	NO
customers_dob	datetime		NO		0001-01-01 00:00:00
customers_email_address	varchar(96)	utf8mb4_general_ci	NO	MUL
customers_nick	varchar(96)	utf8mb4_general_ci	NO	MUL
customers_default_address_id	int(11)		NO		0
customers_telephone	varchar(32)	utf8mb4_general_ci	NO
customers_fax	varchar(32)	utf8mb4_general_ci	YES
customers_password	varchar(255)	utf8mb4_general_ci	NO
customers_secret	varchar(64)	utf8mb4_general_ci	NO
customers_newsletter	char(1)	utf8mb4_general_ci	YES	MUL
customers_group_pricing	int(11)		NO	MUL	0
customers_email_format	varchar(4)	utf8mb4_general_ci	NO		TEXT
customers_authorization	int(1)		NO		0
customers_referral	varchar(32)	utf8mb4_general_ci	NO	MUL
registration_ip	varchar(45)	utf8mb4_general_ci	NO
last_login_ip	varchar(45)	utf8mb4_general_ci	NO
customers_paypal_payerid	varchar(20)	utf8mb4_general_ci	NO
customers_paypal_ec	tinyint(1) unsigned		NO		0
customers_whole	tinyint(1)		NO		0

customers_basket

Field	Type	Collation	Null	Key	Default	Extra	Comment
customers_basket_id	int(11)		NO	PRI		auto_increment
customers_id	int(11)		NO	MUL	0
products_id	tinytext	utf8mb4_general_ci	NO
customers_basket_quantity	float		NO		0
customers_basket_date_added	varchar(8)	utf8mb4_general_ci	YES

customers_basket_attributes

Field	Type	Collation	Null	Key	Default	Extra	Comment
customers_basket_attributes_id	int(11)		NO	PRI		auto_increment
customers_id	int(11)		NO	MUL	0
products_id	tinytext	utf8mb4_general_ci	NO
products_options_id	varchar(64)	utf8mb4_general_ci	NO		0
products_options_value_id	int(11)		NO		0
products_options_value_text	blob		YES
products_options_sort_order	text	utf8mb4_general_ci	NO

customers_info

Field	Type	Collation	Null	Key	Default	Extra	Comment
customers_info_id	int(11)		NO	PRI	0
customers_info_date_of_last_logon	datetime		YES
customers_info_number_of_logons	int(5)		YES
customers_info_date_account_created	datetime		YES	MUL
customers_info_date_account_last_modified	datetime		YES
global_product_notifications	int(1)		YES		0

customers_to_groups

Field	Type	Collation	Null	Key	Default	Extra	Comment
id	int(10) unsigned		NO	PRI		auto_increment
group_id	int(10) unsigned		NO	MUL
customer_id	int(10) unsigned		NO	MUL
date_added	timestamp		NO		CURRENT_TIMESTAMP
updated_at	timestamp		NO		CURRENT_TIMESTAMP	on update CURRENT_TIMESTAMP

db_cache

Field	Type	Collation	Null	Key	Default	Extra	Comment
cache_entry_name	varchar(64)	utf8mb4_general_ci	NO	PRI
cache_data	mediumblob		YES
cache_entry_created	int(15)		YES

email_archive

Field	Type	Collation	Null	Key	Default	Extra	Comment
archive_id	int(11)		NO	PRI		auto_increment
email_to_name	varchar(96)	utf8mb4_general_ci	NO
email_to_address	varchar(96)	utf8mb4_general_ci	NO	MUL
email_from_name	varchar(96)	utf8mb4_general_ci	NO
email_from_address	varchar(96)	utf8mb4_general_ci	NO
email_subject	varchar(255)	utf8mb4_general_ci	NO
email_html	text	utf8mb4_general_ci	NO
email_text	text	utf8mb4_general_ci	NO
date_sent	datetime		NO	MUL	0001-01-01 00:00:00
module	varchar(64)	utf8mb4_general_ci	NO	MUL
errorinfo	text	utf8mb4_general_ci	YES

ezpages

Field	Type	Collation	Null	Key	Default	Extra	Comment
pages_id	int(11)		NO	PRI		auto_increment
alt_url	varchar(255)	utf8mb4_general_ci	NO
alt_url_external	varchar(255)	utf8mb4_general_ci	NO
status_mobile	tinyint(4)		NO	MUL	1
status_header	int(1)		NO	MUL	1
status_sidebox	int(1)		NO	MUL	1
status_footer	int(1)		NO	MUL	1
status_visible	int(1)		NO		0
status_toc	int(1)		NO	MUL	1
mobile_sort_order	tinyint(4)		NO		0
header_sort_order	int(3)		NO		0
sidebox_sort_order	int(3)		NO		0
footer_sort_order	int(3)		NO		0
toc_sort_order	int(3)		NO		0
page_open_new_window	int(1)		NO		0
page_is_ssl	int(1)		NO		1
toc_chapter	int(11)		NO		0

ezpages_content

Field	Type	Collation	Null	Key	Default	Extra	Comment
pages_id	int(11)		NO	PRI	0
languages_id	int(11)		NO	PRI	1
pages_title	varchar(64)	utf8mb4_general_ci	NO
pages_html_text	mediumtext	utf8mb4_general_ci	YES

featured

Field	Type	Collation	Null	Key	Default	Extra	Comment
featured_id	int(11)		NO	PRI		auto_increment
products_id	int(11)		NO	MUL	0
featured_date_added	datetime		YES
featured_last_modified	datetime		YES
expires_date	date		NO	MUL	0001-01-01
date_status_change	datetime		YES
status	int(1)		NO	MUL	1
featured_date_available	date		NO	MUL	0001-01-01

featured_categories

Field	Type	Collation	Null	Key	Default	Extra	Comment
featured_categories_id	int(11)		NO	PRI		auto_increment
categories_id	int(11)		NO	MUL	0
featured_date_added	datetime		YES
featured_last_modified	datetime		YES
expires_date	date		NO	MUL	0001-01-01
date_status_change	datetime		YES
status	int(1)		NO	MUL	1
featured_date_available	date		NO	MUL	0001-01-01

files_uploaded

Field	Type	Collation	Null	Key	Default	Extra	Comment
files_uploaded_id	int(11)		NO	PRI		auto_increment
sesskey	varchar(32)	utf8mb4_general_ci	YES
customers_id	int(11)		YES	MUL
files_uploaded_name	varchar(64)	utf8mb4_general_ci	NO

geo_zones

Field	Type	Collation	Null	Key	Default	Extra	Comment
geo_zone_id	int(11)		NO	PRI		auto_increment
geo_zone_name	varchar(32)	utf8mb4_general_ci	NO
geo_zone_description	varchar(255)	utf8mb4_general_ci	NO
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00

get_terms_to_filter

Field	Type	Collation	Null	Key	Default	Extra	Comment
get_term_name	varchar(191)	utf8mb4_general_ci	NO	PRI
get_term_table	varchar(64)	utf8mb4_general_ci	NO
get_term_name_field	varchar(64)	utf8mb4_general_ci	NO

group_pricing

Field	Type	Collation	Null	Key	Default	Extra	Comment
group_id	int(11)		NO	PRI		auto_increment
group_name	varchar(32)	utf8mb4_general_ci	NO
group_percentage	decimal(5,2)		NO		0.00
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00

languages

Field	Type	Collation	Null	Key	Default	Extra	Comment
languages_id	int(11)		NO	PRI		auto_increment
name	varchar(32)	utf8mb4_general_ci	NO	MUL
code	char(2)	utf8mb4_general_ci	NO
image	varchar(64)	utf8mb4_general_ci	YES
directory	varchar(32)	utf8mb4_general_ci	YES
sort_order	int(3)		YES

layout_boxes

Field	Type	Collation	Null	Key	Default	Extra	Comment
layout_id	int(11)		NO	PRI		auto_increment
layout_template	varchar(64)	utf8mb4_general_ci	NO	MUL
layout_box_name	varchar(64)	utf8mb4_general_ci	NO
layout_box_status	tinyint(1)		NO	MUL	0
layout_box_location	tinyint(1)		NO		0
layout_box_sort_order	int(11)		NO	MUL	0
layout_box_sort_order_single	int(11)		NO		0
layout_box_status_single	tinyint(4)		NO		0
plugin_details	varchar(100)	utf8mb4_general_ci	NO

manufacturers

Field	Type	Collation	Null	Key	Default	Extra	Comment
manufacturers_id	int(11)		NO	PRI		auto_increment
manufacturers_name	varchar(32)	utf8mb4_general_ci	NO	MUL
manufacturers_image	varchar(255)	utf8mb4_general_ci	YES
date_added	datetime		YES
last_modified	datetime		YES
featured	tinyint(4)		YES		0

manufacturers_info

Field	Type	Collation	Null	Key	Default	Extra	Comment
manufacturers_id	int(11)		NO	PRI	0
languages_id	int(11)		NO	PRI	0
manufacturers_url	varchar(255)	utf8mb4_general_ci	NO
url_clicked	int(5)		NO		0
date_last_click	datetime		YES

media_clips

Field	Type	Collation	Null	Key	Default	Extra	Comment
clip_id	int(11)		NO	PRI		auto_increment
media_id	int(11)		NO	MUL	0
clip_type	smallint(6)		NO	MUL	0
clip_filename	text	utf8mb4_general_ci	NO
date_added	datetime		NO		0001-01-01 00:00:00
last_modified	datetime		NO		0001-01-01 00:00:00

media_manager

Field	Type	Collation	Null	Key	Default	Extra	Comment
media_id	int(11)		NO	PRI		auto_increment
media_name	varchar(255)	utf8mb4_general_ci	NO	MUL
last_modified	datetime		NO		0001-01-01 00:00:00
date_added	datetime		NO		0001-01-01 00:00:00

media_to_products

Field	Type	Collation	Null	Key	Default	Extra	Comment
media_id	int(11)		NO	MUL	0
product_id	int(11)		NO		0

media_types

Field	Type	Collation	Null	Key	Default	Extra	Comment
type_id	int(11)		NO	PRI		auto_increment
type_name	varchar(64)	utf8mb4_general_ci	NO	MUL
type_ext	varchar(8)	utf8mb4_general_ci	NO

meta_tags_categories_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
categories_id	int(11)		NO	PRI
language_id	int(11)		NO	PRI	1
metatags_title	varchar(255)	utf8mb4_general_ci	NO
metatags_keywords	text	utf8mb4_general_ci	YES
metatags_description	text	utf8mb4_general_ci	YES

meta_tags_products_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI
language_id	int(11)		NO	PRI	1
metatags_title	varchar(255)	utf8mb4_general_ci	NO
metatags_keywords	text	utf8mb4_general_ci	YES
metatags_description	text	utf8mb4_general_ci	YES

music_genre

Field	Type	Collation	Null	Key	Default	Extra	Comment
music_genre_id	int(11)		NO	PRI		auto_increment
music_genre_name	varchar(32)	utf8mb4_general_ci	NO	MUL
date_added	datetime		YES
last_modified	datetime		YES

newsletters

Field	Type	Collation	Null	Key	Default	Extra	Comment
newsletters_id	int(11)		NO	PRI		auto_increment
title	varchar(255)	utf8mb4_general_ci	NO
content	text	utf8mb4_general_ci	NO
content_html	text	utf8mb4_general_ci	NO
module	varchar(255)	utf8mb4_general_ci	NO
date_added	datetime		NO		0001-01-01 00:00:00
date_sent	datetime		YES
status	int(1)		YES
locked	int(1)		YES		0

orders

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_id	int(11)		NO	PRI		auto_increment
customers_id	int(11)		NO	MUL	0
customers_name	varchar(64)	utf8mb4_general_ci	NO
customers_company	varchar(64)	utf8mb4_general_ci	YES
customers_street_address	varchar(128)	utf8mb4_general_ci	NO
customers_suburb	varchar(128)	utf8mb4_general_ci	YES
customers_city	varchar(128)	utf8mb4_general_ci	NO
customers_postcode	varchar(64)	utf8mb4_general_ci	NO
customers_state	varchar(128)	utf8mb4_general_ci	YES
customers_country	varchar(64)	utf8mb4_general_ci	NO
customers_telephone	varchar(32)	utf8mb4_general_ci	NO
customers_email_address	varchar(96)	utf8mb4_general_ci	NO
customers_address_format_id	int(5)		NO		0
delivery_name	varchar(64)	utf8mb4_general_ci	NO
delivery_company	varchar(64)	utf8mb4_general_ci	YES
delivery_street_address	varchar(128)	utf8mb4_general_ci	NO
delivery_suburb	varchar(128)	utf8mb4_general_ci	YES
delivery_city	varchar(128)	utf8mb4_general_ci	NO
delivery_postcode	varchar(64)	utf8mb4_general_ci	NO
delivery_state	varchar(128)	utf8mb4_general_ci	YES
delivery_country	varchar(64)	utf8mb4_general_ci	NO
delivery_address_format_id	int(5)		NO		0
billing_name	varchar(64)	utf8mb4_general_ci	NO
billing_company	varchar(64)	utf8mb4_general_ci	YES
billing_street_address	varchar(128)	utf8mb4_general_ci	NO
billing_suburb	varchar(128)	utf8mb4_general_ci	YES
billing_city	varchar(128)	utf8mb4_general_ci	NO
billing_postcode	varchar(64)	utf8mb4_general_ci	NO
billing_state	varchar(128)	utf8mb4_general_ci	YES
billing_country	varchar(64)	utf8mb4_general_ci	NO
billing_address_format_id	int(5)		NO		0
payment_method	varchar(128)	utf8mb4_general_ci	NO
payment_module_code	varchar(32)	utf8mb4_general_ci	NO
shipping_method	varchar(255)	utf8mb4_general_ci	YES
shipping_module_code	varchar(32)	utf8mb4_general_ci	NO
coupon_code	varchar(32)	utf8mb4_general_ci	NO
cc_type	varchar(20)	utf8mb4_general_ci	YES
cc_owner	varchar(64)	utf8mb4_general_ci	YES
cc_number	varchar(32)	utf8mb4_general_ci	YES
cc_expires	varchar(4)	utf8mb4_general_ci	YES
cc_cvv	blob		YES
last_modified	datetime		YES
date_purchased	datetime		YES	MUL
orders_status	int(5)		NO	MUL	0
orders_date_finished	datetime		YES
currency	char(3)	utf8mb4_general_ci	YES
currency_value	decimal(14,6)		YES
order_total	decimal(15,4)		YES
order_tax	decimal(15,4)		YES
shipping_tax_rate	decimal(15,4)		YES
paypal_ipn_id	int(11)		NO		0
ip_address	varchar(96)	utf8mb4_general_ci	NO
order_weight	float		YES
language_code	char(2)	utf8mb4_general_ci	NO
is_wholesale	tinyint(1)		YES

orders_products

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_products_id	int(11)		NO	PRI		auto_increment
orders_id	int(11)		NO	MUL	0
products_id	int(11)		NO	MUL	0
products_model	varchar(32)	utf8mb4_general_ci	YES
products_name	varchar(191)	utf8mb4_general_ci	NO
products_price	decimal(15,4)		NO		0.0000
final_price	decimal(15,4)		NO		0.0000
products_tax	decimal(7,4)		NO		0.0000
products_quantity	float		NO		0
onetime_charges	decimal(15,4)		NO		0.0000
products_priced_by_attribute	tinyint(1)		NO		0
product_is_free	tinyint(1)		NO		0
products_discount_type	tinyint(1)		NO		0
products_discount_type_from	tinyint(1)		NO		0
products_prid	tinytext	utf8mb4_general_ci	NO
products_weight	float		YES
products_virtual	tinyint(1)		YES
product_is_always_free_shipping	tinyint(1)		YES
products_quantity_order_min	float		YES
products_quantity_order_units	float		YES
products_quantity_order_max	float		YES
products_quantity_mixed	tinyint(1)		YES
products_mixed_discount_quantity	tinyint(1)		YES

orders_products_attributes

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_products_attributes_id	int(11)		NO	PRI		auto_increment
orders_id	int(11)		NO	MUL	0
orders_products_id	int(11)		NO		0
products_options	varchar(32)	utf8mb4_general_ci	NO
products_options_values	text	utf8mb4_general_ci	NO
options_values_price	decimal(15,4)		NO		0.0000
price_prefix	char(1)	utf8mb4_general_ci	NO
product_attribute_is_free	tinyint(1)		NO		0
products_attributes_weight	float		NO		0
products_attributes_weight_prefix	char(1)	utf8mb4_general_ci	NO
attributes_discounted	tinyint(1)		NO		1
attributes_price_base_included	tinyint(1)		NO		1
attributes_price_onetime	decimal(15,4)		NO		0.0000
attributes_price_factor	decimal(15,4)		NO		0.0000
attributes_price_factor_offset	decimal(15,4)		NO		0.0000
attributes_price_factor_onetime	decimal(15,4)		NO		0.0000
attributes_price_factor_onetime_offset	decimal(15,4)		NO		0.0000
attributes_qty_prices	text	utf8mb4_general_ci	YES
attributes_qty_prices_onetime	text	utf8mb4_general_ci	YES
attributes_price_words	decimal(15,4)		NO		0.0000
attributes_price_words_free	int(4)		NO		0
attributes_price_letters	decimal(15,4)		NO		0.0000
attributes_price_letters_free	int(4)		NO		0
products_options_id	int(11)		NO		0
products_options_values_id	int(11)		NO		0
products_prid	tinytext	utf8mb4_general_ci	NO

orders_products_download

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_products_download_id	int(11)		NO	PRI		auto_increment
orders_id	int(11)		NO	MUL	0
orders_products_id	int(11)		NO	MUL	0
orders_products_filename	varchar(255)	utf8mb4_general_ci	NO
download_maxdays	int(2)		NO		0
download_count	int(2)		NO		0
products_prid	tinytext	utf8mb4_general_ci	NO
products_attributes_id	int(11)		YES

orders_status

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_status_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	1
orders_status_name	varchar(32)	utf8mb4_general_ci	NO	MUL
sort_order	int(11)		NO		0

orders_status_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_status_history_id	int(11)		NO	PRI		auto_increment
orders_id	int(11)		NO	MUL	0
orders_status_id	int(5)		NO		0
date_added	datetime		NO		0001-01-01 00:00:00
customer_notified	int(1)		YES		0
comments	text	utf8mb4_general_ci	YES
updated_by	varchar(45)	utf8mb4_general_ci	NO

orders_total

Field	Type	Collation	Null	Key	Default	Extra	Comment
orders_total_id	int(10) unsigned		NO	PRI		auto_increment
orders_id	int(11)		NO	MUL	0
title	varchar(255)	utf8mb4_general_ci	NO
text	varchar(255)	utf8mb4_general_ci	NO
value	decimal(15,4)		NO		0.0000
class	varchar(32)	utf8mb4_general_ci	NO	MUL
sort_order	int(11)		NO		0

paypal

Field	Type	Collation	Null	Key	Default	Extra	Comment
paypal_ipn_id	int(11) unsigned		NO	PRI		auto_increment
order_id	int(11) unsigned		NO	MUL	0
txn_type	varchar(40)	utf8mb4_general_ci	NO
module_name	varchar(40)	utf8mb4_general_ci	NO
module_mode	varchar(40)	utf8mb4_general_ci	NO
reason_code	varchar(40)	utf8mb4_general_ci	YES
payment_type	varchar(40)	utf8mb4_general_ci	NO
payment_status	varchar(32)	utf8mb4_general_ci	NO
pending_reason	varchar(32)	utf8mb4_general_ci	YES
invoice	varchar(128)	utf8mb4_general_ci	YES
mc_currency	char(3)	utf8mb4_general_ci	NO
first_name	varchar(32)	utf8mb4_general_ci	NO
last_name	varchar(32)	utf8mb4_general_ci	NO
payer_business_name	varchar(128)	utf8mb4_general_ci	YES
address_name	varchar(64)	utf8mb4_general_ci	YES
address_street	varchar(254)	utf8mb4_general_ci	YES
address_city	varchar(120)	utf8mb4_general_ci	YES
address_state	varchar(120)	utf8mb4_general_ci	YES
address_zip	varchar(64)	utf8mb4_general_ci	YES
address_country	varchar(64)	utf8mb4_general_ci	YES
address_status	varchar(11)	utf8mb4_general_ci	YES
payer_email	varchar(128)	utf8mb4_general_ci	NO
payer_id	varchar(32)	utf8mb4_general_ci	NO
payer_status	varchar(10)	utf8mb4_general_ci	NO
payment_date	datetime		NO		0001-01-01 00:00:00
business	varchar(128)	utf8mb4_general_ci	NO
receiver_email	varchar(128)	utf8mb4_general_ci	NO
receiver_id	varchar(32)	utf8mb4_general_ci	NO
txn_id	varchar(20)	utf8mb4_general_ci	NO	PRI
parent_txn_id	varchar(20)	utf8mb4_general_ci	YES
num_cart_items	tinyint(4) unsigned		NO		1
mc_gross	decimal(15,4)		NO		0.0000
mc_fee	decimal(15,4)		NO		0.0000
payment_gross	decimal(15,4)		YES
payment_fee	decimal(15,4)		YES
settle_amount	decimal(15,4)		YES
settle_currency	char(3)	utf8mb4_general_ci	YES
exchange_rate	decimal(15,4)		YES
notify_version	varchar(6)	utf8mb4_general_ci	NO
verify_sign	varchar(128)	utf8mb4_general_ci	NO
last_modified	datetime		NO		0001-01-01 00:00:00
date_added	datetime		NO		0001-01-01 00:00:00
memo	text	utf8mb4_general_ci	YES

paypal_payment_status

Field	Type	Collation	Null	Key	Default	Extra	Comment
payment_status_id	int(11)		NO	PRI		auto_increment
payment_status_name	varchar(64)	utf8mb4_general_ci	NO

paypal_payment_status_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
payment_status_history_id	int(11)		NO	PRI		auto_increment
paypal_ipn_id	int(11)		NO	MUL	0
txn_id	varchar(64)	utf8mb4_general_ci	NO
parent_txn_id	varchar(64)	utf8mb4_general_ci	NO
payment_status	varchar(17)	utf8mb4_general_ci	NO
pending_reason	varchar(32)	utf8mb4_general_ci	YES
date_added	datetime		NO		0001-01-01 00:00:00

paypal_session

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_id	int(11)		NO	PRI		auto_increment
session_id	text	utf8mb4_general_ci	NO	MUL
saved_session	mediumblob		NO
expiry	int(17)		NO		0

paypal_testing

Field	Type	Collation	Null	Key	Default	Extra	Comment
paypal_ipn_id	int(11) unsigned		NO	PRI		auto_increment
order_id	int(11) unsigned		NO	MUL	0
custom	varchar(255)	utf8mb4_general_ci	NO
txn_type	varchar(40)	utf8mb4_general_ci	NO
module_name	varchar(40)	utf8mb4_general_ci	NO
module_mode	varchar(40)	utf8mb4_general_ci	NO
reason_code	varchar(40)	utf8mb4_general_ci	YES
payment_type	varchar(40)	utf8mb4_general_ci	NO
payment_status	varchar(32)	utf8mb4_general_ci	NO
pending_reason	varchar(32)	utf8mb4_general_ci	YES
invoice	varchar(128)	utf8mb4_general_ci	YES
mc_currency	char(3)	utf8mb4_general_ci	NO
first_name	varchar(32)	utf8mb4_general_ci	NO
last_name	varchar(32)	utf8mb4_general_ci	NO
payer_business_name	varchar(128)	utf8mb4_general_ci	YES
address_name	varchar(64)	utf8mb4_general_ci	YES
address_street	varchar(254)	utf8mb4_general_ci	YES
address_city	varchar(120)	utf8mb4_general_ci	YES
address_state	varchar(120)	utf8mb4_general_ci	YES
address_zip	varchar(64)	utf8mb4_general_ci	YES
address_country	varchar(64)	utf8mb4_general_ci	YES
address_status	varchar(11)	utf8mb4_general_ci	YES
payer_email	varchar(128)	utf8mb4_general_ci	NO
payer_id	varchar(32)	utf8mb4_general_ci	NO
payer_status	varchar(10)	utf8mb4_general_ci	NO
payment_date	datetime		NO		0001-01-01 00:00:00
business	varchar(128)	utf8mb4_general_ci	NO
receiver_email	varchar(128)	utf8mb4_general_ci	NO
receiver_id	varchar(32)	utf8mb4_general_ci	NO
txn_id	varchar(20)	utf8mb4_general_ci	NO	PRI
parent_txn_id	varchar(20)	utf8mb4_general_ci	YES
num_cart_items	tinyint(4) unsigned		NO		1
mc_gross	decimal(7,2)		NO		0.00
mc_fee	decimal(7,2)		NO		0.00
payment_gross	decimal(7,2)		YES
payment_fee	decimal(7,2)		YES
settle_amount	decimal(7,2)		YES
settle_currency	char(3)	utf8mb4_general_ci	YES
exchange_rate	decimal(4,2)		YES
notify_version	decimal(2,1)		NO		0.0
verify_sign	varchar(128)	utf8mb4_general_ci	NO
last_modified	datetime		NO		0001-01-01 00:00:00
date_added	datetime		NO		0001-01-01 00:00:00
memo	text	utf8mb4_general_ci	YES

plugin_control

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_key	varchar(40)	utf8mb4_general_ci	NO	PRI
name	varchar(64)	utf8mb4_general_ci	NO
description	text	utf8mb4_general_ci	YES
type	varchar(11)	utf8mb4_general_ci	NO		free
managed	tinyint(1)		NO		0
status	tinyint(1)		NO		0
author	varchar(64)	utf8mb4_general_ci	NO
version	varchar(10)	utf8mb4_general_ci	YES
zc_versions	text	utf8mb4_general_ci	NO
zc_contrib_id	int(11)		YES
infs	tinyint(1)		NO		0

plugin_control_versions

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_key	varchar(40)	utf8mb4_general_ci	NO	PRI
version	varchar(10)	utf8mb4_general_ci	NO	PRI
author	varchar(64)	utf8mb4_general_ci	NO
zc_versions	text	utf8mb4_general_ci	NO
infs	tinyint(1)		NO		0

plugin_groups

Field	Type	Collation	Null	Key	Default	Extra	Comment
unique_key	varchar(20)	utf8mb4_general_ci	NO	PRI

plugin_groups_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
plugin_group_unique_key	varchar(20)	utf8mb4_general_ci	NO	PRI
language_id	int(11)		NO	PRI	1
name	varchar(64)	utf8mb4_general_ci	NO

product_music_extra

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI	0
artists_id	int(11)		NO	MUL	0
record_company_id	int(11)		NO	MUL	0
music_genre_id	int(11)		NO	MUL	0

product_type_layout

Field	Type	Collation	Null	Key	Default	Extra	Comment
configuration_id	int(11)		NO	PRI		auto_increment
configuration_title	text	utf8mb4_general_ci	NO
configuration_key	varchar(180)	utf8mb4_general_ci	NO	UNI
configuration_value	text	utf8mb4_general_ci	NO
configuration_description	text	utf8mb4_general_ci	NO
product_type_id	int(11)		NO	MUL	0
sort_order	int(5)		YES
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00
use_function	text	utf8mb4_general_ci	YES
set_function	text	utf8mb4_general_ci	YES

product_types

Field	Type	Collation	Null	Key	Default	Extra	Comment
type_id	int(11)		NO	PRI		auto_increment
type_name	varchar(255)	utf8mb4_general_ci	NO
type_handler	varchar(255)	utf8mb4_general_ci	NO
type_master_type	int(11)		NO	MUL	1
allow_add_to_cart	char(1)	utf8mb4_general_ci	NO		Y
default_image	varchar(255)	utf8mb4_general_ci	NO
date_added	datetime		NO		0001-01-01 00:00:00
last_modified	datetime		NO		0001-01-01 00:00:00

product_types_to_category

Field	Type	Collation	Null	Key	Default	Extra	Comment
product_type_id	int(11)		NO	MUL	0
category_id	int(11)		NO	MUL	0

products

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI		auto_increment
products_type	int(11)		NO		1
products_quantity	float		NO		0
products_model	varchar(32)	utf8mb4_general_ci	YES	MUL
products_mpn	varchar(32)	utf8mb4_general_ci	YES
products_image	varchar(255)	utf8mb4_general_ci	YES
products_price	decimal(15,4)		NO		0.0000
products_price_w	varchar(150)	utf8mb4_general_ci	NO		0
products_virtual	tinyint(1)		NO		0
products_date_added	datetime		NO	MUL	0001-01-01 00:00:00
products_last_modified	datetime		YES
products_date_available	datetime		YES	MUL
products_weight	float		NO		0
products_length	decimal(8,4)		YES
products_width	decimal(8,4)		YES
products_height	decimal(8,4)		YES
product_ships_in_own_box	tinyint(4)		YES
products_status	tinyint(1)		NO	MUL	0
products_tax_class_id	int(11)		NO		0
manufacturers_id	int(11)		YES	MUL
products_ordered	float		NO	MUL	0
products_quantity_order_min	float		NO		1
products_quantity_order_units	float		NO		1
products_priced_by_attribute	tinyint(1)		NO		0
product_is_free	tinyint(1)		NO		0
product_is_call	tinyint(1)		NO		0
products_quantity_mixed	tinyint(1)		NO		0
product_is_always_free_shipping	tinyint(1)		NO		0
products_qty_box_status	tinyint(1)		NO		1
products_quantity_order_max	float		NO		0
products_sort_order	int(11)		NO	MUL	0
products_discount_type	tinyint(1)		NO		0
products_discount_type_from	tinyint(1)		NO		0
products_price_sorter	decimal(15,4)		NO	MUL	0.0000
master_categories_id	int(11)		NO	MUL	0
products_mixed_discount_quantity	tinyint(1)		NO		1
metatags_title_status	tinyint(1)		NO		0
metatags_products_name_status	tinyint(1)		NO		0
metatags_model_status	tinyint(1)		NO		0
metatags_price_status	tinyint(1)		NO		0
metatags_title_tagline_status	tinyint(1)		NO		0

products_attributes

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_attributes_id	int(11)		NO	PRI		auto_increment
products_id	int(11)		NO	MUL	0
options_id	int(11)		NO		0
options_values_id	int(11)		NO		0
options_values_price	decimal(15,4)		NO		0.0000
options_values_price_w	varchar(150)	utf8mb4_general_ci	NO		0
price_prefix	char(1)	utf8mb4_general_ci	NO
products_options_sort_order	int(11)		NO	MUL	0
product_attribute_is_free	tinyint(1)		NO		0
products_attributes_weight	float		NO		0
products_attributes_weight_prefix	char(1)	utf8mb4_general_ci	NO
attributes_display_only	tinyint(1)		NO		0
attributes_default	tinyint(1)		NO		0
attributes_discounted	tinyint(1)		NO		1
attributes_image	varchar(255)	utf8mb4_general_ci	YES
attributes_price_base_included	tinyint(1)		NO		1
attributes_price_onetime	decimal(15,4)		NO		0.0000
attributes_price_factor	decimal(15,4)		NO		0.0000
attributes_price_factor_offset	decimal(15,4)		NO		0.0000
attributes_price_factor_onetime	decimal(15,4)		NO		0.0000
attributes_price_factor_onetime_offset	decimal(15,4)		NO		0.0000
attributes_qty_prices	text	utf8mb4_general_ci	YES
attributes_qty_prices_onetime	text	utf8mb4_general_ci	YES
attributes_price_words	decimal(15,4)		NO		0.0000
attributes_price_words_free	int(4)		NO		0
attributes_price_letters	decimal(15,4)		NO		0.0000
attributes_price_letters_free	int(4)		NO		0
attributes_required	tinyint(1)		NO		0

products_attributes_download

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_attributes_id	int(11)		NO	PRI	0
products_attributes_filename	varchar(255)	utf8mb4_general_ci	NO
products_attributes_maxdays	int(2)		YES		0
products_attributes_maxcount	int(2)		YES		0

products_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI
language_id	int(11)		NO	PRI	1
products_name	varchar(191)	utf8mb4_general_ci	NO	MUL
products_description	text	utf8mb4_general_ci	YES
products_url	varchar(255)	utf8mb4_general_ci	YES
products_viewed	int(5)		YES		0

products_discount_quantity

Field	Type	Collation	Null	Key	Default	Extra	Comment
discount_id	int(4)		NO		0
products_id	int(11)		NO	MUL	0
discount_qty	float		NO		0
discount_price_w	varchar(150)	utf8mb4_general_ci	NO		0
discount_price	decimal(15,4)		NO		0.0000

products_notifications

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI	0
customers_id	int(11)		NO	PRI	0
date_added	datetime		NO		0001-01-01 00:00:00

products_options

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_options_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	1
products_options_name	varchar(32)	utf8mb4_general_ci	NO	MUL
products_options_sort_order	int(11)		NO	MUL	0
products_options_type	int(5)		NO		0
products_options_length	smallint(2)		NO		32
products_options_comment	varchar(256)	utf8mb4_general_ci	YES
products_options_comment_position	smallint(2)		NO		0
products_options_size	smallint(2)		NO		32
products_options_images_per_row	int(2)		YES		5
products_options_images_style	int(1)		YES		0
products_options_rows	smallint(2)		NO		1

products_options_types

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_options_types_id	int(11)		NO	PRI	0
products_options_types_name	varchar(32)	utf8mb4_general_ci	YES

products_options_values

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_options_values_id	int(11)		NO	PRI	0
language_id	int(11)		NO	PRI	1
products_options_values_name	varchar(64)	utf8mb4_general_ci	NO	MUL
products_options_values_sort_order	int(11)		NO	MUL	0

products_options_values_to_products_options

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_options_values_to_products_options_id	int(11)		NO	PRI		auto_increment
products_options_id	int(11)		NO	MUL	0
products_options_values_id	int(11)		NO	MUL	0

products_to_categories

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(11)		NO	PRI	0
categories_id	int(11)		NO	PRI	0

project_version

Field	Type	Collation	Null	Key	Default	Extra	Comment
project_version_id	tinyint(3)		NO	PRI		auto_increment
project_version_key	varchar(40)	utf8mb4_general_ci	NO	UNI
project_version_major	varchar(20)	utf8mb4_general_ci	NO
project_version_minor	varchar(20)	utf8mb4_general_ci	NO
project_version_patch1	varchar(20)	utf8mb4_general_ci	NO
project_version_patch2	varchar(20)	utf8mb4_general_ci	NO
project_version_patch1_source	varchar(20)	utf8mb4_general_ci	NO
project_version_patch2_source	varchar(20)	utf8mb4_general_ci	NO
project_version_comment	varchar(250)	utf8mb4_general_ci	NO
project_version_date_applied	datetime		NO		0001-01-01 01:01:01

project_version_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
project_version_id	tinyint(3)		NO	PRI		auto_increment
project_version_key	varchar(40)	utf8mb4_general_ci	NO
project_version_major	varchar(20)	utf8mb4_general_ci	NO
project_version_minor	varchar(20)	utf8mb4_general_ci	NO
project_version_patch	varchar(20)	utf8mb4_general_ci	NO
project_version_comment	varchar(250)	utf8mb4_general_ci	NO
project_version_date_applied	datetime		NO		0001-01-01 01:01:01

query_builder

Field	Type	Collation	Null	Key	Default	Extra	Comment
query_id	int(11)		NO	PRI		auto_increment
query_category	varchar(40)	utf8mb4_general_ci	NO
query_name	varchar(80)	utf8mb4_general_ci	NO	UNI
query_description	text	utf8mb4_general_ci	NO
query_string	text	utf8mb4_general_ci	NO
query_keys_list	text	utf8mb4_general_ci	NO

record_artists

Field	Type	Collation	Null	Key	Default	Extra	Comment
artists_id	int(11)		NO	PRI		auto_increment
artists_name	varchar(32)	utf8mb4_general_ci	NO	MUL
artists_image	varchar(255)	utf8mb4_general_ci	YES
date_added	datetime		YES
last_modified	datetime		YES

record_artists_info

Field	Type	Collation	Null	Key	Default	Extra	Comment
artists_id	int(11)		NO	PRI	0
languages_id	int(11)		NO	PRI	0
artists_url	varchar(255)	utf8mb4_general_ci	NO
url_clicked	int(5)		NO		0
date_last_click	datetime		YES

record_company

Field	Type	Collation	Null	Key	Default	Extra	Comment
record_company_id	int(11)		NO	PRI		auto_increment
record_company_name	varchar(32)	utf8mb4_general_ci	NO	MUL
record_company_image	varchar(255)	utf8mb4_general_ci	YES
date_added	datetime		YES
last_modified	datetime		YES

record_company_info

Field	Type	Collation	Null	Key	Default	Extra	Comment
record_company_id	int(11)		NO	PRI	0
languages_id	int(11)		NO	PRI	0
record_company_url	varchar(255)	utf8mb4_general_ci	NO
url_clicked	int(5)		NO		0
date_last_click	datetime		YES

reviews

Field	Type	Collation	Null	Key	Default	Extra	Comment
reviews_id	int(11)		NO	PRI		auto_increment
products_id	int(11)		NO	MUL	0
customers_id	int(11)		YES	MUL
customers_name	varchar(64)	utf8mb4_general_ci	NO
reviews_rating	int(1)		YES
date_added	datetime		YES	MUL
last_modified	datetime		YES
reviews_read	int(5)		NO		0
status	int(1)		NO	MUL	1

reviews_description

Field	Type	Collation	Null	Key	Default	Extra	Comment
reviews_id	int(11)		NO	PRI	0
languages_id	int(11)		NO	PRI	0
reviews_text	text	utf8mb4_general_ci	NO

salemaker_sales

Field	Type	Collation	Null	Key	Default	Extra	Comment
sale_id	int(11)		NO	PRI		auto_increment
sale_status	tinyint(4)		NO	MUL	0
sale_name	varchar(128)	utf8mb4_general_ci	NO
sale_deduction_value	decimal(15,4)		NO		0.0000
sale_deduction_type	tinyint(4)		NO		0
sale_pricerange_from	decimal(15,4)		NO		0.0000
sale_pricerange_to	decimal(15,4)		NO		0.0000
sale_specials_condition	tinyint(4)		NO		0
sale_categories_selected	text	utf8mb4_general_ci	YES
sale_categories_all	text	utf8mb4_general_ci	YES
sale_date_start	date		NO	MUL	0001-01-01
sale_date_end	date		NO	MUL	0001-01-01
sale_date_added	date		NO		0001-01-01
sale_date_last_modified	date		NO		0001-01-01
sale_date_status_change	date		NO		0001-01-01

sessions

Field	Type	Collation	Null	Key	Default	Extra	Comment
sesskey	varchar(191)	utf8mb4_general_ci	NO	PRI
expiry	int(11) unsigned		NO		0
value	mediumblob		NO

specials

Field	Type	Collation	Null	Key	Default	Extra	Comment
specials_id	int(11)		NO	PRI		auto_increment
products_id	int(11)		NO	MUL	0
specials_new_products_price	decimal(15,4)		NO		0.0000
specials_date_added	datetime		YES
specials_last_modified	datetime		YES
expires_date	date		NO	MUL	0001-01-01
date_status_change	datetime		YES
status	int(1)		NO	MUL	1
specials_date_available	date		NO	MUL	0001-01-01

tax_class

Field	Type	Collation	Null	Key	Default	Extra	Comment
tax_class_id	int(11)		NO	PRI		auto_increment
tax_class_title	varchar(32)	utf8mb4_general_ci	NO
tax_class_description	varchar(255)	utf8mb4_general_ci	NO
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00

tax_rates

Field	Type	Collation	Null	Key	Default	Extra	Comment
tax_rates_id	int(11)		NO	PRI		auto_increment
tax_zone_id	int(11)		NO	MUL	0
tax_class_id	int(11)		NO	MUL	0
tax_priority	int(5)		YES		1
tax_rate	decimal(7,4)		NO		0.0000
tax_description	varchar(255)	utf8mb4_general_ci	NO
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00

template_select

Field	Type	Collation	Null	Key	Default	Extra	Comment
template_id	int(11)		NO	PRI		auto_increment
template_dir	varchar(64)	utf8mb4_general_ci	NO
template_language	varchar(64)	utf8mb4_general_ci	NO	MUL	0
template_settings	longtext	utf8mb4_general_ci	YES

upgrade_exceptions

Field	Type	Collation	Null	Key	Default	Extra	Comment
upgrade_exception_id	smallint(5)		NO	PRI		auto_increment
sql_file	varchar(128)	utf8mb4_general_ci	YES
reason	text	utf8mb4_general_ci	YES
errordate	datetime		YES
sqlstatement	text	utf8mb4_general_ci	YES

whos_online

Field	Type	Collation	Null	Key	Default	Extra	Comment
customer_id	int(11)		YES	MUL
full_name	varchar(64)	utf8mb4_general_ci	NO
session_id	varchar(191)	utf8mb4_general_ci	NO	MUL
ip_address	varchar(45)	utf8mb4_general_ci	NO	MUL
time_entry	varchar(14)	utf8mb4_general_ci	NO	MUL
time_last_click	varchar(14)	utf8mb4_general_ci	NO	MUL
last_page_url	varchar(255)	utf8mb4_general_ci	NO	MUL
host_address	text	utf8mb4_general_ci	NO
user_agent	varchar(255)	utf8mb4_general_ci	NO

zones

Field	Type	Collation	Null	Key	Default	Extra	Comment
zone_id	int(11)		NO	PRI		auto_increment
zone_country_id	int(11)		NO	MUL	0
zone_code	varchar(32)	utf8mb4_general_ci	NO	MUL
zone_name	varchar(128)	utf8mb4_general_ci	NO

zones_to_geo_zones

Field	Type	Collation	Null	Key	Default	Extra	Comment
association_id	int(11)		NO	PRI		auto_increment
zone_country_id	int(11)		NO		0
zone_id	int(11)		YES
geo_zone_id	int(11)		YES	MUL
last_modified	datetime		YES
date_added	datetime		NO		0001-01-01 00:00:00

Still have questions? Use the Search box in the upper right, or try the full list of FAQs. If you can't find it there, head over to the Zen Cart support forum and ask there in the appropriate subforum. In your post, please include your Zen Cart and PHP versions, and a link to your site.

Is there an error or omission on this page? Please post to General Questions on the support forum. Or, if you'd like to open a pull request, just review the guidelines and get started. You can even PR right here.

Last modified November 23, 2024 by Scott Wilson (5bc112f2).