Zen Cart 1.5.1 Schema
Legend:
bolded fields are primary keys,
links are foreign keys.
address_book Field Type Collation Null Key Default Extra Comment address_book_id int(11) NO PRI auto_increment customers_id int(11) NO MUL 0 entry_gender char(1) utf8_general_ci NO entry_company varchar(64) utf8_general_ci YES entry_firstname varchar(32) utf8_general_ci NO entry_lastname varchar(32) utf8_general_ci NO entry_street_address varchar(64) utf8_general_ci NO entry_suburb varchar(32) utf8_general_ci YES entry_postcode varchar(10) utf8_general_ci NO entry_city varchar(32) utf8_general_ci NO entry_state varchar(32) utf8_general_ci YES entry_country_id int(11) NO 0 entry_zone_id int(11) NO 0
address_book Field Type Collation Null Key Default Extra Comment address_book_id int(11) NO PRI auto_increment customers_id int(11) NO MUL 0 entry_gender char(1) utf8_general_ci NO entry_company varchar(64) utf8_general_ci YES entry_firstname varchar(32) utf8_general_ci NO entry_lastname varchar(32) utf8_general_ci NO entry_street_address varchar(64) utf8_general_ci NO entry_suburb varchar(32) utf8_general_ci YES entry_postcode varchar(10) utf8_general_ci NO entry_city varchar(32) utf8_general_ci NO entry_state varchar(32) utf8_general_ci YES entry_country_id int(11) NO 0 entry_zone_id int(11) NO 0
Field Type Collation Null Key Default Extra Comment address_format_id int(11) NO PRI auto_increment address_format varchar(128) utf8_general_ci NO address_summary varchar(48) utf8_general_ci NO
admin Field Type Collation Null Key Default Extra Comment admin_id int(11) NO PRI auto_increment admin_name varchar(32) utf8_general_ci NO MUL admin_email varchar(96) utf8_general_ci NO MUL admin_profile int(11) NO MUL 0 admin_pass varchar(40) utf8_general_ci NO prev_pass1 varchar(40) utf8_general_ci NO prev_pass2 varchar(40) utf8_general_ci NO prev_pass3 varchar(40) utf8_general_ci NO pwd_last_change_date datetime NO 0000-00-00 00:00:00 reset_token varchar(60) utf8_general_ci NO last_modified datetime NO 0000-00-00 00:00:00 last_login_date datetime NO 0000-00-00 00:00:00 last_login_ip varchar(45) utf8_general_ci NO failed_logins smallint(4) unsigned NO 0 lockout_expires int(11) NO 0 last_failed_attempt datetime NO 0000-00-00 00:00:00 last_failed_ip varchar(45) utf8_general_ci NO
admin_activity_log Field Type Collation Null Key Default Extra Comment log_id bigint(15) NO PRI auto_increment access_date datetime NO MUL 0001-01-01 00:00:00 admin_id int(11) NO 0 page_accessed varchar(80) utf8_general_ci NO MUL page_parameters text utf8_general_ci YES ip_address varchar(45) utf8_general_ci NO MUL flagged tinyint(4) NO MUL 0 attention varchar(255) utf8_general_ci NO gzpost mediumblob YES
Field Type Collation Null Key Default Extra Comment menu_key varchar(32) utf8_general_ci NO PRI language_key varchar(255) utf8_general_ci NO sort_order int(11) NO 0
admin_pages Field Type Collation Null Key Default Extra Comment page_key varchar(32) utf8_general_ci NO PRI language_key varchar(255) utf8_general_ci NO main_page varchar(64) utf8_general_ci NO page_params varchar(64) utf8_general_ci NO menu_key varchar(32) utf8_general_ci NO display_on_menu char(1) utf8_general_ci NO N sort_order int(11) NO 0
admin_pages_to_profiles Field Type Collation Null Key Default Extra Comment profile_id int(11) NO PRI 0 page_key varchar(32) utf8_general_ci NO PRI
admin_profiles Field Type Collation Null Key Default Extra Comment profile_id int(11) NO PRI auto_increment profile_name varchar(64) utf8_general_ci NO
authorizenet Field Type Collation Null Key Default Extra Comment id int(11) unsigned NO PRI auto_increment customer_id int(11) NO 0 order_id int(11) NO 0 response_code int(1) NO 0 response_text varchar(255) utf8_general_ci NO authorization_type varchar(50) utf8_general_ci NO transaction_id bigint(20) YES sent longtext utf8_general_ci NO received longtext utf8_general_ci NO time varchar(50) utf8_general_ci NO session_id varchar(255) utf8_general_ci NO
banners Field Type Collation Null Key Default Extra Comment banners_id int(11) NO PRI auto_increment banners_title varchar(64) utf8_general_ci NO banners_url varchar(255) utf8_general_ci NO banners_image varchar(64) utf8_general_ci NO banners_group varchar(15) utf8_general_ci NO banners_html_text text utf8_general_ci YES expires_impressions int(7) YES 0 expires_date datetime YES MUL date_scheduled datetime YES MUL date_added datetime NO 0001-01-01 00:00:00 date_status_change datetime YES status int(1) NO MUL 1 banners_open_new_windows int(1) NO 1 banners_on_ssl int(1) NO 1 banners_sort_order int(11) NO 0
banners_history Field Type Collation Null Key Default Extra Comment banners_history_id int(11) NO PRI auto_increment banners_id int(11) NO MUL 0 banners_shown int(5) NO 0 banners_clicked int(5) NO 0 banners_history_date datetime NO 0001-01-01 00:00:00
categories Field Type Collation Null Key Default Extra Comment categories_id int(11) NO PRI auto_increment categories_image varchar(64) utf8_general_ci YES parent_id int(11) NO MUL 0 sort_order int(3) YES MUL date_added datetime YES last_modified datetime YES categories_status tinyint(1) NO MUL 1
categories_description Field Type Collation Null Key Default Extra Comment categories_id int(11) NO PRI 0 language_id int(11) NO PRI 1 categories_name varchar(32) utf8_general_ci NO MUL categories_description text utf8_general_ci NO
configuration Field Type Collation Null Key Default Extra Comment configuration_id int(11) NO PRI auto_increment configuration_title text utf8_general_ci NO configuration_key varchar(255) utf8_general_ci NO UNI configuration_value text utf8_general_ci NO configuration_description text utf8_general_ci NO configuration_group_id int(11) NO MUL 0 sort_order int(5) YES last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00 use_function text utf8_general_ci YES set_function text utf8_general_ci YES
configuration_group Field Type Collation Null Key Default Extra Comment configuration_group_id int(11) NO PRI auto_increment configuration_group_title varchar(64) utf8_general_ci NO configuration_group_description varchar(255) utf8_general_ci NO sort_order int(5) YES visible int(1) YES MUL 1
counter Field Type Collation Null Key Default Extra Comment startdate char(8) utf8_general_ci YES counter int(12) YES
counter_history Field Type Collation Null Key Default Extra Comment startdate char(8) utf8_general_ci YES PRI counter int(12) YES session_counter int(12) YES
countries Field Type Collation Null Key Default Extra Comment countries_id int(11) NO PRI auto_increment countries_name varchar(64) utf8_general_ci NO MUL countries_iso_code_2 char(2) utf8_general_ci NO MUL countries_iso_code_3 char(3) utf8_general_ci NO MUL address_format_id int(11) NO MUL 0
coupon_email_track Field Type Collation Null Key Default Extra Comment unique_id int(11) NO PRI auto_increment coupon_id int(11) NO MUL 0 customer_id_sent int(11) NO 0 sent_firstname varchar(32) utf8_general_ci YES sent_lastname varchar(32) utf8_general_ci YES emailed_to varchar(32) utf8_general_ci YES date_sent datetime NO 0001-01-01 00:00:00
coupon_gv_customer Field Type Collation Null Key Default Extra Comment customer_id int(5) NO PRI 0 amount decimal(15,4) NO 0.0000
coupon_gv_queue Field Type Collation Null Key Default Extra Comment unique_id int(5) NO PRI auto_increment customer_id int(5) NO MUL 0 order_id int(5) NO 0 amount decimal(15,4) NO 0.0000 date_created datetime NO 0001-01-01 00:00:00 ipaddr varchar(45) utf8_general_ci NO release_flag char(1) utf8_general_ci NO MUL N
coupon_redeem_track Field Type Collation Null Key Default Extra Comment unique_id int(11) NO PRI auto_increment coupon_id int(11) NO MUL 0 customer_id int(11) NO 0 redeem_date datetime NO 0001-01-01 00:00:00 redeem_ip varchar(45) utf8_general_ci NO order_id int(11) NO 0
coupon_restrict Field Type Collation Null Key Default Extra Comment restrict_id int(11) NO PRI auto_increment coupon_id int(11) NO MUL 0 product_id int(11) NO 0 category_id int(11) NO 0 coupon_restrict char(1) utf8_general_ci NO N
coupons Field Type Collation Null Key Default Extra Comment coupon_id int(11) NO PRI auto_increment coupon_type char(1) utf8_general_ci NO MUL F coupon_code varchar(32) utf8_general_ci NO MUL coupon_amount decimal(15,4) NO 0.0000 coupon_minimum_order decimal(15,4) NO 0.0000 coupon_start_date datetime NO 0001-01-01 00:00:00 coupon_expire_date datetime NO 0001-01-01 00:00:00 uses_per_coupon int(5) NO 1 uses_per_user int(5) NO 0 restrict_to_products varchar(255) utf8_general_ci YES restrict_to_categories varchar(255) utf8_general_ci YES restrict_to_customers text utf8_general_ci YES coupon_active char(1) utf8_general_ci NO MUL Y date_created datetime NO 0001-01-01 00:00:00 date_modified datetime NO 0001-01-01 00:00:00 coupon_zone_restriction int(11) NO 0
coupons_description Field Type Collation Null Key Default Extra Comment coupon_id int(11) NO PRI 0 language_id int(11) NO PRI 0 coupon_name varchar(32) utf8_general_ci NO coupon_description text utf8_general_ci YES
currencies Field Type Collation Null Key Default Extra Comment currencies_id int(11) NO PRI auto_increment title varchar(32) utf8_general_ci NO code char(3) utf8_general_ci NO symbol_left varchar(24) utf8_general_ci YES symbol_right varchar(24) utf8_general_ci YES decimal_point char(1) utf8_general_ci YES thousands_point char(1) utf8_general_ci YES decimal_places char(1) utf8_general_ci YES value float(13,8) YES last_updated datetime YES
customers Field Type Collation Null Key Default Extra Comment customers_id int(11) NO PRI auto_increment customers_gender char(1) utf8_general_ci NO customers_firstname varchar(32) utf8_general_ci NO customers_lastname varchar(32) utf8_general_ci NO customers_dob datetime NO 0001-01-01 00:00:00 customers_email_address varchar(96) utf8_general_ci NO MUL customers_nick varchar(96) utf8_general_ci NO MUL customers_default_address_id int(11) NO 0 customers_telephone varchar(32) utf8_general_ci NO customers_fax varchar(32) utf8_general_ci YES customers_password varchar(40) utf8_general_ci NO customers_newsletter char(1) utf8_general_ci YES MUL customers_group_pricing int(11) NO MUL 0 customers_email_format varchar(4) utf8_general_ci NO TEXT customers_authorization int(1) NO 0 customers_referral varchar(32) utf8_general_ci NO MUL customers_paypal_payerid varchar(20) utf8_general_ci NO customers_paypal_ec tinyint(1) unsigned NO 0
customers_basket Field Type Collation Null Key Default Extra Comment customers_basket_id int(11) NO PRI auto_increment customers_id int(11) NO MUL 0 products_id tinytext utf8_general_ci NO customers_basket_quantity float NO 0 final_price decimal(15,4) NO 0.0000 customers_basket_date_added varchar(8) utf8_general_ci YES
customers_basket_attributes customers_info Field Type Collation Null Key Default Extra Comment customers_info_id int(11) NO PRI 0 customers_info_date_of_last_logon datetime YES customers_info_number_of_logons int(5) YES customers_info_date_account_created datetime YES customers_info_date_account_last_modified datetime YES global_product_notifications int(1) YES 0
db_cache Field Type Collation Null Key Default Extra Comment cache_entry_name varchar(64) utf8_general_ci NO PRI cache_data mediumblob YES cache_entry_created int(15) YES
email_archive Field Type Collation Null Key Default Extra Comment archive_id int(11) NO PRI auto_increment email_to_name varchar(96) utf8_general_ci NO email_to_address varchar(96) utf8_general_ci NO MUL email_from_name varchar(96) utf8_general_ci NO email_from_address varchar(96) utf8_general_ci NO email_subject varchar(255) utf8_general_ci NO email_html text utf8_general_ci NO email_text text utf8_general_ci NO date_sent datetime NO 0001-01-01 00:00:00 module varchar(64) utf8_general_ci NO MUL
ezpages Field Type Collation Null Key Default Extra Comment pages_id int(11) NO PRI auto_increment languages_id int(11) NO MUL 1 pages_title varchar(64) utf8_general_ci NO alt_url varchar(255) utf8_general_ci NO alt_url_external varchar(255) utf8_general_ci NO pages_html_text mediumtext utf8_general_ci YES status_header int(1) NO MUL 1 status_sidebox int(1) NO MUL 1 status_footer int(1) NO MUL 1 status_toc int(1) NO MUL 1 header_sort_order int(3) NO 0 sidebox_sort_order int(3) NO 0 footer_sort_order int(3) NO 0 toc_sort_order int(3) NO 0 page_open_new_window int(1) NO 0 page_is_ssl int(1) NO 0 toc_chapter int(11) NO 0
featured Field Type Collation Null Key Default Extra Comment featured_id int(11) NO PRI auto_increment products_id int(11) NO MUL 0 featured_date_added datetime YES featured_last_modified datetime YES expires_date date NO MUL 0001-01-01 date_status_change datetime YES status int(1) NO MUL 1 featured_date_available date NO MUL 0001-01-01
files_uploaded Field Type Collation Null Key Default Extra Comment files_uploaded_id int(11) NO PRI auto_increment sesskey varchar(32) utf8_general_ci YES customers_id int(11) YES MUL files_uploaded_name varchar(64) utf8_general_ci NO
geo_zones Field Type Collation Null Key Default Extra Comment geo_zone_id int(11) NO PRI auto_increment geo_zone_name varchar(32) utf8_general_ci NO geo_zone_description varchar(255) utf8_general_ci NO last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00
get_terms_to_filter Field Type Collation Null Key Default Extra Comment get_term_name varchar(255) utf8_general_ci NO PRI get_term_table varchar(64) utf8_general_ci NO get_term_name_field varchar(64) utf8_general_ci NO
group_pricing Field Type Collation Null Key Default Extra Comment group_id int(11) NO PRI auto_increment group_name varchar(32) utf8_general_ci NO group_percentage decimal(5,2) NO 0.00 last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00
languages Field Type Collation Null Key Default Extra Comment languages_id int(11) NO PRI auto_increment name varchar(32) utf8_general_ci NO MUL code char(2) utf8_general_ci NO image varchar(64) utf8_general_ci YES directory varchar(32) utf8_general_ci YES sort_order int(3) YES
layout_boxes Field Type Collation Null Key Default Extra Comment layout_id int(11) NO PRI auto_increment layout_template varchar(64) utf8_general_ci NO MUL layout_box_name varchar(64) utf8_general_ci NO layout_box_status tinyint(1) NO MUL 0 layout_box_location tinyint(1) NO 0 layout_box_sort_order int(11) NO MUL 0 layout_box_sort_order_single int(11) NO 0 layout_box_status_single tinyint(4) NO 0
manufacturers Field Type Collation Null Key Default Extra Comment manufacturers_id int(11) NO PRI auto_increment manufacturers_name varchar(32) utf8_general_ci NO MUL manufacturers_image varchar(64) utf8_general_ci YES date_added datetime YES last_modified datetime YES
manufacturers_info Field Type Collation Null Key Default Extra Comment manufacturers_id int(11) NO PRI 0 languages_id int(11) NO PRI 0 manufacturers_url varchar(255) utf8_general_ci NO url_clicked int(5) NO 0 date_last_click datetime YES
Field Type Collation Null Key Default Extra Comment clip_id int(11) NO PRI auto_increment media_id int(11) NO MUL 0 clip_type smallint(6) NO MUL 0 clip_filename text utf8_general_ci NO date_added datetime NO 0001-01-01 00:00:00 last_modified datetime NO 0001-01-01 00:00:00
Field Type Collation Null Key Default Extra Comment media_id int(11) NO PRI auto_increment media_name varchar(255) utf8_general_ci NO MUL last_modified datetime NO 0001-01-01 00:00:00 date_added datetime NO 0001-01-01 00:00:00
Field Type Collation Null Key Default Extra Comment media_id int(11) NO MUL 0 product_id int(11) NO 0
Field Type Collation Null Key Default Extra Comment type_id int(11) NO PRI auto_increment type_name varchar(64) utf8_general_ci NO MUL type_ext varchar(8) utf8_general_ci NO
Field Type Collation Null Key Default Extra Comment categories_id int(11) NO PRI language_id int(11) NO PRI 1 metatags_title varchar(255) utf8_general_ci NO metatags_keywords text utf8_general_ci YES metatags_description text utf8_general_ci YES
Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI language_id int(11) NO PRI 1 metatags_title varchar(255) utf8_general_ci NO metatags_keywords text utf8_general_ci YES metatags_description text utf8_general_ci YES
music_genre Field Type Collation Null Key Default Extra Comment music_genre_id int(11) NO PRI auto_increment music_genre_name varchar(32) utf8_general_ci NO MUL date_added datetime YES last_modified datetime YES
newsletters Field Type Collation Null Key Default Extra Comment newsletters_id int(11) NO PRI auto_increment title varchar(255) utf8_general_ci NO content text utf8_general_ci NO content_html text utf8_general_ci NO module varchar(255) utf8_general_ci NO date_added datetime NO 0001-01-01 00:00:00 date_sent datetime YES status int(1) YES locked int(1) YES 0
orders Field Type Collation Null Key Default Extra Comment orders_id int(11) NO PRI auto_increment customers_id int(11) NO MUL 0 customers_name varchar(64) utf8_general_ci NO customers_company varchar(64) utf8_general_ci YES customers_street_address varchar(64) utf8_general_ci NO customers_suburb varchar(32) utf8_general_ci YES customers_city varchar(32) utf8_general_ci NO customers_postcode varchar(10) utf8_general_ci NO customers_state varchar(32) utf8_general_ci YES customers_country varchar(32) utf8_general_ci NO customers_telephone varchar(32) utf8_general_ci NO customers_email_address varchar(96) utf8_general_ci NO customers_address_format_id int(5) NO 0 delivery_name varchar(64) utf8_general_ci NO delivery_company varchar(64) utf8_general_ci YES delivery_street_address varchar(64) utf8_general_ci NO delivery_suburb varchar(32) utf8_general_ci YES delivery_city varchar(32) utf8_general_ci NO delivery_postcode varchar(10) utf8_general_ci NO delivery_state varchar(32) utf8_general_ci YES delivery_country varchar(32) utf8_general_ci NO delivery_address_format_id int(5) NO 0 billing_name varchar(64) utf8_general_ci NO billing_company varchar(64) utf8_general_ci YES billing_street_address varchar(64) utf8_general_ci NO billing_suburb varchar(32) utf8_general_ci YES billing_city varchar(32) utf8_general_ci NO billing_postcode varchar(10) utf8_general_ci NO billing_state varchar(32) utf8_general_ci YES billing_country varchar(32) utf8_general_ci NO billing_address_format_id int(5) NO 0 payment_method varchar(128) utf8_general_ci NO payment_module_code varchar(32) utf8_general_ci NO shipping_method varchar(128) utf8_general_ci NO shipping_module_code varchar(32) utf8_general_ci NO coupon_code varchar(32) utf8_general_ci NO cc_type varchar(20) utf8_general_ci YES cc_owner varchar(64) utf8_general_ci YES cc_number varchar(32) utf8_general_ci YES cc_expires varchar(4) utf8_general_ci YES cc_cvv blob YES last_modified datetime YES date_purchased datetime YES MUL orders_status int(5) NO MUL 0 orders_date_finished datetime YES currency char(3) utf8_general_ci YES currency_value decimal(14,6) YES order_total decimal(14,2) YES order_tax decimal(14,2) YES paypal_ipn_id int(11) NO 0 ip_address varchar(96) utf8_general_ci NO
orders_products Field Type Collation Null Key Default Extra Comment orders_products_id int(11) NO PRI auto_increment orders_id int(11) NO MUL 0 products_id int(11) NO MUL 0 products_model varchar(32) utf8_general_ci YES products_name varchar(64) utf8_general_ci NO products_price decimal(15,4) NO 0.0000 final_price decimal(15,4) NO 0.0000 products_tax decimal(7,4) NO 0.0000 products_quantity float NO 0 onetime_charges decimal(15,4) NO 0.0000 products_priced_by_attribute tinyint(1) NO 0 product_is_free tinyint(1) NO 0 products_discount_type tinyint(1) NO 0 products_discount_type_from tinyint(1) NO 0 products_prid tinytext utf8_general_ci NO
orders_products_attributes Field Type Collation Null Key Default Extra Comment orders_products_attributes_id int(11) NO PRI auto_increment orders_id int(11) NO MUL 0 orders_products_id int(11) NO 0 products_options varchar(32) utf8_general_ci NO products_options_values text utf8_general_ci NO options_values_price decimal(15,4) NO 0.0000 price_prefix char(1) utf8_general_ci NO product_attribute_is_free tinyint(1) NO 0 products_attributes_weight float NO 0 products_attributes_weight_prefix char(1) utf8_general_ci NO attributes_discounted tinyint(1) NO 1 attributes_price_base_included tinyint(1) NO 1 attributes_price_onetime decimal(15,4) NO 0.0000 attributes_price_factor decimal(15,4) NO 0.0000 attributes_price_factor_offset decimal(15,4) NO 0.0000 attributes_price_factor_onetime decimal(15,4) NO 0.0000 attributes_price_factor_onetime_offset decimal(15,4) NO 0.0000 attributes_qty_prices text utf8_general_ci YES attributes_qty_prices_onetime text utf8_general_ci YES attributes_price_words decimal(15,4) NO 0.0000 attributes_price_words_free int(4) NO 0 attributes_price_letters decimal(15,4) NO 0.0000 attributes_price_letters_free int(4) NO 0 products_options_id int(11) NO 0 products_options_values_id int(11) NO 0 products_prid tinytext utf8_general_ci NO
orders_products_download Field Type Collation Null Key Default Extra Comment orders_products_download_id int(11) NO PRI auto_increment orders_id int(11) NO MUL 0 orders_products_id int(11) NO MUL 0 orders_products_filename varchar(255) utf8_general_ci NO download_maxdays int(2) NO 0 download_count int(2) NO 0 products_prid tinytext utf8_general_ci NO
orders_status Field Type Collation Null Key Default Extra Comment orders_status_id int(11) NO PRI 0 language_id int(11) NO PRI 1 orders_status_name varchar(32) utf8_general_ci NO MUL
orders_status_history Field Type Collation Null Key Default Extra Comment orders_status_history_id int(11) NO PRI auto_increment orders_id int(11) NO MUL 0 orders_status_id int(5) NO 0 date_added datetime NO 0001-01-01 00:00:00 customer_notified int(1) YES 0 comments text utf8_general_ci YES
orders_total Field Type Collation Null Key Default Extra Comment orders_total_id int(10) unsigned NO PRI auto_increment orders_id int(11) NO MUL 0 title varchar(255) utf8_general_ci NO text varchar(255) utf8_general_ci NO value decimal(15,4) NO 0.0000 class varchar(32) utf8_general_ci NO MUL sort_order int(11) NO 0
paypal Field Type Collation Null Key Default Extra Comment paypal_ipn_id int(11) unsigned NO PRI auto_increment order_id int(11) unsigned NO MUL 0 txn_type varchar(40) utf8_general_ci NO module_name varchar(40) utf8_general_ci NO module_mode varchar(40) utf8_general_ci NO reason_code varchar(40) utf8_general_ci YES payment_type varchar(40) utf8_general_ci NO payment_status varchar(32) utf8_general_ci NO pending_reason varchar(32) utf8_general_ci YES invoice varchar(128) utf8_general_ci YES mc_currency char(3) utf8_general_ci NO first_name varchar(32) utf8_general_ci NO last_name varchar(32) utf8_general_ci NO payer_business_name varchar(128) utf8_general_ci YES address_name varchar(64) utf8_general_ci YES address_street varchar(254) utf8_general_ci YES address_city varchar(120) utf8_general_ci YES address_state varchar(120) utf8_general_ci YES address_zip varchar(10) utf8_general_ci YES address_country varchar(64) utf8_general_ci YES address_status varchar(11) utf8_general_ci YES payer_email varchar(128) utf8_general_ci NO payer_id varchar(32) utf8_general_ci NO payer_status varchar(10) utf8_general_ci NO payment_date datetime NO 0001-01-01 00:00:00 business varchar(128) utf8_general_ci NO receiver_email varchar(128) utf8_general_ci NO receiver_id varchar(32) utf8_general_ci NO txn_id varchar(20) utf8_general_ci NO PRI parent_txn_id varchar(20) utf8_general_ci YES num_cart_items tinyint(4) unsigned NO 1 mc_gross decimal(7,2) NO 0.00 mc_fee decimal(7,2) NO 0.00 payment_gross decimal(7,2) YES payment_fee decimal(7,2) YES settle_amount decimal(7,2) YES settle_currency char(3) utf8_general_ci YES exchange_rate decimal(4,2) YES notify_version varchar(6) utf8_general_ci NO verify_sign varchar(128) utf8_general_ci NO last_modified datetime NO 0001-01-01 00:00:00 date_added datetime NO 0001-01-01 00:00:00 memo text utf8_general_ci YES
paypal_payment_status Field Type Collation Null Key Default Extra Comment payment_status_id int(11) NO PRI auto_increment payment_status_name varchar(64) utf8_general_ci NO
paypal_payment_status_history Field Type Collation Null Key Default Extra Comment payment_status_history_id int(11) NO PRI auto_increment paypal_ipn_id int(11) NO MUL 0 txn_id varchar(64) utf8_general_ci NO parent_txn_id varchar(64) utf8_general_ci NO payment_status varchar(17) utf8_general_ci NO pending_reason varchar(14) utf8_general_ci YES date_added datetime NO 0001-01-01 00:00:00
paypal_session Field Type Collation Null Key Default Extra Comment unique_id int(11) NO PRI auto_increment session_id text utf8_general_ci NO MUL saved_session mediumblob NO expiry int(17) NO 0
paypal_testing Field Type Collation Null Key Default Extra Comment paypal_ipn_id int(11) unsigned NO PRI auto_increment order_id int(11) unsigned NO MUL 0 custom varchar(255) utf8_general_ci NO txn_type varchar(40) utf8_general_ci NO module_name varchar(40) utf8_general_ci NO module_mode varchar(40) utf8_general_ci NO reason_code varchar(40) utf8_general_ci YES payment_type varchar(40) utf8_general_ci NO payment_status varchar(32) utf8_general_ci NO pending_reason varchar(32) utf8_general_ci YES invoice varchar(128) utf8_general_ci YES mc_currency char(3) utf8_general_ci NO first_name varchar(32) utf8_general_ci NO last_name varchar(32) utf8_general_ci NO payer_business_name varchar(128) utf8_general_ci YES address_name varchar(64) utf8_general_ci YES address_street varchar(254) utf8_general_ci YES address_city varchar(120) utf8_general_ci YES address_state varchar(120) utf8_general_ci YES address_zip varchar(10) utf8_general_ci YES address_country varchar(64) utf8_general_ci YES address_status varchar(11) utf8_general_ci YES payer_email varchar(128) utf8_general_ci NO payer_id varchar(32) utf8_general_ci NO payer_status varchar(10) utf8_general_ci NO payment_date datetime NO 0001-01-01 00:00:00 business varchar(128) utf8_general_ci NO receiver_email varchar(128) utf8_general_ci NO receiver_id varchar(32) utf8_general_ci NO txn_id varchar(20) utf8_general_ci NO PRI parent_txn_id varchar(20) utf8_general_ci YES num_cart_items tinyint(4) unsigned NO 1 mc_gross decimal(7,2) NO 0.00 mc_fee decimal(7,2) NO 0.00 payment_gross decimal(7,2) YES payment_fee decimal(7,2) YES settle_amount decimal(7,2) YES settle_currency char(3) utf8_general_ci YES exchange_rate decimal(4,2) YES notify_version decimal(2,1) NO 0.0 verify_sign varchar(128) utf8_general_ci NO last_modified datetime NO 0001-01-01 00:00:00 date_added datetime NO 0001-01-01 00:00:00 memo text utf8_general_ci YES
Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI 0 artists_id int(11) NO MUL 0 record_company_id int(11) NO MUL 0 music_genre_id int(11) NO MUL 0
product_type_layout Field Type Collation Null Key Default Extra Comment configuration_id int(11) NO PRI auto_increment configuration_title text utf8_general_ci NO configuration_key varchar(255) utf8_general_ci NO UNI configuration_value text utf8_general_ci NO configuration_description text utf8_general_ci NO product_type_id int(11) NO MUL 0 sort_order int(5) YES last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00 use_function text utf8_general_ci YES set_function text utf8_general_ci YES
product_types Field Type Collation Null Key Default Extra Comment type_id int(11) NO PRI auto_increment type_name varchar(255) utf8_general_ci NO type_handler varchar(255) utf8_general_ci NO type_master_type int(11) NO MUL 1 allow_add_to_cart char(1) utf8_general_ci NO Y default_image varchar(255) utf8_general_ci NO date_added datetime NO 0001-01-01 00:00:00 last_modified datetime NO 0001-01-01 00:00:00
product_types_to_category Field Type Collation Null Key Default Extra Comment product_type_id int(11) NO MUL 0 category_id int(11) NO MUL 0
products Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI auto_increment products_type int(11) NO 1 products_quantity float NO 0 products_model varchar(32) utf8_general_ci YES MUL products_image varchar(64) utf8_general_ci YES products_price decimal(15,4) NO 0.0000 products_virtual tinyint(1) NO 0 products_date_added datetime NO MUL 0001-01-01 00:00:00 products_last_modified datetime YES products_date_available datetime YES MUL products_weight float NO 0 products_status tinyint(1) NO MUL 0 products_tax_class_id int(11) NO 0 manufacturers_id int(11) YES MUL products_ordered float NO MUL 0 products_quantity_order_min float NO 1 products_quantity_order_units float NO 1 products_priced_by_attribute tinyint(1) NO 0 product_is_free tinyint(1) NO 0 product_is_call tinyint(1) NO 0 products_quantity_mixed tinyint(1) NO 0 product_is_always_free_shipping tinyint(1) NO 0 products_qty_box_status tinyint(1) NO 1 products_quantity_order_max float NO 0 products_sort_order int(11) NO MUL 0 products_discount_type tinyint(1) NO 0 products_discount_type_from tinyint(1) NO 0 products_price_sorter decimal(15,4) NO MUL 0.0000 master_categories_id int(11) NO MUL 0 products_mixed_discount_quantity tinyint(1) NO 1 metatags_title_status tinyint(1) NO 0 metatags_products_name_status tinyint(1) NO 0 metatags_model_status tinyint(1) NO 0 metatags_price_status tinyint(1) NO 0 metatags_title_tagline_status tinyint(1) NO 0
products_attributes Field Type Collation Null Key Default Extra Comment products_attributes_id int(11) NO PRI auto_increment products_id int(11) NO MUL 0 options_id int(11) NO 0 options_values_id int(11) NO 0 options_values_price decimal(15,4) NO 0.0000 price_prefix char(1) utf8_general_ci NO products_options_sort_order int(11) NO MUL 0 product_attribute_is_free tinyint(1) NO 0 products_attributes_weight float NO 0 products_attributes_weight_prefix char(1) utf8_general_ci NO attributes_display_only tinyint(1) NO 0 attributes_default tinyint(1) NO 0 attributes_discounted tinyint(1) NO 1 attributes_image varchar(64) utf8_general_ci YES attributes_price_base_included tinyint(1) NO 1 attributes_price_onetime decimal(15,4) NO 0.0000 attributes_price_factor decimal(15,4) NO 0.0000 attributes_price_factor_offset decimal(15,4) NO 0.0000 attributes_price_factor_onetime decimal(15,4) NO 0.0000 attributes_price_factor_onetime_offset decimal(15,4) NO 0.0000 attributes_qty_prices text utf8_general_ci YES attributes_qty_prices_onetime text utf8_general_ci YES attributes_price_words decimal(15,4) NO 0.0000 attributes_price_words_free int(4) NO 0 attributes_price_letters decimal(15,4) NO 0.0000 attributes_price_letters_free int(4) NO 0 attributes_required tinyint(1) NO 0
products_attributes_download Field Type Collation Null Key Default Extra Comment products_attributes_id int(11) NO PRI 0 products_attributes_filename varchar(255) utf8_general_ci NO products_attributes_maxdays int(2) YES 0 products_attributes_maxcount int(2) YES 0
products_description Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI auto_increment language_id int(11) NO PRI 1 products_name varchar(64) utf8_general_ci NO MUL products_description text utf8_general_ci YES products_url varchar(255) utf8_general_ci YES products_viewed int(5) YES 0
products_discount_quantity Field Type Collation Null Key Default Extra Comment discount_id int(4) NO 0 products_id int(11) NO MUL 0 discount_qty float NO 0 discount_price decimal(15,4) NO 0.0000
products_notifications Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI 0 customers_id int(11) NO PRI 0 date_added datetime NO 0001-01-01 00:00:00
products_options Field Type Collation Null Key Default Extra Comment products_options_id int(11) NO PRI 0 language_id int(11) NO PRI 1 products_options_name varchar(32) utf8_general_ci NO MUL products_options_sort_order int(11) NO MUL 0 products_options_type int(5) NO 0 products_options_length smallint(2) NO 32 products_options_comment varchar(64) utf8_general_ci YES products_options_size smallint(2) NO 32 products_options_images_per_row int(2) YES 5 products_options_images_style int(1) YES 0 products_options_rows smallint(2) NO 1
products_options_types Field Type Collation Null Key Default Extra Comment products_options_types_id int(11) NO PRI 0 products_options_types_name varchar(32) utf8_general_ci YES
products_options_values Field Type Collation Null Key Default Extra Comment products_options_values_id int(11) NO PRI 0 language_id int(11) NO PRI 1 products_options_values_name varchar(64) utf8_general_ci NO MUL products_options_values_sort_order int(11) NO MUL 0
products_options_values_to_products_options Field Type Collation Null Key Default Extra Comment products_options_values_to_products_options_id int(11) NO PRI auto_increment products_options_id int(11) NO MUL 0 products_options_values_id int(11) NO MUL 0
products_to_categories Field Type Collation Null Key Default Extra Comment products_id int(11) NO PRI 0 categories_id int(11) NO PRI 0
project_version Field Type Collation Null Key Default Extra Comment project_version_id tinyint(3) NO PRI auto_increment project_version_key varchar(40) utf8_general_ci NO UNI project_version_major varchar(20) utf8_general_ci NO project_version_minor varchar(20) utf8_general_ci NO project_version_patch1 varchar(20) utf8_general_ci NO project_version_patch2 varchar(20) utf8_general_ci NO project_version_patch1_source varchar(20) utf8_general_ci NO project_version_patch2_source varchar(20) utf8_general_ci NO project_version_comment varchar(250) utf8_general_ci NO project_version_date_applied datetime NO 0001-01-01 01:01:01
project_version_history Field Type Collation Null Key Default Extra Comment project_version_id tinyint(3) NO PRI auto_increment project_version_key varchar(40) utf8_general_ci NO project_version_major varchar(20) utf8_general_ci NO project_version_minor varchar(20) utf8_general_ci NO project_version_patch varchar(20) utf8_general_ci NO project_version_comment varchar(250) utf8_general_ci NO project_version_date_applied datetime NO 0001-01-01 01:01:01
query_builder Field Type Collation Null Key Default Extra Comment query_id int(11) NO PRI auto_increment query_category varchar(40) utf8_general_ci NO query_name varchar(80) utf8_general_ci NO UNI query_description text utf8_general_ci NO query_string text utf8_general_ci NO query_keys_list text utf8_general_ci NO
record_artists Field Type Collation Null Key Default Extra Comment artists_id int(11) NO PRI auto_increment artists_name varchar(32) utf8_general_ci NO MUL artists_image varchar(64) utf8_general_ci YES date_added datetime YES last_modified datetime YES
record_artists_info Field Type Collation Null Key Default Extra Comment artists_id int(11) NO PRI 0 languages_id int(11) NO PRI 0 artists_url varchar(255) utf8_general_ci NO url_clicked int(5) NO 0 date_last_click datetime YES
record_company Field Type Collation Null Key Default Extra Comment record_company_id int(11) NO PRI auto_increment record_company_name varchar(32) utf8_general_ci NO MUL record_company_image varchar(64) utf8_general_ci YES date_added datetime YES last_modified datetime YES
record_company_info Field Type Collation Null Key Default Extra Comment record_company_id int(11) NO PRI 0 languages_id int(11) NO PRI 0 record_company_url varchar(255) utf8_general_ci NO url_clicked int(5) NO 0 date_last_click datetime YES
reviews Field Type Collation Null Key Default Extra Comment reviews_id int(11) NO PRI auto_increment products_id int(11) NO MUL 0 customers_id int(11) YES MUL customers_name varchar(64) utf8_general_ci NO reviews_rating int(1) YES date_added datetime YES MUL last_modified datetime YES reviews_read int(5) NO 0 status int(1) NO MUL 1
reviews_description Field Type Collation Null Key Default Extra Comment reviews_id int(11) NO PRI 0 languages_id int(11) NO PRI 0 reviews_text text utf8_general_ci NO
salemaker_sales Field Type Collation Null Key Default Extra Comment sale_id int(11) NO PRI auto_increment sale_status tinyint(4) NO MUL 0 sale_name varchar(30) utf8_general_ci NO sale_deduction_value decimal(15,4) NO 0.0000 sale_deduction_type tinyint(4) NO 0 sale_pricerange_from decimal(15,4) NO 0.0000 sale_pricerange_to decimal(15,4) NO 0.0000 sale_specials_condition tinyint(4) NO 0 sale_categories_selected text utf8_general_ci YES sale_categories_all text utf8_general_ci YES sale_date_start date NO MUL 0001-01-01 sale_date_end date NO MUL 0001-01-01 sale_date_added date NO 0001-01-01 sale_date_last_modified date NO 0001-01-01 sale_date_status_change date NO 0001-01-01
sessions Field Type Collation Null Key Default Extra Comment sesskey varchar(64) utf8_general_ci NO PRI expiry int(11) unsigned NO 0 value mediumblob NO
specials Field Type Collation Null Key Default Extra Comment specials_id int(11) NO PRI auto_increment products_id int(11) NO MUL 0 specials_new_products_price decimal(15,4) NO 0.0000 specials_date_added datetime YES specials_last_modified datetime YES expires_date date NO MUL 0001-01-01 date_status_change datetime YES status int(1) NO MUL 1 specials_date_available date NO MUL 0001-01-01
tax_class Field Type Collation Null Key Default Extra Comment tax_class_id int(11) NO PRI auto_increment tax_class_title varchar(32) utf8_general_ci NO tax_class_description varchar(255) utf8_general_ci NO last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00
tax_rates Field Type Collation Null Key Default Extra Comment tax_rates_id int(11) NO PRI auto_increment tax_zone_id int(11) NO MUL 0 tax_class_id int(11) NO MUL 0 tax_priority int(5) YES 1 tax_rate decimal(7,4) NO 0.0000 tax_description varchar(255) utf8_general_ci NO last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00
template_select Field Type Collation Null Key Default Extra Comment template_id int(11) NO PRI auto_increment template_dir varchar(64) utf8_general_ci NO template_language varchar(64) utf8_general_ci NO MUL 0
upgrade_exceptions Field Type Collation Null Key Default Extra Comment upgrade_exception_id smallint(5) NO PRI auto_increment sql_file varchar(50) utf8_general_ci YES reason varchar(200) utf8_general_ci YES errordate datetime YES 0001-01-01 00:00:00 sqlstatement text utf8_general_ci YES
whos_online Field Type Collation Null Key Default Extra Comment customer_id int(11) YES MUL full_name varchar(64) utf8_general_ci NO session_id varchar(128) utf8_general_ci NO MUL ip_address varchar(45) utf8_general_ci NO MUL time_entry varchar(14) utf8_general_ci NO MUL time_last_click varchar(14) utf8_general_ci NO MUL last_page_url varchar(255) utf8_general_ci NO MUL host_address text utf8_general_ci NO user_agent varchar(255) utf8_general_ci NO
zones Field Type Collation Null Key Default Extra Comment zone_id int(11) NO PRI auto_increment zone_country_id int(11) NO MUL 0 zone_code varchar(32) utf8_general_ci NO MUL zone_name varchar(32) utf8_general_ci NO
zones_to_geo_zones Field Type Collation Null Key Default Extra Comment association_id int(11) NO PRI auto_increment zone_country_id int(11) NO 0 zone_id int(11) YES geo_zone_id int(11) YES MUL last_modified datetime YES date_added datetime NO 0001-01-01 00:00:00
Last modified September 13, 2020 by Scott C Wilson
(354bf510) .
Translate.png){kind=logo}
