Zen Cart 1.3.9 Schema

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

address_book address_format admin admin_activity_log authorizenet banners banners_history categories categories_description configuration configuration_group counter counter_history countries coupon_email_track coupon_gv_customer coupon_gv_queue coupon_redeem_track coupon_restrict coupons coupons_description currencies customers customers_basket customers_basket_attributes customers_info customers_wishlist db_cache email_archive ezpages featured 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 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)	latin1_general_ci	NO
entry_company	varchar(64)	latin1_general_ci	YES
entry_firstname	varchar(32)	latin1_general_ci	NO
entry_lastname	varchar(32)	latin1_general_ci	NO
entry_street_address	varchar(64)	latin1_general_ci	NO
entry_suburb	varchar(32)	latin1_general_ci	YES
entry_postcode	varchar(10)	latin1_general_ci	NO
entry_city	varchar(32)	latin1_general_ci	NO
entry_state	varchar(32)	latin1_general_ci	YES
entry_country_id	int(11)		NO		0
entry_zone_id	int(11)		NO		0

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)	latin1_general_ci	NO
entry_company	varchar(64)	latin1_general_ci	YES
entry_firstname	varchar(32)	latin1_general_ci	NO
entry_lastname	varchar(32)	latin1_general_ci	NO
entry_street_address	varchar(64)	latin1_general_ci	NO
entry_suburb	varchar(32)	latin1_general_ci	YES
entry_postcode	varchar(10)	latin1_general_ci	NO
entry_city	varchar(32)	latin1_general_ci	NO
entry_state	varchar(32)	latin1_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)	latin1_general_ci	NO
address_summary	varchar(48)	latin1_general_ci	NO

admin

Field	Type	Collation	Null	Key	Default	Extra	Comment
admin_id	int(11)		NO	PRI		auto_increment
admin_name	varchar(32)	latin1_general_ci	NO	MUL
admin_email	varchar(96)	latin1_general_ci	NO	MUL
admin_pass	varchar(40)	latin1_general_ci	NO
admin_level	tinyint(1)		NO		1

admin_activity_log

Field	Type	Collation	Null	Key	Default	Extra	Comment
log_id	int(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)	latin1_general_ci	NO	MUL
page_parameters	text	latin1_general_ci	YES
ip_address	varchar(15)	latin1_general_ci	NO	MUL

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)	latin1_general_ci	NO
authorization_type	varchar(50)	latin1_general_ci	NO
transaction_id	bigint(20)		YES
sent	longtext	latin1_general_ci	NO
received	longtext	latin1_general_ci	NO
time	varchar(50)	latin1_general_ci	NO
session_id	varchar(255)	latin1_general_ci	NO

banners

Field	Type	Collation	Null	Key	Default	Extra	Comment
banners_id	int(11)		NO	PRI		auto_increment
banners_title	varchar(64)	latin1_general_ci	NO
banners_url	varchar(255)	latin1_general_ci	NO
banners_image	varchar(64)	latin1_general_ci	NO
banners_group	varchar(15)	latin1_general_ci	NO
banners_html_text	text	latin1_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)	latin1_general_ci	NO	MUL
categories_description	text	latin1_general_ci	NO

configuration

Field	Type	Collation	Null	Key	Default	Extra	Comment
configuration_id	int(11)		NO	PRI		auto_increment
configuration_title	text	latin1_general_ci	NO
configuration_key	varchar(255)	latin1_general_ci	NO	UNI
configuration_value	text	latin1_general_ci	NO
configuration_description	text	latin1_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	latin1_general_ci	YES
set_function	text	latin1_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)	latin1_general_ci	NO
configuration_group_description	varchar(255)	latin1_general_ci	NO
sort_order	int(5)		YES
visible	int(1)		YES	MUL	1

counter

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

counter_history

Field	Type	Collation	Null	Key	Default	Extra	Comment
startdate	char(8)	latin1_general_ci	YES	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)	latin1_general_ci	NO	MUL
countries_iso_code_2	char(2)	latin1_general_ci	NO	MUL
countries_iso_code_3	char(3)	latin1_general_ci	NO	MUL
address_format_id	int(11)		NO	MUL	0

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)	latin1_general_ci	YES
sent_lastname	varchar(32)	latin1_general_ci	YES
emailed_to	varchar(32)	latin1_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(32)	latin1_general_ci	NO
release_flag	char(1)	latin1_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(32)	latin1_general_ci	NO
order_id	int(11)		NO		0

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)	latin1_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)	latin1_general_ci	NO	MUL	F
coupon_code	varchar(32)	latin1_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)	latin1_general_ci	YES
restrict_to_categories	varchar(255)	latin1_general_ci	YES
restrict_to_customers	text	latin1_general_ci	YES
coupon_active	char(1)	latin1_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

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(32)	latin1_general_ci	NO
coupon_description	text	latin1_general_ci	YES

