Database Model plugin_tmp.xml

new_address_book
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_id INTEGER(11) PK NN        
address_book_id INTEGER(11) PK NN   1    
entry_gender VARCHAR(1)   NN        
entry_company VARCHAR(32)   NN        
entry_owner VARCHAR(32)   NN        
entry_firstname VARCHAR(32)   NN        
entry_lastname VARCHAR(32)   NN        
entry_street_address VARCHAR(64)   NN        
entry_suburb VARCHAR(32)   NN        
entry_postcode VARCHAR(10)   NN        
entry_city VARCHAR(32)   NN        
entry_state VARCHAR(32)   NN        
entry_country_id INTEGER(11)   NN        
entry_zone_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_id
address_book_id


new_address_format
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
address_format_id INTEGER(11) PK NN        
address_format VARCHAR(128)   NN        
address_summary VARCHAR(48)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY address_format_id


new_admin
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
admin_id INTEGER(11) PK NN        
admin_groups_id INTEGER(11)   NN        
admin_gender VARCHAR(1)   NN        
admin_firstname VARCHAR(32)   NN        
admin_lastname VARCHAR(32)   NN        
admin_email_address VARCHAR(96)   NN        
admin_telephone VARCHAR(32)   NN        
admin_fax VARCHAR(32)   NN        
admin_password VARCHAR(40)   NN        
admin_created DATETIME   NN        
admin_modified DATETIME   NN        
admin_logdate DATETIME   NN        
admin_lognum INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY admin_id
idx_admin_id Index admin_id
idx_admin_firstname Index admin_firstname
idx_admin_lastname Index admin_lastname
idx_admin_email_address Index admin_email_address
idx_admin_password Index admin_password


new_admin_files
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
admin_files_id INTEGER(11) PK NN        
admin_files_name VARCHAR(64)   NN        
admin_files_is_boxes TINYINT(4)   NN        
admin_files_to_boxes INTEGER(11)   NN        
admin_groups_id TINYINT(4)   NN   1    
IndexName IndexType Columns
PRIMARY PRIMARY admin_files_id


new_admin_groups
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
admin_groups_id INTEGER(11) PK NN        
admin_groups_name VARCHAR(64)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY admin_groups_id


new_affiliate_affiliate
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_id INTEGER(11) PK NN        
affiliate_gender VARCHAR(1)   NN        
affiliate_firstname VARCHAR(32)   NN        
affiliate_lastname VARCHAR(32)   NN        
affiliate_dob DATETIME   NN        
affiliate_email_address VARCHAR(96)   NN        
affiliate_telephone VARCHAR(32)   NN        
affiliate_fax VARCHAR(32)   NN        
affiliate_password VARCHAR(40)   NN        
affiliate_homepage VARCHAR(96)   NN        
affiliate_street_address VARCHAR(64)   NN        
affiliate_suburb VARCHAR(64)   NN        
affiliate_city VARCHAR(32)   NN        
affiliate_postcode VARCHAR(10)   NN        
affiliate_state VARCHAR(32)   NN        
affiliate_country_id INTEGER(11)   NN        
affiliate_zone_id INTEGER(11)   NN        
affiliate_agb TINYINT(4)   NN        
affiliate_company VARCHAR(60)   NN        
affiliate_company_taxid VARCHAR(64)   NN        
affiliate_commission_percent DECIMAL(4,2)   NN   0.00    
affiliate_payment_check VARCHAR(100)   NN        
affiliate_payment_paypal VARCHAR(64)   NN        
affiliate_payment_bank_name VARCHAR(64)   NN        
affiliate_payment_bank_branch_number VARCHAR(64)   NN        
affiliate_payment_bank_swift_code VARCHAR(64)   NN        
affiliate_payment_bank_account_name VARCHAR(64)   NN        
affiliate_payment_bank_account_number VARCHAR(64)   NN        
affiliate_date_of_last_logon DATETIME   NN        
affiliate_number_of_logons INTEGER(11)   NN        
affiliate_date_account_created DATETIME   NN        
affiliate_date_account_last_modified DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_id


