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

FieldTypeCollationNullKeyDefaultExtraComment
address_book_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
entry_genderchar(1)latin1_general_ciNO
entry_companyvarchar(64)latin1_general_ciYES
entry_firstnamevarchar(32)latin1_general_ciNO
entry_lastnamevarchar(32)latin1_general_ciNO
entry_street_addressvarchar(64)latin1_general_ciNO
entry_suburbvarchar(32)latin1_general_ciYES
entry_postcodevarchar(10)latin1_general_ciNO
entry_cityvarchar(32)latin1_general_ciNO
entry_statevarchar(32)latin1_general_ciYES
entry_country_idint(11)NO0
entry_zone_idint(11)NO0

address_book

FieldTypeCollationNullKeyDefaultExtraComment
address_book_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
entry_genderchar(1)latin1_general_ciNO
entry_companyvarchar(64)latin1_general_ciYES
entry_firstnamevarchar(32)latin1_general_ciNO
entry_lastnamevarchar(32)latin1_general_ciNO
entry_street_addressvarchar(64)latin1_general_ciNO
entry_suburbvarchar(32)latin1_general_ciYES
entry_postcodevarchar(10)latin1_general_ciNO
entry_cityvarchar(32)latin1_general_ciNO
entry_statevarchar(32)latin1_general_ciYES
entry_country_idint(11)NO0
entry_zone_idint(11)NO0

address_format

FieldTypeCollationNullKeyDefaultExtraComment
address_format_idint(11)NOPRIauto_increment
address_formatvarchar(128)latin1_general_ciNO
address_summaryvarchar(48)latin1_general_ciNO

admin

FieldTypeCollationNullKeyDefaultExtraComment
admin_idint(11)NOPRIauto_increment
admin_namevarchar(32)latin1_general_ciNOMUL
admin_emailvarchar(96)latin1_general_ciNOMUL
admin_passvarchar(40)latin1_general_ciNO
admin_leveltinyint(1)NO1

admin_activity_log

FieldTypeCollationNullKeyDefaultExtraComment
log_idint(15)NOPRIauto_increment
access_datedatetimeNOMUL0001-01-01 00:00:00
admin_idint(11)NO0
page_accessedvarchar(80)latin1_general_ciNOMUL
page_parameterstextlatin1_general_ciYES
ip_addressvarchar(15)latin1_general_ciNOMUL

authorizenet

FieldTypeCollationNullKeyDefaultExtraComment
idint(11) unsignedNOPRIauto_increment
customer_idint(11)NO0
order_idint(11)NO0
response_codeint(1)NO0
response_textvarchar(255)latin1_general_ciNO
authorization_typevarchar(50)latin1_general_ciNO
transaction_idbigint(20)YES
sentlongtextlatin1_general_ciNO
receivedlongtextlatin1_general_ciNO
timevarchar(50)latin1_general_ciNO
session_idvarchar(255)latin1_general_ciNO

banners

FieldTypeCollationNullKeyDefaultExtraComment
banners_idint(11)NOPRIauto_increment
banners_titlevarchar(64)latin1_general_ciNO
banners_urlvarchar(255)latin1_general_ciNO
banners_imagevarchar(64)latin1_general_ciNO
banners_groupvarchar(15)latin1_general_ciNO
banners_html_texttextlatin1_general_ciYES
expires_impressionsint(7)YES0
expires_datedatetimeYESMUL
date_scheduleddatetimeYESMUL
date_addeddatetimeNO0001-01-01 00:00:00
date_status_changedatetimeYES
statusint(1)NOMUL1
banners_open_new_windowsint(1)NO1
banners_on_sslint(1)NO1
banners_sort_orderint(11)NO0

banners_history

FieldTypeCollationNullKeyDefaultExtraComment
banners_history_idint(11)NOPRIauto_increment
banners_idint(11)NOMUL0
banners_shownint(5)NO0
banners_clickedint(5)NO0
banners_history_datedatetimeNO0001-01-01 00:00:00

categories

FieldTypeCollationNullKeyDefaultExtraComment
categories_idint(11)NOPRIauto_increment
categories_imagevarchar(64)latin1_general_ciYES
parent_idint(11)NOMUL0
sort_orderint(3)YESMUL
date_addeddatetimeYES
last_modifieddatetimeYES
categories_statustinyint(1)NOMUL1

categories_description

FieldTypeCollationNullKeyDefaultExtraComment
categories_idint(11)NOPRI0
language_idint(11)NOPRI1
categories_namevarchar(32)latin1_general_ciNOMUL
categories_descriptiontextlatin1_general_ciNO

configuration

FieldTypeCollationNullKeyDefaultExtraComment
configuration_idint(11)NOPRIauto_increment
configuration_titletextlatin1_general_ciNO
configuration_keyvarchar(255)latin1_general_ciNOUNI
configuration_valuetextlatin1_general_ciNO
configuration_descriptiontextlatin1_general_ciNO
configuration_group_idint(11)NOMUL0
sort_orderint(5)YES
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00
use_functiontextlatin1_general_ciYES
set_functiontextlatin1_general_ciYES

configuration_group

FieldTypeCollationNullKeyDefaultExtraComment
configuration_group_idint(11)NOPRIauto_increment
configuration_group_titlevarchar(64)latin1_general_ciNO
configuration_group_descriptionvarchar(255)latin1_general_ciNO
sort_orderint(5)YES
visibleint(1)YESMUL1

counter

FieldTypeCollationNullKeyDefaultExtraComment
startdatechar(8)latin1_general_ciYES
counterint(12)YES

counter_history