currencies

Field	Type	Collation	Null	Key	Default	Extra	Comment
currencies_id	int(11)		NO	PRI		auto_increment
title	varchar(32)	latin1_general_ci	NO
code	char(3)	latin1_general_ci	NO
symbol_left	varchar(24)	latin1_general_ci	YES
symbol_right	varchar(24)	latin1_general_ci	YES
decimal_point	char(1)	latin1_general_ci	YES
thousands_point	char(1)	latin1_general_ci	YES
decimal_places	char(1)	latin1_general_ci	YES
value	float(13,8)		YES
last_updated	datetime		YES

customers

Field	Type	Collation	Null	Key	Default	Extra	Comment
customers_id	int(11)		NO	PRI		auto_increment
customers_gender	char(1)	latin1_general_ci	NO
customers_firstname	varchar(32)	latin1_general_ci	NO
customers_lastname	varchar(32)	latin1_general_ci	NO
customers_dob	datetime		NO		0001-01-01 00:00:00
customers_email_address	varchar(96)	latin1_general_ci	NO	MUL
customers_nick	varchar(96)	latin1_general_ci	NO	MUL
customers_default_address_id	int(11)		NO		0
customers_telephone	varchar(32)	latin1_general_ci	NO
customers_fax	varchar(32)	latin1_general_ci	YES
customers_password	varchar(40)	latin1_general_ci	NO
customers_newsletter	char(1)	latin1_general_ci	YES	MUL
customers_group_pricing	int(11)		NO	MUL	0
customers_email_format	varchar(4)	latin1_general_ci	NO		TEXT
customers_authorization	int(1)		NO		0
customers_referral	varchar(32)	latin1_general_ci	NO	MUL
customers_paypal_payerid	varchar(20)	latin1_general_ci	NO
customers_paypal_ec	tinyint(1) unsigned		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	latin1_general_ci	NO
customers_basket_quantity	float		NO		0
final_price	decimal(15,4)		NO		0.0000
customers_basket_date_added	varchar(8)	latin1_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	latin1_general_ci	NO
products_options_id	varchar(64)	latin1_general_ci	NO		0
products_options_value_id	int(11)		NO		0
products_options_value_text	blob		YES
products_options_sort_order	text	latin1_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
customers_info_date_account_last_modified	datetime		YES
global_product_notifications	int(1)		YES		0

customers_wishlist

Field	Type	Collation	Null	Key	Default	Extra	Comment
products_id	int(13)		NO		0
customers_id	int(13)		NO		0
products_model	varchar(13)	latin1_general_ci	YES
products_name	varchar(64)	latin1_general_ci	NO
products_price	decimal(8,2)		NO		0.00
final_price	decimal(8,2)		NO		0.00
products_quantity	int(2)		NO		0
wishlist_name	varchar(64)	latin1_general_ci	YES

db_cache

Field	Type	Collation	Null	Key	Default	Extra	Comment
cache_entry_name	varchar(64)	latin1_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)	latin1_general_ci	NO
email_to_address	varchar(96)	latin1_general_ci	NO	MUL
email_from_name	varchar(96)	latin1_general_ci	NO
email_from_address	varchar(96)	latin1_general_ci	NO
email_subject	varchar(255)	latin1_general_ci	NO
email_html	text	latin1_general_ci	NO
email_text	text	latin1_general_ci	NO
date_sent	datetime		NO		0001-01-01 00:00:00
module	varchar(64)	latin1_general_ci	NO	MUL

ezpages

Field	Type	Collation	Null	Key	Default	Extra	Comment
pages_id	int(11)		NO	PRI		auto_increment
languages_id	int(11)		NO	MUL	1
pages_title	varchar(64)	latin1_general_ci	NO
alt_url	varchar(255)	latin1_general_ci	NO
alt_url_external	varchar(255)	latin1_general_ci	NO
pages_html_text	mediumtext	latin1_general_ci	YES
status_header	int(1)		NO	MUL	1
status_sidebox	int(1)		NO	MUL	1
status_footer	int(1)		NO	MUL	1
status_toc	int(1)		NO	MUL	1
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		0
toc_chapter	int(11)		NO		0

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