new_affiliate_banners
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_banners_id INTEGER(11) PK NN        
affiliate_banners_title VARCHAR(64)   NN        
affiliate_products_id INTEGER(11)   NN        
affiliate_banners_image VARCHAR(64)   NN        
affiliate_banners_group VARCHAR(10)   NN        
affiliate_banners_html_text TEXT   NN        
affiliate_expires_impressions SMALLINT(6)   NN        
affiliate_expires_date DATETIME   NN        
affiliate_date_scheduled DATETIME   NN        
affiliate_date_added DATETIME   NN        
affiliate_date_status_change DATETIME   NN        
affiliate_status TINYINT(4)   NN   1    
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_banners_id


new_affiliate_banners_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_banners_history_id INTEGER(11) PK NN        
affiliate_banners_products_id INTEGER(11) PK NN        
affiliate_banners_id INTEGER(11)   NN        
affiliate_banners_affiliate_id INTEGER(11)   NN        
affiliate_banners_shown INTEGER(11)   NN        
affiliate_banners_clicks TINYINT(4)   NN        
affiliate_banners_history_date DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_banners_history_id
affiliate_banners_products_id


new_affiliate_clickthroughs
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_clickthrough_id INTEGER(11) PK NN        
affiliate_id INTEGER(11)   NN        
affiliate_clientdate DATETIME   NN        
affiliate_clientbrowser VARCHAR(200)   NN   Could Not Find This Data    
affiliate_clientip VARCHAR(50)   NN   Could Not Find This Data    
affiliate_clientreferer VARCHAR(200)   NN   none detected (maybe a direct link)    
affiliate_products_id INTEGER(11)   NN        
affiliate_banner_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_clickthrough_id
idx_affiliate_id Index affiliate_id


new_affiliate_payment
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_payment_id INTEGER(11) PK NN        
affiliate_id INTEGER(11)   NN        
affiliate_payment DECIMAL(15,2)   NN   0.00    
affiliate_payment_tax DECIMAL(15,2)   NN   0.00    
affiliate_payment_total DECIMAL(15,2)   NN   0.00    
affiliate_payment_date DATETIME   NN        
affiliate_payment_last_modified DATETIME   NN        
affiliate_payment_status SMALLINT(6)   NN        
affiliate_firstname VARCHAR(32)   NN        
affiliate_lastname VARCHAR(32)   NN        
affiliate_street_address VARCHAR(64)   NN        
affiliate_suburb VARCHAR(64)   NN        
affiliate_city VARCHAR(32)   NN        
affiliate_postcode VARCHAR(10)   NN        
affiliate_country VARCHAR(32)   NN        
affiliate_company VARCHAR(60)   NN        
affiliate_state VARCHAR(32)   NN        
affiliate_address_format_id SMALLINT(6)   NN        
affiliate_last_modified DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_payment_id


new_affiliate_payment_status
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_payment_status_id INTEGER(11) PK NN        
affiliate_languages_id INTEGER(11) PK NN   1    
affiliate_payment_status_name VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_payment_status_id
affiliate_languages_id
idx_affiliate_payment_status_name Index affiliate_payment_status_name


new_affiliate_payment_status_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_status_history_id INTEGER(11) PK NN        
affiliate_payment_id INTEGER(11)   NN        
affiliate_new_value SMALLINT(6)   NN        
affiliate_old_value SMALLINT(6)   NN        
affiliate_date_added DATETIME   NN        
affiliate_notified TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_status_history_id


new_affiliate_sales
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
affiliate_orders_id INTEGER(11) PK NN        
affiliate_id INTEGER(11)   NN        
affiliate_date DATETIME   NN        
affiliate_browser VARCHAR(100)   NN        
affiliate_ipaddress VARCHAR(20)   NN        
affiliate_value DECIMAL(15,2)   NN   0.00    
affiliate_payment DECIMAL(15,2)   NN   0.00    
affiliate_clickthroughs_id INTEGER(11)   NN        
affiliate_billing_status SMALLINT(6)   NN        
affiliate_payment_date DATETIME   NN        
affiliate_payment_id INTEGER(11)   NN        
affiliate_percent DECIMAL(4,2)   NN   0.00    
IndexName IndexType Columns
PRIMARY PRIMARY affiliate_orders_id


new_banktransfer
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
orders_id INTEGER(11)   NN        
banktransfer_owner VARCHAR(64)   NN        
banktransfer_number VARCHAR(24)   NN        
banktransfer_bankname VARCHAR(64)   NN        
banktransfer_blz VARCHAR(8)   NN        
banktransfer_status INTEGER(11)   NN        
banktransfer_prz VARCHAR(2)   NN        
banktransfer_fax VARCHAR(2)   NN        
IndexName IndexType Columns
idx_banktransfer_orders_id Index orders_id


