Zen Cart 1.5.6 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) | utf8mb4_general_ci | NO | | | | |
entry_company | varchar(64) | utf8mb4_general_ci | YES | | | | |
entry_firstname | varchar(32) | utf8mb4_general_ci | NO | | | | |
entry_lastname | varchar(32) | utf8mb4_general_ci | NO | | | | |
entry_street_address | varchar(64) | utf8mb4_general_ci | NO | | | | |
entry_suburb | varchar(32) | utf8mb4_general_ci | YES | | | | |
entry_postcode | varchar(10) | utf8mb4_general_ci | NO | | | | |
entry_city | varchar(32) | utf8mb4_general_ci | NO | | | | |
entry_state | varchar(32) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
address_summary | varchar(48) | utf8mb4_general_ci | NO | | | | |
admin
Field | Type | Collation | Null | Key | Default | Extra | Comment |
admin_id | int(11) | | NO | PRI | | auto_increment | |
admin_name | varchar(32) | utf8mb4_general_ci | NO | MUL | | | |
admin_email | varchar(96) | utf8mb4_general_ci | NO | MUL | | | |
admin_profile | int(11) | | NO | MUL | 0 | | |
admin_pass | varchar(255) | utf8mb4_general_ci | NO | | | | |
prev_pass1 | varchar(255) | utf8mb4_general_ci | NO | | | | |
prev_pass2 | varchar(255) | utf8mb4_general_ci | NO | | | | |
prev_pass3 | varchar(255) | utf8mb4_general_ci | NO | | | | |
pwd_last_change_date | datetime | | NO | | 0001-01-01 00:00:00 | | |
reset_token | varchar(255) | utf8mb4_general_ci | NO | | | | |
last_modified | datetime | | NO | | 0001-01-01 00:00:00 | | |
last_login_date | datetime | | NO | | 0001-01-01 00:00:00 | | |
last_login_ip | varchar(45) | utf8mb4_general_ci | NO | | | | |
failed_logins | smallint(4) unsigned | | NO | | 0 | | |
lockout_expires | int(11) | | NO | | 0 | | |
last_failed_attempt | datetime | | NO | | 0001-01-01 00:00:00 | | |
last_failed_ip | varchar(45) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
page_parameters | text | utf8mb4_general_ci | YES | | | | |
ip_address | varchar(45) | utf8mb4_general_ci | NO | MUL | | | |
flagged | tinyint(4) | | NO | MUL | 0 | | |
attention | varchar(255) | utf8mb4_general_ci | NO | | | | |
gzpost | mediumblob | | YES | | | | |
logmessage | mediumtext | utf8mb4_general_ci | NO | | | | |
severity | varchar(9) | utf8mb4_general_ci | NO | | info | | |
Field | Type | Collation | Null | Key | Default | Extra | Comment |
menu_key | varchar(191) | utf8mb4_general_ci | NO | PRI | | | |
language_key | varchar(255) | utf8mb4_general_ci | NO | | | | |
sort_order | int(11) | | NO | | 0 | | |
admin_notifications
Field | Type | Collation | Null | Key | Default | Extra | Comment |
notification_key | varchar(40) | utf8mb4_general_ci | NO | PRI | | | |
admin_id | int(11) | | YES | | | | |
dismissed | char(1) | utf8mb4_general_ci | YES | | | | |
admin_pages
Field | Type | Collation | Null | Key | Default | Extra | Comment |
page_key | varchar(191) | utf8mb4_general_ci | NO | PRI | | | |
language_key | varchar(255) | utf8mb4_general_ci | NO | | | | |
main_page | varchar(255) | utf8mb4_general_ci | NO | | | | |
page_params | varchar(255) | utf8mb4_general_ci | NO | | | | |
menu_key | varchar(191) | utf8mb4_general_ci | NO | | | | |
display_on_menu | char(1) | utf8mb4_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(191) | utf8mb4_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(255) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
authorization_type | varchar(50) | utf8mb4_general_ci | NO | | | | |
transaction_id | varchar(32) | utf8mb4_general_ci | YES | | | | |
sent | longtext | utf8mb4_general_ci | NO | | | | |
received | longtext | utf8mb4_general_ci | NO | | | | |
time | varchar(50) | utf8mb4_general_ci | NO | | | | |
session_id | varchar(255) | utf8mb4_general_ci | NO | | | | |
banners
Field | Type | Collation | Null | Key | Default | Extra | Comment |
banners_id | int(11) | | NO | PRI | | auto_increment | |
banners_title | varchar(64) | utf8mb4_general_ci | NO | | | | |
banners_url | varchar(255) | utf8mb4_general_ci | NO | | | | |
banners_image | varchar(255) | utf8mb4_general_ci | NO | | | | |
banners_group | varchar(15) | utf8mb4_general_ci | NO | | | | |
banners_html_text | text | utf8mb4_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(255) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
categories_description | text | utf8mb4_general_ci | NO | | | | |
configuration
Field | Type | Collation | Null | Key | Default | Extra | Comment |
configuration_id | int(11) | | NO | PRI | | auto_increment | |
configuration_title | text | utf8mb4_general_ci | NO | | | | |
configuration_key | varchar(180) | utf8mb4_general_ci | NO | UNI | | | |
configuration_value | text | utf8mb4_general_ci | NO | | | | |
configuration_description | text | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
set_function | text | utf8mb4_general_ci | YES | | | | |
val_function | text | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
configuration_group_description | varchar(255) | utf8mb4_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) | utf8mb4_general_ci | YES | | | | |
counter | int(12) | | YES | | | | |
counter_history
Field | Type | Collation | Null | Key | Default | Extra | Comment |
startdate | char(8) | utf8mb4_general_ci | NO | 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) | utf8mb4_general_ci | NO | MUL | | | |
countries_iso_code_2 | char(2) | utf8mb4_general_ci | NO | MUL | | | |
countries_iso_code_3 | char(3) | utf8mb4_general_ci | NO | MUL | | | |
address_format_id | int(11) | | NO | MUL | 0 | | |
status | tinyint(1) | | YES | | 1 | | |
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) | utf8mb4_general_ci | YES | | | | |
sent_lastname | varchar(32) | utf8mb4_general_ci | YES | | | | |
emailed_to | varchar(32) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
release_flag | char(1) | utf8mb4_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) | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | F | | |
coupon_code | varchar(32) | utf8mb4_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) | utf8mb4_general_ci | YES | | | | |
restrict_to_categories | varchar(255) | utf8mb4_general_ci | YES | | | | |
restrict_to_customers | text | utf8mb4_general_ci | YES | | | | |
coupon_active | char(1) | utf8mb4_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 | | |
coupon_calc_base | tinyint(1) | | NO | | 0 | | |
coupon_order_limit | int(4) | | NO | | 0 | | |
coupon_is_valid_for_sales | tinyint(1) | | NO | | 1 | | |
coupon_product_count | tinyint(1) | | 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(64) | utf8mb4_general_ci | NO | | | | |
coupon_description | text | utf8mb4_general_ci | YES | | | | |
currencies
Field | Type | Collation | Null | Key | Default | Extra | Comment |
currencies_id | int(11) | | NO | PRI | | auto_increment | |
title | varchar(32) | utf8mb4_general_ci | NO | | | | |
code | char(3) | utf8mb4_general_ci | NO | | | | |
symbol_left | varchar(32) | utf8mb4_general_ci | YES | | | | |
symbol_right | varchar(32) | utf8mb4_general_ci | YES | | | | |
decimal_point | char(1) | utf8mb4_general_ci | YES | | | | |
thousands_point | char(1) | utf8mb4_general_ci | YES | | | | |
decimal_places | char(1) | utf8mb4_general_ci | YES | | | | |
value | decimal(14,6) | | 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) | utf8mb4_general_ci | NO | | | | |
customers_firstname | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_lastname | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_dob | datetime | | NO | | 0001-01-01 00:00:00 | | |
customers_email_address | varchar(96) | utf8mb4_general_ci | NO | MUL | | | |
customers_nick | varchar(96) | utf8mb4_general_ci | NO | MUL | | | |
customers_default_address_id | int(11) | | NO | | 0 | | |
customers_telephone | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_fax | varchar(32) | utf8mb4_general_ci | YES | | | | |
customers_password | varchar(255) | utf8mb4_general_ci | NO | | | | |
customers_newsletter | char(1) | utf8mb4_general_ci | YES | MUL | | | |
customers_group_pricing | int(11) | | NO | MUL | 0 | | |
customers_email_format | varchar(4) | utf8mb4_general_ci | NO | | TEXT | | |
customers_authorization | int(1) | | NO | | 0 | | |
customers_referral | varchar(32) | utf8mb4_general_ci | NO | MUL | | | |
customers_paypal_payerid | varchar(20) | utf8mb4_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 | utf8mb4_general_ci | NO | | | | |
customers_basket_quantity | float | | NO | | 0 | | |
customers_basket_date_added | varchar(8) | utf8mb4_general_ci | YES | | | | |
customers_basket_attributes
Field | Type | Collation | Null | Key | Default | Extra | Comment |
customers_basket_attributes_id | int(11) | | NO | PRI | | auto_increment | |
customers_id | int(11) | | NO | MUL | 0 | | |
products_id | tinytext | utf8mb4_general_ci | NO | | | | |
products_options_id | varchar(64) | utf8mb4_general_ci | NO | | 0 | | |
products_options_value_id | int(11) | | NO | | 0 | | |
products_options_value_text | blob | | YES | | | | |
products_options_sort_order | text | utf8mb4_general_ci | NO | | | | |
customers_info
Field | Type | Collation | Null | Key | Default | Extra | Comment |
customers_info_id | int(11) | | NO | PRI | 0 | | |
customers_info_date_of_last_logon | datetime | | YES | | | | |
customers_info_number_of_logons | int(5) | | YES | | | | |
customers_info_date_account_created | datetime | | YES | | | | |
customers_info_date_account_last_modified | datetime | | YES | | | | |
global_product_notifications | int(1) | | YES | | 0 | | |
db_cache
Field | Type | Collation | Null | Key | Default | Extra | Comment |
cache_entry_name | varchar(64) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
email_to_address | varchar(96) | utf8mb4_general_ci | NO | MUL | | | |
email_from_name | varchar(96) | utf8mb4_general_ci | NO | | | | |
email_from_address | varchar(96) | utf8mb4_general_ci | NO | | | | |
email_subject | varchar(255) | utf8mb4_general_ci | NO | | | | |
email_html | text | utf8mb4_general_ci | NO | | | | |
email_text | text | utf8mb4_general_ci | NO | | | | |
date_sent | datetime | | NO | | 0001-01-01 00:00:00 | | |
module | varchar(64) | utf8mb4_general_ci | NO | MUL | | | |
ezpages
Field | Type | Collation | Null | Key | Default | Extra | Comment |
pages_id | int(11) | | NO | PRI | | auto_increment | |
alt_url | varchar(255) | utf8mb4_general_ci | NO | | | | |
alt_url_external | varchar(255) | utf8mb4_general_ci | NO | | | | |
status_header | int(1) | | NO | MUL | 1 | | |
status_sidebox | int(1) | | NO | MUL | 1 | | |
status_footer | int(1) | | NO | MUL | 1 | | |
status_visible | int(1) | | NO | | 0 | | |
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 | | |
ezpages_content
Field | Type | Collation | Null | Key | Default | Extra | Comment |
pages_id | int(11) | | NO | PRI | 0 | | |
languages_id | int(11) | | NO | PRI | 1 | | |
pages_title | varchar(64) | utf8mb4_general_ci | NO | | | | |
pages_html_text | text | utf8mb4_general_ci | YES | | | | |
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) | utf8mb4_general_ci | YES | | | | |
customers_id | int(11) | | YES | MUL | | | |
files_uploaded_name | varchar(64) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
geo_zone_description | varchar(255) | utf8mb4_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(191) | utf8mb4_general_ci | NO | PRI | | | |
get_term_table | varchar(64) | utf8mb4_general_ci | NO | | | | |
get_term_name_field | varchar(64) | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
code | char(2) | utf8mb4_general_ci | NO | | | | |
image | varchar(64) | utf8mb4_general_ci | YES | | | | |
directory | varchar(32) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
layout_box_name | varchar(64) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
manufacturers_image | varchar(255) | utf8mb4_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) | utf8mb4_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 | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
type_ext | varchar(8) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
metatags_keywords | text | utf8mb4_general_ci | YES | | | | |
metatags_description | text | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
metatags_keywords | text | utf8mb4_general_ci | YES | | | | |
metatags_description | text | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
content | text | utf8mb4_general_ci | NO | | | | |
content_html | text | utf8mb4_general_ci | NO | | | | |
module | varchar(255) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
customers_company | varchar(64) | utf8mb4_general_ci | YES | | | | |
customers_street_address | varchar(64) | utf8mb4_general_ci | NO | | | | |
customers_suburb | varchar(32) | utf8mb4_general_ci | YES | | | | |
customers_city | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_postcode | varchar(10) | utf8mb4_general_ci | NO | | | | |
customers_state | varchar(32) | utf8mb4_general_ci | YES | | | | |
customers_country | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_telephone | varchar(32) | utf8mb4_general_ci | NO | | | | |
customers_email_address | varchar(96) | utf8mb4_general_ci | NO | | | | |
customers_address_format_id | int(5) | | NO | | 0 | | |
delivery_name | varchar(64) | utf8mb4_general_ci | NO | | | | |
delivery_company | varchar(64) | utf8mb4_general_ci | YES | | | | |
delivery_street_address | varchar(64) | utf8mb4_general_ci | NO | | | | |
delivery_suburb | varchar(32) | utf8mb4_general_ci | YES | | | | |
delivery_city | varchar(32) | utf8mb4_general_ci | NO | | | | |
delivery_postcode | varchar(10) | utf8mb4_general_ci | NO | | | | |
delivery_state | varchar(32) | utf8mb4_general_ci | YES | | | | |
delivery_country | varchar(32) | utf8mb4_general_ci | NO | | | | |
delivery_address_format_id | int(5) | | NO | | 0 | | |
billing_name | varchar(64) | utf8mb4_general_ci | NO | | | | |
billing_company | varchar(64) | utf8mb4_general_ci | YES | | | | |
billing_street_address | varchar(64) | utf8mb4_general_ci | NO | | | | |
billing_suburb | varchar(32) | utf8mb4_general_ci | YES | | | | |
billing_city | varchar(32) | utf8mb4_general_ci | NO | | | | |
billing_postcode | varchar(10) | utf8mb4_general_ci | NO | | | | |
billing_state | varchar(32) | utf8mb4_general_ci | YES | | | | |
billing_country | varchar(32) | utf8mb4_general_ci | NO | | | | |
billing_address_format_id | int(5) | | NO | | 0 | | |
payment_method | varchar(128) | utf8mb4_general_ci | NO | | | | |
payment_module_code | varchar(32) | utf8mb4_general_ci | NO | | | | |
shipping_method | varchar(255) | utf8mb4_general_ci | YES | | | | |
shipping_module_code | varchar(32) | utf8mb4_general_ci | NO | | | | |
coupon_code | varchar(32) | utf8mb4_general_ci | NO | | | | |
cc_type | varchar(20) | utf8mb4_general_ci | YES | | | | |
cc_owner | varchar(64) | utf8mb4_general_ci | YES | | | | |
cc_number | varchar(32) | utf8mb4_general_ci | YES | | | | |
cc_expires | varchar(4) | utf8mb4_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) | utf8mb4_general_ci | YES | | | | |
currency_value | decimal(14,6) | | YES | | | | |
order_total | decimal(15,4) | | YES | | | | |
order_tax | decimal(15,4) | | YES | | | | |
paypal_ipn_id | int(11) | | NO | | 0 | | |
ip_address | varchar(96) | utf8mb4_general_ci | NO | | | | |
order_weight | float | | YES | | | | |
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) | utf8mb4_general_ci | YES | | | | |
products_name | varchar(64) | utf8mb4_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 | utf8mb4_general_ci | NO | | | | |
products_weight | float | | YES | | | | |
products_virtual | tinyint(1) | | YES | | | | |
product_is_always_free_shipping | tinyint(1) | | YES | | | | |
products_quantity_order_min | float | | YES | | | | |
products_quantity_order_units | float | | YES | | | | |
products_quantity_order_max | float | | YES | | | | |
products_quantity_mixed | tinyint(1) | | YES | | | | |
products_mixed_discount_quantity | tinyint(1) | | YES | | | | |
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) | utf8mb4_general_ci | NO | | | | |
products_options_values | text | utf8mb4_general_ci | NO | | | | |
options_values_price | decimal(15,4) | | NO | | 0.0000 | | |
price_prefix | char(1) | utf8mb4_general_ci | NO | | | | |
product_attribute_is_free | tinyint(1) | | NO | | 0 | | |
products_attributes_weight | float | | NO | | 0 | | |
products_attributes_weight_prefix | char(1) | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
attributes_qty_prices_onetime | text | utf8mb4_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 | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
download_maxdays | int(2) | | NO | | 0 | | |
download_count | int(2) | | NO | | 0 | | |
products_prid | tinytext | utf8mb4_general_ci | NO | | | | |
products_attributes_id | int(11) | | YES | | | | |
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) | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
updated_by | varchar(45) | utf8mb4_general_ci | NO | | | | |
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) | utf8mb4_general_ci | NO | | | | |
text | varchar(255) | utf8mb4_general_ci | NO | | | | |
value | decimal(15,4) | | NO | | 0.0000 | | |
class | varchar(32) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
module_name | varchar(40) | utf8mb4_general_ci | NO | | | | |
module_mode | varchar(40) | utf8mb4_general_ci | NO | | | | |
reason_code | varchar(40) | utf8mb4_general_ci | YES | | | | |
payment_type | varchar(40) | utf8mb4_general_ci | NO | | | | |
payment_status | varchar(32) | utf8mb4_general_ci | NO | | | | |
pending_reason | varchar(32) | utf8mb4_general_ci | YES | | | | |
invoice | varchar(128) | utf8mb4_general_ci | YES | | | | |
mc_currency | char(3) | utf8mb4_general_ci | NO | | | | |
first_name | varchar(32) | utf8mb4_general_ci | NO | | | | |
last_name | varchar(32) | utf8mb4_general_ci | NO | | | | |
payer_business_name | varchar(128) | utf8mb4_general_ci | YES | | | | |
address_name | varchar(64) | utf8mb4_general_ci | YES | | | | |
address_street | varchar(254) | utf8mb4_general_ci | YES | | | | |
address_city | varchar(120) | utf8mb4_general_ci | YES | | | | |
address_state | varchar(120) | utf8mb4_general_ci | YES | | | | |
address_zip | varchar(10) | utf8mb4_general_ci | YES | | | | |
address_country | varchar(64) | utf8mb4_general_ci | YES | | | | |
address_status | varchar(11) | utf8mb4_general_ci | YES | | | | |
payer_email | varchar(128) | utf8mb4_general_ci | NO | | | | |
payer_id | varchar(32) | utf8mb4_general_ci | NO | | | | |
payer_status | varchar(10) | utf8mb4_general_ci | NO | | | | |
payment_date | datetime | | NO | | 0001-01-01 00:00:00 | | |
business | varchar(128) | utf8mb4_general_ci | NO | | | | |
receiver_email | varchar(128) | utf8mb4_general_ci | NO | | | | |
receiver_id | varchar(32) | utf8mb4_general_ci | NO | | | | |
txn_id | varchar(20) | utf8mb4_general_ci | NO | PRI | | | |
parent_txn_id | varchar(20) | utf8mb4_general_ci | YES | | | | |
num_cart_items | tinyint(4) unsigned | | NO | | 1 | | |
mc_gross | decimal(15,4) | | NO | | 0.0000 | | |
mc_fee | decimal(15,4) | | NO | | 0.0000 | | |
payment_gross | decimal(15,4) | | YES | | | | |
payment_fee | decimal(15,4) | | YES | | | | |
settle_amount | decimal(15,4) | | YES | | | | |
settle_currency | char(3) | utf8mb4_general_ci | YES | | | | |
exchange_rate | decimal(15,4) | | YES | | | | |
notify_version | varchar(6) | utf8mb4_general_ci | NO | | | | |
verify_sign | varchar(128) | utf8mb4_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 | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
parent_txn_id | varchar(64) | utf8mb4_general_ci | NO | | | | |
payment_status | varchar(17) | utf8mb4_general_ci | NO | | | | |
pending_reason | varchar(32) | utf8mb4_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 | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
txn_type | varchar(40) | utf8mb4_general_ci | NO | | | | |
module_name | varchar(40) | utf8mb4_general_ci | NO | | | | |
module_mode | varchar(40) | utf8mb4_general_ci | NO | | | | |
reason_code | varchar(40) | utf8mb4_general_ci | YES | | | | |
payment_type | varchar(40) | utf8mb4_general_ci | NO | | | | |
payment_status | varchar(32) | utf8mb4_general_ci | NO | | | | |
pending_reason | varchar(32) | utf8mb4_general_ci | YES | | | | |
invoice | varchar(128) | utf8mb4_general_ci | YES | | | | |
mc_currency | char(3) | utf8mb4_general_ci | NO | | | | |
first_name | varchar(32) | utf8mb4_general_ci | NO | | | | |
last_name | varchar(32) | utf8mb4_general_ci | NO | | | | |
payer_business_name | varchar(128) | utf8mb4_general_ci | YES | | | | |
address_name | varchar(64) | utf8mb4_general_ci | YES | | | | |
address_street | varchar(254) | utf8mb4_general_ci | YES | | | | |
address_city | varchar(120) | utf8mb4_general_ci | YES | | | | |
address_state | varchar(120) | utf8mb4_general_ci | YES | | | | |
address_zip | varchar(10) | utf8mb4_general_ci | YES | | | | |
address_country | varchar(64) | utf8mb4_general_ci | YES | | | | |
address_status | varchar(11) | utf8mb4_general_ci | YES | | | | |
payer_email | varchar(128) | utf8mb4_general_ci | NO | | | | |
payer_id | varchar(32) | utf8mb4_general_ci | NO | | | | |
payer_status | varchar(10) | utf8mb4_general_ci | NO | | | | |
payment_date | datetime | | NO | | 0001-01-01 00:00:00 | | |
business | varchar(128) | utf8mb4_general_ci | NO | | | | |
receiver_email | varchar(128) | utf8mb4_general_ci | NO | | | | |
receiver_id | varchar(32) | utf8mb4_general_ci | NO | | | | |
txn_id | varchar(20) | utf8mb4_general_ci | NO | PRI | | | |
parent_txn_id | varchar(20) | utf8mb4_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) | utf8mb4_general_ci | YES | | | | |
exchange_rate | decimal(4,2) | | YES | | | | |
notify_version | decimal(2,1) | | NO | | 0.0 | | |
verify_sign | varchar(128) | utf8mb4_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 | utf8mb4_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 | utf8mb4_general_ci | NO | | | | |
configuration_key | varchar(180) | utf8mb4_general_ci | NO | UNI | | | |
configuration_value | text | utf8mb4_general_ci | NO | | | | |
configuration_description | text | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
set_function | text | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
type_handler | varchar(255) | utf8mb4_general_ci | NO | | | | |
type_master_type | int(11) | | NO | MUL | 1 | | |
allow_add_to_cart | char(1) | utf8mb4_general_ci | NO | | Y | | |
default_image | varchar(255) | utf8mb4_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) | utf8mb4_general_ci | YES | MUL | | | |
products_image | varchar(255) | utf8mb4_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) | utf8mb4_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) | utf8mb4_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(255) | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
attributes_qty_prices_onetime | text | utf8mb4_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) | utf8mb4_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 | | | |
language_id | int(11) | | NO | PRI | 1 | | |
products_name | varchar(64) | utf8mb4_general_ci | NO | MUL | | | |
products_description | text | utf8mb4_general_ci | YES | | | | |
products_url | varchar(255) | utf8mb4_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) | utf8mb4_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(255) | utf8mb4_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) | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | UNI | | | |
project_version_major | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_minor | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_patch1 | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_patch2 | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_patch1_source | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_patch2_source | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_comment | varchar(250) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
project_version_major | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_minor | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_patch | varchar(20) | utf8mb4_general_ci | NO | | | | |
project_version_comment | varchar(250) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
query_name | varchar(80) | utf8mb4_general_ci | NO | UNI | | | |
query_description | text | utf8mb4_general_ci | NO | | | | |
query_string | text | utf8mb4_general_ci | NO | | | | |
query_keys_list | text | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
artists_image | varchar(255) | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
record_company_image | varchar(255) | utf8mb4_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) | utf8mb4_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) | utf8mb4_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 | utf8mb4_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(128) | utf8mb4_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 | utf8mb4_general_ci | YES | | | | |
sale_categories_all | text | utf8mb4_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(191) | utf8mb4_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 | | |
square_payments
Field | Type | Collation | Null | Key | Default | Extra | Comment |
id | int(11) unsigned | | NO | PRI | | auto_increment | |
order_id | int(11) unsigned | | NO | | | | |
location_id | varchar(40) | utf8_general_ci | NO | | | | |
transaction_id | varchar(255) | utf8_general_ci | NO | | | | |
tender_id | varchar(64) | utf8_general_ci | YES | | | | |
action | varchar(40) | utf8_general_ci | YES | | | | |
created_at | timestamp | | NO | | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP | |
tax_class
Field | Type | Collation | Null | Key | Default | Extra | Comment |
tax_class_id | int(11) | | NO | PRI | | auto_increment | |
tax_class_title | varchar(32) | utf8mb4_general_ci | NO | | | | |
tax_class_description | varchar(255) | utf8mb4_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) | utf8mb4_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) | utf8mb4_general_ci | NO | | | | |
template_language | varchar(64) | utf8mb4_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(128) | utf8mb4_general_ci | YES | | | | |
reason | text | utf8mb4_general_ci | YES | | | | |
errordate | datetime | | YES | | | | |
sqlstatement | text | utf8mb4_general_ci | YES | | | | |
whos_online
Field | Type | Collation | Null | Key | Default | Extra | Comment |
customer_id | int(11) | | YES | MUL | | | |
full_name | varchar(64) | utf8mb4_general_ci | NO | | | | |
session_id | varchar(191) | utf8mb4_general_ci | NO | MUL | | | |
ip_address | varchar(45) | utf8mb4_general_ci | NO | MUL | | | |
time_entry | varchar(14) | utf8mb4_general_ci | NO | MUL | | | |
time_last_click | varchar(14) | utf8mb4_general_ci | NO | MUL | | | |
last_page_url | varchar(255) | utf8mb4_general_ci | NO | MUL | | | |
host_address | text | utf8mb4_general_ci | NO | | | | |
user_agent | varchar(255) | utf8mb4_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) | utf8mb4_general_ci | NO | MUL | | | |
zone_name | varchar(32) | utf8mb4_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
(354bf51).