Zen Cart 1.5.1 Schema


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


address_book    address_format    admin    admin_activity_log    admin_menus    admin_pages    admin_pages_to_profiles    admin_profiles    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    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)utf8_general_ciNO
entry_companyvarchar(64)utf8_general_ciYES
entry_firstnamevarchar(32)utf8_general_ciNO
entry_lastnamevarchar(32)utf8_general_ciNO
entry_street_addressvarchar(64)utf8_general_ciNO
entry_suburbvarchar(32)utf8_general_ciYES
entry_postcodevarchar(10)utf8_general_ciNO
entry_cityvarchar(32)utf8_general_ciNO
entry_statevarchar(32)utf8_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)utf8_general_ciNO
entry_companyvarchar(64)utf8_general_ciYES
entry_firstnamevarchar(32)utf8_general_ciNO
entry_lastnamevarchar(32)utf8_general_ciNO
entry_street_addressvarchar(64)utf8_general_ciNO
entry_suburbvarchar(32)utf8_general_ciYES
entry_postcodevarchar(10)utf8_general_ciNO
entry_cityvarchar(32)utf8_general_ciNO
entry_statevarchar(32)utf8_general_ciYES
entry_country_idint(11)NO0
entry_zone_idint(11)NO0

address_format

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

admin

FieldTypeCollationNullKeyDefaultExtraComment
admin_idint(11)NOPRIauto_increment
admin_namevarchar(32)utf8_general_ciNOMUL
admin_emailvarchar(96)utf8_general_ciNOMUL
admin_profileint(11)NOMUL0
admin_passvarchar(40)utf8_general_ciNO
prev_pass1varchar(40)utf8_general_ciNO
prev_pass2varchar(40)utf8_general_ciNO
prev_pass3varchar(40)utf8_general_ciNO
pwd_last_change_datedatetimeNO0000-00-00 00:00:00
reset_tokenvarchar(60)utf8_general_ciNO
last_modifieddatetimeNO0000-00-00 00:00:00
last_login_datedatetimeNO0000-00-00 00:00:00
last_login_ipvarchar(45)utf8_general_ciNO
failed_loginssmallint(4) unsignedNO0
lockout_expiresint(11)NO0
last_failed_attemptdatetimeNO0000-00-00 00:00:00
last_failed_ipvarchar(45)utf8_general_ciNO

admin_activity_log

FieldTypeCollationNullKeyDefaultExtraComment
log_idbigint(15)NOPRIauto_increment
access_datedatetimeNOMUL0001-01-01 00:00:00
admin_idint(11)NO0
page_accessedvarchar(80)utf8_general_ciNOMUL
page_parameterstextutf8_general_ciYES
ip_addressvarchar(45)utf8_general_ciNOMUL
flaggedtinyint(4)NOMUL0
attentionvarchar(255)utf8_general_ciNO
gzpostmediumblobYES

admin_menus

FieldTypeCollationNullKeyDefaultExtraComment
menu_keyvarchar(32)utf8_general_ciNOPRI
language_keyvarchar(255)utf8_general_ciNO
sort_orderint(11)NO0

admin_pages

FieldTypeCollationNullKeyDefaultExtraComment
page_keyvarchar(32)utf8_general_ciNOPRI
language_keyvarchar(255)utf8_general_ciNO
main_pagevarchar(64)utf8_general_ciNO
page_paramsvarchar(64)utf8_general_ciNO
menu_keyvarchar(32)utf8_general_ciNO
display_on_menuchar(1)utf8_general_ciNON
sort_orderint(11)NO0

admin_pages_to_profiles

FieldTypeCollationNullKeyDefaultExtraComment
profile_idint(11)NOPRI0
page_keyvarchar(32)utf8_general_ciNOPRI

admin_profiles

FieldTypeCollationNullKeyDefaultExtraComment
profile_idint(11)NOPRIauto_increment
profile_namevarchar(64)utf8_general_ciNO

authorizenet

FieldTypeCollationNullKeyDefaultExtraComment
idint(11) unsignedNOPRIauto_increment
customer_idint(11)NO0
order_idint(11)NO0
response_codeint(1)NO0
response_textvarchar(255)utf8_general_ciNO
authorization_typevarchar(50)utf8_general_ciNO
transaction_idbigint(20)YES
sentlongtextutf8_general_ciNO
receivedlongtextutf8_general_ciNO
timevarchar(50)utf8_general_ciNO
session_idvarchar(255)utf8_general_ciNO