FieldTypeCollationNullKeyDefaultExtraComment
startdatechar(8)latin1_general_ciYESPRI
counterint(12)YES
session_counterint(12)YES

countries

FieldTypeCollationNullKeyDefaultExtraComment
countries_idint(11)NOPRIauto_increment
countries_namevarchar(64)latin1_general_ciNOMUL
countries_iso_code_2char(2)latin1_general_ciNOMUL
countries_iso_code_3char(3)latin1_general_ciNOMUL
address_format_idint(11)NOMUL0

coupon_email_track

FieldTypeCollationNullKeyDefaultExtraComment
unique_idint(11)NOPRIauto_increment
coupon_idint(11)NOMUL0
customer_id_sentint(11)NO0
sent_firstnamevarchar(32)latin1_general_ciYES
sent_lastnamevarchar(32)latin1_general_ciYES
emailed_tovarchar(32)latin1_general_ciYES
date_sentdatetimeNO0001-01-01 00:00:00

coupon_gv_customer

FieldTypeCollationNullKeyDefaultExtraComment
customer_idint(5)NOPRI0
amountdecimal(15,4)NO0.0000

coupon_gv_queue

FieldTypeCollationNullKeyDefaultExtraComment
unique_idint(5)NOPRIauto_increment
customer_idint(5)NOMUL0
order_idint(5)NO0
amountdecimal(15,4)NO0.0000
date_createddatetimeNO0001-01-01 00:00:00
ipaddrvarchar(32)latin1_general_ciNO
release_flagchar(1)latin1_general_ciNOMULN

coupon_redeem_track

FieldTypeCollationNullKeyDefaultExtraComment
unique_idint(11)NOPRIauto_increment
coupon_idint(11)NOMUL0
customer_idint(11)NO0
redeem_datedatetimeNO0001-01-01 00:00:00
redeem_ipvarchar(32)latin1_general_ciNO
order_idint(11)NO0

coupon_restrict

FieldTypeCollationNullKeyDefaultExtraComment
restrict_idint(11)NOPRIauto_increment
coupon_idint(11)NOMUL0
product_idint(11)NO0
category_idint(11)NO0
coupon_restrictchar(1)latin1_general_ciNON

coupons

FieldTypeCollationNullKeyDefaultExtraComment
coupon_idint(11)NOPRIauto_increment
coupon_typechar(1)latin1_general_ciNOMULF
coupon_codevarchar(32)latin1_general_ciNOMUL
coupon_amountdecimal(15,4)NO0.0000
coupon_minimum_orderdecimal(15,4)NO0.0000
coupon_start_datedatetimeNO0001-01-01 00:00:00
coupon_expire_datedatetimeNO0001-01-01 00:00:00
uses_per_couponint(5)NO1
uses_per_userint(5)NO0
restrict_to_productsvarchar(255)latin1_general_ciYES
restrict_to_categoriesvarchar(255)latin1_general_ciYES
restrict_to_customerstextlatin1_general_ciYES
coupon_activechar(1)latin1_general_ciNOMULY
date_createddatetimeNO0001-01-01 00:00:00
date_modifieddatetimeNO0001-01-01 00:00:00
coupon_zone_restrictionint(11)NO0

coupons_description

FieldTypeCollationNullKeyDefaultExtraComment
coupon_idint(11)NOPRI0
language_idint(11)NOPRI0
coupon_namevarchar(32)latin1_general_ciNO
coupon_descriptiontextlatin1_general_ciYES

currencies

FieldTypeCollationNullKeyDefaultExtraComment
currencies_idint(11)NOPRIauto_increment
titlevarchar(32)latin1_general_ciNO
codechar(3)latin1_general_ciNO
symbol_leftvarchar(24)latin1_general_ciYES
symbol_rightvarchar(24)latin1_general_ciYES
decimal_pointchar(1)latin1_general_ciYES
thousands_pointchar(1)latin1_general_ciYES
decimal_placeschar(1)latin1_general_ciYES
valuefloat(13,8)YES
last_updateddatetimeYES

customers

FieldTypeCollationNullKeyDefaultExtraComment
customers_idint(11)NOPRIauto_increment
customers_genderchar(1)latin1_general_ciNO
customers_firstnamevarchar(32)latin1_general_ciNO
customers_lastnamevarchar(32)latin1_general_ciNO
customers_dobdatetimeNO0001-01-01 00:00:00
customers_email_addressvarchar(96)latin1_general_ciNOMUL
customers_nickvarchar(96)latin1_general_ciNOMUL
customers_default_address_idint(11)NO0
customers_telephonevarchar(32)latin1_general_ciNO
customers_faxvarchar(32)latin1_general_ciYES
customers_passwordvarchar(40)latin1_general_ciNO
customers_newsletterchar(1)latin1_general_ciYESMUL
customers_group_pricingint(11)NOMUL0
customers_email_formatvarchar(4)latin1_general_ciNOTEXT
customers_authorizationint(1)NO0
customers_referralvarchar(32)latin1_general_ciNOMUL
customers_paypal_payeridvarchar(20)latin1_general_ciNO
customers_paypal_ectinyint(1) unsignedNO0

customers_basket

FieldTypeCollationNullKeyDefaultExtraComment
customers_basket_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
products_idtinytextlatin1_general_ciNO
customers_basket_quantityfloatNO0
final_pricedecimal(15,4)NO0.0000
customers_basket_date_addedvarchar(8)latin1_general_ciYES

customers_basket_attributes

FieldTypeCollationNullKeyDefaultExtraComment
customers_basket_attributes_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
products_idtinytextlatin1_general_ciNO
products_options_idvarchar(64)latin1_general_ciNO0
products_options_value_idint(11)NO0
products_options_value_textblobYES
products_options_sort_ordertextlatin1_general_ciNO