new_banners
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
banners_id INTEGER(11) PK NN        
banners_title VARCHAR(64)   NN        
banners_url VARCHAR(255)   NN        
banners_image VARCHAR(64)   NN        
banners_group VARCHAR(10)   NN        
banners_html_text TEXT   NN        
expires_impressions SMALLINT(6)   NN        
expires_date DATETIME   NN        
date_scheduled DATETIME   NN        
date_added DATETIME   NN        
date_status_change DATETIME   NN        
status TINYINT(4)   NN   1    
IndexName IndexType Columns
PRIMARY PRIMARY banners_id


new_banners_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
banners_history_id INTEGER(11) PK NN        
banners_id INTEGER(11)   NN        
banners_shown SMALLINT(6)   NN        
banners_clicked SMALLINT(6)   NN        
banners_history_date DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY banners_history_id


new_block
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
block_id INTEGER(11) PK NN        
block_side VARCHAR(32)   NN        
block_status SMALLINT(6)   NN   1    
block_file VARCHAR(32)   NN        
block_cache VARCHAR(32)   NN        
block_type SMALLINT(6)   NN   1    
block_sort_order SMALLINT(6)   NN        
block_login_flag SMALLINT(6)   NN        
block_author_name VARCHAR(32)   NN        
block_author_www VARCHAR(255)   NN        
block_modules_group VARCHAR(32)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
set_function VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY block_id


new_block_info
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
block_id INTEGER(11) PK NN        
block_languages_id INTEGER(11) PK NN   1    
block_name VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY block_id
block_languages_id
idx_block_name Index block_name


new_block_to_page_type
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
block_id INTEGER(11) PK NN        
page_type_id INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY block_id
page_type_id


new_campaigns
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
campaigns_id INTEGER(11) PK NN        
campaigns_languages_id INTEGER(11) PK NN   1    
campaigns_name VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY campaigns_id
campaigns_languages_id
idx_campaigns_name Index campaigns_name


new_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
categories_id INTEGER(11) PK NN        
categories_image VARCHAR(64)   NN        
parent_id INTEGER(11)   NN        
access INTEGER(11)   NN        
sort_order TINYINT(4)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
categories_status TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY categories_id
idx_parent_id Index parent_id


new_categories_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
categories_id INTEGER(11) PK NN        
categories_languages_id INTEGER(11) PK NN   1    
categories_name VARCHAR(32)   NN        
categories_heading_title VARCHAR(64)   NN        
categories_description TEXT   NN        
categories_description_meta VARCHAR(250)   NN        
categories_keywords_meta VARCHAR(250)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY categories_id
categories_languages_id
idx_categories_name Index categories_name


new_configuration
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
configuration_id INTEGER(11) PK NN        
configuration_key VARCHAR(64)   NN        
configuration_value VARCHAR(255)   NN        
configuration_group_id INTEGER(11)   NN        
sort_order SMALLINT(6)   NN        
last_modified DATETIME   NN        
date_added DATETIME   NN        
use_function VARCHAR(255)   NN        
set_function VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY configuration_id


new_configuration_group
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
configuration_group_id INTEGER(11) PK NN        
sort_order SMALLINT(6)   NN        
visible TINYINT(4)   NN   1    
IndexName IndexType Columns
PRIMARY PRIMARY configuration_group_id


new_counter
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
startdate VARCHAR(8)   NN        
counter INTEGER(11)   NN        


new_counter_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
month VARCHAR(8)   NN        
counter INTEGER(11)   NN        


new_countries
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
countries_id INTEGER(11) PK NN        
countries_name VARCHAR(64)   NN        
countries_iso_code_2 VARCHAR(2)   NN        
countries_iso_code_3 VARCHAR(3)   NN        
countries_moneybookers VARCHAR(3)   NN        
address_format_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY countries_id
idx_countries_name Index countries_name


new_coupon_email_track
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
unique_id INTEGER(11) PK NN        
coupon_id INTEGER(11)   NN        
customer_id_sent INTEGER(11)   NN        
sent_firstname VARCHAR(32)   NN        
sent_lastname VARCHAR(32)   NN        
emailed_to VARCHAR(32)   NN        
date_sent DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY unique_id