banners

FieldTypeCollationNullKeyDefaultExtraComment
banners_idint(11)NOPRIauto_increment
banners_titlevarchar(64)utf8_general_ciNO
banners_urlvarchar(255)utf8_general_ciNO
banners_imagevarchar(64)utf8_general_ciNO
banners_groupvarchar(15)utf8_general_ciNO
banners_html_texttextutf8_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)utf8_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)utf8_general_ciNOMUL
categories_descriptiontextutf8_general_ciNO

configuration

FieldTypeCollationNullKeyDefaultExtraComment
configuration_idint(11)NOPRIauto_increment
configuration_titletextutf8_general_ciNO
configuration_keyvarchar(255)utf8_general_ciNOUNI
configuration_valuetextutf8_general_ciNO
configuration_descriptiontextutf8_general_ciNO
configuration_group_idint(11)NOMUL0
sort_orderint(5)YES
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00
use_functiontextutf8_general_ciYES
set_functiontextutf8_general_ciYES

configuration_group

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

counter

FieldTypeCollationNullKeyDefaultExtraComment
startdatechar(8)utf8_general_ciYES
counterint(12)YES

counter_history

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

countries

FieldTypeCollationNullKeyDefaultExtraComment
countries_idint(11)NOPRIauto_increment
countries_namevarchar(64)utf8_general_ciNOMUL
countries_iso_code_2char(2)utf8_general_ciNOMUL
countries_iso_code_3char(3)utf8_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)utf8_general_ciYES
sent_lastnamevarchar(32)utf8_general_ciYES
emailed_tovarchar(32)utf8_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(45)utf8_general_ciNO
release_flagchar(1)utf8_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(45)utf8_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)utf8_general_ciNON

coupons

FieldTypeCollationNullKeyDefaultExtraComment
coupon_idint(11)NOPRIauto_increment
coupon_typechar(1)utf8_general_ciNOMULF
coupon_codevarchar(32)utf8_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)utf8_general_ciYES
restrict_to_categoriesvarchar(255)utf8_general_ciYES
restrict_to_customerstextutf8_general_ciYES
coupon_activechar(1)utf8_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)utf8_general_ciNO
coupon_descriptiontextutf8_general_ciYES

currencies

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

customers

FieldTypeCollationNullKeyDefaultExtraComment
customers_idint(11)NOPRIauto_increment
customers_genderchar(1)utf8_general_ciNO
customers_firstnamevarchar(32)utf8_general_ciNO
customers_lastnamevarchar(32)utf8_general_ciNO
customers_dobdatetimeNO0001-01-01 00:00:00
customers_email_addressvarchar(96)utf8_general_ciNOMUL
customers_nickvarchar(96)utf8_general_ciNOMUL
customers_default_address_idint(11)NO0
customers_telephonevarchar(32)utf8_general_ciNO
customers_faxvarchar(32)utf8_general_ciYES
customers_passwordvarchar(40)utf8_general_ciNO
customers_newsletterchar(1)utf8_general_ciYESMUL
customers_group_pricingint(11)NOMUL0
customers_email_formatvarchar(4)utf8_general_ciNOTEXT
customers_authorizationint(1)NO0
customers_referralvarchar(32)utf8_general_ciNOMUL
customers_paypal_payeridvarchar(20)utf8_general_ciNO
customers_paypal_ectinyint(1) unsignedNO0

customers_basket

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

customers_basket_attributes

FieldTypeCollationNullKeyDefaultExtraComment
customers_basket_attributes_idint(11)NOPRIauto_increment
customers_idint(11)NOMUL0
products_idtinytextutf8_general_ciNO
products_options_idvarchar(64)utf8_general_ciNO0
products_options_value_idint(11)NO0
products_options_value_textblobYES
products_options_sort_ordertextutf8_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

db_cache

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

email_archive