files_uploaded

Field	Type	Collation	Null	Key	Default	Extra	Comment
files_uploaded_id	int(11)		NO	PRI		auto_increment
sesskey	varchar(32)	latin1_general_ci	YES
customers_id	int(11)		YES	MUL
files_uploaded_name	varchar(64)	latin1_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)	latin1_general_ci	NO
geo_zone_description	varchar(255)	latin1_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(255)	latin1_general_ci	NO	PRI
get_term_table	varchar(64)	latin1_general_ci	NO
get_term_name_field	varchar(64)	latin1_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)	latin1_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)	latin1_general_ci	NO	MUL
code	char(2)	latin1_general_ci	NO
image	varchar(64)	latin1_general_ci	YES
directory	varchar(32)	latin1_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)	latin1_general_ci	NO	MUL
layout_box_name	varchar(64)	latin1_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

manufacturers

Field	Type	Collation	Null	Key	Default	Extra	Comment
manufacturers_id	int(11)		NO	PRI		auto_increment
manufacturers_name	varchar(32)	latin1_general_ci	NO	MUL
manufacturers_image	varchar(64)	latin1_general_ci	YES
date_added	datetime		YES
last_modified	datetime		YES

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)	latin1_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	latin1_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)	latin1_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)	latin1_general_ci	NO	MUL
type_ext	varchar(8)	latin1_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)	latin1_general_ci	NO
metatags_keywords	text	latin1_general_ci	YES
metatags_description	text	latin1_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)	latin1_general_ci	NO
metatags_keywords	text	latin1_general_ci	YES
metatags_description	text	latin1_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)	latin1_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)	latin1_general_ci	NO
content	text	latin1_general_ci	NO
content_html	text	latin1_general_ci	NO
module	varchar(255)	latin1_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)	latin1_general_ci	NO
customers_company	varchar(64)	latin1_general_ci	YES
customers_street_address	varchar(64)	latin1_general_ci	NO
customers_suburb	varchar(32)	latin1_general_ci	YES
customers_city	varchar(32)	latin1_general_ci	NO
customers_postcode	varchar(10)	latin1_general_ci	NO
customers_state	varchar(32)	latin1_general_ci	YES
customers_country	varchar(32)	latin1_general_ci	NO
customers_telephone	varchar(32)	latin1_general_ci	NO
customers_email_address	varchar(96)	latin1_general_ci	NO
customers_address_format_id	int(5)		NO		0
delivery_name	varchar(64)	latin1_general_ci	NO
delivery_company	varchar(64)	latin1_general_ci	YES
delivery_street_address	varchar(64)	latin1_general_ci	NO
delivery_suburb	varchar(32)	latin1_general_ci	YES
delivery_city	varchar(32)	latin1_general_ci	NO
delivery_postcode	varchar(10)	latin1_general_ci	NO
delivery_state	varchar(32)	latin1_general_ci	YES
delivery_country	varchar(32)	latin1_general_ci	NO
delivery_address_format_id	int(5)		NO		0
billing_name	varchar(64)	latin1_general_ci	NO
billing_company	varchar(64)	latin1_general_ci	YES
billing_street_address	varchar(64)	latin1_general_ci	NO
billing_suburb	varchar(32)	latin1_general_ci	YES
billing_city	varchar(32)	latin1_general_ci	NO
billing_postcode	varchar(10)	latin1_general_ci	NO
billing_state	varchar(32)	latin1_general_ci	YES
billing_country	varchar(32)	latin1_general_ci	NO
billing_address_format_id	int(5)		NO		0
payment_method	varchar(128)	latin1_general_ci	NO
payment_module_code	varchar(32)	latin1_general_ci	NO
shipping_method	varchar(128)	latin1_general_ci	NO
shipping_module_code	varchar(32)	latin1_general_ci	NO
coupon_code	varchar(32)	latin1_general_ci	NO
cc_type	varchar(20)	latin1_general_ci	YES
cc_owner	varchar(64)	latin1_general_ci	YES
cc_number	varchar(32)	latin1_general_ci	YES
cc_expires	varchar(4)	latin1_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)	latin1_general_ci	YES
currency_value	decimal(14,6)		YES
order_total	decimal(14,2)		YES
order_tax	decimal(14,2)		YES
paypal_ipn_id	int(11)		NO		0
ip_address	varchar(96)	latin1_general_ci	NO

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)	latin1_general_ci	YES
products_name	varchar(64)	latin1_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	latin1_general_ci	NO

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)	latin1_general_ci	NO
products_options_values	text	latin1_general_ci	NO
options_values_price	decimal(15,4)		NO		0.0000
price_prefix	char(1)	latin1_general_ci	NO
product_attribute_is_free	tinyint(1)		NO		0
products_attributes_weight	float		NO		0
products_attributes_weight_prefix	char(1)	latin1_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	latin1_general_ci	YES
attributes_qty_prices_onetime	text	latin1_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	latin1_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)	latin1_general_ci	NO
download_maxdays	int(2)		NO		0
download_count	int(2)		NO		0
products_prid	tinytext	latin1_general_ci	NO

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)	latin1_general_ci	NO	MUL

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	latin1_general_ci	YES

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)	latin1_general_ci	NO
text	varchar(255)	latin1_general_ci	NO
value	decimal(15,4)		NO		0.0000
class	varchar(32)	latin1_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)	latin1_general_ci	NO
module_name	varchar(40)	latin1_general_ci	NO
module_mode	varchar(40)	latin1_general_ci	NO
reason_code	varchar(40)	latin1_general_ci	YES
payment_type	varchar(40)	latin1_general_ci	NO
payment_status	varchar(32)	latin1_general_ci	NO
pending_reason	varchar(32)	latin1_general_ci	YES
invoice	varchar(128)	latin1_general_ci	YES
mc_currency	char(3)	latin1_general_ci	NO
first_name	varchar(32)	latin1_general_ci	NO
last_name	varchar(32)	latin1_general_ci	NO
payer_business_name	varchar(128)	latin1_general_ci	YES
address_name	varchar(64)	latin1_general_ci	YES
address_street	varchar(254)	latin1_general_ci	YES
address_city	varchar(120)	latin1_general_ci	YES
address_state	varchar(120)	latin1_general_ci	YES
address_zip	varchar(10)	latin1_general_ci	YES
address_country	varchar(64)	latin1_general_ci	YES
address_status	varchar(11)	latin1_general_ci	YES
payer_email	varchar(128)	latin1_general_ci	NO
payer_id	varchar(32)	latin1_general_ci	NO
payer_status	varchar(10)	latin1_general_ci	NO
payment_date	datetime		NO		0001-01-01 00:00:00
business	varchar(128)	latin1_general_ci	NO
receiver_email	varchar(128)	latin1_general_ci	NO
receiver_id	varchar(32)	latin1_general_ci	NO
txn_id	varchar(20)	latin1_general_ci	NO	PRI
parent_txn_id	varchar(20)	latin1_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)	latin1_general_ci	YES
exchange_rate	decimal(4,2)		YES
notify_version	varchar(6)	latin1_general_ci	NO
verify_sign	varchar(128)	latin1_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	latin1_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)	latin1_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)	latin1_general_ci	NO
parent_txn_id	varchar(64)	latin1_general_ci	NO
payment_status	varchar(17)	latin1_general_ci	NO
pending_reason	varchar(14)	latin1_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	latin1_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)	latin1_general_ci	NO
txn_type	varchar(40)	latin1_general_ci	NO
module_name	varchar(40)	latin1_general_ci	NO
module_mode	varchar(40)	latin1_general_ci	NO
reason_code	varchar(40)	latin1_general_ci	YES
payment_type	varchar(40)	latin1_general_ci	NO
payment_status	varchar(32)	latin1_general_ci	NO
pending_reason	varchar(32)	latin1_general_ci	YES
invoice	varchar(128)	latin1_general_ci	YES
mc_currency	char(3)	latin1_general_ci	NO
first_name	varchar(32)	latin1_general_ci	NO
last_name	varchar(32)	latin1_general_ci	NO
payer_business_name	varchar(128)	latin1_general_ci	YES
address_name	varchar(64)	latin1_general_ci	YES
address_street	varchar(254)	latin1_general_ci	YES
address_city	varchar(120)	latin1_general_ci	YES
address_state	varchar(120)	latin1_general_ci	YES
address_zip	varchar(10)	latin1_general_ci	YES
address_country	varchar(64)	latin1_general_ci	YES
address_status	varchar(11)	latin1_general_ci	YES
payer_email	varchar(128)	latin1_general_ci	NO
payer_id	varchar(32)	latin1_general_ci	NO
payer_status	varchar(10)	latin1_general_ci	NO
payment_date	datetime		NO		0001-01-01 00:00:00
business	varchar(128)	latin1_general_ci	NO
receiver_email	varchar(128)	latin1_general_ci	NO
receiver_id	varchar(32)	latin1_general_ci	NO
txn_id	varchar(20)	latin1_general_ci	NO	PRI
parent_txn_id	varchar(20)	latin1_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)	latin1_general_ci	YES
exchange_rate	decimal(4,2)		YES
notify_version	decimal(2,1)		NO		0.0
verify_sign	varchar(128)	latin1_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	latin1_general_ci	YES

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	latin1_general_ci	NO
configuration_key	varchar(255)	latin1_general_ci	NO	UNI
configuration_value	text	latin1_general_ci	NO
configuration_description	text	latin1_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	latin1_general_ci	YES
set_function	text	latin1_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)	latin1_general_ci	NO
type_handler	varchar(255)	latin1_general_ci	NO
type_master_type	int(11)		NO	MUL	1
allow_add_to_cart	char(1)	latin1_general_ci	NO		Y
default_image	varchar(255)	latin1_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)	latin1_general_ci	YES	MUL
products_image	varchar(64)	latin1_general_ci	YES
products_price	decimal(15,4)		NO		0.0000
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_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
price_prefix	char(1)	latin1_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)	latin1_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(64)	latin1_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	latin1_general_ci	YES
attributes_qty_prices_onetime	text	latin1_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)	latin1_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		auto_increment
language_id	int(11)		NO	PRI	1
products_name	varchar(64)	latin1_general_ci	NO	MUL
products_description	text	latin1_general_ci	YES
products_url	varchar(255)	latin1_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	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)	latin1_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(64)	latin1_general_ci	YES
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)	latin1_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)	latin1_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)	latin1_general_ci	NO	UNI
project_version_major	varchar(20)	latin1_general_ci	NO
project_version_minor	varchar(20)	latin1_general_ci	NO
project_version_patch1	varchar(20)	latin1_general_ci	NO
project_version_patch2	varchar(20)	latin1_general_ci	NO
project_version_patch1_source	varchar(20)	latin1_general_ci	NO
project_version_patch2_source	varchar(20)	latin1_general_ci	NO
project_version_comment	varchar(250)	latin1_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)	latin1_general_ci	NO
project_version_major	varchar(20)	latin1_general_ci	NO
project_version_minor	varchar(20)	latin1_general_ci	NO
project_version_patch	varchar(20)	latin1_general_ci	NO
project_version_comment	varchar(250)	latin1_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)	latin1_general_ci	NO
query_name	varchar(80)	latin1_general_ci	NO	UNI
query_description	text	latin1_general_ci	NO
query_string	text	latin1_general_ci	NO
query_keys_list	text	latin1_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)	latin1_general_ci	NO	MUL
artists_image	varchar(64)	latin1_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)	latin1_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)	latin1_general_ci	NO	MUL
record_company_image	varchar(64)	latin1_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)	latin1_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)	latin1_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	latin1_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(30)	latin1_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	latin1_general_ci	YES
sale_categories_all	text	latin1_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(32)	latin1_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)	latin1_general_ci	NO
tax_class_description	varchar(255)	latin1_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)	latin1_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)	latin1_general_ci	NO
template_language	varchar(64)	latin1_general_ci	NO	MUL	0

upgrade_exceptions

Field	Type	Collation	Null	Key	Default	Extra	Comment
upgrade_exception_id	smallint(5)		NO	PRI		auto_increment
sql_file	varchar(50)	latin1_general_ci	YES
reason	varchar(200)	latin1_general_ci	YES
errordate	datetime		YES		0001-01-01 00:00:00
sqlstatement	text	latin1_general_ci	YES

whos_online

Field	Type	Collation	Null	Key	Default	Extra	Comment
customer_id	int(11)		YES	MUL
full_name	varchar(64)	latin1_general_ci	NO
session_id	varchar(128)	latin1_general_ci	NO	MUL
ip_address	varchar(15)	latin1_general_ci	NO	MUL
time_entry	varchar(14)	latin1_general_ci	NO	MUL
time_last_click	varchar(14)	latin1_general_ci	NO	MUL
last_page_url	varchar(255)	latin1_general_ci	NO	MUL
host_address	text	latin1_general_ci	NO
user_agent	varchar(255)	latin1_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)	latin1_general_ci	NO	MUL
zone_name	varchar(32)	latin1_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 September 13, 2020 by Scott C Wilson (354bf510).