customers_info

FieldTypeCollationNullKeyDefaultExtraComment
customers_info_idint(11)NOPRI0
customers_info_date_of_last_logondatetimeYES
customers_info_number_of_logonsint(5)YES
customers_info_date_account_createddatetimeYES
customers_info_date_account_last_modifieddatetimeYES
global_product_notificationsint(1)YES0

customers_wishlist

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(13)NO0
customers_idint(13)NO0
products_modelvarchar(13)latin1_general_ciYES
products_namevarchar(64)latin1_general_ciNO
products_pricedecimal(8,2)NO0.00
final_pricedecimal(8,2)NO0.00
products_quantityint(2)NO0
wishlist_namevarchar(64)latin1_general_ciYES

db_cache

FieldTypeCollationNullKeyDefaultExtraComment
cache_entry_namevarchar(64)latin1_general_ciNOPRI
cache_datamediumblobYES
cache_entry_createdint(15)YES

email_archive

FieldTypeCollationNullKeyDefaultExtraComment
archive_idint(11)NOPRIauto_increment
email_to_namevarchar(96)latin1_general_ciNO
email_to_addressvarchar(96)latin1_general_ciNOMUL
email_from_namevarchar(96)latin1_general_ciNO
email_from_addressvarchar(96)latin1_general_ciNO
email_subjectvarchar(255)latin1_general_ciNO
email_htmltextlatin1_general_ciNO
email_texttextlatin1_general_ciNO
date_sentdatetimeNO0001-01-01 00:00:00
modulevarchar(64)latin1_general_ciNOMUL

ezpages

FieldTypeCollationNullKeyDefaultExtraComment
pages_idint(11)NOPRIauto_increment
languages_idint(11)NOMUL1
pages_titlevarchar(64)latin1_general_ciNO
alt_urlvarchar(255)latin1_general_ciNO
alt_url_externalvarchar(255)latin1_general_ciNO
pages_html_textmediumtextlatin1_general_ciYES
status_headerint(1)NOMUL1
status_sideboxint(1)NOMUL1
status_footerint(1)NOMUL1
status_tocint(1)NOMUL1
header_sort_orderint(3)NO0
sidebox_sort_orderint(3)NO0
footer_sort_orderint(3)NO0
toc_sort_orderint(3)NO0
page_open_new_windowint(1)NO0
page_is_sslint(1)NO0
toc_chapterint(11)NO0
FieldTypeCollationNullKeyDefaultExtraComment
featured_idint(11)NOPRIauto_increment
products_idint(11)NOMUL0
featured_date_addeddatetimeYES
featured_last_modifieddatetimeYES
expires_datedateNOMUL0001-01-01
date_status_changedatetimeYES
statusint(1)NOMUL1
featured_date_availabledateNOMUL0001-01-01

files_uploaded

FieldTypeCollationNullKeyDefaultExtraComment
files_uploaded_idint(11)NOPRIauto_increment
sesskeyvarchar(32)latin1_general_ciYES
customers_idint(11)YESMUL
files_uploaded_namevarchar(64)latin1_general_ciNO

geo_zones

FieldTypeCollationNullKeyDefaultExtraComment
geo_zone_idint(11)NOPRIauto_increment
geo_zone_namevarchar(32)latin1_general_ciNO
geo_zone_descriptionvarchar(255)latin1_general_ciNO
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00

get_terms_to_filter

FieldTypeCollationNullKeyDefaultExtraComment
get_term_namevarchar(255)latin1_general_ciNOPRI
get_term_tablevarchar(64)latin1_general_ciNO
get_term_name_fieldvarchar(64)latin1_general_ciNO

group_pricing

FieldTypeCollationNullKeyDefaultExtraComment
group_idint(11)NOPRIauto_increment
group_namevarchar(32)latin1_general_ciNO
group_percentagedecimal(5,2)NO0.00
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00

languages

FieldTypeCollationNullKeyDefaultExtraComment
languages_idint(11)NOPRIauto_increment
namevarchar(32)latin1_general_ciNOMUL
codechar(2)latin1_general_ciNO
imagevarchar(64)latin1_general_ciYES
directoryvarchar(32)latin1_general_ciYES
sort_orderint(3)YES

layout_boxes

FieldTypeCollationNullKeyDefaultExtraComment
layout_idint(11)NOPRIauto_increment
layout_templatevarchar(64)latin1_general_ciNOMUL
layout_box_namevarchar(64)latin1_general_ciNO
layout_box_statustinyint(1)NOMUL0
layout_box_locationtinyint(1)NO0
layout_box_sort_orderint(11)NOMUL0
layout_box_sort_order_singleint(11)NO0
layout_box_status_singletinyint(4)NO0

manufacturers

FieldTypeCollationNullKeyDefaultExtraComment
manufacturers_idint(11)NOPRIauto_increment
manufacturers_namevarchar(32)latin1_general_ciNOMUL
manufacturers_imagevarchar(64)latin1_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

manufacturers_info

FieldTypeCollationNullKeyDefaultExtraComment
manufacturers_idint(11)NOPRI0
languages_idint(11)NOPRI0
manufacturers_urlvarchar(255)latin1_general_ciNO
url_clickedint(5)NO0
date_last_clickdatetimeYES

media_clips

FieldTypeCollationNullKeyDefaultExtraComment
clip_idint(11)NOPRIauto_increment
media_idint(11)NOMUL0
clip_typesmallint(6)NOMUL0
clip_filenametextlatin1_general_ciNO
date_addeddatetimeNO0001-01-01 00:00:00
last_modifieddatetimeNO0001-01-01 00:00:00