FieldTypeCollationNullKeyDefaultExtraComment
archive_idint(11)NOPRIauto_increment
email_to_namevarchar(96)utf8_general_ciNO
email_to_addressvarchar(96)utf8_general_ciNOMUL
email_from_namevarchar(96)utf8_general_ciNO
email_from_addressvarchar(96)utf8_general_ciNO
email_subjectvarchar(255)utf8_general_ciNO
email_htmltextutf8_general_ciNO
email_texttextutf8_general_ciNO
date_sentdatetimeNO0001-01-01 00:00:00
modulevarchar(64)utf8_general_ciNOMUL

ezpages

FieldTypeCollationNullKeyDefaultExtraComment
pages_idint(11)NOPRIauto_increment
languages_idint(11)NOMUL1
pages_titlevarchar(64)utf8_general_ciNO
alt_urlvarchar(255)utf8_general_ciNO
alt_url_externalvarchar(255)utf8_general_ciNO
pages_html_textmediumtextutf8_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)utf8_general_ciYES
customers_idint(11)YESMUL
files_uploaded_namevarchar(64)utf8_general_ciNO

geo_zones

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

get_terms_to_filter

FieldTypeCollationNullKeyDefaultExtraComment
get_term_namevarchar(255)utf8_general_ciNOPRI
get_term_tablevarchar(64)utf8_general_ciNO
get_term_name_fieldvarchar(64)utf8_general_ciNO

group_pricing

FieldTypeCollationNullKeyDefaultExtraComment
group_idint(11)NOPRIauto_increment
group_namevarchar(32)utf8_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)utf8_general_ciNOMUL
codechar(2)utf8_general_ciNO
imagevarchar(64)utf8_general_ciYES
directoryvarchar(32)utf8_general_ciYES
sort_orderint(3)YES

layout_boxes

FieldTypeCollationNullKeyDefaultExtraComment
layout_idint(11)NOPRIauto_increment
layout_templatevarchar(64)utf8_general_ciNOMUL
layout_box_namevarchar(64)utf8_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)utf8_general_ciNOMUL
manufacturers_imagevarchar(64)utf8_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

manufacturers_info

FieldTypeCollationNullKeyDefaultExtraComment
manufacturers_idint(11)NOPRI0
languages_idint(11)NOPRI0
manufacturers_urlvarchar(255)utf8_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_filenametextutf8_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)utf8_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)utf8_general_ciNOMUL
type_extvarchar(8)utf8_general_ciNO

meta_tags_categories_description

FieldTypeCollationNullKeyDefaultExtraComment
categories_idint(11)NOPRI
language_idint(11)NOPRI1
metatags_titlevarchar(255)utf8_general_ciNO
metatags_keywordstextutf8_general_ciYES
metatags_descriptiontextutf8_general_ciYES

meta_tags_products_description

FieldTypeCollationNullKeyDefaultExtraComment
products_idint(11)NOPRI
language_idint(11)NOPRI1
metatags_titlevarchar(255)utf8_general_ciNO
metatags_keywordstextutf8_general_ciYES
metatags_descriptiontextutf8_general_ciYES

music_genre

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

newsletters

FieldTypeCollationNullKeyDefaultExtraComment
newsletters_idint(11)NOPRIauto_increment
titlevarchar(255)utf8_general_ciNO
contenttextutf8_general_ciNO
content_htmltextutf8_general_ciNO
modulevarchar(255)utf8_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)utf8_general_ciNO
customers_companyvarchar(64)utf8_general_ciYES
customers_street_addressvarchar(64)utf8_general_ciNO
customers_suburbvarchar(32)utf8_general_ciYES
customers_cityvarchar(32)utf8_general_ciNO
customers_postcodevarchar(10)utf8_general_ciNO
customers_statevarchar(32)utf8_general_ciYES
customers_countryvarchar(32)utf8_general_ciNO
customers_telephonevarchar(32)utf8_general_ciNO
customers_email_addressvarchar(96)utf8_general_ciNO
customers_address_format_idint(5)NO0
delivery_namevarchar(64)utf8_general_ciNO
delivery_companyvarchar(64)utf8_general_ciYES
delivery_street_addressvarchar(64)utf8_general_ciNO
delivery_suburbvarchar(32)utf8_general_ciYES
delivery_cityvarchar(32)utf8_general_ciNO
delivery_postcodevarchar(10)utf8_general_ciNO
delivery_statevarchar(32)utf8_general_ciYES
delivery_countryvarchar(32)utf8_general_ciNO
delivery_address_format_idint(5)NO0
billing_namevarchar(64)utf8_general_ciNO
billing_companyvarchar(64)utf8_general_ciYES
billing_street_addressvarchar(64)utf8_general_ciNO
billing_suburbvarchar(32)utf8_general_ciYES
billing_cityvarchar(32)utf8_general_ciNO
billing_postcodevarchar(10)utf8_general_ciNO
billing_statevarchar(32)utf8_general_ciYES
billing_countryvarchar(32)utf8_general_ciNO
billing_address_format_idint(5)NO0
payment_methodvarchar(128)utf8_general_ciNO
payment_module_codevarchar(32)utf8_general_ciNO
shipping_methodvarchar(128)utf8_general_ciNO
shipping_module_codevarchar(32)utf8_general_ciNO
coupon_codevarchar(32)utf8_general_ciNO
cc_typevarchar(20)utf8_general_ciYES
cc_ownervarchar(64)utf8_general_ciYES
cc_numbervarchar(32)utf8_general_ciYES
cc_expiresvarchar(4)utf8_general_ciYES
cc_cvvblobYES
last_modifieddatetimeYES
date_purchaseddatetimeYESMUL
orders_statusint(5)NOMUL0
orders_date_finisheddatetimeYES
currencychar(3)utf8_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)utf8_general_ciNO