new_coupon_gv_customer
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customer_id INTEGER(11) PK NN        
amount DECIMAL(8,4)   NN   0.0000    
IndexName IndexType Columns
PRIMARY PRIMARY customer_id


new_coupon_gv_queue
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
unique_id SMALLINT(6) PK NN        
customer_id SMALLINT(6)   NN        
order_id SMALLINT(6)   NN        
amount DECIMAL(8,4)   NN   0.0000    
date_created DATETIME   NN        
ipaddr VARCHAR(32)   NN        
release_flag VARCHAR(1)   NN   N    
IndexName IndexType Columns
PRIMARY PRIMARY unique_id


new_coupon_redeem_track
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
unique_id INTEGER(11) PK NN        
coupon_id INTEGER(11)   NN        
customer_id INTEGER(11)   NN        
redeem_date DATETIME   NN        
redeem_ip VARCHAR(32)   NN        
order_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY unique_id


new_coupons
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
coupon_id INTEGER(11) PK NN        
coupon_type VARCHAR(1)   NN   F    
coupon_code VARCHAR(32)   NN        
coupon_amount DECIMAL(8,4)   NN   0.0000    
coupon_minimum_order DECIMAL(8,4)   NN   0.0000    
coupon_start_date DATETIME   NN        
coupon_expire_date DATETIME   NN        
uses_per_coupon SMALLINT(6)   NN   1    
uses_per_user SMALLINT(6)   NN        
restrict_to_products VARCHAR(255)   NN        
restrict_to_categories VARCHAR(255)   NN        
restrict_to_customers TEXT   NN        
coupon_active VARCHAR(1)   NN   Y    
date_created DATETIME   NN        
date_modified DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY coupon_id


new_coupons_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
coupon_id INTEGER(11) PK NN        
coupon_languages_id INTEGER(11) PK NN   1    
coupon_name VARCHAR(32)   NN        
coupon_description TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY coupon_id
coupon_languages_id


new_currencies
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
currencies_id INTEGER(11) PK NN        
title VARCHAR(32)   NN        
code VARCHAR(3)   NN        
symbol_left VARCHAR(12)   NN        
symbol_right VARCHAR(12)   NN        
decimal_point VARCHAR(1)   NN        
thousands_point VARCHAR(1)   NN        
decimal_places VARCHAR(1)   NN        
value DECIMAL(13,8)   NN        
last_updated DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY currencies_id


new_customers
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_id INTEGER(11) PK NN        
customers_gender VARCHAR(1)   NN        
customers_firstname VARCHAR(32)   NN        
customers_lastname VARCHAR(32)   NN        
customers_image VARCHAR(64)   NN        
customers_number VARCHAR(16)   NN        
customers_dob DATETIME   NN        
customers_email_address VARCHAR(96)   NN        
customers_default_address_id SMALLINT(6)   NN   1    
customers_vat_id VARCHAR(20)   NN        
customers_vat_id_status TINYINT(4)   NN        
customers_telephone VARCHAR(32)   NN        
customers_fax VARCHAR(32)   NN        
customers_password VARCHAR(40)   NN        
customers_wishlist_link_id VARCHAR(32)   NN        
customers_newsletter VARCHAR(1)   NN        
customers_status VARCHAR(1)   NN   1    
customers_login VARCHAR(1)   NN        
customers_language VARCHAR(3)   NN        
customers_max_order DECIMAL(15,8)   NN   0.00000000    
IndexName IndexType Columns
PRIMARY PRIMARY customers_id


new_customers_basket
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_basket_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
to_wishlist_id VARCHAR(32)   NN        
products_id VARCHAR(32)   NN        
customers_basket_quantity DECIMAL(10,2)   NN   1.00    
final_price DECIMAL(15,8)   NN        
customers_basket_date_added VARCHAR(8)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_basket_id


new_customers_basket_attributes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_basket_attributes_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
products_id VARCHAR(32)   NN        
products_options_id INTEGER(11)   NN        
products_options_value_id INTEGER(11)   NN        
products_options_value_text VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_basket_attributes_id


new_customers_info
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_info_id INTEGER(11) PK NN        
customers_info_date_of_last_logon DATETIME   NN        
customers_info_number_of_logons SMALLINT(6)   NN        
customers_info_date_account_created DATETIME   NN        
customers_info_date_account_last_modified DATETIME   NN        
global_product_notifications TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_info_id