media_manager

FieldTypeCollationNullKeyDefaultExtraComment
media_idint(11)NOPRIauto_increment
media_namevarchar(255)latin1_general_ciNOMUL
last_modifieddatetimeNO0001-01-01 00:00:00
date_addeddatetimeNO0001-01-01 00:00:00

media_to_products

FieldTypeCollationNullKeyDefaultExtraComment
media_idint(11)NOMUL0
product_idint(11)NO0

media_types

FieldTypeCollationNullKeyDefaultExtraComment
type_idint(11)NOPRIauto_increment
type_namevarchar(64)latin1_general_ciNOMUL
type_extvarchar(8)latin1_general_ciNO

meta_tags_categories_description

FieldTypeCollationNullKeyDefaultExtraComment
categories_idint(11)NOPRI
language_idint(11)NOPRI1
metatags_titlevarchar(255)latin1_general_ciNO
metatags_keywordstextlatin1_general_ciYES
metatags_descriptiontextlatin1_general_ciYES

meta_tags_products_description

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRI
language_idint(11)NOPRI1
metatags_titlevarchar(255)latin1_general_ciNO
metatags_keywordstextlatin1_general_ciYES
metatags_descriptiontextlatin1_general_ciYES

music_genre

FieldTypeCollationNullKeyDefaultExtraComment
music_genre_idint(11)NOPRIauto_increment
music_genre_namevarchar(32)latin1_general_ciNOMUL
date_addeddatetimeYES
last_modifieddatetimeYES

newsletters

FieldTypeCollationNullKeyDefaultExtraComment
newsletters_idint(11)NOPRIauto_increment
titlevarchar(255)latin1_general_ciNO
contenttextlatin1_general_ciNO
content_htmltextlatin1_general_ciNO
modulevarchar(255)latin1_general_ciNO
date_addeddatetimeNO0001-01-01 00:00:00
date_sentdatetimeYES
statusint(1)YES
lockedint(1)YES0

orders

FieldTypeCollationNullKeyDefaultExtraComment
orders_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
customers_namevarchar(64)latin1_general_ciNO
customers_companyvarchar(64)latin1_general_ciYES
customers_street_addressvarchar(64)latin1_general_ciNO
customers_suburbvarchar(32)latin1_general_ciYES
customers_cityvarchar(32)latin1_general_ciNO
customers_postcodevarchar(10)latin1_general_ciNO
customers_statevarchar(32)latin1_general_ciYES
customers_countryvarchar(32)latin1_general_ciNO
customers_telephonevarchar(32)latin1_general_ciNO
customers_email_addressvarchar(96)latin1_general_ciNO
customers_address_format_idint(5)NO0
delivery_namevarchar(64)latin1_general_ciNO
delivery_companyvarchar(64)latin1_general_ciYES
delivery_street_addressvarchar(64)latin1_general_ciNO
delivery_suburbvarchar(32)latin1_general_ciYES
delivery_cityvarchar(32)latin1_general_ciNO
delivery_postcodevarchar(10)latin1_general_ciNO
delivery_statevarchar(32)latin1_general_ciYES
delivery_countryvarchar(32)latin1_general_ciNO
delivery_address_format_idint(5)NO0
billing_namevarchar(64)latin1_general_ciNO
billing_companyvarchar(64)latin1_general_ciYES
billing_street_addressvarchar(64)latin1_general_ciNO
billing_suburbvarchar(32)latin1_general_ciYES
billing_cityvarchar(32)latin1_general_ciNO
billing_postcodevarchar(10)latin1_general_ciNO
billing_statevarchar(32)latin1_general_ciYES
billing_countryvarchar(32)latin1_general_ciNO
billing_address_format_idint(5)NO0
payment_methodvarchar(128)latin1_general_ciNO
payment_module_codevarchar(32)latin1_general_ciNO
shipping_methodvarchar(128)latin1_general_ciNO
shipping_module_codevarchar(32)latin1_general_ciNO
coupon_codevarchar(32)latin1_general_ciNO
cc_typevarchar(20)latin1_general_ciYES
cc_ownervarchar(64)latin1_general_ciYES
cc_numbervarchar(32)latin1_general_ciYES
cc_expiresvarchar(4)latin1_general_ciYES
cc_cvvblobYES
last_modifieddatetimeYES
date_purchaseddatetimeYESMUL
orders_statusint(5)NOMUL0
orders_date_finisheddatetimeYES
currencychar(3)latin1_general_ciYES
currency_valuedecimal(14,6)YES
order_totaldecimal(14,2)YES
order_taxdecimal(14,2)YES
paypal_ipn_idint(11)NO0
ip_addressvarchar(96)latin1_general_ciNO

orders_products

FieldTypeCollationNullKeyDefaultExtraComment
orders_products_idint(11)NOPRIauto_increment
orders_idint(11)NOMUL0
products_idint(11)NOMUL0
products_modelvarchar(32)latin1_general_ciYES
products_namevarchar(64)latin1_general_ciNO
products_pricedecimal(15,4)NO0.0000
final_pricedecimal(15,4)NO0.0000
products_taxdecimal(7,4)NO0.0000
products_quantityfloatNO0
onetime_chargesdecimal(15,4)NO0.0000
products_priced_by_attributetinyint(1)NO0
product_is_freetinyint(1)NO0
products_discount_typetinyint(1)NO0
products_discount_type_fromtinyint(1)NO0
products_pridtinytextlatin1_general_ciNO

orders_products_attributes