orders_products

FieldTypeCollationNullKeyDefaultExtraComment
orders_products_idint(11)NOPRIauto_increment
orders_idint(11)NOMUL0
products_idint(11)NOMUL0
products_modelvarchar(32)utf8_general_ciYES
products_namevarchar(64)utf8_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_pridtinytextutf8_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)utf8_general_ciNO
products_options_valuestextutf8_general_ciNO
options_values_pricedecimal(15,4)NO0.0000
price_prefixchar(1)utf8_general_ciNO
product_attribute_is_freetinyint(1)NO0
products_attributes_weightfloatNO0
products_attributes_weight_prefixchar(1)utf8_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_pricestextutf8_general_ciYES
attributes_qty_prices_onetimetextutf8_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_pridtinytextutf8_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)utf8_general_ciNO
download_maxdaysint(2)NO0
download_countint(2)NO0
products_pridtinytextutf8_general_ciNO

orders_status

FieldTypeCollationNullKeyDefaultExtraComment
orders_status_idint(11)NOPRI0
language_idint(11)NOPRI1
orders_status_namevarchar(32)utf8_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
commentstextutf8_general_ciYES

orders_total

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

paypal

FieldTypeCollationNullKeyDefaultExtraComment
paypal_ipn_idint(11) unsignedNOPRIauto_increment
order_idint(11) unsignedNOMUL0
txn_typevarchar(40)utf8_general_ciNO
module_namevarchar(40)utf8_general_ciNO
module_modevarchar(40)utf8_general_ciNO
reason_codevarchar(40)utf8_general_ciYES
payment_typevarchar(40)utf8_general_ciNO
payment_statusvarchar(32)utf8_general_ciNO
pending_reasonvarchar(32)utf8_general_ciYES
invoicevarchar(128)utf8_general_ciYES
mc_currencychar(3)utf8_general_ciNO
first_namevarchar(32)utf8_general_ciNO
last_namevarchar(32)utf8_general_ciNO
payer_business_namevarchar(128)utf8_general_ciYES
address_namevarchar(64)utf8_general_ciYES
address_streetvarchar(254)utf8_general_ciYES
address_cityvarchar(120)utf8_general_ciYES
address_statevarchar(120)utf8_general_ciYES
address_zipvarchar(10)utf8_general_ciYES
address_countryvarchar(64)utf8_general_ciYES
address_statusvarchar(11)utf8_general_ciYES
payer_emailvarchar(128)utf8_general_ciNO
payer_idvarchar(32)utf8_general_ciNO
payer_statusvarchar(10)utf8_general_ciNO
payment_datedatetimeNO0001-01-01 00:00:00
businessvarchar(128)utf8_general_ciNO
receiver_emailvarchar(128)utf8_general_ciNO
receiver_idvarchar(32)utf8_general_ciNO
txn_idvarchar(20)utf8_general_ciNOPRI
parent_txn_idvarchar(20)utf8_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)utf8_general_ciYES
exchange_ratedecimal(4,2)YES
notify_versionvarchar(6)utf8_general_ciNO
verify_signvarchar(128)utf8_general_ciNO
last_modifieddatetimeNO0001-01-01 00:00:00
date_addeddatetimeNO0001-01-01 00:00:00
memotextutf8_general_ciYES

