Zen Cart 1.5.1 Schema

This is the database schema for Zen Cart version 1.5.1.


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


Last modified March 23, 2020 by Scott C Wilson (7eff069).