new_customers_status
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_status_id INTEGER(11) PK NN        
customers_status_languages_id INTEGER(11) PK NN   1    
customers_status_name VARCHAR(32)   NN        
customers_status_image VARCHAR(64)   NN        
customers_status_discount DECIMAL(4,2)   NN   0.00    
customers_status_ot_discount_flag TINYINT(4)   NN        
customers_status_ot_discount DECIMAL(4,2)   NN   0.00    
customers_status_ot_minimum DECIMAL(15,2)   NN   100.00    
customers_status_public TINYINT(4)   NN        
customers_status_show_price TINYINT(4)   NN        
customers_status_show_price_tax TINYINT(4)   NN        
customers_status_qty_discounts TINYINT(4)   NN        
customers_status_payment VARCHAR(255)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_status_id
customers_status_languages_id
idx_customers_status_name Index customers_status_name


new_customers_status_history
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_status_history_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
new_value TINYINT(4)   NN        
old_value TINYINT(4)   NN        
date_added DATETIME   NN        
customer_notified TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_status_history_id


new_customers_wishlist
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_wishlist_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
customers_wishlist_link_id VARCHAR(32)   NN        
products_id VARCHAR(32)   NN        
customers_wishlist_quantity TINYINT(4)   NN        
final_price DECIMAL(15,8)   NN        
customers_wishlist_date_added VARCHAR(8)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_wishlist_id


new_customers_wishlist_attributes
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
customers_wishlist_attributes_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
customers_wishlist_link_id VARCHAR(32)   NN        
products_id VARCHAR(32)   NN        
products_options_id INTEGER(11)   NN        
products_options_value_id INTEGER(11)   NN        
customers_wishlist_date_added VARCHAR(8)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY customers_wishlist_attributes_id


new_featured
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
featured_id INTEGER(11) PK NN        
products_id INTEGER(11)   NN        
featured_date_added DATETIME   NN        
featured_last_modified DATETIME   NN        
expires_date DATETIME   NN        
date_status_change DATETIME   NN        
status TINYINT(4)   NN   1    
IndexName IndexType Columns
PRIMARY PRIMARY featured_id


new_files_uploaded
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
files_uploaded_id INTEGER(11) PK NN        
sesskey VARCHAR(32)   NN        
customers_id INTEGER(11)   NN        
files_uploaded_name VARCHAR(64)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY files_uploaded_id


new_geo_zones
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
geo_zone_id INTEGER(11) PK NN        
geo_zone_name VARCHAR(32)   NN        
geo_zone_description VARCHAR(255)   NN        
last_modified DATETIME   NN        
date_added DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY geo_zone_id


new_information
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
information_id INTEGER(11) PK NN        
information_image VARCHAR(64)   NN        
sort_order TINYINT(4)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
status TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY information_id


new_information_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
information_id INTEGER(11) PK NN        
information_languages_id INTEGER(11) PK NN   1    
information_url VARCHAR(255)   NN        
information_name VARCHAR(64)   NN        
information_heading_title VARCHAR(64)   NN        
information_description TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY information_id
information_languages_id


new_languages
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
languages_id INTEGER(11) PK NN        
name VARCHAR(32)   NN        
iso_639_2 VARCHAR(3)   NN        
iso_639_1 VARCHAR(2)   NN        
status TINYINT(4)   NN        
sort_order TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY languages_id
idx_name Index name


new_link_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
link_categories_id INTEGER(11) PK NN        
link_categories_image VARCHAR(64)   NN        
link_categories_sort_order TINYINT(4)   NN        
link_categories_date_added DATETIME   NN        
link_categories_last_modified DATETIME   NN        
link_categories_status TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY link_categories_id
idx_link_categories_date_added Index link_categories_date_added


new_link_categories_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
link_categories_id INTEGER(11) PK NN        
link_categories_languages_id INTEGER(11) PK NN   1    
link_categories_name VARCHAR(32)   NN        
link_categories_description TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY link_categories_id
link_categories_languages_id
idx_link_categories_name Index link_categories_name


new_links
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
links_id INTEGER(11) PK NN        
links_url VARCHAR(255)   NN        
links_reciprocal_url VARCHAR(255)   NN        
links_image_url VARCHAR(255)   NN        
links_contact_name VARCHAR(64)   NN        
links_contact_email VARCHAR(96)   NN        
links_date_added DATETIME   NN        
links_last_modified DATETIME   NN        
links_status TINYINT(4)   NN        
links_clicked INTEGER(11)   NN        
links_rating INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY links_id