FieldTypeCollationNullKeyDefaultExtraComment
orders_products_attributes_idint(11)NOPRIauto_increment
orders_idint(11)NOMUL0
orders_products_idint(11)NO0
products_optionsvarchar(32)latin1_general_ciNO
products_options_valuestextlatin1_general_ciNO
options_values_pricedecimal(15,4)NO0.0000
price_prefixchar(1)latin1_general_ciNO
product_attribute_is_freetinyint(1)NO0
products_attributes_weightfloatNO0
products_attributes_weight_prefixchar(1)latin1_general_ciNO
attributes_discountedtinyint(1)NO1
attributes_price_base_includedtinyint(1)NO1
attributes_price_onetimedecimal(15,4)NO0.0000
attributes_price_factordecimal(15,4)NO0.0000
attributes_price_factor_offsetdecimal(15,4)NO0.0000
attributes_price_factor_onetimedecimal(15,4)NO0.0000
attributes_price_factor_onetime_offsetdecimal(15,4)NO0.0000
attributes_qty_pricestextlatin1_general_ciYES
attributes_qty_prices_onetimetextlatin1_general_ciYES
attributes_price_wordsdecimal(15,4)NO0.0000
attributes_price_words_freeint(4)NO0
attributes_price_lettersdecimal(15,4)NO0.0000
attributes_price_letters_freeint(4)NO0
products_options_idint(11)NO0
products_options_values_idint(11)NO0
products_pridtinytextlatin1_general_ciNO

orders_products_download

FieldTypeCollationNullKeyDefaultExtraComment
orders_products_download_idint(11)NOPRIauto_increment
orders_idint(11)NOMUL0
orders_products_idint(11)NOMUL0
orders_products_filenamevarchar(255)latin1_general_ciNO
download_maxdaysint(2)NO0
download_countint(2)NO0
products_pridtinytextlatin1_general_ciNO

orders_status

FieldTypeCollationNullKeyDefaultExtraComment
orders_status_idint(11)NOPRI0
language_idint(11)NOPRI1
orders_status_namevarchar(32)latin1_general_ciNOMUL

orders_status_history

FieldTypeCollationNullKeyDefaultExtraComment
orders_status_history_idint(11)NOPRIauto_increment
orders_idint(11)NOMUL0
orders_status_idint(5)NO0
date_addeddatetimeNO0001-01-01 00:00:00
customer_notifiedint(1)YES0
commentstextlatin1_general_ciYES

orders_total

FieldTypeCollationNullKeyDefaultExtraComment
orders_total_idint(10) unsignedNOPRIauto_increment
orders_idint(11)NOMUL0
titlevarchar(255)latin1_general_ciNO
textvarchar(255)latin1_general_ciNO
valuedecimal(15,4)NO0.0000
classvarchar(32)latin1_general_ciNOMUL
sort_orderint(11)NO0

paypal

FieldTypeCollationNullKeyDefaultExtraComment
paypal_ipn_idint(11) unsignedNOPRIauto_increment
order_idint(11) unsignedNOMUL0
txn_typevarchar(40)latin1_general_ciNO
module_namevarchar(40)latin1_general_ciNO
module_modevarchar(40)latin1_general_ciNO
reason_codevarchar(40)latin1_general_ciYES
payment_typevarchar(40)latin1_general_ciNO
payment_statusvarchar(32)latin1_general_ciNO
pending_reasonvarchar(32)latin1_general_ciYES
invoicevarchar(128)latin1_general_ciYES
mc_currencychar(3)latin1_general_ciNO
first_namevarchar(32)latin1_general_ciNO
last_namevarchar(32)latin1_general_ciNO
payer_business_namevarchar(128)latin1_general_ciYES
address_namevarchar(64)latin1_general_ciYES
address_streetvarchar(254)latin1_general_ciYES
address_cityvarchar(120)latin1_general_ciYES
address_statevarchar(120)latin1_general_ciYES
address_zipvarchar(10)latin1_general_ciYES
address_countryvarchar(64)latin1_general_ciYES
address_statusvarchar(11)latin1_general_ciYES
payer_emailvarchar(128)latin1_general_ciNO
payer_idvarchar(32)latin1_general_ciNO
payer_statusvarchar(10)latin1_general_ciNO
payment_datedatetimeNO0001-01-01 00:00:00
businessvarchar(128)latin1_general_ciNO
receiver_emailvarchar(128)latin1_general_ciNO
receiver_idvarchar(32)latin1_general_ciNO
txn_idvarchar(20)latin1_general_ciNOPRI
parent_txn_idvarchar(20)latin1_general_ciYES
num_cart_itemstinyint(4) unsignedNO1
mc_grossdecimal(7,2)NO0.00
mc_feedecimal(7,2)NO0.00
payment_grossdecimal(7,2)YES
payment_feedecimal(7,2)YES
settle_amountdecimal(7,2)YES
settle_currencychar(3)latin1_general_ciYES
exchange_ratedecimal(4,2)YES
notify_versionvarchar(6)latin1_general_ciNO
verify_signvarchar(128)latin1_general_ciNO
last_modifieddatetimeNO0001-01-01 00:00:00
date_addeddatetimeNO0001-01-01 00:00:00
memotextlatin1_general_ciYES

paypal_payment_status

FieldTypeCollationNullKeyDefaultExtraComment
payment_status_idint(11)NOPRIauto_increment
payment_status_namevarchar(64)latin1_general_ciNO

paypal_payment_status_history