paypal_payment_status

FieldTypeCollationNullKeyDefaultExtraComment
payment_status_idint(11)NOPRIauto_increment
payment_status_namevarchar(64)utf8_general_ciNO

paypal_payment_status_history

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

paypal_session

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

paypal_testing

FieldTypeCollationNullKeyDefaultExtraComment
paypal_ipn_idint(11) unsignedNOPRIauto_increment
order_idint(11) unsignedNOMUL0
customvarchar(255)utf8_general_ciNO
txn_typevarchar(40)utf8_general_ciNO
module_namevarchar(40)utf8_general_ciNO
module_modevarchar(40)utf8_general_ciNO
reason_codevarchar(40)utf8_general_ciYES
payment_typevarchar(40)utf8_general_ciNO
payment_statusvarchar(32)utf8_general_ciNO
pending_reasonvarchar(32)utf8_general_ciYES
invoicevarchar(128)utf8_general_ciYES
mc_currencychar(3)utf8_general_ciNO
first_namevarchar(32)utf8_general_ciNO
last_namevarchar(32)utf8_general_ciNO
payer_business_namevarchar(128)utf8_general_ciYES
address_namevarchar(64)utf8_general_ciYES
address_streetvarchar(254)utf8_general_ciYES
address_cityvarchar(120)utf8_general_ciYES
address_statevarchar(120)utf8_general_ciYES
address_zipvarchar(10)utf8_general_ciYES
address_countryvarchar(64)utf8_general_ciYES
address_statusvarchar(11)utf8_general_ciYES
payer_emailvarchar(128)utf8_general_ciNO
payer_idvarchar(32)utf8_general_ciNO
payer_statusvarchar(10)utf8_general_ciNO
payment_datedatetimeNO0001-01-01 00:00:00
businessvarchar(128)utf8_general_ciNO
receiver_emailvarchar(128)utf8_general_ciNO
receiver_idvarchar(32)utf8_general_ciNO
txn_idvarchar(20)utf8_general_ciNOPRI
parent_txn_idvarchar(20)utf8_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)utf8_general_ciYES
exchange_ratedecimal(4,2)YES
notify_versiondecimal(2,1)NO0.0
verify_signvarchar(128)utf8_general_ciNO
last_modifieddatetimeNO0001-01-01 00:00:00
date_addeddatetimeNO0001-01-01 00:00:00
memotextutf8_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_titletextutf8_general_ciNO
configuration_keyvarchar(255)utf8_general_ciNOUNI
configuration_valuetextutf8_general_ciNO
configuration_descriptiontextutf8_general_ciNO
product_type_idint(11)NOMUL0
sort_orderint(5)YES
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00
use_functiontextutf8_general_ciYES
set_functiontextutf8_general_ciYES

product_types

FieldTypeCollationNullKeyDefaultExtraComment
type_idint(11)NOPRIauto_increment
type_namevarchar(255)utf8_general_ciNO
type_handlervarchar(255)utf8_general_ciNO
type_master_typeint(11)NOMUL1
allow_add_to_cartchar(1)utf8_general_ciNOY
default_imagevarchar(255)utf8_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)utf8_general_ciYESMUL
products_imagevarchar(64)utf8_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)utf8_general_ciNO
products_options_sort_orderint(11)NOMUL0
product_attribute_is_freetinyint(1)NO0
products_attributes_weightfloatNO0
products_attributes_weight_prefixchar(1)utf8_general_ciNO
attributes_display_onlytinyint(1)NO0
attributes_defaulttinyint(1)NO0
attributes_discountedtinyint(1)NO1
attributes_imagevarchar(64)utf8_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_pricestextutf8_general_ciYES
attributes_qty_prices_onetimetextutf8_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)utf8_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)utf8_general_ciNOMUL
products_descriptiontextutf8_general_ciYES
products_urlvarchar(255)utf8_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)utf8_general_ciNOMUL
products_options_sort_orderint(11)NOMUL0
products_options_typeint(5)NO0
products_options_lengthsmallint(2)NO32
products_options_commentvarchar(64)utf8_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)utf8_general_ciYES