new_links_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
links_id INTEGER(11) PK NN        
links_languages_id INTEGER(11) PK NN   1    
links_title VARCHAR(64)   NN        
links_description TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY links_id
links_languages_id


new_links_status
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
links_status_id INTEGER(11) PK NN        
links_status_languages_id INTEGER(11) PK NN   1    
links_status_name VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY links_status_id
links_status_languages_id
idx_links_status_name Index links_status_name


new_links_to_link_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
links_id INTEGER(11) PK NN        
link_categories_id INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY links_id
link_categories_id


new_logsql
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
created DATETIME   NN        
sql0 VARCHAR(250)   NN        
sql1 TEXT   NN        
params TEXT   NN        
tracer TEXT   NN        
timer DECIMAL(16,6)   NN        


new_maillist
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
maillist_id INTEGER(11) PK NN        
customers_gender VARCHAR(1)   NN        
customers_firstname VARCHAR(32)   NN        
customers_lastname VARCHAR(32)   NN        
customers_email_address VARCHAR(96)   NN        
customers_newsletter VARCHAR(1)   NN        
customers_actkey VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY maillist_id


new_manual_info
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
man_info_id INTEGER(11) PK NN        
man_name VARCHAR(25)   NN        
status TINYINT(4)   NN        
manual_date_added DATETIME   NN        
manual_last_modified DATETIME   NN        
date_status_change DATETIME   NN        
expires_date DATETIME   NN        
man_key VARCHAR(24)   NN        
defined VARCHAR(10)   NN        
man_key2 VARCHAR(24)   NN        
man_key3 VARCHAR(35)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY man_info_id


new_manufacturers
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
manufacturers_id INTEGER(11) PK NN        
manufacturers_name VARCHAR(32)   NN        
manufacturers_image VARCHAR(64)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY manufacturers_id
idx_manufacturers_name Index manufacturers_name


new_manufacturers_info
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
manufacturers_id INTEGER(11) PK NN        
manufacturers_languages_id INTEGER(11) PK NN   1    
manufacturers_url VARCHAR(255)   NN        
url_clicked SMALLINT(6)   NN        
date_last_click DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY manufacturers_id
manufacturers_languages_id


new_news
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_id INTEGER(11) PK NN        
news_image VARCHAR(64)   NN        
news_date_added DATETIME   NN        
news_added_by INTEGER(11)   NN        
news_last_modified DATETIME   NN        
news_modified_by INTEGER(11)   NN        
news_expires_date DATETIME   NN        
news_status TINYINT(4)   NN        
newsfeed_categories_id INTEGER(11)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_id
idx_news_date_added Index news_date_added


new_news_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_categories_id INTEGER(11) PK NN        
news_categories_image VARCHAR(64)   NN        
parent_id INTEGER(11)   NN        
sort_order TINYINT(4)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
news_categories_status TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_categories_id
idx_news_categories_id Index news_categories_id


new_news_categories_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_categories_id INTEGER(11) PK NN        
news_categories_languages_id INTEGER(11) PK NN   1    
news_categories_name VARCHAR(32)   NN        
news_categories_heading_title VARCHAR(64)   NN        
news_categories_description TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_categories_id
news_categories_languages_id
idx_news_categories_name Index news_categories_name


new_news_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_id INTEGER(11) PK NN        
news_languages_id INTEGER(11) PK NN   1    
news_name VARCHAR(64)   NN        
news_description TEXT   NN        
news_url VARCHAR(255)   NN        
news_viewed SMALLINT(6)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_id
news_languages_id
idx_news_name Index news_name


new_news_reviews
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_reviews_id INTEGER(11) PK NN        
news_id INTEGER(11)   NN        
customers_id INTEGER(11)   NN        
customers_name VARCHAR(64)   NN        
news_reviews_rating TINYINT(4)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
news_reviews_read SMALLINT(6)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_reviews_id


new_news_reviews_description
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_reviews_id INTEGER(11) PK NN        
news_reviews_languages_id INTEGER(11) PK NN   1    
news_reviews_text TEXT   NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_reviews_id
news_reviews_languages_id


new_news_to_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
news_id INTEGER(11) PK NN        
news_categories_id INTEGER(11) PK NN        
IndexName IndexType Columns
PRIMARY PRIMARY news_id
news_categories_id