FieldTypeCollationNullKeyDefaultExtraComment
payment_status_history_idint(11)NOPRIauto_increment
paypal_ipn_idint(11)NOMUL0
txn_idvarchar(64)latin1_general_ciNO
parent_txn_idvarchar(64)latin1_general_ciNO
payment_statusvarchar(17)latin1_general_ciNO
pending_reasonvarchar(14)latin1_general_ciYES
date_addeddatetimeNO0001-01-01 00:00:00

paypal_session

FieldTypeCollationNullKeyDefaultExtraComment
unique_idint(11)NOPRIauto_increment
session_idtextlatin1_general_ciNOMUL
saved_sessionmediumblobNO
expiryint(17)NO0

paypal_testing

FieldTypeCollationNullKeyDefaultExtraComment
paypal_ipn_idint(11) unsignedNOPRIauto_increment
order_idint(11) unsignedNOMUL0
customvarchar(255)latin1_general_ciNO
txn_typevarchar(40)latin1_general_ciNO
module_namevarchar(40)latin1_general_ciNO
module_modevarchar(40)latin1_general_ciNO
reason_codevarchar(40)latin1_general_ciYES
payment_typevarchar(40)latin1_general_ciNO
payment_statusvarchar(32)latin1_general_ciNO
pending_reasonvarchar(32)latin1_general_ciYES
invoicevarchar(128)latin1_general_ciYES
mc_currencychar(3)latin1_general_ciNO
first_namevarchar(32)latin1_general_ciNO
last_namevarchar(32)latin1_general_ciNO
payer_business_namevarchar(128)latin1_general_ciYES
address_namevarchar(64)latin1_general_ciYES
address_streetvarchar(254)latin1_general_ciYES
address_cityvarchar(120)latin1_general_ciYES
address_statevarchar(120)latin1_general_ciYES
address_zipvarchar(10)latin1_general_ciYES
address_countryvarchar(64)latin1_general_ciYES
address_statusvarchar(11)latin1_general_ciYES
payer_emailvarchar(128)latin1_general_ciNO
payer_idvarchar(32)latin1_general_ciNO
payer_statusvarchar(10)latin1_general_ciNO
payment_datedatetimeNO0001-01-01 00:00:00
businessvarchar(128)latin1_general_ciNO
receiver_emailvarchar(128)latin1_general_ciNO
receiver_idvarchar(32)latin1_general_ciNO
txn_idvarchar(20)latin1_general_ciNOPRI
parent_txn_idvarchar(20)latin1_general_ciYES
num_cart_itemstinyint(4) unsignedNO1
mc_grossdecimal(7,2)NO0.00
mc_feedecimal(7,2)NO0.00
payment_grossdecimal(7,2)YES
payment_feedecimal(7,2)YES
settle_amountdecimal(7,2)YES
settle_currencychar(3)latin1_general_ciYES
exchange_ratedecimal(4,2)YES
notify_versiondecimal(2,1)NO0.0
verify_signvarchar(128)latin1_general_ciNO
last_modifieddatetimeNO0001-01-01 00:00:00
date_addeddatetimeNO0001-01-01 00:00:00
memotextlatin1_general_ciYES

product_music_extra

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRI0
artists_idint(11)NOMUL0
record_company_idint(11)NOMUL0
music_genre_idint(11)NOMUL0

product_type_layout

FieldTypeCollationNullKeyDefaultExtraComment
configuration_idint(11)NOPRIauto_increment
configuration_titletextlatin1_general_ciNO
configuration_keyvarchar(255)latin1_general_ciNOUNI
configuration_valuetextlatin1_general_ciNO
configuration_descriptiontextlatin1_general_ciNO
product_type_idint(11)NOMUL0
sort_orderint(5)YES
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00
use_functiontextlatin1_general_ciYES
set_functiontextlatin1_general_ciYES

product_types

FieldTypeCollationNullKeyDefaultExtraComment
type_idint(11)NOPRIauto_increment
type_namevarchar(255)latin1_general_ciNO
type_handlervarchar(255)latin1_general_ciNO
type_master_typeint(11)NOMUL1
allow_add_to_cartchar(1)latin1_general_ciNOY
default_imagevarchar(255)latin1_general_ciNO
date_addeddatetimeNO0001-01-01 00:00:00
last_modifieddatetimeNO0001-01-01 00:00:00

product_types_to_category

FieldTypeCollationNullKeyDefaultExtraComment
product_type_idint(11)NOMUL0
category_idint(11)NOMUL0

products

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRIauto_increment
products_typeint(11)NO1
products_quantityfloatNO0
products_modelvarchar(32)latin1_general_ciYESMUL
products_imagevarchar(64)latin1_general_ciYES
products_pricedecimal(15,4)NO0.0000
products_virtualtinyint(1)NO0
products_date_addeddatetimeNOMUL0001-01-01 00:00:00
products_last_modifieddatetimeYES
products_date_availabledatetimeYESMUL
products_weightfloatNO0
products_statustinyint(1)NOMUL0
products_tax_class_idint(11)NO0
manufacturers_idint(11)YESMUL
products_orderedfloatNOMUL0
products_quantity_order_minfloatNO1
products_quantity_order_unitsfloatNO1
products_priced_by_attributetinyint(1)NO0
product_is_freetinyint(1)NO0
product_is_calltinyint(1)NO0
products_quantity_mixedtinyint(1)NO0
product_is_always_free_shippingtinyint(1)NO0
products_qty_box_statustinyint(1)NO1
products_quantity_order_maxfloatNO0
products_sort_orderint(11)NOMUL0
products_discount_typetinyint(1)NO0
products_discount_type_fromtinyint(1)NO0
products_price_sorterdecimal(15,4)NOMUL0.0000
master_categories_idint(11)NOMUL0
products_mixed_discount_quantitytinyint(1)NO1
metatags_title_statustinyint(1)NO0
metatags_products_name_statustinyint(1)NO0
metatags_model_statustinyint(1)NO0
metatags_price_statustinyint(1)NO0
metatags_title_tagline_statustinyint(1)NO0

