{"slug":"wp-easycart","name":"Shopping Cart & eCommerce Store","description":"A FREE WordPress eCommerce & WordPress Shopping Cart plugin that can sell products, subscriptions, downloads, services, donations, and much more o …","author":"levelfourdevelopment","active_installs":4000,"version":"5.9.1","wp_org_url":"https://wordpress.org/plugins/wp-easycart/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"ec_address","full_table_name":"wp_ec_address","description":"Stores ec address data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"address_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line_2","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"zip","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"company_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rule_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rule_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"rule_amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"rule_limit","type":"int(11)","nullable":false,"primary_key":false},{"name":"rule_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"rule_recurring","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"affiliate_rule_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"affiliate_id","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"affiliate_rule_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"bundled_product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"category_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"parent_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"short_description","type":"text","nullable":true,"primary_key":false},{"name":"image","type":"text","nullable":true,"primary_key":false},{"name":"featured_category","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priority","type":"int(11)","nullable":false,"primary_key":false},{"name":"square_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"code_val","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"orderdetail_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"name_cnt","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"iso2_cnt","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"iso3_cnt","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"vat_rate_cnt","type":"float(9,3)","nullable":false,"primary_key":false},{"name":"ship_to_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"stripe_taxrate_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"vat_b2b_enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"table_name","type":"varchar(30)","nullable":false,"primary_key":false},{"name":"field_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"field_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"customfield_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"table_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"data","type":"blob","nullable":false,"primary_key":false},{"name":"date_created","type":"timestamp","nullable":false,"primary_key":false},{"name":"download_count","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_file_name","type":"text","nullable":false,"primary_key":false},{"name":"is_amazon_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"amazon_key","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"fee_label","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"fee_admin_description","type":"text","nullable":true,"primary_key":false},{"name":"fee_country","type":"text","nullable":true,"primary_key":false},{"name":"fee_state","type":"text","nullable":true,"primary_key":false},{"name":"fee_zip","type":"text","nullable":true,"primary_key":false},{"name":"fee_city","type":"text","nullable":true,"primary_key":false},{"name":"fee_category","type":"text","nullable":true,"primary_key":false},{"name":"fee_role","type":"text","nullable":true,"primary_key":false},{"name":"fee_zone","type":"text","nullable":true,"primary_key":false},{"name":"fee_payment_type","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"fee_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"fee_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_min","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_max","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"message","type":"text","nullable":true,"primary_key":false},{"name":"ec_cart_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"rate_data","type":"text","nullable":true,"primary_key":false},{"name":"location_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"latitude","type":"decimal(9,6)","nullable":true,"primary_key":false},{"name":"longitude","type":"decimal(9,6)","nullable":true,"primary_key":false},{"name":"hours_note","type":"text","nullable":false,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"schedule_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"menu_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"seo_keywords","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"seo_description","type":"blob","nullable":true,"primary_key":false},{"name":"banner_image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"menulevel1_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"menu_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"seo_keywords","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"seo_description","type":"blob","nullable":true,"primary_key":false},{"name":"banner_image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"menulevel2_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"menu_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"clicks","type":"int(11)","nullable":false,"primary_key":false},{"name":"seo_keywords","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"seo_description","type":"blob","nullable":true,"primary_key":false},{"name":"banner_image","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"option_name","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"option_label","type":"text","nullable":true,"primary_key":false},{"name":"option_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"option_required","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"option_error_text","type":"text","nullable":true,"primary_key":false},{"name":"option_meta","type":"text","nullable":true,"primary_key":false},{"name":"square_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"option_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"role_label","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"option_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"conditional_logic","type":"text","nullable":true,"primary_key":false},{"name":"stripe_price_id","type":"text","nullable":true,"primary_key":false},{"name":"option_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_name","type":"text","nullable":true,"primary_key":false},{"name":"optionitem_enable_custom_price_label","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_custom_price_label","type":"text","nullable":true,"primary_key":false},{"name":"optionitem_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_onetime","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_override","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_multiplier","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_per_character","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_onetime","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_override","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_multiplier","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_icon","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_initial_value","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_model_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_allow_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_disallow_shipping","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_initially_selected","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_download_override_file","type":"text","nullable":true,"primary_key":false},{"name":"optionitem_download_addition_file","type":"text","nullable":true,"primary_key":false},{"name":"square_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_plan_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_images","type":"text","nullable":true,"primary_key":false},{"name":"image1","type":"text","nullable":false,"primary_key":false},{"name":"image2","type":"text","nullable":false,"primary_key":false},{"name":"image3","type":"text","nullable":false,"primary_key":false},{"name":"image4","type":"text","nullable":false,"primary_key":false},{"name":"image5","type":"text","nullable":false,"primary_key":false},{"name":"product_id","type":"int(17)","nullable":false,"primary_key":false},{"name":"optionitem_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_4","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_5","type":"int(11)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"sku","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"is_enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_stock_tracking_enabled","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"square_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"google_merchant","type":"text","nullable":true,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"user_level","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_updated","type":"datetime","nullable":false,"primary_key":false},{"name":"order_date","type":"timestamp","nullable":false,"primary_key":false},{"name":"orderstatus_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"sub_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"tax_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"shipping_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"discount_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"vat_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"vat_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"duty_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"gst_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"gst_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"pst_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"pst_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"hst_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"hst_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"tip_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"grand_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"refund_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"promo_code_message","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"giftcard_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"use_expedited_shipping","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"shipping_method","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_carrier","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_service_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tracking_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"vat_registration_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"payment_method","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_email_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_transaction_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_payer_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"order_viewed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"order_notes","type":"text","nullable":true,"primary_key":false},{"name":"order_customer_notes","type":"blob","nullable":true,"primary_key":false},{"name":"txn_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"payment_txn_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"edit_sequence","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"quickbooks_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"credit_memo_txn_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"card_holder_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"creditcard_digits","type":"varchar(4)","nullable":false,"primary_key":false},{"name":"cc_exp_month","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"cc_exp_year","type":"varchar(4)","nullable":false,"primary_key":false},{"name":"fraktjakt_order_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fraktjakt_shipment_id","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"stripe_charge_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"nets_transaction_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subscription_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_gateway","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"affirm_charge_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"billing_company_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_company_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"guest_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"agreed_to_terms","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"order_ip_address","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"gateway_transaction_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"success_page_shown","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"email_other","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"includes_preorder_items","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"includes_restaurant_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"pickup_date","type":"datetime","nullable":false,"primary_key":false},{"name":"pickup_asap","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"pickup_time","type":"datetime","nullable":false,"primary_key":false},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"converted_cart_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"fee_label","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"fee_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_timestamp","type":"timestamp","nullable":true,"primary_key":false},{"name":"order_log_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_meta_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_meta_value","type":"text","nullable":true,"primary_key":false},{"name":"orderdetail_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_name","type":"text","nullable":true,"primary_key":false},{"name":"option_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"option_value","type":"text","nullable":false,"primary_key":false},{"name":"option_price_change","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"optionitem_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_onetime","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_override","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_multiplier","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_per_character","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_onetime","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_override","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_weight_multiplier","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_disallow_shipping","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_allow_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_enable_custom_price_label","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"optionitem_custom_price_label","type":"text","nullable":true,"primary_key":false},{"name":"option_label","type":"text","nullable":true,"primary_key":false},{"name":"option_to_product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_override_file","type":"text","nullable":true,"primary_key":false},{"name":"download_addition_file","type":"text","nullable":true,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"model_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"order_date","type":"datetime","nullable":false,"primary_key":false},{"name":"unit_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"unit_discount_promotion","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"unit_discount_coupon","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"total_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"total_discount_promotion","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"total_discount_coupon","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"image1","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_4","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_5","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_name_1","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_name_2","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_name_3","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_name_4","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_name_5","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_label_1","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_label_2","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_label_3","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_label_4","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_label_5","type":"text","nullable":false,"primary_key":false},{"name":"optionitem_price_1","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_2","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_3","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_4","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"optionitem_price_5","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"use_advanced_optionset","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_both_option_types","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"giftcard_id","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"shipper_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"shipper_first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipper_last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"gift_card_message","type":"text","nullable":true,"primary_key":false},{"name":"gift_card_from_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"gift_card_to_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"is_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_giftcard","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_taxable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_shippable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"exclude_shippable_calculation","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"download_file_name","type":"text","nullable":false,"primary_key":false},{"name":"download_key","type":"text","nullable":true,"primary_key":false},{"name":"maximum_downloads_allowed","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_timelimit_seconds","type":"int(11)","nullable":true,"primary_key":false},{"name":"is_amazon_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"amazon_key","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"is_deconetwork","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"deconetwork_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_product_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_options","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_color_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_product_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_image_link","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"gift_card_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"include_code","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"subscription_signup_fee","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"stock_adjusted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"order_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_approved","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_archieved","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"color_code","type":"varchar(40)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_type","type":"varchar(155)","nullable":false,"primary_key":false},{"name":"option_value","type":"text","nullable":false,"primary_key":false},{"name":"perpage","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_less_than","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_greater_than","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"low_point","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"high_point","type":"float(15,3)","nullable":true,"primary_key":false},{"name":"pricepoint_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"model_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"activate_in_store","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"specifications","type":"text","nullable":true,"primary_key":false},{"name":"order_completed_note","type":"text","nullable":true,"primary_key":false},{"name":"order_completed_email_note","type":"text","nullable":true,"primary_key":false},{"name":"order_completed_details_note","type":"text","nullable":true,"primary_key":false},{"name":"price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"list_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"product_cost","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"vat_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"handling_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"handling_price_each","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"stock_quantity","type":"int(7)","nullable":false,"primary_key":false},{"name":"min_purchase_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"max_purchase_quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"weight","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"width","type":"DOUBLE(15,3)","nullable":false,"primary_key":false},{"name":"height","type":"DOUBLE(15,3)","nullable":false,"primary_key":false},{"name":"length","type":"DOUBLE(15,3)","nullable":false,"primary_key":false},{"name":"seo_description","type":"text","nullable":true,"primary_key":false},{"name":"seo_keywords","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"use_specifications","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_customer_reviews","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"manufacturer_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_file_name","type":"text","nullable":false,"primary_key":false},{"name":"product_images","type":"text","nullable":true,"primary_key":false},{"name":"image1","type":"text","nullable":false,"primary_key":false},{"name":"image2","type":"text","nullable":false,"primary_key":false},{"name":"image3","type":"text","nullable":false,"primary_key":false},{"name":"image4","type":"text","nullable":false,"primary_key":false},{"name":"image5","type":"text","nullable":false,"primary_key":false},{"name":"option_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_id_4","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_id_5","type":"int(11)","nullable":false,"primary_key":false},{"name":"use_advanced_optionset","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_both_option_types","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"menulevel1_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel1_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel1_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel2_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel2_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel2_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel3_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel3_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"menulevel3_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"featured_product_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"featured_product_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"featured_product_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"featured_product_id_4","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_giftcard","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_donation","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_special","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_taxable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_shippable","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"exclude_shippable_calculation","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_subscription_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_preorder","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"role_id","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"added_to_db_date","type":"timestamp","nullable":true,"primary_key":false},{"name":"show_on_startup","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_optionitem_images","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"use_optionitem_quantity_tracking","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"views","type":"int(11)","nullable":false,"primary_key":false},{"name":"last_viewed","type":"datetime","nullable":false,"primary_key":false},{"name":"show_stock_quantity","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"maximum_downloads_allowed","type":"int(11)","nullable":false,"primary_key":false},{"name":"download_timelimit_seconds","type":"int(11)","nullable":false,"primary_key":false},{"name":"list_id","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"edit_sequence","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"quickbooks_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"income_account_ref","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"cogs_account_ref","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"asset_account_ref","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"quickbooks_parent_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"quickbooks_parent_list_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subscription_bill_length","type":"int(11)","nullable":false,"primary_key":false},{"name":"subscription_bill_period","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"subscription_bill_duration","type":"int(11)","nullable":false,"primary_key":false},{"name":"subscription_shipping_recurring","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"subscription_recurring_email","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"trial_period_days","type":"int(11)","nullable":false,"primary_key":false},{"name":"stripe_plan_added","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"subscription_plan_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"allow_multiple_subscription_purchases","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"membership_page","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_amazon_download","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"amazon_key","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"catalog_mode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"catalog_mode_phrase","type":"varchar(1024)","nullable":true,"primary_key":false},{"name":"inquiry_mode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"inquiry_url","type":"varchar(1024)","nullable":true,"primary_key":false},{"name":"is_deconetwork","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"deconetwork_mode","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_product_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_size_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_color_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_design_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"short_description","type":"text","nullable":true,"primary_key":false},{"name":"display_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"image_hover_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"tag_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"tag_bg_color","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"tag_text_color","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"tag_text","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"image_effect_type","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"include_code","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"TIC","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"subscription_signup_fee","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"subscription_unique_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"subscription_prorate","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"allow_backorders","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"backorder_fill_date","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_class_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"show_custom_price_range","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"price_range_low","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"price_range_high","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"square_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"square_variation_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"login_for_pricing","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"login_for_pricing_user_level","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"login_for_pricing_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"sort_position","type":"int(11)","nullable":false,"primary_key":false},{"name":"shopify_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_to_billing","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"shipping_restriction","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"enable_price_label","type":"int(11)","nullable":false,"primary_key":false},{"name":"replace_price_label","type":"int(11)","nullable":false,"primary_key":false},{"name":"custom_price_label","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"stripe_product_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"stripe_product_id_sandbox","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"stripe_default_price_id","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"stripe_default_price_id_sandbox","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"is_preorder_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_restaurant_type","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"pickup_locations","type":"text","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"attribute_value","type":"text","nullable":true,"primary_key":false},{"name":"email","type":"varchar(1024)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"status","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"last_notified","type":"datetime","nullable":true,"primary_key":false},{"name":"is_dollar_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_percentage_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_shipping_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_free_item_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_for_me_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_bogo_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"by_manufacturer_id","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"by_category_id","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"by_product_id","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"by_all_products","type":"int(11)","nullable":false,"primary_key":false},{"name":"promo_dollar","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_percentage","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_shipping","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_free_item","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_for_me","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_bogo_dollar","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"promo_bogo_percentage","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"manufacturer_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"message","type":"blob","nullable":false,"primary_key":false},{"name":"max_redemptions","type":"int(11)","nullable":false,"primary_key":false},{"name":"times_redeemed","type":"int(11)","nullable":false,"primary_key":false},{"name":"expiration_date","type":"datetime","nullable":true,"primary_key":false},{"name":"duration","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"duration_in_months","type":"int(11)","nullable":false,"primary_key":false},{"name":"minimum_required","type":"int(11)","nullable":false,"primary_key":false},{"name":"apply_to_shipping","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"first_order_only","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"type","type":"int(11)","nullable":false,"primary_key":false},{"name":"start_date","type":"datetime","nullable":false,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"product_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"manufacturer_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"manufacturer_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"manufacturer_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"category_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"price1","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"price2","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"price3","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"percentage1","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"percentage2","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"percentage3","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"number1","type":"int(11)","nullable":false,"primary_key":false},{"name":"number2","type":"int(11)","nullable":false,"primary_key":false},{"name":"number3","type":"int(11)","nullable":false,"primary_key":false},{"name":"promo_limit","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_error","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"processor","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"response_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"response_text","type":"text","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"approved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"rating","type":"int(2)","nullable":false,"primary_key":false},{"name":"title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"description","type":"mediumblob","nullable":false,"primary_key":false},{"name":"date_submitted","type":"timestamp","nullable":false,"primary_key":false},{"name":"reviewer_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"role_label","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"admin_access","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"role_label","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"admin_panel","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"role_label","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"role_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"schedule_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"day_of_week","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"is_holiday","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"holiday_date","type":"date","nullable":true,"primary_key":false},{"name":"apply_to_retail","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_preorder","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_restaurant","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"retail_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_open_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_close_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"preorder_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"restaurant_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"site_url","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"reg_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"storeversion","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"storetype","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"storepage","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"cartpage","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"accountpage","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"timezone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_method","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_expedite_rate","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"shipping_handling_rate","type":"float(11,2)","nullable":false,"primary_key":false},{"name":"ups_access_license_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ups_user_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ups_password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ups_ship_from_zip","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ups_shipper_number","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ups_country_code","type":"varchar(9)","nullable":false,"primary_key":false},{"name":"ups_weight_type","type":"varchar(19)","nullable":false,"primary_key":false},{"name":"ups_conversion_rate","type":"float(9,3)","nullable":false,"primary_key":false},{"name":"usps_user_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"usps_ship_from_zip","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fedex_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fedex_account_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fedex_meter_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fedex_password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fedex_ship_from_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fedex_weight_units","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fedex_country_code","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fedex_conversion_rate","type":"float(9,3)","nullable":false,"primary_key":false},{"name":"fedex_test_account","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"auspost_api_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"auspost_ship_from_zip","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"dhl_site_id","type":"varchar(155)","nullable":false,"primary_key":false},{"name":"dhl_password","type":"varchar(155)","nullable":false,"primary_key":false},{"name":"dhl_ship_from_country","type":"varchar(25)","nullable":false,"primary_key":false},{"name":"dhl_ship_from_zip","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"dhl_weight_unit","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"dhl_test_mode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"fraktjakt_customer_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"fraktjakt_login_key","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"fraktjakt_conversion_rate","type":"DOUBLE(15,3)","nullable":false,"primary_key":false},{"name":"fraktjakt_test_mode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"fraktjakt_address","type":"varchar(120)","nullable":false,"primary_key":false},{"name":"fraktjakt_city","type":"varchar(55)","nullable":false,"primary_key":false},{"name":"fraktjakt_state","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"fraktjakt_zip","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"fraktjakt_country","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"ups_ship_from_state","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"ups_negotiated_rates","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"canadapost_username","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"canadapost_password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"canadapost_customer_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"canadapost_contract_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"canadapost_test_mode","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"canadapost_ship_from_zip","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"class_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_class_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"shipping_rate_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"zone_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"is_price_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_weight_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_method_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_quantity_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_percentage_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_ups_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_usps_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_fedex_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_auspost_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_dhl_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_canadapost_based","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"trigger_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"shipping_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"shipping_label","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"shipping_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_override_rate","type":"float(11,3)","nullable":true,"primary_key":false},{"name":"free_shipping_at","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"idcnt_sta","type":"int(11)","nullable":false,"primary_key":false},{"name":"code_sta","type":"varchar($max_index_length)","nullable":false,"primary_key":false},{"name":"name_sta","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"sort_order","type":"int(11)","nullable":false,"primary_key":false},{"name":"group_sta","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"ship_to_active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"email","type":"text","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subscription_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subscription_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"title","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"email","type":"text","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"user_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"model_number","type":"varchar(510)","nullable":false,"primary_key":false},{"name":"price","type":"double(21,3)","nullable":false,"primary_key":false},{"name":"payment_length","type":"int(11)","nullable":false,"primary_key":false},{"name":"payment_period","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"payment_duration","type":"int(11)","nullable":false,"primary_key":false},{"name":"start_date","type":"timestamp","nullable":false,"primary_key":false},{"name":"last_payment_date","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"next_payment_date","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"number_payments_completed","type":"int(11)","nullable":false,"primary_key":false},{"name":"paypal_txn_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_txn_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_subscr_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_username","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"paypal_password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_subscription_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":false,"primary_key":false},{"name":"num_failed_payment","type":"int(11)","nullable":false,"primary_key":false},{"name":"plan_title","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"can_downgrade","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_state","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_country","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_duty","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_vat","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_single_vat","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tax_by_all","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"state_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"country_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"duty_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"vat_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"vat_added","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"vat_included","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"all_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"state_code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"vat_country_code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"duty_exempt_country_code","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"stripe_taxrate_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"quantity","type":"int(11)","nullable":true,"primary_key":false},{"name":"grid_quantity","type":"int(11)","nullable":true,"primary_key":false},{"name":"gift_card_message","type":"blob","nullable":true,"primary_key":false},{"name":"gift_card_from_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"gift_card_to_name","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"optionitem_id_1","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_2","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_3","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_4","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id_5","type":"int(11)","nullable":false,"primary_key":false},{"name":"donation_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"last_changed_date","type":"timestamp","nullable":false,"primary_key":false},{"name":"is_deconetwork","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"deconetwork_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_product_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_options","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_edit_link","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_color_code","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_product_id","type":"varchar(64)","nullable":false,"primary_key":false},{"name":"deconetwork_image_link","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"deconetwork_discount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"deconetwork_tax","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"deconetwork_total","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"deconetwork_version","type":"int(11)","nullable":false,"primary_key":false},{"name":"gift_card_email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"abandoned_cart_email_sent","type":"int(11)","nullable":false,"primary_key":false},{"name":"hide_from_admin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"tempcart_time","type":"timestamp","nullable":true,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"user_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"username","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"tip_amount","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"tip_rate","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"coupon_code","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"giftcard","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_company_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"billing_phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_selector","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_company_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"shipping_phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"create_account","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"order_notes","type":"text","nullable":true,"primary_key":false},{"name":"shipping_method","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"estimate_shipping_zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"expedited_shipping","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"estimate_shipping_country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_guest","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"guest_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"subscription_option1","type":"text","nullable":true,"primary_key":false},{"name":"subscription_option2","type":"text","nullable":true,"primary_key":false},{"name":"subscription_option3","type":"text","nullable":true,"primary_key":false},{"name":"subscription_option4","type":"text","nullable":true,"primary_key":false},{"name":"subscription_option5","type":"text","nullable":true,"primary_key":false},{"name":"subscription_advanced_option","type":"text","nullable":true,"primary_key":false},{"name":"subscription_quantity","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"convert_to","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"translate_to","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"taxcloud_tax_amount","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"taxcloud_address_last_verified","type":"text","nullable":true,"primary_key":false},{"name":"taxcloud_address_verified","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"taxjar_tax_amount","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"taxjar_address_verified","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"perpage","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"vat_registration_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"card_error","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"payment_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"payment_method","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_paymentintent_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_pi_client_secret","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amazon_session_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amazon_buyer_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"amazon_payment_selection","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email_other","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"stripe_last_pi_data","type":"text","nullable":true,"primary_key":false},{"name":"pickup_date","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"pickup_asap","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"pickup_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"pickup_location","type":"int(11)","nullable":false,"primary_key":false},{"name":"tempcart_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"option_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"optionitem_value","type":"text","nullable":false,"primary_key":false},{"name":"session_id","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"optionitem_model_number","type":"text","nullable":false,"primary_key":false},{"name":"name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"identifier","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_demo_item","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"password","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"list_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"edit_sequence","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"quickbooks_status","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"first_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"last_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"default_billing_address_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"default_shipping_address_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_level","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"is_subscriber","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"realauth_registered","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"stripe_customer_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"default_card_type","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"default_card_last4","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"exclude_tax","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"exclude_shipping","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"user_notes","type":"text","nullable":true,"primary_key":false},{"name":"vat_registration_number","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email_other","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"allow_shipping_bypass","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"is_stripe_test_user","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"webhook_type","type":"varchar(128)","nullable":false,"primary_key":false},{"name":"webhook_data","type":"blob","nullable":true,"primary_key":false},{"name":"zone_name","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"zone_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"iso2_cnt","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"code_sta","type":"varchar(50)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_address ( address_id int(11) NOT NULL AUTO_INCREMENT, user_id int(11) NOT NULL DEFAULT '0', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', address_line_1 varchar(255) NOT NULL DEFAULT '', address_line_2 varchar(255) DEFAULT '', city varchar(255) NOT NULL DEFAULT '', state varchar(128) NOT NULL DEFAULT '', zip varchar(128) NOT NULL DEFAULT '', country varchar(255) NOT NULL DEFAULT '', phone varchar(255) NOT NULL DEFAULT '', company_name varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (address_id), UNIQUE KEY address_id (address_id), KEY ec_address_idx1 (address_id), KEY ec_address_idx2 (user_id) ) $collate; CREATE TABLE ec_affiliate_rule ( affiliate_rule_id int(11) NOT NULL AUTO_INCREMENT, rule_name varchar(255) NOT NULL DEFAULT '', rule_type varchar(20) NOT NULL DEFAULT '', rule_amount float(15,3) NOT NULL DEFAULT '0.000', rule_limit int(11) NOT NULL DEFAULT '0', rule_active tinyint(1) NOT NULL DEFAULT '1', rule_recurring tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (affiliate_rule_id), UNIQUE KEY affiliate_rule_id (affiliate_rule_id) ) $collate; CREATE TABLE ec_affiliate_rule_to_affiliate ( rule_to_account_id int(11) NOT NULL AUTO_INCREMENT, affiliate_rule_id int(11) NOT NULL DEFAULT '0', affiliate_id varchar(128) NOT NULL DEFAULT '', PRIMARY KEY (rule_to_account_id), UNIQUE KEY rule_to_account_id (rule_to_account_id), KEY affiliate_rule_id (affiliate_rule_id) , KEY affiliate_id (affiliate_id) ) $collate; CREATE TABLE ec_affiliate_rule_to_product ( rule_to_product_id int(11) NOT NULL AUTO_INCREMENT, affiliate_rule_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (rule_to_product_id), UNIQUE KEY rule_to_product_id (rule_to_product_id), KEY affiliate_rule_id (affiliate_rule_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_bundle ( bundle_id int(11) NOT NULL AUTO_INCREMENT, key_product_id int(11) NOT NULL DEFAULT '0', bundled_product_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (bundle_id), UNIQUE KEY bundle_id (bundle_id) ) $collate; CREATE TABLE ec_category ( category_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', is_active tinyint(1) NOT NULL DEFAULT '1', category_name varchar(255) NOT NULL DEFAULT '', post_id int(11) NOT NULL DEFAULT '0', parent_id int(11) NOT NULL DEFAULT '0', short_description text, image text, featured_category tinyint(1) NOT NULL DEFAULT '0', priority int(11) NOT NULL DEFAULT '0', square_id varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (category_id), UNIQUE KEY category_id (category_id) ) $collate; CREATE TABLE ec_categoryitem ( categoryitem_id int(11) NOT NULL AUTO_INCREMENT, category_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (categoryitem_id), UNIQUE KEY categoryitem_id (categoryitem_id), KEY product_id (product_id), KEY category_id (category_id), KEY idx_category_product (category_id, product_id) ) $collate; CREATE TABLE ec_code ( code_id int(11) NOT NULL AUTO_INCREMENT, code_val varchar(255) DEFAULT '', product_id int(11) NOT NULL DEFAULT '0', orderdetail_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (code_id), UNIQUE KEY code_id (code_id), KEY product_id (product_id), KEY orderdetail_id (orderdetail_id) ) $collate; CREATE TABLE ec_country ( id_cnt int(11) NOT NULL AUTO_INCREMENT, name_cnt varchar(255) NOT NULL DEFAULT '', iso2_cnt varchar(10) NOT NULL DEFAULT '', iso3_cnt varchar(10) NOT NULL DEFAULT '', sort_order int(11) NOT NULL, vat_rate_cnt float(9,3) NOT NULL DEFAULT '0.000', ship_to_active tinyint(1) NOT NULL DEFAULT '1', stripe_taxrate_id varchar(100) NOT NULL DEFAULT '', vat_b2b_enabled tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (id_cnt), KEY iso2_cnt (iso2_cnt), KEY iso3_cnt (iso3_cnt) ) $collate; CREATE TABLE ec_customfield ( customfield_id int(11) NOT NULL AUTO_INCREMENT, table_name varchar(30) NOT NULL DEFAULT '', field_name varchar(255) NOT NULL DEFAULT '', field_label varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (customfield_id), UNIQUE KEY customfield_id (customfield_id) ) $collate; CREATE TABLE ec_customfielddata ( customfielddata_id int(11) NOT NULL AUTO_INCREMENT, customfield_id int(11) DEFAULT NULL, table_id int(11) NOT NULL, data blob NOT NULL, PRIMARY KEY (customfielddata_id) ) $collate; CREATE TABLE ec_download ( download_id varchar($max_index_length) NOT NULL DEFAULT '', date_created timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, download_count int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', download_file_name text NOT NULL DEFAULT '', is_amazon_download tinyint(1) NOT NULL DEFAULT '0', amazon_key varchar(1024) NOT NULL DEFAULT '', PRIMARY KEY (download_id), KEY download_order_id (order_id), KEY download_product_id (product_id) ) $collate; CREATE TABLE ec_fee ( fee_id int(11) NOT NULL AUTO_INCREMENT, fee_label varchar(512) NOT NULL DEFAULT '', fee_admin_description text, fee_country text, fee_state text, fee_zip text, fee_city text, fee_category text, fee_role text, fee_zone text, fee_payment_type varchar(255) DEFAULT '', fee_type int(11) NOT NULL DEFAULT '1', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_price float(15,3) NOT NULL DEFAULT '0.000', fee_min float(15,3) NOT NULL DEFAULT '0.000', fee_max float(15,3) NOT NULL DEFAULT '-1.000', PRIMARY KEY (fee_id) ) $collate; CREATE TABLE ec_giftcard ( giftcard_id varchar(20) NOT NULL DEFAULT '', amount float(15,3) NOT NULL DEFAULT '0.000', message text, PRIMARY KEY (giftcard_id), UNIQUE KEY giftcard_id (giftcard_id) ) $collate; CREATE TABLE ec_live_rate_cache ( live_rate_cache_id int(11) NOT NULL AUTO_INCREMENT, ec_cart_id varchar(255) NOT NULL DEFAULT '', rate_data text, PRIMARY KEY (live_rate_cache_id) ) $collate; CREATE TABLE ec_location ( location_id int(11) NOT NULL AUTO_INCREMENT, location_label varchar(255) DEFAULT '', address_line_1 varchar(255) NOT NULL DEFAULT '', address_line_2 varchar(255) NOT NULL DEFAULT '', city varchar(255) NOT NULL DEFAULT '', state varchar(255) NOT NULL DEFAULT '', country varchar(255) NOT NULL DEFAULT '', zip varchar(255) NOT NULL DEFAULT '', phone varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', latitude decimal(9,6) DEFAULT NULL, longitude decimal(9,6) DEFAULT NULL, hours_note text NOT NULL DEFAULT '', PRIMARY KEY (location_id), UNIQUE KEY location_id (location_id) ) $collate; CREATE TABLE ec_location_to_product ( location_product_id int(11) NOT NULL AUTO_INCREMENT, location_id int(11) NOT NULL DEFAULT 0, product_id int(11) NOT NULL DEFAULT 0, PRIMARY KEY (location_product_id), UNIQUE KEY location_product_id (location_product_id), KEY location_id (location_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_location_to_schedule ( location_schedule_id int(11) NOT NULL AUTO_INCREMENT, location_id int(11) NOT NULL DEFAULT 0, schedule_id int(11) NOT NULL DEFAULT 0, PRIMARY KEY (location_schedule_id), UNIQUE KEY location_schedule_id (location_schedule_id), KEY location_id (location_id), KEY product_id (schedule_id) ) $collate; CREATE TABLE ec_manufacturer ( manufacturer_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', name varchar(255) NOT NULL DEFAULT '', clicks int(11) NOT NULL DEFAULT '0', post_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (manufacturer_id) ) $collate; CREATE TABLE ec_menulevel1 ( menulevel1_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', name varchar(255) NOT NULL DEFAULT '', menu_order int(11) NOT NULL DEFAULT '0', clicks int(11) NOT NULL DEFAULT '0', seo_keywords varchar(255) NOT NULL DEFAULT '', seo_description blob NULL, banner_image varchar(255) NOT NULL DEFAULT '', post_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (menulevel1_id), UNIQUE KEY menu1_menulevel1_id (menulevel1_id) ) $collate; CREATE TABLE ec_menulevel2 ( menulevel2_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', menulevel1_id int(11) NOT NULL DEFAULT '0', name varchar(255) NOT NULL DEFAULT '', menu_order int(11) NOT NULL DEFAULT '0', clicks int(11) NOT NULL DEFAULT '0', seo_keywords varchar(255) NOT NULL DEFAULT '', seo_description blob NULL, banner_image varchar(255) NOT NULL DEFAULT '', post_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (menulevel2_id), UNIQUE KEY menu2_menulevel2_id (menulevel2_id), KEY menu2_menulevel1_id (menulevel1_id) ) $collate; CREATE TABLE ec_menulevel3 ( menulevel3_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', menulevel2_id int(11) NOT NULL DEFAULT '0', name varchar(255) NOT NULL DEFAULT '', menu_order int(11) NOT NULL DEFAULT '0', clicks int(11) NOT NULL DEFAULT '0', seo_keywords varchar(255) NOT NULL DEFAULT '', seo_description blob NULL, banner_image varchar(255) NOT NULL DEFAULT '', post_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (menulevel3_id), UNIQUE KEY menu3_menulevel3_id (menulevel3_id), KEY menu3_menulevel2_id (menulevel2_id) ) $collate; CREATE TABLE ec_option ( option_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', option_name varchar(128) NOT NULL DEFAULT '', option_label text, option_type varchar(20) NOT NULL DEFAULT 'combo', option_required tinyint(1) NOT NULL DEFAULT '1', option_error_text text, option_meta text, square_id varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (option_id), UNIQUE KEY option_option_id (option_id) ) $collate; CREATE TABLE ec_option_to_product ( option_to_product_id int(11) NOT NULL AUTO_INCREMENT, option_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', role_label varchar(20) NOT NULL DEFAULT 'all', option_order int(11) NOT NULL DEFAULT '0', conditional_logic text, stripe_price_id text, PRIMARY KEY (option_to_product_id), UNIQUE KEY option_to_product_id (option_to_product_id), KEY option_id (option_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_optionitem ( optionitem_id int(11) NOT NULL AUTO_INCREMENT, option_id int(11) NOT NULL DEFAULT '0', optionitem_name text, optionitem_enable_custom_price_label tinyint(1) NOT NULL DEFAULT '0', optionitem_custom_price_label text, optionitem_price float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_onetime float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_override float(15,3) NOT NULL DEFAULT '-1.000', optionitem_price_multiplier float(15,3) NOT NULL DEFAULT '0', optionitem_price_per_character float(15,3) NOT NULL DEFAULT '0.000', optionitem_weight float(15,3) NOT NULL DEFAULT '0.000', optionitem_weight_onetime float(15,3) NOT NULL DEFAULT '0.000', optionitem_weight_override float(15,3) NOT NULL DEFAULT '-1.000', optionitem_weight_multiplier float(15,3) NOT NULL DEFAULT '0', optionitem_order int(11) NOT NULL DEFAULT '1', optionitem_icon varchar(255) NOT NULL DEFAULT '', optionitem_initial_value varchar(255) NOT NULL DEFAULT '', optionitem_model_number varchar(255) NOT NULL DEFAULT '', optionitem_allow_download tinyint(1) NOT NULL DEFAULT '1', optionitem_disallow_shipping tinyint(1) NOT NULL DEFAULT '0', optionitem_initially_selected tinyint(1) NOT NULL DEFAULT '0', optionitem_download_override_file text, optionitem_download_addition_file text, square_id varchar(255) NOT NULL DEFAULT '', stripe_plan_id varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (optionitem_id), KEY option_id (option_id) ) $collate; CREATE TABLE ec_optionitemimage ( optionitemimage_id int(11) NOT NULL AUTO_INCREMENT, optionitem_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', product_images text NULL, image1 text NOT NULL DEFAULT '', image2 text NOT NULL DEFAULT '', image3 text NOT NULL DEFAULT '', image4 text NOT NULL DEFAULT '', image5 text NOT NULL DEFAULT '', PRIMARY KEY (optionitemimage_id), KEY optionitem_id (optionitem_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_optionitemquantity ( optionitemquantity_id int(11) NOT NULL AUTO_INCREMENT, product_id int(17) NOT NULL DEFAULT '0', optionitem_id_1 int(11) NOT NULL DEFAULT '0', optionitem_id_2 int(11) NOT NULL DEFAULT '0', optionitem_id_3 int(11) NOT NULL DEFAULT '0', optionitem_id_4 int(11) NOT NULL DEFAULT '0', optionitem_id_5 int(11) NOT NULL DEFAULT '0', quantity int(11) NOT NULL DEFAULT '0', sku varchar(255) NOT NULL DEFAULT '', price float(15,3) NOT NULL DEFAULT '-1.000', is_enabled tinyint(1) NOT NULL DEFAULT '1', is_stock_tracking_enabled tinyint(1) NOT NULL DEFAULT '1', square_id varchar(255) NOT NULL DEFAULT '', google_merchant text NULL, PRIMARY KEY (optionitemquantity_id), UNIQUE KEY optionitemquantity_id (optionitemquantity_id), KEY product_id (product_id), KEY optionitem_id_1 (optionitem_id_1), KEY optionitem_id_2 (optionitem_id_2), KEY optionitem_id_3 (optionitem_id_3), KEY optionitem_id_4 (optionitem_id_4), KEY optionitem_id_5 (optionitem_id_5) ) $collate; CREATE TABLE ec_order ( order_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', user_email varchar(255) NOT NULL DEFAULT '', user_level varchar(255) NOT NULL DEFAULT 'shopper', last_updated datetime NOT NULL DEFAULT '0000-00-00 00:00:00', order_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, orderstatus_id int(11) NOT NULL DEFAULT '5', order_weight float(15,3) NOT NULL DEFAULT '0.000', sub_total float(15,3) NOT NULL DEFAULT '0.000', tax_total float(15,3) NOT NULL DEFAULT '0.000', shipping_total float(15,3) NOT NULL DEFAULT '0.000', discount_total float(15,3) NOT NULL DEFAULT '0.000', vat_total float(15,3) NOT NULL DEFAULT '0.000', vat_rate float(15,3) NOT NULL DEFAULT '0.000', duty_total float(15,3) NOT NULL DEFAULT '0.000', gst_total float(15,3) NOT NULL DEFAULT '0.000', gst_rate float(15,3) NOT NULL DEFAULT '0.000', pst_total float(15,3) NOT NULL DEFAULT '0.000', pst_rate float(15,3) NOT NULL DEFAULT '0.000', hst_total float(15,3) NOT NULL DEFAULT '0.000', hst_rate float(15,3) NOT NULL DEFAULT '0.000', tip_total float(15,3) NOT NULL DEFAULT '0.000', grand_total float(15,3) NOT NULL DEFAULT '0.000', refund_total float(15,3) NOT NULL DEFAULT '0.000', promo_code varchar(255) NOT NULL DEFAULT '', promo_code_message varchar(1024) NOT NULL DEFAULT '', giftcard_id varchar(20) NOT NULL DEFAULT '', use_expedited_shipping tinyint(1) NOT NULL DEFAULT '0', shipping_method varchar(255) NOT NULL DEFAULT '', shipping_carrier varchar(255) NOT NULL DEFAULT '', shipping_service_code varchar(255) NOT NULL DEFAULT '', tracking_number varchar(255) NOT NULL DEFAULT '', billing_first_name varchar(255) NOT NULL DEFAULT '', billing_last_name varchar(255) NOT NULL DEFAULT '', billing_address_line_1 varchar(255) NOT NULL DEFAULT '', billing_address_line_2 varchar(255) NOT NULL DEFAULT '', billing_city varchar(255) NOT NULL DEFAULT '', billing_state varchar(255) NOT NULL DEFAULT '', billing_country varchar(255) NOT NULL DEFAULT '', billing_zip varchar(255) NOT NULL DEFAULT '', billing_phone varchar(255) NOT NULL DEFAULT '', shipping_first_name varchar(255) NOT NULL DEFAULT '', shipping_last_name varchar(255) NOT NULL DEFAULT '', shipping_address_line_1 varchar(255) NOT NULL DEFAULT '', shipping_address_line_2 varchar(255) NOT NULL DEFAULT '', shipping_city varchar(255) NOT NULL DEFAULT '', shipping_state varchar(255) NOT NULL DEFAULT '', shipping_country varchar(255) NOT NULL DEFAULT '', shipping_zip varchar(255) NOT NULL DEFAULT '', shipping_phone varchar(255) NOT NULL DEFAULT '', vat_registration_number varchar(255) NOT NULL DEFAULT '', payment_method varchar(255) NOT NULL DEFAULT '', paypal_email_id varchar(255) NOT NULL DEFAULT '', paypal_transaction_id varchar(255) NOT NULL DEFAULT '', paypal_payer_id varchar(255) NOT NULL DEFAULT '', order_viewed tinyint(1) NOT NULL DEFAULT '0', order_notes text, order_customer_notes blob, txn_id varchar(50) NOT NULL DEFAULT '', payment_txn_id varchar(50) NOT NULL DEFAULT '', edit_sequence varchar(50) NOT NULL DEFAULT '', quickbooks_status varchar(255) NOT NULL DEFAULT 'Not Queued', credit_memo_txn_id varchar(255) NOT NULL DEFAULT '', card_holder_name varchar(255) NOT NULL DEFAULT '', creditcard_digits varchar(4) NOT NULL DEFAULT '', cc_exp_month varchar(2) NOT NULL DEFAULT '', cc_exp_year varchar(4) NOT NULL DEFAULT '', fraktjakt_order_id varchar(20) NOT NULL DEFAULT '', fraktjakt_shipment_id varchar(20) DEFAULT '', stripe_charge_id varchar(255) NOT NULL DEFAULT '', nets_transaction_id varchar(255) NOT NULL DEFAULT '', subscription_id int(11) NOT NULL DEFAULT '0', order_gateway varchar(64) NOT NULL DEFAULT '', affirm_charge_id varchar(100) NOT NULL DEFAULT '', billing_company_name varchar(255) NOT NULL DEFAULT '', shipping_company_name varchar(255) NOT NULL DEFAULT '', guest_key varchar(255) NOT NULL DEFAULT '', agreed_to_terms tinyint(1) NOT NULL DEFAULT '0', order_ip_address varchar(255) NOT NULL DEFAULT '', gateway_transaction_id varchar(255) NOT NULL DEFAULT '', success_page_shown tinyint(1) NOT NULL DEFAULT 0, email_other varchar(255) NOT NULL DEFAULT '', includes_preorder_items tinyint(1) NOT NULL DEFAULT 0, includes_restaurant_type tinyint(1) NOT NULL DEFAULT 0, pickup_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00', pickup_asap tinyint(1) NOT NULL DEFAULT 1, pickup_time datetime NOT NULL DEFAULT '0000-00-00 00:00:00', location_id int(11) NOT NULL DEFAULT 0, converted_cart_id varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (order_id), UNIQUE KEY order_id (order_id), KEY user_id (user_id), KEY giftcard_id (giftcard_id) ) $collate; CREATE TABLE ec_order_fee ( order_fee_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', fee_label varchar(512) NOT NULL DEFAULT '', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_total float(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (order_fee_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_order_log ( order_log_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', order_log_key varchar(100) NOT NULL DEFAULT '', order_log_timestamp timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (order_log_id), UNIQUE KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_order_log_meta ( order_log_meta_id int(11) NOT NULL AUTO_INCREMENT, order_log_id int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', order_log_meta_key varchar(100) NOT NULL DEFAULT '', order_log_meta_value text, PRIMARY KEY (order_log_meta_id), UNIQUE KEY order_log_meta_id (order_log_meta_id), KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_order_option ( order_option_id int(11) NOT NULL AUTO_INCREMENT, orderdetail_id int(11) NOT NULL DEFAULT '0', option_name varchar(255) NOT NULL DEFAULT '', optionitem_name text, option_type varchar(20) NOT NULL DEFAULT 'combo', option_value text NOT NULL, option_price_change varchar(255) NOT NULL DEFAULT '', optionitem_price float(15,3) NOT NULL DEFAULT '0.00', optionitem_price_onetime float(15,3) NOT NULL DEFAULT '0.00', optionitem_price_override float(15,3) NOT NULL DEFAULT '-1.00', optionitem_price_multiplier float(15,3) NOT NULL DEFAULT '0.00', optionitem_price_per_character float(15,3) NOT NULL DEFAULT '0.00', optionitem_weight float(15,3) NOT NULL DEFAULT '0.00', optionitem_weight_onetime float(15,3) NOT NULL DEFAULT '0.00', optionitem_weight_override float(15,3) NOT NULL DEFAULT '-1.00', optionitem_weight_multiplier float(15,3) NOT NULL DEFAULT '0.00', optionitem_disallow_shipping tinyint(1) NOT NULL DEFAULT '0', optionitem_allow_download tinyint(1) NOT NULL DEFAULT '1', optionitem_enable_custom_price_label tinyint(1) NOT NULL DEFAULT '0', optionitem_custom_price_label text, option_label text, option_to_product_id int(11) NOT NULL DEFAULT '0', option_order int(11) NOT NULL DEFAULT '0', download_override_file text, download_addition_file text, PRIMARY KEY (order_option_id), UNIQUE KEY order_option_id (order_option_id), KEY orderdetail_id (orderdetail_id) ) $collate; CREATE TABLE ec_orderdetail ( orderdetail_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', title varchar(255) DEFAULT NULL, model_number varchar(255) NOT NULL, order_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00', unit_price float(15,3) NOT NULL DEFAULT '0.000', unit_discount_promotion float(15,3) NOT NULL DEFAULT '0.000', unit_discount_coupon float(15,3) NOT NULL DEFAULT '0.000', total_price float(15,3) NOT NULL DEFAULT '0.000', total_discount_promotion float(15,3) NOT NULL DEFAULT '0.000', total_discount_coupon float(15,3) NOT NULL DEFAULT '0.000', quantity int(11) NOT NULL DEFAULT '0', image1 text NOT NULL, optionitem_id_1 int(11) NOT NULL DEFAULT '0', optionitem_id_2 int(11) NOT NULL DEFAULT '0', optionitem_id_3 int(11) NOT NULL DEFAULT '0', optionitem_id_4 int(11) NOT NULL DEFAULT '0', optionitem_id_5 int(11) NOT NULL DEFAULT '0', optionitem_name_1 text NOT NULL DEFAULT '', optionitem_name_2 text NOT NULL DEFAULT '', optionitem_name_3 text NOT NULL DEFAULT '', optionitem_name_4 text NOT NULL DEFAULT '', optionitem_name_5 text NOT NULL DEFAULT '', optionitem_label_1 text NOT NULL DEFAULT '', optionitem_label_2 text NOT NULL DEFAULT '', optionitem_label_3 text NOT NULL DEFAULT '', optionitem_label_4 text NOT NULL DEFAULT '', optionitem_label_5 text NOT NULL DEFAULT '', optionitem_price_1 float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_2 float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_3 float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_4 float(15,3) NOT NULL DEFAULT '0.000', optionitem_price_5 float(15,3) NOT NULL DEFAULT '0.000', use_advanced_optionset tinyint(1) NOT NULL DEFAULT '0', use_both_option_types tinyint(1) NOT NULL DEFAULT '0', giftcard_id varchar(20) NOT NULL DEFAULT '', shipper_id int(11) DEFAULT '0', shipper_first_name varchar(255) NOT NULL DEFAULT '', shipper_last_name varchar(255) NOT NULL DEFAULT '', gift_card_message text NULL, gift_card_from_name varchar(255) NULL, gift_card_to_name varchar(255) NULL, is_download tinyint(1) NOT NULL DEFAULT '0', is_giftcard tinyint(1) NOT NULL DEFAULT '0', is_taxable tinyint(1) NOT NULL DEFAULT '1', is_shippable tinyint(1) NOT NULL DEFAULT '1', exclude_shippable_calculation tinyint(1) NOT NULL DEFAULT '0', download_file_name text NOT NULL DEFAULT '', download_key text DEFAULT '', maximum_downloads_allowed int(11) NOT NULL DEFAULT '0', download_timelimit_seconds int(11) DEFAULT '0', is_amazon_download tinyint(1) NOT NULL DEFAULT '0', amazon_key varchar(1024) NOT NULL DEFAULT '', is_deconetwork tinyint(1) NOT NULL DEFAULT '0', deconetwork_id varchar(64) NOT NULL DEFAULT '', deconetwork_name varchar(255) NOT NULL DEFAULT '', deconetwork_product_code varchar(64) NOT NULL DEFAULT '', deconetwork_options varchar(255) NOT NULL DEFAULT '', deconetwork_color_code varchar(64) NOT NULL DEFAULT '', deconetwork_product_id varchar(64) NOT NULL DEFAULT '', deconetwork_image_link varchar(255) NOT NULL DEFAULT '', gift_card_email varchar(255) NOT NULL DEFAULT '', include_code tinyint(1) NOT NULL DEFAULT '0', subscription_signup_fee float(15,3) NOT NULL DEFAULT '0.000', stock_adjusted tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (orderdetail_id), UNIQUE KEY orderdetail_id (orderdetail_id), KEY orderdetail_order_id (order_id), KEY orderdetail_product_id (product_id), KEY orderdetail_giftcard_id (giftcard_id) ) $collate; CREATE TABLE ec_orderstatus ( status_id int(11) NOT NULL AUTO_INCREMENT, order_status varchar(255) NOT NULL DEFAULT '', is_approved tinyint(1) DEFAULT '0', is_archieved tinyint(1) DEFAULT '0', color_code varchar(40) NOT NULL DEFAULT '#FFFFFF', PRIMARY KEY (status_id), UNIQUE KEY orderstatus_status_id (status_id) ) $collate; CREATE TABLE ec_pageoption ( pageoption_id int(11) NOT NULL AUTO_INCREMENT, post_id int(11) NOT NULL DEFAULT '0', option_type varchar(155) NOT NULL DEFAULT '', option_value text NOT NULL, PRIMARY KEY (pageoption_id), UNIQUE KEY pageoption_id (pageoption_id) ) $collate; CREATE TABLE ec_perpage ( perpage_id int(11) NOT NULL AUTO_INCREMENT, perpage int(11) NOT NULL DEFAULT '0', PRIMARY KEY (perpage_id), UNIQUE KEY perpageid (perpage_id) ) $collate; CREATE TABLE ec_pricepoint ( pricepoint_id int(11) NOT NULL AUTO_INCREMENT, is_less_than tinyint(1) NOT NULL DEFAULT 0, is_greater_than tinyint(1) NOT NULL DEFAULT 0, low_point float(15,3) NOT NULL DEFAULT '0.000', high_point float(15,3) DEFAULT '0.000', pricepoint_order int(11) NOT NULL DEFAULT '0', PRIMARY KEY (pricepoint_id), UNIQUE KEY pricepoint_pricepoint_id (pricepoint_id) ) $collate; CREATE TABLE ec_pricetier ( pricetier_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT '0', price float(15,3) NOT NULL DEFAULT '0.000', quantity int(11) NOT NULL DEFAULT '10', PRIMARY KEY (pricetier_id), UNIQUE KEY pricetier_id (pricetier_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_product ( product_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', model_number varchar(255) NOT NULL DEFAULT '', post_id int(11) NOT NULL DEFAULT '0', activate_in_store tinyint(1) NOT NULL DEFAULT 0, title varchar(255) NOT NULL DEFAULT '', description text NULL, specifications text NULL, order_completed_note text NULL, order_completed_email_note text NULL, order_completed_details_note text NULL, price float(15,3) NOT NULL DEFAULT '0.000', list_price float(15,3) NOT NULL DEFAULT '0.000', product_cost float(15,3) NOT NULL DEFAULT '0.000', vat_rate float(15,3) NOT NULL DEFAULT '0.000', handling_price float(15,3) NOT NULL DEFAULT '0.000', handling_price_each float(15,3) NOT NULL DEFAULT '0.000', stock_quantity int(7) NOT NULL DEFAULT '0', min_purchase_quantity int(11) NOT NULL DEFAULT '0', max_purchase_quantity int(11) NOT NULL DEFAULT '0', weight float(15,3) NOT NULL DEFAULT '0.000', width DOUBLE(15,3) NOT NULL DEFAULT '1.000', height DOUBLE(15,3) NOT NULL DEFAULT '1.000', length DOUBLE(15,3) NOT NULL DEFAULT '1.000', seo_description text NULL, seo_keywords varchar(255) NOT NULL DEFAULT '', use_specifications tinyint(1) NOT NULL DEFAULT 0, use_customer_reviews tinyint(1) NOT NULL DEFAULT 0, manufacturer_id int(11) NOT NULL DEFAULT '0', download_file_name text NOT NULL DEFAULT '', product_images text NULL, image1 text NOT NULL DEFAULT '', image2 text NOT NULL DEFAULT '', image3 text NOT NULL DEFAULT '', image4 text NOT NULL DEFAULT '', image5 text NOT NULL DEFAULT '', option_id_1 int(11) NOT NULL DEFAULT '0', option_id_2 int(11) NOT NULL DEFAULT '0', option_id_3 int(11) NOT NULL DEFAULT '0', option_id_4 int(11) NOT NULL DEFAULT '0', option_id_5 int(11) NOT NULL DEFAULT '0', use_advanced_optionset tinyint(1) NOT NULL DEFAULT 0, use_both_option_types tinyint(1) NOT NULL DEFAULT '0', menulevel1_id_1 int(11) NOT NULL DEFAULT '0', menulevel1_id_2 int(11) NOT NULL DEFAULT '0', menulevel1_id_3 int(11) NOT NULL DEFAULT '0', menulevel2_id_1 int(11) NOT NULL DEFAULT '0', menulevel2_id_2 int(11) NOT NULL DEFAULT '0', menulevel2_id_3 int(11) NOT NULL DEFAULT '0', menulevel3_id_1 int(11) NOT NULL DEFAULT '0', menulevel3_id_2 int(11) NOT NULL DEFAULT '0', menulevel3_id_3 int(11) NOT NULL DEFAULT '0', featured_product_id_1 int(11) NOT NULL DEFAULT '0', featured_product_id_2 int(11) NOT NULL DEFAULT '0', featured_product_id_3 int(11) NOT NULL DEFAULT '0', featured_product_id_4 int(11) NOT NULL DEFAULT '0', is_giftcard tinyint(1) NOT NULL DEFAULT 0, is_download tinyint(1) NOT NULL DEFAULT 0, is_donation tinyint(1) NOT NULL DEFAULT 0, is_special tinyint(1) NOT NULL DEFAULT 0, is_taxable tinyint(1) NOT NULL DEFAULT 1, is_shippable tinyint(1) NOT NULL DEFAULT 1, exclude_shippable_calculation tinyint(1) NOT NULL DEFAULT 0, is_subscription_item tinyint(1) NOT NULL DEFAULT 0, is_preorder tinyint(1) NOT NULL DEFAULT 0, role_id tinyint(1) NOT NULL DEFAULT 0, added_to_db_date timestamp NULL DEFAULT CURRENT_TIMESTAMP, show_on_startup tinyint(1) NOT NULL DEFAULT 0, use_optionitem_images tinyint(1) NOT NULL DEFAULT 0, use_optionitem_quantity_tracking tinyint(1) NOT NULL DEFAULT 0, views int(11) NOT NULL DEFAULT '0', last_viewed datetime NOT NULL DEFAULT '0000-00-00 00:00:00', show_stock_quantity tinyint(1) NOT NULL DEFAULT 1, maximum_downloads_allowed int(11) NOT NULL DEFAULT '0', download_timelimit_seconds int(11) NOT NULL DEFAULT '0', list_id varchar(50) NOT NULL DEFAULT '', edit_sequence varchar(55) NOT NULL DEFAULT '', quickbooks_status varchar(255) NOT NULL DEFAULT 'Not Queued', income_account_ref varchar(255) NOT NULL DEFAULT 'Online Sales', cogs_account_ref varchar(255) NOT NULL DEFAULT 'Cost of Goods Sold', asset_account_ref varchar(255) NOT NULL DEFAULT 'Inventory Asset', quickbooks_parent_name varchar(255) NOT NULL DEFAULT '', quickbooks_parent_list_id varchar(255) NOT NULL DEFAULT '', subscription_bill_length int(11) NOT NULL DEFAULT '1', subscription_bill_period varchar(20) NOT NULL DEFAULT 'M', subscription_bill_duration int(11) NOT NULL DEFAULT '0', subscription_shipping_recurring tinyint(1) NOT NULL DEFAULT '0', subscription_recurring_email tinyint(1) NOT NULL DEFAULT '1', trial_period_days int(11) NOT NULL DEFAULT '0', stripe_plan_added tinyint(1) NOT NULL DEFAULT 0, subscription_plan_id int(11) NOT NULL DEFAULT '0', allow_multiple_subscription_purchases tinyint(1) NOT NULL DEFAULT 1, membership_page varchar(255) NOT NULL DEFAULT '', is_amazon_download tinyint(1) NOT NULL DEFAULT 0, amazon_key varchar(1024) NOT NULL DEFAULT '', catalog_mode tinyint(1) NOT NULL DEFAULT 0, catalog_mode_phrase varchar(1024) DEFAULT NULL, inquiry_mode tinyint(1) NOT NULL DEFAULT 0, inquiry_url varchar(1024) DEFAULT NULL, is_deconetwork tinyint(1) NOT NULL DEFAULT 0, deconetwork_mode varchar(64) NOT NULL DEFAULT 'designer', deconetwork_product_id varchar(64) NOT NULL DEFAULT '', deconetwork_size_id varchar(64) NOT NULL DEFAULT '', deconetwork_color_id varchar(64) NOT NULL DEFAULT '', deconetwork_design_id varchar(64) NOT NULL DEFAULT '', short_description text NULL, display_type int(11) NOT NULL DEFAULT '1', image_hover_type int(11) NOT NULL DEFAULT '3', tag_type int(11) NOT NULL DEFAULT '0', tag_bg_color varchar(20) NOT NULL DEFAULT '', tag_text_color varchar(20) NOT NULL DEFAULT '', tag_text varchar(255) NOT NULL DEFAULT '', image_effect_type varchar(20) NOT NULL DEFAULT 'none', include_code tinyint(1) NOT NULL DEFAULT '0', TIC varchar(128) NOT NULL DEFAULT '00000', subscription_signup_fee float(15,3) NOT NULL DEFAULT '0.000', subscription_unique_id int(11) NOT NULL DEFAULT '0', subscription_prorate tinyint(1) NOT NULL DEFAULT '1', allow_backorders tinyint(1) NOT NULL DEFAULT '0', backorder_fill_date varchar(255) NOT NULL DEFAULT '', shipping_class_id int(11) NOT NULL DEFAULT '0', show_custom_price_range tinyint(1) NOT NULL DEFAULT '0', price_range_low float(15,3) NOT NULL DEFAULT '0.000', price_range_high float(15,3) NOT NULL DEFAULT '0.000', square_id varchar(255) NOT NULL DEFAULT '', square_variation_id varchar(255) NOT NULL DEFAULT '', login_for_pricing tinyint(1) NOT NULL DEFAULT '0', login_for_pricing_user_level varchar(255) NOT NULL DEFAULT '', login_for_pricing_label varchar(255) NOT NULL DEFAULT '', sort_position int(11) NOT NULL DEFAULT '0', shopify_id varchar(255) NOT NULL DEFAULT '', ship_to_billing tinyint(1) NOT NULL DEFAULT '0', shipping_restriction tinyint(1) NOT NULL DEFAULT '0', enable_price_label int(11) NOT NULL DEFAULT 0, replace_price_label int(11) NOT NULL DEFAULT 0, custom_price_label varchar(512) NOT NULL DEFAULT '', stripe_product_id varchar(255) DEFAULT '', stripe_product_id_sandbox varchar(255) DEFAULT '', stripe_default_price_id varchar(255) DEFAULT '', stripe_default_price_id_sandbox varchar(255) DEFAULT '', is_preorder_type tinyint(1) NOT NULL DEFAULT 0, is_restaurant_type tinyint(1) NOT NULL DEFAULT 0, pickup_locations text NULL, PRIMARY KEY (product_id), UNIQUE KEY product_product_id (product_id), UNIQUE KEY product_model_number (model_number($max_index_length)), KEY product_menulevel1_id_1 (menulevel1_id_1,menulevel2_id_1,menulevel3_id_1), KEY product_menulevel1_id_2 (menulevel1_id_2,menulevel2_id_2,menulevel3_id_2), KEY product_menulevel1_id_3 (menulevel1_id_3,menulevel2_id_3,menulevel3_id_3), KEY product_manufacturer_id (manufacturer_id), KEY product_option_id_1 (option_id_1), KEY product_option_id_2 (option_id_2), KEY product_option_id_3 (option_id_3), KEY product_option_id_4 (option_id_4), KEY product_option_id_5 (option_id_5), KEY idx_storefront_default (activate_in_store, role_id, sort_position), KEY idx_post_id (post_id) ) $collate; CREATE TABLE ec_product_google_attributes ( product_google_attribute_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT '0', attribute_value text, PRIMARY KEY (product_google_attribute_id), UNIQUE KEY product_google_attribute_id (product_google_attribute_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_product_subscriber ( product_subscriber_id int(11) NOT NULL AUTO_INCREMENT, email varchar(1024) NOT NULL DEFAULT '', product_id int(11) NOT NULL DEFAULT '0', status varchar(100) NOT NULL DEFAULT 'subscribed', last_notified datetime DEFAULT NULL, PRIMARY KEY (product_subscriber_id), UNIQUE KEY product_subscriber_id (product_subscriber_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_promocode ( promocode_id varchar($max_index_length) NOT NULL DEFAULT '', is_dollar_based tinyint(1) NOT NULL DEFAULT '0', is_percentage_based tinyint(1) NOT NULL DEFAULT '0', is_shipping_based tinyint(1) NOT NULL DEFAULT '0', is_free_item_based tinyint(1) NOT NULL DEFAULT '0', is_for_me_based tinyint(1) NOT NULL DEFAULT '0', is_bogo_based tinyint(1) NOT NULL DEFAULT '0', by_manufacturer_id tinyint(1) NOT NULL DEFAULT '0', by_category_id tinyint(1) NOT NULL DEFAULT '0', by_product_id tinyint(1) NOT NULL DEFAULT '0', by_all_products int(11) NOT NULL DEFAULT '0', promo_dollar float(15,3) NOT NULL DEFAULT '0.000', promo_percentage float(15,3) NOT NULL DEFAULT '0.000', promo_shipping float(15,3) NOT NULL DEFAULT '0.000', promo_free_item float(15,3) NOT NULL DEFAULT '0.000', promo_for_me float(15,3) NOT NULL DEFAULT '0.000', promo_bogo_dollar float(15,3) NOT NULL DEFAULT '0.000', promo_bogo_percentage float(15,3) NOT NULL DEFAULT '0.000', manufacturer_id int(11) NOT NULL DEFAULT '0', category_id int(11) NOT NULL DEFAULT '0', product_id int(11) NOT NULL DEFAULT '0', message blob NOT NULL, max_redemptions int(11) NOT NULL DEFAULT '999', times_redeemed int(11) NOT NULL DEFAULT '0', expiration_date datetime DEFAULT NULL, duration varchar(20) NOT NULL DEFAULT 'forever', duration_in_months int(11) NOT NULL DEFAULT '1', minimum_required int(11) NOT NULL DEFAULT '0', apply_to_shipping tinyint(1) NOT NULL DEFAULT '0', first_order_only tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (promocode_id), KEY promo_manufacturer_id (manufacturer_id), KEY promo_product_id (product_id) ) $collate; CREATE TABLE ec_promotion ( promotion_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL DEFAULT '', type int(11) NOT NULL DEFAULT '0', start_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00', end_date datetime DEFAULT '0000-00-00 00:00:00', product_id_1 int(11) NOT NULL DEFAULT '0', product_id_2 int(11) NOT NULL DEFAULT '0', product_id_3 int(11) NOT NULL DEFAULT '0', manufacturer_id_1 int(11) NOT NULL DEFAULT '0', manufacturer_id_2 int(11) NOT NULL DEFAULT '0', manufacturer_id_3 int(11) NOT NULL DEFAULT '0', category_id_1 int(11) NOT NULL DEFAULT '0', category_id_2 int(11) NOT NULL DEFAULT '0', category_id_3 int(11) NOT NULL DEFAULT '0', price1 float(15,3) NOT NULL DEFAULT '0.000', price2 float(15,3) NOT NULL DEFAULT '0.000', price3 float(15,3) NOT NULL DEFAULT '0.000', percentage1 float(15,3) NOT NULL DEFAULT '0.000', percentage2 float(15,3) NOT NULL DEFAULT '0.000', percentage3 float(15,3) NOT NULL DEFAULT '0.000', number1 int(11) NOT NULL DEFAULT '0', number2 int(11) NOT NULL DEFAULT '0', number3 int(11) NOT NULL DEFAULT '0', promo_limit int(11) NOT NULL DEFAULT '3', PRIMARY KEY (promotion_id), UNIQUE KEY promotion_promotion_id (promotion_id), KEY promotion_product_id_1 (product_id_1), KEY promotion_product_id_2 (product_id_2), KEY promotion_product_id_3 (product_id_3), KEY promotion_manufacturer_id_1 (manufacturer_id_1), KEY promotion_manufacturer_id_2 (manufacturer_id_2), KEY promotion_manufacturer_id_3 (manufacturer_id_3), KEY promotion_category_id_1 (category_id_1), KEY promotion_category_id_2 (category_id_2), KEY promotion_category_id_3 (category_id_3) ) $collate; CREATE TABLE ec_response ( response_id int(11) NOT NULL AUTO_INCREMENT, is_error tinyint(1) NOT NULL DEFAULT '0', processor varchar(255) DEFAULT NULL, order_id int(11) DEFAULT NULL, response_time timestamp NULL DEFAULT CURRENT_TIMESTAMP, response_text text, PRIMARY KEY (response_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_review ( review_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT '0', user_id int(11) NOT NULL DEFAULT '0', approved tinyint(1) NOT NULL DEFAULT '0', rating int(2) NOT NULL DEFAULT '0', title varchar(255) NOT NULL DEFAULT '', description mediumblob NOT NULL, date_submitted timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, reviewer_name varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (review_id), UNIQUE KEY review_id (review_id), KEY product_id (product_id), KEY user_id (user_id), KEY idx_product_approved (product_id, approved) ) $collate; CREATE TABLE ec_role ( role_id int(11) NOT NULL AUTO_INCREMENT, role_label varchar($max_index_length) NOT NULL DEFAULT '', admin_access tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (role_id), UNIQUE KEY role_id (role_id), KEY role_label (role_label) ) $collate; CREATE TABLE ec_roleaccess ( roleaccess_id int(11) NOT NULL AUTO_INCREMENT, role_label varchar($max_index_length) NOT NULL DEFAULT '', admin_panel varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (roleaccess_id), UNIQUE KEY roleaccess_id (roleaccess_id), KEY role_label (role_label) ) $collate; CREATE TABLE ec_roleprice ( roleprice_id int(11) NOT NULL AUTO_INCREMENT, product_id int(11) NOT NULL DEFAULT '0', role_label varchar($max_index_length) NOT NULL DEFAULT '', role_price float(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (roleprice_id), UNIQUE KEY roleprice_id (roleprice_id), KEY product_id (product_id), KEY role_label (role_label), KEY idx_product_role (product_id, role_label) ) $collate; CREATE TABLE ec_schedule ( schedule_id int(11) NOT NULL AUTO_INCREMENT, schedule_label varchar(255) DEFAULT '', day_of_week varchar(20) NOT NULL DEFAULT '', is_holiday tinyint(1) NOT NULL DEFAULT 1, holiday_date date DEFAULT NULL, apply_to_retail tinyint(1) NOT NULL DEFAULT 0, apply_to_preorder tinyint(1) NOT NULL DEFAULT 0, apply_to_restaurant tinyint(1) NOT NULL DEFAULT 0, retail_start varchar(32) NOT NULL DEFAULT '', retail_end varchar(32) NOT NULL DEFAULT '', preorder_start varchar(32) NOT NULL DEFAULT '', preorder_end varchar(32) NOT NULL DEFAULT '', preorder_open_time varchar(32) NOT NULL DEFAULT '', preorder_close_time varchar(32) NOT NULL DEFAULT '', restaurant_start varchar(32) NOT NULL DEFAULT '', restaurant_end varchar(32) NOT NULL DEFAULT '', retail_closed tinyint(1) NOT NULL DEFAULT 0, preorder_closed tinyint(1) NOT NULL DEFAULT 0, restaurant_closed tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (schedule_id), UNIQUE KEY schedule_id (schedule_id) ) $collate; CREATE TABLE ec_setting ( setting_id int(11) NOT NULL AUTO_INCREMENT, site_url varchar(255) NOT NULL DEFAULT '', reg_code varchar(255) NOT NULL DEFAULT '', storeversion varchar(20) NOT NULL DEFAULT '', storetype varchar(20) NOT NULL DEFAULT 'wordpress', storepage varchar(255) NOT NULL DEFAULT 'store', cartpage varchar(255) NOT NULL DEFAULT 'cart', accountpage varchar(255) NOT NULL DEFAULT 'account', timezone varchar(255) NOT NULL DEFAULT 'Europe/London', shipping_method varchar(255) NOT NULL DEFAULT 'method', shipping_expedite_rate float(11,2) NOT NULL DEFAULT '0.00', shipping_handling_rate float(11,2) NOT NULL DEFAULT '0.00', ups_access_license_number varchar(255) NOT NULL DEFAULT '', ups_user_id varchar(255) NOT NULL DEFAULT '', ups_password varchar(255) NOT NULL DEFAULT '', ups_ship_from_zip varchar(20) NOT NULL DEFAULT '', ups_shipper_number varchar(20) NOT NULL DEFAULT '', ups_country_code varchar(9) NOT NULL DEFAULT 'US', ups_weight_type varchar(19) NOT NULL DEFAULT 'LBS', ups_conversion_rate float(9,3) NOT NULL DEFAULT '1.000', usps_user_name varchar(255) NOT NULL DEFAULT '', usps_ship_from_zip varchar(20) NOT NULL DEFAULT '', fedex_key varchar(255) NOT NULL DEFAULT '', fedex_account_number varchar(255) NOT NULL DEFAULT '', fedex_meter_number varchar(255) NOT NULL DEFAULT '', fedex_password varchar(255) NOT NULL DEFAULT '', fedex_ship_from_zip varchar(255) NOT NULL DEFAULT '', fedex_weight_units varchar(20) NOT NULL DEFAULT 'LB', fedex_country_code varchar(20) NOT NULL DEFAULT 'US', fedex_conversion_rate float(9,3) NOT NULL DEFAULT '1.000', fedex_test_account tinyint(1) NOT NULL DEFAULT '0', auspost_api_key varchar(255) NOT NULL DEFAULT '', auspost_ship_from_zip varchar(55) NOT NULL DEFAULT '', dhl_site_id varchar(155) NOT NULL DEFAULT '', dhl_password varchar(155) NOT NULL DEFAULT '', dhl_ship_from_country varchar(25) NOT NULL DEFAULT 'US', dhl_ship_from_zip varchar(64) NOT NULL DEFAULT '', dhl_weight_unit varchar(20) NOT NULL DEFAULT 'LB', dhl_test_mode tinyint(1) NOT NULL DEFAULT '0', fraktjakt_customer_id varchar(64) NOT NULL DEFAULT '', fraktjakt_login_key varchar(64) NOT NULL DEFAULT '', fraktjakt_conversion_rate DOUBLE(15,3) NOT NULL DEFAULT '1.000', fraktjakt_test_mode tinyint(1) NOT NULL DEFAULT '0', fraktjakt_address varchar(120) NOT NULL DEFAULT '', fraktjakt_city varchar(55) NOT NULL DEFAULT '', fraktjakt_state varchar(2) NOT NULL DEFAULT '', fraktjakt_zip varchar(20) NOT NULL DEFAULT '', fraktjakt_country varchar(2) NOT NULL DEFAULT '', ups_ship_from_state varchar(2) NOT NULL DEFAULT '', ups_negotiated_rates tinyint(1) NOT NULL DEFAULT '0', canadapost_username varchar(255) NOT NULL DEFAULT '', canadapost_password varchar(255) NOT NULL DEFAULT '', canadapost_customer_number varchar(255) NOT NULL DEFAULT '', canadapost_contract_id varchar(255) NOT NULL DEFAULT '', canadapost_test_mode tinyint(1) NOT NULL DEFAULT '0', canadapost_ship_from_zip varchar(100) NOT NULL DEFAULT '', PRIMARY KEY (setting_id) ) $collate; CREATE TABLE ec_shipping_class ( shipping_class_id int(11) NOT NULL AUTO_INCREMENT, class_name varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (shipping_class_id) ) $collate; CREATE TABLE ec_shipping_class_to_rate ( shipping_class_to_rate_id int(11) NOT NULL AUTO_INCREMENT, shipping_class_id int(11) NOT NULL DEFAULT '0', shipping_rate_id int(11) NOT NULL DEFAULT '0', PRIMARY KEY (shipping_class_to_rate_id) ) $collate; CREATE TABLE ec_shippingrate ( shippingrate_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', zone_id int(11) NOT NULL DEFAULT '0', is_price_based tinyint(1) NOT NULL DEFAULT '0', is_weight_based tinyint(1) NOT NULL DEFAULT '0', is_method_based tinyint(1) NOT NULL DEFAULT '0', is_quantity_based tinyint(1) NOT NULL DEFAULT '0', is_percentage_based tinyint(1) NOT NULL DEFAULT '0', is_ups_based tinyint(1) NOT NULL DEFAULT '0', is_usps_based tinyint(1) NOT NULL DEFAULT '0', is_fedex_based tinyint(1) NOT NULL DEFAULT '0', is_auspost_based tinyint(1) NOT NULL DEFAULT '0', is_dhl_based tinyint(1) NOT NULL DEFAULT '0', is_canadapost_based tinyint(1) NOT NULL DEFAULT '0', trigger_rate float(15,3) NOT NULL DEFAULT '0.000', shipping_rate float(15,3) NOT NULL DEFAULT '0.000', shipping_label varchar(255) NOT NULL DEFAULT '', shipping_order int(11) NOT NULL DEFAULT '0', shipping_code varchar(255) NOT NULL DEFAULT '', shipping_override_rate float(11,3) NULL, free_shipping_at float(15,3) NOT NULL DEFAULT '-1.000', PRIMARY KEY (shippingrate_id), UNIQUE KEY shippingrate_id (shippingrate_id), KEY zone_id (zone_id) ) $collate; CREATE TABLE ec_state ( id_sta int(11) NOT NULL AUTO_INCREMENT, idcnt_sta int(11) NOT NULL DEFAULT '0', code_sta varchar($max_index_length) NOT NULL DEFAULT '', name_sta varchar(255) NOT NULL DEFAULT '', sort_order int(11) NOT NULL DEFAULT '0', group_sta varchar(255) NOT NULL DEFAULT '', ship_to_active tinyint(1) NOT NULL DEFAULT '1', PRIMARY KEY (id_sta), KEY idcnt_sta (idcnt_sta), KEY code_sta (code_sta) ) $collate; CREATE TABLE ec_subscriber ( subscriber_id int(11) NOT NULL AUTO_INCREMENT, email text NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (subscriber_id), UNIQUE KEY subscriber_email (email($max_index_length)) ) $collate; CREATE TABLE ec_subscription ( subscription_id int(11) NOT NULL AUTO_INCREMENT, subscription_type varchar(255) NOT NULL DEFAULT 'paypal', subscription_status varchar(255) NOT NULL DEFAULT 'Active', title text NOT NULL DEFAULT '', user_id int(11) NOT NULL DEFAULT '0', email text NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', user_country varchar(255) NOT NULL DEFAULT 'US', product_id int(11) NOT NULL DEFAULT '0', model_number varchar(510) NOT NULL DEFAULT '', price double(21,3) NOT NULL DEFAULT '0.000', payment_length int(11) NOT NULL DEFAULT '1', payment_period varchar(255) NOT NULL DEFAULT '', payment_duration int(11) NOT NULL DEFAULT '0', start_date timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, last_payment_date varchar(255) NOT NULL DEFAULT '', next_payment_date varchar(255) NOT NULL DEFAULT '', number_payments_completed int(11) NOT NULL DEFAULT '1', paypal_txn_id varchar(255) NOT NULL DEFAULT '', paypal_txn_type varchar(255) NOT NULL DEFAULT '', paypal_subscr_id varchar(255) NOT NULL DEFAULT '', paypal_username varchar(255) NOT NULL DEFAULT '', paypal_password varchar(255) NOT NULL DEFAULT '', stripe_subscription_id varchar(255) NOT NULL DEFAULT '', quantity int(11) NOT NULL DEFAULT '1', num_failed_payment int(11) NOT NULL DEFAULT '0', PRIMARY KEY (subscription_id), UNIQUE KEY subscription_id (subscription_id), KEY user_id (user_id), KEY product_id (product_id) ) $collate; CREATE TABLE ec_subscription_plan ( subscription_plan_id int(11) NOT NULL AUTO_INCREMENT, plan_title varchar(255) NOT NULL DEFAULT '', can_downgrade tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (subscription_plan_id) ) $collate; CREATE TABLE ec_taxrate ( taxrate_id int(11) NOT NULL AUTO_INCREMENT, tax_by_state tinyint(1) NOT NULL DEFAULT '0', tax_by_country tinyint(1) NOT NULL DEFAULT '0', tax_by_duty tinyint(1) NOT NULL DEFAULT '0', tax_by_vat tinyint(1) NOT NULL DEFAULT '0', tax_by_single_vat tinyint(1) NOT NULL DEFAULT '0', tax_by_all tinyint(1) NOT NULL DEFAULT '0', state_rate float(15,3) NOT NULL DEFAULT '0.000', country_rate float(15,3) NOT NULL DEFAULT '0.000', duty_rate float(15,3) NOT NULL DEFAULT '0.000', vat_rate float(15,3) NOT NULL DEFAULT '0.000', vat_added tinyint(1) NOT NULL DEFAULT '0', vat_included tinyint(1) NOT NULL DEFAULT '0', all_rate float(15,3) NOT NULL DEFAULT '0.000', state_code varchar(50) NOT NULL DEFAULT '', country_code varchar(50) NOT NULL DEFAULT '', vat_country_code varchar(50) NOT NULL DEFAULT '', duty_exempt_country_code varchar(50) NOT NULL DEFAULT '', stripe_taxrate_id varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (taxrate_id), UNIQUE KEY taxrate_id (taxrate_id), KEY state_code (state_code), KEY country_code (country_code), KEY vat_country_code (vat_country_code), KEY duty_exempt_country_code (duty_exempt_country_code) ) $collate; CREATE TABLE ec_tempcart ( tempcart_id int(11) NOT NULL AUTO_INCREMENT, session_id varchar(100) DEFAULT NULL, product_id int(11) NOT NULL DEFAULT '0', quantity int(11) DEFAULT '0', grid_quantity int(11) DEFAULT '0', gift_card_message blob, gift_card_from_name varchar(255) DEFAULT NULL, gift_card_to_name varchar(255) DEFAULT NULL, optionitem_id_1 int(11) NOT NULL DEFAULT '0', optionitem_id_2 int(11) NOT NULL DEFAULT '0', optionitem_id_3 int(11) NOT NULL DEFAULT '0', optionitem_id_4 int(11) NOT NULL DEFAULT '0', optionitem_id_5 int(11) NOT NULL DEFAULT '0', donation_price float(15,3) NOT NULL DEFAULT '0.000', last_changed_date timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP DEFAULT CURRENT_TIMESTAMP, is_deconetwork tinyint(1) NOT NULL DEFAULT '0', deconetwork_id varchar(64) NOT NULL DEFAULT '', deconetwork_name varchar(255) NOT NULL DEFAULT '', deconetwork_product_code varchar(64) NOT NULL DEFAULT '', deconetwork_options varchar(255) NOT NULL DEFAULT '', deconetwork_edit_link varchar(255) NOT NULL DEFAULT '', deconetwork_color_code varchar(64) NOT NULL DEFAULT '', deconetwork_product_id varchar(64) NOT NULL DEFAULT '', deconetwork_image_link varchar(255) NOT NULL DEFAULT '', deconetwork_discount float(15,3) NOT NULL DEFAULT '0.000', deconetwork_tax float(15,3) NOT NULL DEFAULT '0.000', deconetwork_total float(15,3) NOT NULL DEFAULT '0.000', deconetwork_version int(11) NOT NULL DEFAULT '1', gift_card_email varchar(255) NOT NULL DEFAULT '', abandoned_cart_email_sent int(11) NOT NULL DEFAULT '0', hide_from_admin tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (tempcart_id), UNIQUE KEY tempcart_tempcart_id (tempcart_id), KEY tempcart_session_id (session_id), KEY tempcart_product_id (product_id), KEY tempcart_optionitem_id_1 (optionitem_id_1), KEY tempcart_optionitem_id_2 (optionitem_id_2), KEY tempcart_optionitem_id_3 (optionitem_id_3), KEY tempcart_optionitem_id_4 (optionitem_id_4), KEY tempcart_optionitem_id_5 (optionitem_id_5) ) $collate; CREATE TABLE ec_tempcart_data ( tempcart_data_id int(11) NOT NULL AUTO_INCREMENT, tempcart_time timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, session_id varchar(100) NOT NULL DEFAULT '', user_id varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', username varchar(255) NOT NULL DEFAULT '', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', tip_amount float(15,3) NOT NULL DEFAULT '0.000', tip_rate varchar(10) NOT NULL DEFAULT '0.000', coupon_code varchar(255) NOT NULL DEFAULT '', giftcard varchar(255) NOT NULL DEFAULT '', billing_first_name varchar(255) NOT NULL DEFAULT '', billing_last_name varchar(255) NOT NULL DEFAULT '', billing_company_name varchar(255) NOT NULL DEFAULT '', billing_address_line_1 varchar(255) NOT NULL DEFAULT '', billing_address_line_2 varchar(255) NOT NULL DEFAULT '', billing_city varchar(255) NOT NULL DEFAULT '', billing_state varchar(255) NOT NULL DEFAULT '', billing_zip varchar(255) NOT NULL DEFAULT '', billing_country varchar(255) NOT NULL DEFAULT '', billing_phone varchar(255) NOT NULL DEFAULT '', shipping_selector varchar(255) NOT NULL DEFAULT '', shipping_first_name varchar(255) NOT NULL DEFAULT '', shipping_last_name varchar(255) NOT NULL DEFAULT '', shipping_company_name varchar(255) NOT NULL DEFAULT '', shipping_address_line_2 varchar(255) NOT NULL DEFAULT '', shipping_address_line_1 varchar(255) NOT NULL DEFAULT '', shipping_city varchar(255) NOT NULL DEFAULT '', shipping_state varchar(255) NOT NULL DEFAULT '', shipping_zip varchar(255) NOT NULL DEFAULT '', shipping_country varchar(255) NOT NULL DEFAULT '', shipping_phone varchar(255) NOT NULL DEFAULT '', create_account varchar(255) NOT NULL DEFAULT '', order_notes text, shipping_method varchar(255) NOT NULL DEFAULT '', estimate_shipping_zip varchar(255) NOT NULL DEFAULT '', expedited_shipping varchar(255) NOT NULL DEFAULT '', estimate_shipping_country varchar(255) NOT NULL DEFAULT '', is_guest varchar(255) NOT NULL DEFAULT '', guest_key varchar(255) NOT NULL DEFAULT '', subscription_option1 text, subscription_option2 text, subscription_option3 text, subscription_option4 text, subscription_option5 text, subscription_advanced_option text, subscription_quantity varchar(255) NOT NULL DEFAULT '', convert_to varchar(255) NOT NULL DEFAULT '', translate_to varchar(255) NOT NULL DEFAULT '', taxcloud_tax_amount varchar(255) NOT NULL DEFAULT '', taxcloud_address_last_verified text, taxcloud_address_verified tinyint(1) NOT NULL DEFAULT '0', taxjar_tax_amount varchar(255) NOT NULL DEFAULT '', taxjar_address_verified tinyint(1) NOT NULL DEFAULT '0', perpage varchar(255) NOT NULL DEFAULT '', vat_registration_number varchar(255) NOT NULL DEFAULT '', card_error varchar(255) NOT NULL DEFAULT '', payment_type varchar(255) NOT NULL DEFAULT '', payment_method varchar(255) NOT NULL DEFAULT '', stripe_paymentintent_id varchar(255) NOT NULL DEFAULT '', stripe_pi_client_secret varchar(255) NOT NULL DEFAULT '', amazon_session_id varchar(255) NOT NULL DEFAULT '', amazon_buyer_id varchar(255) NOT NULL DEFAULT '', amazon_payment_selection varchar(255) NOT NULL DEFAULT '', email_other varchar(255) NOT NULL DEFAULT '', stripe_last_pi_data text, pickup_date varchar(32) NOT NULL DEFAULT '', pickup_asap tinyint(1) NOT NULL DEFAULT 1, pickup_time varchar(32) NOT NULL DEFAULT '', pickup_location int(11) NOT NULL DEFAULT 0, PRIMARY KEY (tempcart_data_id) ) $collate; CREATE TABLE ec_tempcart_optionitem ( tempcart_optionitem_id int(11) NOT NULL AUTO_INCREMENT, tempcart_id int(11) NOT NULL DEFAULT '0', option_id int(11) NOT NULL DEFAULT '0', optionitem_id int(11) NOT NULL DEFAULT '0', optionitem_value text NOT NULL, session_id varchar(100) NOT NULL DEFAULT '', optionitem_model_number text NOT NULL DEFAULT '', PRIMARY KEY (tempcart_optionitem_id), UNIQUE KEY tempcart_optionitem_id (tempcart_optionitem_id), KEY tempcart_id (tempcart_id), KEY option_id (option_id), KEY optionitem_id (optionitem_id), KEY session_id (session_id) ) $collate; CREATE TABLE ec_timezone ( timezone_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255) NOT NULL DEFAULT '', identifier varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (timezone_id), UNIQUE KEY timezone_id (timezone_id) ) $collate; CREATE TABLE ec_user ( user_id int(11) NOT NULL AUTO_INCREMENT, is_demo_item tinyint(1) NOT NULL DEFAULT '0', email varchar(255) NOT NULL DEFAULT '', password varchar(255) NOT NULL DEFAULT '', list_id varchar(255) NOT NULL DEFAULT '', edit_sequence varchar(255) NOT NULL DEFAULT '', quickbooks_status varchar(255) NOT NULL DEFAULT 'Not Queued', first_name varchar(255) NOT NULL DEFAULT '', last_name varchar(255) NOT NULL DEFAULT '', default_billing_address_id int(11) NOT NULL DEFAULT '0', default_shipping_address_id int(11) NOT NULL DEFAULT '0', user_level varchar(255) NOT NULL DEFAULT 'shopper', is_subscriber tinyint(1) NOT NULL DEFAULT '0', realauth_registered tinyint(1) NOT NULL DEFAULT '0', stripe_customer_id varchar(255) NOT NULL DEFAULT '', default_card_type varchar(255) NOT NULL DEFAULT '', default_card_last4 varchar(255) NOT NULL DEFAULT '', exclude_tax tinyint(1) NOT NULL DEFAULT '0', exclude_shipping tinyint(1) NOT NULL DEFAULT '0', user_notes text, vat_registration_number varchar(255) NOT NULL DEFAULT '', email_other varchar(255) NOT NULL DEFAULT '', allow_shipping_bypass tinyint(1) NOT NULL DEFAULT 0, is_stripe_test_user tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (user_id), UNIQUE KEY user_user_id (user_id), UNIQUE KEY user_email (email($max_index_length)), KEY user_password (password($max_index_length)), KEY user_default_billing_address_id (default_billing_address_id), KEY user_default_shipping_address_id (default_shipping_address_id), KEY user_user_level (user_level($max_index_length)) ) $collate; CREATE TABLE ec_webhook ( webhook_id varchar($max_index_length) NOT NULL, webhook_type varchar(128) NOT NULL DEFAULT '', webhook_data blob, PRIMARY KEY (webhook_id), UNIQUE KEY webhook_id (webhook_id) ) $collate; CREATE TABLE ec_zone ( zone_id int(11) NOT NULL AUTO_INCREMENT, zone_name varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (zone_id) ) $collate; CREATE TABLE ec_zone_to_location ( zone_to_location_id int(11) NOT NULL AUTO_INCREMENT, zone_id int(11) NOT NULL DEFAULT '0', iso2_cnt varchar(20) NOT NULL DEFAULT '', code_sta varchar(50) NOT NULL DEFAULT '', PRIMARY KEY (zone_to_location_id) ) $collate;\"; return $schema; } public function install_base_data( ){ global $wpdb; $wpdb->insert( \"ec_setting\", array( \"setting_id\" => \"1\", \"site_url\" => \"\", \"reg_code\" => \"\", \"storeversion\" => \"1.0.0\", \"storetype\" => \"wordpress\", \"storepage\" => \"6\", \"cartpage\" => \"7\", \"accountpage\" => \"8\", \"timezone\" => \"America/Los_Angeles\", \"shipping_method\" => \"price\", \"shipping_expedite_rate\" => \"0\", \"shipping_handling_rate\" => \"0\", \"ups_access_license_number\" => \"\", \"ups_user_id\" => \"\", \"ups_password\" => \"\", \"ups_ship_from_zip\" => \"\", \"ups_shipper_number\" => \"\", \"ups_country_code\" => \"\", \"ups_weight_type\" => \"\", \"ups_conversion_rate\" => \"1.000\", \"usps_user_name\" => \"\", \"usps_ship_from_zip\" => \"\", \"fedex_key\" => \"\", \"fedex_account_number\" => \"\", \"fedex_meter_number\" => \"\", \"fedex_password\" => \"\", \"fedex_ship_from_zip\" => \"\", \"fedex_weight_units\" => \"LB\", \"fedex_country_code\" => \"US\", \"fedex_conversion_rate\" => \"1.000\", \"fedex_test_account\" => \"0\", \"auspost_api_key\" => \"\", \"auspost_ship_from_zip\" => \"\", \"dhl_site_id\" => \"\", \"dhl_password\" => \"\", \"dhl_ship_from_country\" => \"\", \"dhl_ship_from_zip\" => \"\", \"dhl_weight_unit\" => \"\", \"dhl_test_mode\" => \"0\", \"fraktjakt_customer_id\" => \"\", \"fraktjakt_login_key\" => \"\", \"fraktjakt_conversion_rate\" => \"1.000\", \"fraktjakt_test_mode\" => \"0\" ) );"},{"table_name":"ec_fee","full_table_name":"wp_ec_fee","description":"Stores ec fee data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"fee_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"fee_label","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"fee_admin_description","type":"text","nullable":true,"primary_key":false},{"name":"fee_country","type":"text","nullable":true,"primary_key":false},{"name":"fee_state","type":"text","nullable":true,"primary_key":false},{"name":"fee_zip","type":"text","nullable":true,"primary_key":false},{"name":"fee_city","type":"text","nullable":true,"primary_key":false},{"name":"fee_category","type":"text","nullable":true,"primary_key":false},{"name":"fee_role","type":"text","nullable":true,"primary_key":false},{"name":"fee_zone","type":"text","nullable":true,"primary_key":false},{"name":"fee_type","type":"int(11)","nullable":false,"primary_key":false},{"name":"fee_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_price","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_min","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_max","type":"float(15,3)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_fee ( fee_id int(11) NOT NULL AUTO_INCREMENT, fee_label varchar(512) NOT NULL DEFAULT '', fee_admin_description text, fee_country text, fee_state text, fee_zip text, fee_city text, fee_category text, fee_role text, fee_zone text, fee_type int(11) NOT NULL DEFAULT '1', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_price float(15,3) NOT NULL DEFAULT '0.000', fee_min float(15,3) NOT NULL DEFAULT '0.000', fee_max float(15,3) NOT NULL DEFAULT '-1.000', PRIMARY KEY (fee_id) ) $collate;\" );"},{"table_name":"ec_location","full_table_name":"wp_ec_location","description":"Stores ec location data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"location_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"location_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"address_line_1","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"address_line_2","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"city","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"state","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"country","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"zip","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"phone","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"email","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"latitude","type":"decimal(9,6)","nullable":true,"primary_key":false},{"name":"longitude","type":"decimal(9,6)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE ec_location ( location_id int(11) NOT NULL AUTO_INCREMENT, location_label varchar(255) DEFAULT '', address_line_1 varchar(255) NOT NULL DEFAULT '', address_line_2 varchar(255) NOT NULL DEFAULT '', city varchar(255) NOT NULL DEFAULT '', state varchar(255) NOT NULL DEFAULT '', country varchar(255) NOT NULL DEFAULT '', zip varchar(255) NOT NULL DEFAULT '', phone varchar(255) NOT NULL DEFAULT '', email varchar(255) NOT NULL DEFAULT '', latitude decimal(9,6) DEFAULT NULL, longitude decimal(9,6) DEFAULT NULL, PRIMARY KEY (location_id), UNIQUE KEY location_id (location_id) ) $collate;\" );"},{"table_name":"ec_location_to_product","full_table_name":"wp_ec_location_to_product","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"location_product_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"product_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_location_to_product ( location_product_id int(11) NOT NULL AUTO_INCREMENT, location_id int(11) NOT NULL DEFAULT 0, product_id int(11) NOT NULL DEFAULT 0, PRIMARY KEY (location_product_id), UNIQUE KEY location_product_id (location_product_id), KEY location_id (location_id), KEY product_id (product_id) ) $collate;\" );"},{"table_name":"ec_location_to_schedule","full_table_name":"wp_ec_location_to_schedule","description":"Stores ec location to schedule data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"location_schedule_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"location_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"schedule_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_location_to_schedule ( location_schedule_id int(11) NOT NULL AUTO_INCREMENT, location_id int(11) NOT NULL DEFAULT 0, schedule_id int(11) NOT NULL DEFAULT 0, PRIMARY KEY (location_schedule_id), UNIQUE KEY location_schedule_id (location_schedule_id), KEY location_id (location_id), KEY product_id (schedule_id) ) $collate;\" );"},{"table_name":"ec_order_fee","full_table_name":"wp_ec_order_fee","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[{"name":"order_fee_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"fee_label","type":"varchar(512)","nullable":false,"primary_key":false},{"name":"fee_rate","type":"float(15,3)","nullable":false,"primary_key":false},{"name":"fee_total","type":"float(15,3)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_order_fee ( order_fee_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', fee_label varchar(512) NOT NULL DEFAULT '', fee_rate float(15,3) NOT NULL DEFAULT '0.000', fee_total float(15,3) NOT NULL DEFAULT '0.000', PRIMARY KEY (order_fee_id), KEY order_id (order_id) ) $collate;\" );"},{"table_name":"ec_order_log","full_table_name":"wp_ec_order_log","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"order_log_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_timestamp","type":"timestamp","nullable":true,"primary_key":false},{"name":"order_log_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"order_log_meta_key","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"order_log_meta_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE ec_order_log ( order_log_id int(11) NOT NULL AUTO_INCREMENT, order_id int(11) NOT NULL DEFAULT '0', order_log_key varchar(100) NOT NULL DEFAULT '', order_log_timestamp timestamp NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (order_log_id), UNIQUE KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate; CREATE TABLE ec_order_log_meta ( order_log_meta_id int(11) NOT NULL AUTO_INCREMENT, order_log_id int(11) NOT NULL DEFAULT '0', order_id int(11) NOT NULL DEFAULT '0', order_log_meta_key varchar(100) NOT NULL DEFAULT '', order_log_meta_value text, PRIMARY KEY (order_log_meta_id), UNIQUE KEY order_log_meta_id (order_log_meta_id), KEY order_log_id (order_log_id), KEY order_id (order_id) ) $collate;\" );"},{"table_name":"ec_schedule","full_table_name":"wp_ec_schedule","description":"Stores ec schedule data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"schedule_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"schedule_label","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"day_of_week","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"is_holiday","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"holiday_date","type":"date","nullable":true,"primary_key":false},{"name":"apply_to_retail","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_preorder","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"apply_to_restaurant","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"retail_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_open_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"preorder_close_time","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_start","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"restaurant_end","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"retail_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"preorder_closed","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"restaurant_closed","type":"tinyint(1)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE ec_schedule ( schedule_id int(11) NOT NULL AUTO_INCREMENT, schedule_label varchar(255) DEFAULT '', day_of_week varchar(20) NOT NULL DEFAULT '', is_holiday tinyint(1) NOT NULL DEFAULT 1, holiday_date date DEFAULT NULL, apply_to_retail tinyint(1) NOT NULL DEFAULT 0, apply_to_preorder tinyint(1) NOT NULL DEFAULT 0, apply_to_restaurant tinyint(1) NOT NULL DEFAULT 0, retail_start varchar(32) NOT NULL DEFAULT '', retail_end varchar(32) NOT NULL DEFAULT '', preorder_start varchar(32) NOT NULL DEFAULT '', preorder_end varchar(32) NOT NULL DEFAULT '', preorder_open_time varchar(32) NOT NULL DEFAULT '', preorder_close_time varchar(32) NOT NULL DEFAULT '', restaurant_start varchar(32) NOT NULL DEFAULT '', restaurant_end varchar(32) NOT NULL DEFAULT '', retail_closed tinyint(1) NOT NULL DEFAULT 0, preorder_closed tinyint(1) NOT NULL DEFAULT 0, restaurant_closed tinyint(1) NOT NULL DEFAULT 0, PRIMARY KEY (schedule_id), UNIQUE KEY schedule_id (schedule_id) ) $collate;\" );"}],"table_count":8}