new_newsfeed
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
newsfeed_id INTEGER(11) PK NN        
newsfeed_image VARCHAR(64)   NN        
newsfeed_type VARCHAR(64)   NN        
date_added DATETIME   NN        
last_modified DATETIME   NN        
IndexName IndexType Columns
PRIMARY PRIMARY newsfeed_id


new_newsfeed_categories
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
newsfeed_categories_id INTEGER(11) PK NN        
newsfeed_categories_languages_id INTEGER(11) PK NN   1    
newsfeed_categories_name VARCHAR(32)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY newsfeed_categories_id
newsfeed_categories_languages_id
idx_newsfeed_categories Index newsfeed_categories_name


new_newsfeed_info
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
newsfeed_id INTEGER(11) PK NN        
newsfeed_languages_id INTEGER(11) PK NN   1    
newsfeed_name VARCHAR(32)   NN        
newsfeed_title VARCHAR(200)   NN        
newsfeed_description VARCHAR(200)   NN        
newsfeed_viewed SMALLINT(6)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY newsfeed_id
newsfeed_languages_id
idx_newsfeed_name Index newsfeed_name
idx_newsfeed_title Index newsfeed_title
idx_newsfeed_description Index newsfeed_description


new_newsfeed_manager
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
newsfeed_manager_id INTEGER(11) PK NN        
newsfeed_manager_languages_id INTEGER(11) PK NN   1    
newsfeed_categories_id INTEGER(11)   NN        
newsfeed_manager_name VARCHAR(55)   NN        
newsfeed_manager_link VARCHAR(255)   NN        
newsfeed_manager_numarticles SMALLINT(6)   NN   1    
newsfeed_manager_refresh DECIMAL(5,0)   NN   3600    
newsfeed_manager_status TINYINT(4)   NN        
newsfeed_manager_date_added DATETIME   NN        
newsfeed_manager_last_modified DATETIME   NN        
newsfeed_manager_sort_order TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY newsfeed_manager_id
newsfeed_manager_languages_id
idx_newsfeed_manager_name Index newsfeed_manager_name
idx_newsfeed_manager_link Index newsfeed_manager_link


new_newsletters
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
newsletters_id INTEGER(11) PK NN        
title VARCHAR(255)   NN        
content TEXT   NN        
module VARCHAR(255)   NN        
date_added DATETIME   NN        
date_sent DATETIME   NN        
status TINYINT(4)   NN        
locked TINYINT(4)   NN        
IndexName IndexType Columns
PRIMARY PRIMARY newsletters_id


new_orders
ColumnName DataType PrimaryKey   NotNull   Flags Default Value Comment AutoInc
orders_id INTEGER(11) PK NN        
customers_id INTEGER(11)   NN        
customers_name VARCHAR(64)   NN        
customers_company VARCHAR(32)   NN        
customers_street_address VARCHAR(64)   NN        
customers_suburb VARCHAR(32)   NN        
customers_city VARCHAR(32)   NN        
customers_postcode VARCHAR(10)   NN        
customers_state VARCHAR(32)   NN        
customers_country VARCHAR(32)   NN        
customers_telephone VARCHAR(32)   NN        
customers_email_address VARCHAR(96)   NN        
customers_address_format_id SMALLINT(6)   NN        
delivery_name VARCHAR(64)   NN        
delivery_company VARCHAR(32)   NN        
delivery_street_address VARCHAR(64)   NN        
delivery_suburb VARCHAR(32)   NN        
delivery_city VARCHAR(32)   NN        
delivery_postcode VARCHAR(10)   NN        
delivery_state VARCHAR(32)   NN        
delivery_country VARCHAR(32)   NN        
delivery_address_format_id SMALLINT(6)   NN        
billing_name VARCHAR(64)   NN        
billing_company VARCHAR(32)   NN        
billing_street_address VARCHAR(64)   NN        
billing_suburb VARCHAR(32)   NN        
billing_city VARCHAR(32)   NN        
billing_postcode VARCHAR(10)   NN        
billing_state VARCHAR(32)   NN        
billing_country VARCHAR(32)   NN        
billing_address_format_id SMALLINT(6)   NN        
payment_method VARCHAR(32)   NN        
cc_type VARCHAR(20)   NN        
cc_owner VARCHAR(64)   NN