products_attributes

FieldTypeCollationNullKeyDefaultExtraComment
products_attributes_idint(11)NOPRIauto_increment
products_idint(11)NOMUL0
options_idint(11)NO0
options_values_idint(11)NO0
options_values_pricedecimal(15,4)NO0.0000
price_prefixchar(1)latin1_general_ciNO
products_options_sort_orderint(11)NOMUL0
product_attribute_is_freetinyint(1)NO0
products_attributes_weightfloatNO0
products_attributes_weight_prefixchar(1)latin1_general_ciNO
attributes_display_onlytinyint(1)NO0
attributes_defaulttinyint(1)NO0
attributes_discountedtinyint(1)NO1
attributes_imagevarchar(64)latin1_general_ciYES
attributes_price_base_includedtinyint(1)NO1
attributes_price_onetimedecimal(15,4)NO0.0000
attributes_price_factordecimal(15,4)NO0.0000
attributes_price_factor_offsetdecimal(15,4)NO0.0000
attributes_price_factor_onetimedecimal(15,4)NO0.0000
attributes_price_factor_onetime_offsetdecimal(15,4)NO0.0000
attributes_qty_pricestextlatin1_general_ciYES
attributes_qty_prices_onetimetextlatin1_general_ciYES
attributes_price_wordsdecimal(15,4)NO0.0000
attributes_price_words_freeint(4)NO0
attributes_price_lettersdecimal(15,4)NO0.0000
attributes_price_letters_freeint(4)NO0
attributes_requiredtinyint(1)NO0

products_attributes_download

FieldTypeCollationNullKeyDefaultExtraComment
products_attributes_idint(11)NOPRI0
products_attributes_filenamevarchar(255)latin1_general_ciNO
products_attributes_maxdaysint(2)YES0
products_attributes_maxcountint(2)YES0

products_description

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRIauto_increment
language_idint(11)NOPRI1
products_namevarchar(64)latin1_general_ciNOMUL
products_descriptiontextlatin1_general_ciYES
products_urlvarchar(255)latin1_general_ciYES
products_viewedint(5)YES0

products_discount_quantity

FieldTypeCollationNullKeyDefaultExtraComment
discount_idint(4)NO0
products_idint(11)NOMUL0
discount_qtyfloatNO0
discount_pricedecimal(15,4)NO0.0000

products_notifications

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRI0
customers_idint(11)NOPRI0
date_addeddatetimeNO0001-01-01 00:00:00

products_options

FieldTypeCollationNullKeyDefaultExtraComment
products_options_idint(11)NOPRI0
language_idint(11)NOPRI1
products_options_namevarchar(32)latin1_general_ciNOMUL
products_options_sort_orderint(11)NOMUL0
products_options_typeint(5)NO0
products_options_lengthsmallint(2)NO32
products_options_commentvarchar(64)latin1_general_ciYES
products_options_sizesmallint(2)NO32
products_options_images_per_rowint(2)YES5
products_options_images_styleint(1)YES0
products_options_rowssmallint(2)NO1

products_options_types

FieldTypeCollationNullKeyDefaultExtraComment
products_options_types_idint(11)NOPRI0
products_options_types_namevarchar(32)latin1_general_ciYES

products_options_values

FieldTypeCollationNullKeyDefaultExtraComment
products_options_values_idint(11)NOPRI0
language_idint(11)NOPRI1
products_options_values_namevarchar(64)latin1_general_ciNOMUL
products_options_values_sort_orderint(11)NOMUL0

products_options_values_to_products_options

FieldTypeCollationNullKeyDefaultExtraComment
products_options_values_to_products_options_idint(11)NOPRIauto_increment
products_options_idint(11)NOMUL0
products_options_values_idint(11)NOMUL0

products_to_categories

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRI0
categories_idint(11)NOPRI0

project_version

FieldTypeCollationNullKeyDefaultExtraComment
project_version_idtinyint(3)NOPRIauto_increment
project_version_keyvarchar(40)latin1_general_ciNOUNI
project_version_majorvarchar(20)latin1_general_ciNO
project_version_minorvarchar(20)latin1_general_ciNO
project_version_patch1varchar(20)latin1_general_ciNO
project_version_patch2varchar(20)latin1_general_ciNO
project_version_patch1_sourcevarchar(20)latin1_general_ciNO
project_version_patch2_sourcevarchar(20)latin1_general_ciNO
project_version_commentvarchar(250)latin1_general_ciNO
project_version_date_applieddatetimeNO0001-01-01 01:01:01

project_version_history

FieldTypeCollationNullKeyDefaultExtraComment
project_version_idtinyint(3)NOPRIauto_increment
project_version_keyvarchar(40)latin1_general_ciNO
project_version_majorvarchar(20)latin1_general_ciNO
project_version_minorvarchar(20)latin1_general_ciNO
project_version_patchvarchar(20)latin1_general_ciNO
project_version_commentvarchar(250)latin1_general_ciNO
project_version_date_applieddatetimeNO0001-01-01 01:01:01

query_builder

FieldTypeCollationNullKeyDefaultExtraComment
query_idint(11)NOPRIauto_increment
query_categoryvarchar(40)latin1_general_ciNO
query_namevarchar(80)latin1_general_ciNOUNI
query_descriptiontextlatin1_general_ciNO
query_stringtextlatin1_general_ciNO
query_keys_listtextlatin1_general_ciNO