products_options_values

FieldTypeCollationNullKeyDefaultExtraComment
products_options_values_idint(11)NOPRI0
language_idint(11)NOPRI1
products_options_values_namevarchar(64)utf8_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)utf8_general_ciNOUNI
project_version_majorvarchar(20)utf8_general_ciNO
project_version_minorvarchar(20)utf8_general_ciNO
project_version_patch1varchar(20)utf8_general_ciNO
project_version_patch2varchar(20)utf8_general_ciNO
project_version_patch1_sourcevarchar(20)utf8_general_ciNO
project_version_patch2_sourcevarchar(20)utf8_general_ciNO
project_version_commentvarchar(250)utf8_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)utf8_general_ciNO
project_version_majorvarchar(20)utf8_general_ciNO
project_version_minorvarchar(20)utf8_general_ciNO
project_version_patchvarchar(20)utf8_general_ciNO
project_version_commentvarchar(250)utf8_general_ciNO
project_version_date_applieddatetimeNO0001-01-01 01:01:01

query_builder

FieldTypeCollationNullKeyDefaultExtraComment
query_idint(11)NOPRIauto_increment
query_categoryvarchar(40)utf8_general_ciNO
query_namevarchar(80)utf8_general_ciNOUNI
query_descriptiontextutf8_general_ciNO
query_stringtextutf8_general_ciNO
query_keys_listtextutf8_general_ciNO

record_artists

FieldTypeCollationNullKeyDefaultExtraComment
artists_idint(11)NOPRIauto_increment
artists_namevarchar(32)utf8_general_ciNOMUL
artists_imagevarchar(64)utf8_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

record_artists_info

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

record_company

FieldTypeCollationNullKeyDefaultExtraComment
record_company_idint(11)NOPRIauto_increment
record_company_namevarchar(32)utf8_general_ciNOMUL
record_company_imagevarchar(64)utf8_general_ciYES
date_addeddatetimeYES
last_modifieddatetimeYES

record_company_info

FieldTypeCollationNullKeyDefaultExtraComment
record_company_idint(11)NOPRI0
languages_idint(11)NOPRI0
record_company_urlvarchar(255)utf8_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)utf8_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_texttextutf8_general_ciNO

salemaker_sales

FieldTypeCollationNullKeyDefaultExtraComment
sale_idint(11)NOPRIauto_increment
sale_statustinyint(4)NOMUL0
sale_namevarchar(30)utf8_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_selectedtextutf8_general_ciYES
sale_categories_alltextutf8_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(64)utf8_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)utf8_general_ciNO
tax_class_descriptionvarchar(255)utf8_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)utf8_general_ciNO
last_modifieddatetimeYES
date_addeddatetimeNO0001-01-01 00:00:00

template_select

FieldTypeCollationNullKeyDefaultExtraComment
template_idint(11)NOPRIauto_increment
template_dirvarchar(64)utf8_general_ciNO
template_languagevarchar(64)utf8_general_ciNOMUL0

upgrade_exceptions

FieldTypeCollationNullKeyDefaultExtraComment
upgrade_exception_idsmallint(5)NOPRIauto_increment
sql_filevarchar(50)utf8_general_ciYES
reasonvarchar(200)utf8_general_ciYES
errordatedatetimeYES0001-01-01 00:00:00
sqlstatementtextutf8_general_ciYES

whos_online

FieldTypeCollationNullKeyDefaultExtraComment
customer_idint(11)YESMUL
full_namevarchar(64)utf8_general_ciNO
session_idvarchar(128)utf8_general_ciNOMUL
ip_addressvarchar(45)utf8_general_ciNOMUL
time_entryvarchar(14)utf8_general_ciNOMUL
time_last_clickvarchar(14)utf8_general_ciNOMUL
last_page_urlvarchar(255)utf8_general_ciNOMUL
host_addresstextutf8_general_ciNO
user_agentvarchar(255)utf8_general_ciNO

zones

FieldTypeCollationNullKeyDefaultExtraComment
zone_idint(11)NOPRIauto_increment
zone_country_idint(11)NOMUL0
zone_codevarchar(32)utf8_general_ciNOMUL
zone_namevarchar(32)utf8_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).