record_artists

FieldTypeCollationNullKeyDefaultExtraComment
artists_idint(11)NOPRIauto_increment
artists_namevarchar(32)latin1_general_ciNOMUL
artists_imagevarchar(64)latin1_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

record_artists_info

FieldTypeCollationNullKeyDefaultExtraComment
artists_idint(11)NOPRI0
languages_idint(11)NOPRI0
artists_urlvarchar(255)latin1_general_ciNO
url_clickedint(5)NO0
date_last_clickdatetimeYES

record_company

FieldTypeCollationNullKeyDefaultExtraComment
record_company_idint(11)NOPRIauto_increment
record_company_namevarchar(32)latin1_general_ciNOMUL
record_company_imagevarchar(64)latin1_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

record_company_info

FieldTypeCollationNullKeyDefaultExtraComment
record_company_idint(11)NOPRI0
languages_idint(11)NOPRI0
record_company_urlvarchar(255)latin1_general_ciNO
url_clickedint(5)NO0
date_last_clickdatetimeYES

reviews

FieldTypeCollationNullKeyDefaultExtraComment
reviews_idint(11)NOPRIauto_increment
products_idint(11)NOMUL0
customers_idint(11)YESMUL
customers_namevarchar(64)latin1_general_ciNO
reviews_ratingint(1)YES
date_addeddatetimeYESMUL
last_modifieddatetimeYES
reviews_readint(5)NO0
statusint(1)NOMUL1

reviews_description

FieldTypeCollationNullKeyDefaultExtraComment
reviews_idint(11)NOPRI0
languages_idint(11)NOPRI0
reviews_texttextlatin1_general_ciNO

salemaker_sales

FieldTypeCollationNullKeyDefaultExtraComment
sale_idint(11)NOPRIauto_increment
sale_statustinyint(4)NOMUL0
sale_namevarchar(30)latin1_general_ciNO
sale_deduction_valuedecimal(15,4)NO0.0000
sale_deduction_typetinyint(4)NO0
sale_pricerange_fromdecimal(15,4)NO0.0000
sale_pricerange_todecimal(15,4)NO0.0000
sale_specials_conditiontinyint(4)NO0
sale_categories_selectedtextlatin1_general_ciYES
sale_categories_alltextlatin1_general_ciYES
sale_date_startdateNOMUL0001-01-01
sale_date_enddateNOMUL0001-01-01
sale_date_addeddateNO0001-01-01
sale_date_last_modifieddateNO0001-01-01
sale_date_status_changedateNO0001-01-01

sessions

FieldTypeCollationNullKeyDefaultExtraComment
sesskeyvarchar(32)latin1_general_ciNOPRI
expiryint(11) unsignedNO0
valuemediumblobNO

specials

FieldTypeCollationNullKeyDefaultExtraComment
specials_idint(11)NOPRIauto_increment
products_idint(11)NOMUL0
specials_new_products_pricedecimal(15,4)NO0.0000
specials_date_addeddatetimeYES
specials_last_modifieddatetimeYES
expires_datedateNOMUL0001-01-01
date_status_changedatetimeYES
statusint(1)NOMUL1
specials_date_availabledateNOMUL0001-01-01

tax_class

FieldTypeCollationNullKeyDefaultExtraComment
tax_class_idint(11)NOPRIauto_increment
tax_class_titlevarchar(32)latin1_general_ciNO
tax_class_descriptionvarchar(255)latin1_general_ciNO
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00

tax_rates

FieldTypeCollationNullKeyDefaultExtraComment
tax_rates_idint(11)NOPRIauto_increment
tax_zone_idint(11)NOMUL0
tax_class_idint(11)NOMUL0
tax_priorityint(5)YES1
tax_ratedecimal(7,4)NO0.0000
tax_descriptionvarchar(255)latin1_general_ciNO
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00

template_select

FieldTypeCollationNullKeyDefaultExtraComment
template_idint(11)NOPRIauto_increment
template_dirvarchar(64)latin1_general_ciNO
template_languagevarchar(64)latin1_general_ciNOMUL0

upgrade_exceptions

FieldTypeCollationNullKeyDefaultExtraComment
upgrade_exception_idsmallint(5)NOPRIauto_increment
sql_filevarchar(50)latin1_general_ciYES
reasonvarchar(200)latin1_general_ciYES
errordatedatetimeYES0001-01-01 00:00:00
sqlstatementtextlatin1_general_ciYES

whos_online

FieldTypeCollationNullKeyDefaultExtraComment
customer_idint(11)YESMUL
full_namevarchar(64)latin1_general_ciNO
session_idvarchar(128)latin1_general_ciNOMUL
ip_addressvarchar(15)latin1_general_ciNOMUL
time_entryvarchar(14)latin1_general_ciNOMUL
time_last_clickvarchar(14)latin1_general_ciNOMUL
last_page_urlvarchar(255)latin1_general_ciNOMUL
host_addresstextlatin1_general_ciNO
user_agentvarchar(255)latin1_general_ciNO

zones

FieldTypeCollationNullKeyDefaultExtraComment
zone_idint(11)NOPRIauto_increment
zone_country_idint(11)NOMUL0
zone_codevarchar(32)latin1_general_ciNOMUL
zone_namevarchar(32)latin1_general_ciNO

zones_to_geo_zones

FieldTypeCollationNullKeyDefaultExtraComment
association_idint(11)NOPRIauto_increment
zone_country_idint(11)NO0
zone_idint(11)YES
geo_zone_idint(11)YESMUL
last_modifieddatetimeYES
date_addeddatetimeNO0001-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 (354bf51).