Drop files here

SQL upload ( 0 ) x -

Page-related settings Click on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Untitled *
v Show/Hide tables list View in fullscreen Add tables from other databases New page Open page Save page Save page as Delete pages Create table Create relationship Choose column to display Reload Help Angular links / Direct links Snap to grid v Small/Big All Toggle small/big Toggle relationship lines Export schema > Move Menu > Pin text
v v
Number of tables: 0
v prestashop q2duq_access
* id_profile : int(10) unsigned
* id_authorization_role : int(10) unsigned
v prestashop q2duq_accessory
* id_product_1 : int(10) unsigned
* id_product_2 : int(10) unsigned
v prestashop q2duq_address
* id_address : int(10) unsigned
* id_country : int(10) unsigned
* id_state : int(10) unsigned
* id_customer : int(10) unsigned
* id_manufacturer : int(10) unsigned
* id_supplier : int(10) unsigned
* id_warehouse : int(10) unsigned
* alias : varchar(32)
* company : varchar(255)
* lastname : varchar(255)
* firstname : varchar(255)
* address1 : varchar(128)
* address2 : varchar(128)
* postcode : varchar(12)
* city : varchar(64)
* other : mediumtext
* phone : varchar(32)
* phone_mobile : varchar(32)
* vat_number : varchar(32)
* dni : varchar(16)
* date_add : datetime
* date_upd : datetime
* active : tinyint(1) unsigned
* deleted : tinyint(1) unsigned
v prestashop q2duq_address_format
* id_country : int(10) unsigned
* format : varchar(255)
v prestashop q2duq_admin_filter
* id : int(11)
* employee : int(11)
* shop : int(11)
* controller : varchar(60)
* action : varchar(100)
* filter : longtext
* filter_id : varchar(191)
v prestashop q2duq_alias
* id_alias : int(10) unsigned
* alias : varchar(191)
* search : varchar(255)
* active : tinyint(1)
v prestashop q2duq_api_client
* id_api_client : int(10) unsigned
* client_id : varchar(255)
* client_name : varchar(255)
* client_secret : varchar(255)
* enabled : tinyint(1)
* scopes : longtext
* description : varchar(255)
* external_issuer : varchar(255)
* lifetime : int(11)
v prestashop q2duq_attachment
* id_attachment : int(10) unsigned
* file : varchar(40)
* file_name : varchar(255)
* file_size : bigint(10) unsigned
* mime : varchar(128)
v prestashop q2duq_attachment_lang
* id_attachment : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(255)
* description : mediumtext
v prestashop q2duq_attribute
* id_attribute : int(11)
* id_attribute_group : int(11)
* color : varchar(32)
* position : int(11)
v prestashop q2duq_attribute_group
* id_attribute_group : int(11)
* is_color_group : tinyint(1)
* group_type : varchar(255)
* position : int(11)
v prestashop q2duq_attribute_group_lang
* id_attribute_group : int(11)
* id_lang : int(11)
* name : varchar(128)
* public_name : varchar(64)
v prestashop q2duq_attribute_group_shop
* id_attribute_group : int(11)
* id_shop : int(11)
v prestashop q2duq_attribute_lang
* id_attribute : int(11)
* id_lang : int(11)
* name : varchar(128)
v prestashop q2duq_attribute_shop
* id_attribute : int(11)
* id_shop : int(11)
v prestashop q2duq_authorization_role
* id_authorization_role : int(10) unsigned
* slug : varchar(191)
v prestashop q2duq_blockwishlist_statistics
* id_statistics : int(10) unsigned
* id_cart : int(10) unsigned
* id_product : int(10) unsigned
* id_product_attribute : int(10) unsigned
* date_add : datetime
* id_shop : int(10) unsigned
v prestashop q2duq_carrier
* id_carrier : int(10) unsigned
* id_reference : int(10) unsigned
* name : varchar(64)
* url : varchar(255)
* active : tinyint(1) unsigned
* deleted : tinyint(1) unsigned
* shipping_handling : tinyint(1) unsigned
* range_behavior : tinyint(1) unsigned
* is_module : tinyint(1) unsigned
* is_free : tinyint(1) unsigned
* shipping_external : tinyint(1) unsigned
* need_range : tinyint(1) unsigned
* external_module_name : varchar(64)
* shipping_method : int(2)
* position : int(10) unsigned
* max_width : int(10)
* max_height : int(10)
* max_depth : int(10)
* max_weight : decimal(20,6)
* grade : int(10)
v prestashop q2duq_carrier_group
* id_carrier : int(10) unsigned
* id_group : int(10) unsigned
v prestashop q2duq_carrier_lang
* id_carrier : int(10) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* delay : varchar(512)
v prestashop q2duq_carrier_shop
* id_carrier : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_carrier_tax_rules_group_shop
* id_carrier : int(11) unsigned
* id_tax_rules_group : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_carrier_zone
* id_carrier : int(10) unsigned
* id_zone : int(10) unsigned
v prestashop q2duq_cart
* id_cart : int(10) unsigned
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* id_carrier : int(10) unsigned
* delivery_option : mediumtext
* id_lang : int(10) unsigned
* id_address_delivery : int(10) unsigned
* id_address_invoice : int(10) unsigned
* id_currency : int(10) unsigned
* id_customer : int(10) unsigned
* id_guest : int(10) unsigned
* secure_key : varchar(32)
* recyclable : tinyint(1) unsigned
* gift : tinyint(1) unsigned
* gift_message : mediumtext
* mobile_theme : tinyint(1)
* allow_seperated_package : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
* checkout_session_data : mediumtext
v prestashop q2duq_cart_cart_rule
* id_cart : int(10) unsigned
* id_cart_rule : int(10) unsigned
v prestashop q2duq_cart_product
* id_cart : int(10) unsigned
* id_product : int(10) unsigned
* id_address_delivery : int(10) unsigned
* id_shop : int(10) unsigned
* id_product_attribute : int(10) unsigned
* id_customization : int(10) unsigned
* quantity : int(10) unsigned
* date_add : datetime
v prestashop q2duq_cart_rule
* id_cart_rule : int(10) unsigned
* id_customer : int(10) unsigned
* date_from : datetime
* date_to : datetime
* description : mediumtext
* quantity : int(10) unsigned
* quantity_per_user : int(10) unsigned
* priority : int(10) unsigned
* partial_use : tinyint(1) unsigned
* code : varchar(254)
* minimum_amount : decimal(20,6)
* minimum_amount_tax : tinyint(1)
* minimum_amount_currency : int(10) unsigned
* minimum_amount_shipping : tinyint(1)
* country_restriction : tinyint(1) unsigned
* carrier_restriction : tinyint(1) unsigned
* group_restriction : tinyint(1) unsigned
* cart_rule_restriction : tinyint(1) unsigned
* product_restriction : tinyint(1) unsigned
* shop_restriction : tinyint(1) unsigned
* free_shipping : tinyint(1)
* reduction_percent : decimal(5,2)
* reduction_amount : decimal(20,6)
* reduction_tax : tinyint(1) unsigned
* reduction_currency : int(10) unsigned
* reduction_product : int(10)
* reduction_exclude_special : tinyint(1) unsigned
* gift_product : int(10) unsigned
* gift_product_attribute : int(10) unsigned
* highlight : tinyint(1) unsigned
* active : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
* id_cart_rule_type : int(10) unsigned
* minimum_product_quantity : int(10) unsigned
v prestashop q2duq_cart_rule_carrier
* id_cart_rule : int(10) unsigned
* id_carrier : int(10) unsigned
v prestashop q2duq_cart_rule_combination
* id_cart_rule_1 : int(10) unsigned
* id_cart_rule_2 : int(10) unsigned
v prestashop q2duq_cart_rule_compatible_types
* id_cart_rule : int(10) unsigned
* id_cart_rule_type : int(10) unsigned
v prestashop q2duq_cart_rule_country
* id_cart_rule : int(10) unsigned
* id_country : int(10) unsigned
v prestashop q2duq_cart_rule_group
* id_cart_rule : int(10) unsigned
* id_group : int(10) unsigned
v prestashop q2duq_cart_rule_lang
* id_cart_rule : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(254)
v prestashop q2duq_cart_rule_product_rule
* id_product_rule : int(10) unsigned
* id_product_rule_group : int(10) unsigned
* type : enum('products','categories','attributes','manufacturers','suppliers','combinations','features')
v prestashop q2duq_cart_rule_product_rule_group
* id_product_rule_group : int(10) unsigned
* id_cart_rule : int(10) unsigned
* quantity : int(10) unsigned
* type : enum('at_least_one_product_rule','all_product_rules')
v prestashop q2duq_cart_rule_product_rule_value
* id_product_rule : int(10) unsigned
* id_item : int(10) unsigned
v prestashop q2duq_cart_rule_shop
* id_cart_rule : int(10) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_cart_rule_type
* id_cart_rule_type : int(10) unsigned
* discount_type : varchar(128)
* is_core : tinyint(1) unsigned
* active : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_cart_rule_type_lang
* id_cart_rule_type : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(254)
* description : text
v prestashop q2duq_category
* id_category : int(10) unsigned
* id_parent : int(10) unsigned
* id_shop_default : int(10) unsigned
* level_depth : tinyint(3) unsigned
* nleft : int(10) unsigned
* nright : int(10) unsigned
* active : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
* redirect_type : enum('404','410','301','302')
* id_type_redirected : int(10) unsigned
* position : int(10) unsigned
* is_root_category : tinyint(1)
v prestashop q2duq_category_group
* id_category : int(10) unsigned
* id_group : int(10) unsigned
v prestashop q2duq_category_lang
* id_category : int(10) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* name : varchar(128)
* description : mediumtext
* additional_description : mediumtext
* meta_title : varchar(255)
* meta_description : varchar(512)
v prestashop q2duq_category_product
* id_category : int(10) unsigned
* id_product : int(10) unsigned
* position : int(10) unsigned
v prestashop q2duq_category_shop
* id_category : int(11)
* id_shop : int(11)
* position : int(10) unsigned
v prestashop q2duq_cms
* id_cms : int(10) unsigned
* id_cms_category : int(10) unsigned
* position : int(10) unsigned
* active : tinyint(1) unsigned
* indexation : tinyint(1) unsigned
v prestashop q2duq_cms_category
* id_cms_category : int(10) unsigned
* id_parent : int(10) unsigned
* level_depth : tinyint(3) unsigned
* active : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
* position : int(10) unsigned
v prestashop q2duq_cms_category_lang
* id_cms_category : int(10) unsigned
* id_lang : int(10) unsigned
* id_shop : int(10) unsigned
* name : varchar(128)
* description : mediumtext
* meta_title : varchar(255)
* meta_description : varchar(512)
v prestashop q2duq_cms_category_shop
* id_cms_category : int(10) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_cms_lang
* id_cms : int(10) unsigned
* id_lang : int(10) unsigned
* id_shop : int(10) unsigned
* meta_title : varchar(255)
* head_seo_title : varchar(255)
* meta_description : varchar(512)
* content : longtext
v prestashop q2duq_cms_role
* id_cms_role : int(11) unsigned
* name : varchar(50)
* id_cms : int(11) unsigned
v prestashop q2duq_cms_role_lang
* id_cms_role : int(11) unsigned
* id_lang : int(11) unsigned
* id_shop : int(11) unsigned
* name : varchar(128)
v prestashop q2duq_cms_shop
* id_cms : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_configuration
* id_configuration : int(10) unsigned
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* name : varchar(254)
* value : mediumtext
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_configuration_kpi
* id_configuration_kpi : int(10) unsigned
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* name : varchar(64)
* value : mediumtext
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_configuration_kpi_lang
* id_configuration_kpi : int(10) unsigned
* id_lang : int(10) unsigned
* value : mediumtext
* date_upd : datetime
v prestashop q2duq_configuration_lang
* id_configuration : int(10) unsigned
* id_lang : int(10) unsigned
* value : mediumtext
* date_upd : datetime
v prestashop q2duq_connections
* id_connections : int(10) unsigned
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* id_guest : int(10) unsigned
* id_page : int(10) unsigned
* ip_address : bigint(20)
* date_add : datetime
* http_referer : varchar(255)
v prestashop q2duq_connections_page
* id_connections : int(10) unsigned
* id_page : int(10) unsigned
* time_start : datetime
* time_end : datetime
v prestashop q2duq_connections_source
* id_connections_source : int(10) unsigned
* id_connections : int(10) unsigned
* http_referer : varchar(255)
* request_uri : varchar(255)
* keywords : varchar(255)
* date_add : datetime
v prestashop q2duq_contact
* id_contact : int(10) unsigned
* email : varchar(255)
* customer_service : tinyint(1)
* position : tinyint(2) unsigned
v prestashop q2duq_contact_lang
* id_contact : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(255)
* description : mediumtext
v prestashop q2duq_contact_shop
* id_contact : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_country
* id_country : int(10) unsigned
* id_zone : int(10) unsigned
* id_currency : int(10) unsigned
* iso_code : varchar(3)
* call_prefix : int(10)
* active : tinyint(1) unsigned
* contains_states : tinyint(1)
* need_identification_number : tinyint(1)
* need_zip_code : tinyint(1)
* zip_code_format : varchar(12)
* display_tax_label : tinyint(1)
v prestashop q2duq_country_lang
* id_country : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(64)
v prestashop q2duq_country_shop
* id_country : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_currency
* id_currency : int(10) unsigned
* name : varchar(64)
* iso_code : varchar(3)
* numeric_iso_code : varchar(3)
* precision : int(2)
* conversion_rate : decimal(13,6)
* deleted : tinyint(1) unsigned
* active : tinyint(1) unsigned
* unofficial : tinyint(1) unsigned
* modified : tinyint(1) unsigned
v prestashop q2duq_currency_lang
* id_currency : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(255)
* symbol : varchar(255)
* pattern : varchar(255)
v prestashop q2duq_currency_shop
* id_currency : int(11) unsigned
* id_shop : int(11) unsigned
* conversion_rate : decimal(13,6)
v prestashop q2duq_customer
* id_customer : int(10) unsigned
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* id_gender : int(10) unsigned
* id_default_group : int(10) unsigned
* id_lang : int(10) unsigned
* id_risk : int(10) unsigned
* company : varchar(255)
* siret : varchar(14)
* ape : varchar(6)
* firstname : varchar(255)
* lastname : varchar(255)
* email : varchar(255)
* passwd : varchar(255)
* last_passwd_gen : timestamp
* birthday : date
* newsletter : tinyint(1) unsigned
* ip_registration_newsletter : varchar(15)
* newsletter_date_add : datetime
* optin : tinyint(1) unsigned
* website : varchar(128)
* outstanding_allow_amount : decimal(20,6)
* show_public_prices : tinyint(1) unsigned
* max_payment_days : int(10) unsigned
* secure_key : varchar(32)
* note : mediumtext
* active : tinyint(1) unsigned
* is_guest : tinyint(1)
* deleted : tinyint(1)
* date_add : datetime
* date_upd : datetime
* reset_password_token : varchar(40)
* reset_password_validity : datetime
v prestashop q2duq_customer_group
* id_customer : int(10) unsigned
* id_group : int(10) unsigned
v prestashop q2duq_customer_message
* id_customer_message : int(10) unsigned
* id_customer_thread : int(11)
* id_employee : int(10) unsigned
* id_product : int(10) unsigned
* message : mediumtext
* file_name : varchar(18)
* ip_address : varchar(16)
* user_agent : varchar(255)
* date_add : datetime
* date_upd : datetime
* private : tinyint(4)
* read : tinyint(1)
v prestashop q2duq_customer_message_sync_imap
* md5_header : varbinary(32)
v prestashop q2duq_customer_session
* id_customer_session : int(11) unsigned
* id_customer : int(10) unsigned
* token : varchar(40)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_customer_thread
* id_customer_thread : int(11) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* id_contact : int(10) unsigned
* id_customer : int(10) unsigned
* id_order : int(10) unsigned
* id_product : int(10) unsigned
* status : enum('open','closed','pending1','pending2')
* email : varchar(255)
* token : varchar(12)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_customization
* id_customization : int(10) unsigned
* id_product_attribute : int(10) unsigned
* id_address_delivery : int(10) unsigned
* id_cart : int(10) unsigned
* id_product : int(10)
* quantity : int(10)
* quantity_refunded : int(11)
* quantity_returned : int(11)
* in_cart : tinyint(1) unsigned
v prestashop q2duq_customization_field
* id_customization_field : int(10) unsigned
* id_product : int(10) unsigned
* type : tinyint(1)
* required : tinyint(1)
* is_module : tinyint(1)
* is_deleted : tinyint(1)
v prestashop q2duq_customization_field_lang
* id_customization_field : int(10) unsigned
* id_lang : int(10) unsigned
* id_shop : int(10) unsigned
* name : varchar(255)
v prestashop q2duq_customized_data
* id_customization : int(10) unsigned
* type : tinyint(1)
* index : int(3)
* value : varchar(1024)
* id_module : int(10)
* price : decimal(20,6)
* weight : decimal(20,6)
v prestashop q2duq_date_range
* id_date_range : int(10) unsigned
* time_start : datetime
* time_end : datetime
v prestashop q2duq_delivery
* id_delivery : int(10) unsigned
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* id_carrier : int(10) unsigned
* id_range_price : int(10) unsigned
* id_range_weight : int(10) unsigned
* id_zone : int(10) unsigned
* price : decimal(20,6)
v prestashop q2duq_emailsubscription
* id : int(6)
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* email : varchar(255)
* newsletter_date_add : datetime
* ip_registration_newsletter : varchar(15)
* http_referer : varchar(255)
* active : tinyint(1)
* id_lang : int(10)
v prestashop q2duq_employee
* id_employee : int(10) unsigned
* id_profile : int(10) unsigned
* id_lang : int(10) unsigned
* lastname : varchar(255)
* firstname : varchar(255)
* email : varchar(255)
* passwd : varchar(255)
* last_passwd_gen : timestamp
* stats_date_from : date
* stats_date_to : date
* stats_compare_from : date
* stats_compare_to : date
* stats_compare_option : int(1) unsigned
* preselect_date_range : varchar(32)
* bo_color : varchar(32)
* bo_theme : varchar(32)
* bo_css : varchar(64)
* default_tab : int(10) unsigned
* bo_width : int(10) unsigned
* bo_menu : tinyint(1)
* active : tinyint(1) unsigned
* optin : tinyint(1) unsigned
* id_last_order : int(10) unsigned
* id_last_customer_message : int(10) unsigned
* id_last_customer : int(10) unsigned
* last_connection_date : date
* reset_password_token : varchar(40)
* reset_password_validity : datetime
* has_enabled_gravatar : tinyint(3) unsigned
v prestashop q2duq_employee_account
* id_employee_account : int(11)
* id_employee : int(11)
* email : varchar(64)
* uid : varchar(64)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_employee_session
* id_employee_session : int(11) unsigned
* id_employee : int(10) unsigned
* token : varchar(40)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_employee_shop
* id_employee : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_eventbus_incremental_sync
* type : varchar(50)
* action : varchar(50)
* id_object : varchar(50)
* id_shop : int(10) unsigned
* lang_iso : varchar(3)
* created_at : datetime
v prestashop q2duq_eventbus_job
* job_id : varchar(200)
* created_at : datetime
v prestashop q2duq_eventbus_live_sync
* shop_content : varchar(50)
* last_change_at : datetime
v prestashop q2duq_eventbus_type_sync
* type : varchar(50)
* offset : int(10) unsigned
* id_shop : int(10) unsigned
* lang_iso : varchar(3)
* full_sync_finished : tinyint(1)
* last_sync_date : datetime
v prestashop q2duq_fb_category_match
* id_category : int(11)
* google_category_id : int(64)
* google_category_name : varchar(255)
* google_category_parent_id : int(64)
* google_category_parent_name : varchar(255)
* is_parent_category : tinyint(1)
* id_shop : int(11)
v prestashop q2duq_feature
* id_feature : int(10) unsigned
* position : int(10) unsigned
v prestashop q2duq_feature_flag
* id_feature_flag : int(10) unsigned
* name : varchar(191)
* type : varchar(64)
* state : tinyint(1)
* label_wording : varchar(191)
* label_domain : varchar(255)
* description_wording : varchar(191)
* description_domain : varchar(255)
* stability : varchar(64)
v prestashop q2duq_feature_lang
* id_feature : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(128)
v prestashop q2duq_feature_product
* id_feature : int(10) unsigned
* id_product : int(10) unsigned
* id_feature_value : int(10) unsigned
v prestashop q2duq_feature_shop
* id_feature : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_feature_value
* id_feature_value : int(10) unsigned
* id_feature : int(10) unsigned
* custom : tinyint(3) unsigned
* position : int(10) unsigned
v prestashop q2duq_feature_value_lang
* id_feature_value : int(10) unsigned
* id_lang : int(10) unsigned
* value : varchar(255)
v prestashop q2duq_ganalytics
* id_google_analytics : int(11)
* id_order : int(11)
* id_customer : int(10)
* id_shop : int(11)
* sent : tinyint(1)
* refund_sent : tinyint(1)
* date_add : datetime
v prestashop q2duq_ganalytics_data
* id_cart : int(11)
* id_shop : int(11)
* data : text
v prestashop q2duq_gender
* id_gender : int(11)
* type : tinyint(1)
v prestashop q2duq_gender_lang
* id_gender : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(20)
v prestashop q2duq_group
* id_group : int(10) unsigned
* reduction : decimal(5,2)
* price_display_method : tinyint(4)
* show_prices : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_group_lang
* id_group : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(32)
v prestashop q2duq_group_reduction
* id_group_reduction : mediumint(8) unsigned
* id_group : int(10) unsigned
* id_category : int(10) unsigned
* reduction : decimal(5,4)
v prestashop q2duq_group_shop
* id_group : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_gsitemap_sitemap
* id_shop : int(11)
v prestashop q2duq_guest
* id_guest : int(10) unsigned
* id_operating_system : int(10) unsigned
* id_web_browser : int(10) unsigned
* id_customer : int(10) unsigned
* javascript : tinyint(1)
* screen_resolution_x : smallint(5) unsigned
* screen_resolution_y : smallint(5) unsigned
* screen_color : tinyint(3) unsigned
* sun_java : tinyint(1)
* adobe_flash : tinyint(1)
* adobe_director : tinyint(1)
* apple_quicktime : tinyint(1)
* real_player : tinyint(1)
* windows_media : tinyint(1)
* accept_language : varchar(8)
* mobile_theme : tinyint(1)
v prestashop q2duq_homeslider
* id_homeslider_slides : int(10) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_homeslider_slides
* id_homeslider_slides : int(10) unsigned
* position : int(10) unsigned
* active : tinyint(1) unsigned
v prestashop q2duq_homeslider_slides_lang
* id_homeslider_slides : int(10) unsigned
* id_lang : int(10) unsigned
* title : varchar(255)
* description : text
* legend : varchar(255)
* url : varchar(255)
* image : varchar(255)
v prestashop q2duq_hook
* id_hook : int(10) unsigned
* name : varchar(191)
* title : varchar(255)
* description : mediumtext
* active : tinyint(1) unsigned
* position : tinyint(1)
v prestashop q2duq_hook_alias
* id_hook_alias : int(10) unsigned
* alias : varchar(191)
* name : varchar(191)
v prestashop q2duq_hook_module
* id_module : int(10) unsigned
* id_shop : int(11) unsigned
* id_hook : int(10) unsigned
* position : tinyint(2) unsigned
v prestashop q2duq_hook_module_exceptions
* id_hook_module_exceptions : int(10) unsigned
* id_shop : int(11) unsigned
* id_module : int(10) unsigned
* id_hook : int(10) unsigned
* file_name : varchar(255)
v prestashop q2duq_image
* id_image : int(10) unsigned
* id_product : int(10) unsigned
* position : smallint(2) unsigned
* cover : tinyint(1) unsigned
v prestashop q2duq_image_lang
* id_image : int(10) unsigned
* id_lang : int(10) unsigned
* legend : varchar(128)
v prestashop q2duq_image_shop
* id_product : int(10) unsigned
* id_image : int(11) unsigned
* id_shop : int(11) unsigned
* cover : tinyint(1) unsigned
v prestashop q2duq_image_type
* id_image_type : int(10) unsigned
* name : varchar(64)
* width : int(10) unsigned
* height : int(10) unsigned
* products : tinyint(1)
* categories : tinyint(1)
* manufacturers : tinyint(1)
* suppliers : tinyint(1)
* stores : tinyint(1)
v prestashop q2duq_import_match
* id_import_match : int(10)
* name : varchar(32)
* match : mediumtext
* skip : int(2)
v prestashop q2duq_info
* id_info : int(10) unsigned
v prestashop q2duq_info_lang
* id_info : int(10) unsigned
* id_shop : int(10) unsigned
* id_lang : int(10) unsigned
* text : text
v prestashop q2duq_info_shop
* id_info : int(10) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_lang
* id_lang : int(11)
* name : varchar(32)
* active : tinyint(1)
* iso_code : varchar(2)
* language_code : varchar(5)
* locale : varchar(5)
* date_format_lite : varchar(32)
* date_format_full : varchar(32)
* is_rtl : tinyint(1)
v prestashop q2duq_lang_shop
* id_lang : int(11)
* id_shop : int(11)
v prestashop q2duq_layered_category
* id_layered_category : int(10) unsigned
* id_shop : int(11) unsigned
* controller : varchar(64)
* id_category : int(10) unsigned
* id_value : int(10) unsigned
* type : enum('category','id_feature','id_attribute_group','availability','condition','manufacturer','weight','price','extras')
* position : int(10) unsigned
* filter_type : int(10) unsigned
* filter_show_limit : int(10) unsigned
v prestashop q2duq_layered_filter
* id_layered_filter : int(10) unsigned
* name : varchar(64)
* filters : longtext
* n_categories : int(10) unsigned
* date_add : datetime
v prestashop q2duq_layered_filter_block
* hash : char(32)
* data : text
v prestashop q2duq_layered_filter_shop
* id_layered_filter : int(10) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_layered_indexable_attribute_group
* id_attribute_group : int(11)
* indexable : tinyint(1)
v prestashop q2duq_layered_indexable_attribute_group_lang_value
* id_attribute_group : int(11)
* id_lang : int(11)
* url_name : varchar(128)
* meta_title : varchar(128)
v prestashop q2duq_layered_indexable_attribute_lang_value
* id_attribute : int(11)
* id_lang : int(11)
* url_name : varchar(128)
* meta_title : varchar(128)
v prestashop q2duq_layered_indexable_feature
* id_feature : int(11)
* indexable : tinyint(1)
v prestashop q2duq_layered_indexable_feature_lang_value
* id_feature : int(11)
* id_lang : int(11)
* url_name : varchar(128)
* meta_title : varchar(128)
v prestashop q2duq_layered_indexable_feature_value_lang_value
* id_feature_value : int(11)
* id_lang : int(11)
* url_name : varchar(128)
* meta_title : varchar(128)
v prestashop q2duq_layered_price_index
* id_product : int(11)
* id_currency : int(11)
* id_shop : int(11)
* price_min : decimal(20,6)
* price_max : decimal(20,6)
* id_country : int(11)
v prestashop q2duq_layered_product_attribute
* id_attribute : int(10) unsigned
* id_product : int(10) unsigned
* id_attribute_group : int(10) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_linksmenutop
* id_linksmenutop : int(10) unsigned
* id_shop : int(11) unsigned
* new_window : tinyint(1)
v prestashop q2duq_linksmenutop_lang
* id_linksmenutop : int(11) unsigned
* id_lang : int(11) unsigned
* id_shop : int(11) unsigned
* label : varchar(128)
v prestashop q2duq_log
* id_log : int(10) unsigned
* severity : tinyint(1)
* error_code : int(11)
* message : mediumtext
* object_type : varchar(32)
* object_id : int(10) unsigned
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* id_lang : int(10) unsigned
* in_all_shops : tinyint(1) unsigned
* id_employee : int(10) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_mail
* id_mail : int(11) unsigned
* recipient : varchar(255)
* template : varchar(62)
* subject : varchar(255)
* id_lang : int(11) unsigned
* date_add : timestamp
v prestashop q2duq_mailalert_customer_oos
* id_customer : int(10) unsigned
* customer_email : varchar(128)
* id_product : int(10) unsigned
* id_product_attribute : int(10) unsigned
* id_shop : int(10) unsigned
* id_lang : int(10) unsigned
v prestashop q2duq_manufacturer
* id_manufacturer : int(10) unsigned
* name : varchar(64)
* date_add : datetime
* date_upd : datetime
* active : tinyint(1)
v prestashop q2duq_manufacturer_lang
* id_manufacturer : int(10) unsigned
* id_lang : int(10) unsigned
* description : mediumtext
* short_description : mediumtext
* meta_title : varchar(255)
* meta_description : varchar(512)
v prestashop q2duq_manufacturer_shop
* id_manufacturer : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_mbo_api_config
* id_mbo_api_config : int(10) unsigned
* config_key : varchar(255)
* config_value : varchar(255)
* ps_version : varchar(255)
* mbo_version : varchar(255)
* applied : tinyint(1)
* date_add : datetime
v prestashop q2duq_memcached_servers
* id_memcached_server : int(11) unsigned
* ip : varchar(254)
* port : int(11) unsigned
* weight : int(11) unsigned
v prestashop q2duq_message
* id_message : int(10) unsigned
* id_cart : int(10) unsigned
* id_customer : int(10) unsigned
* id_employee : int(10) unsigned
* id_order : int(10) unsigned
* message : mediumtext
* private : tinyint(1) unsigned
* date_add : datetime
v prestashop q2duq_message_readed
* id_message : int(10) unsigned
* id_employee : int(10) unsigned
* date_add : datetime
v prestashop q2duq_meta
* id_meta : int(10) unsigned
* page : varchar(64)
* configurable : tinyint(1) unsigned
v prestashop q2duq_meta_lang
* id_meta : int(10) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* title : varchar(128)
* description : varchar(255)
* url_rewrite : varchar(255)
v prestashop q2duq_module
* id_module : int(10) unsigned
* name : varchar(64)
* active : tinyint(1) unsigned
* version : varchar(8)
v prestashop q2duq_module_access
* id_profile : int(10) unsigned
* id_authorization_role : int(10) unsigned
v prestashop q2duq_module_carrier
* id_module : int(10) unsigned
* id_shop : int(11) unsigned
* id_reference : int(11)
v prestashop q2duq_module_country
* id_module : int(10) unsigned
* id_shop : int(11) unsigned
* id_country : int(10) unsigned
v prestashop q2duq_module_currency
* id_module : int(10) unsigned
* id_shop : int(11) unsigned
* id_currency : int(11)
v prestashop q2duq_module_group
* id_module : int(10) unsigned
* id_shop : int(11) unsigned
* id_group : int(11) unsigned
v prestashop q2duq_module_history
* id : int(11)
* id_employee : int(11)
* id_module : int(11)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_module_preference
* id_module_preference : int(11)
* id_employee : int(11)
* module : varchar(191)
* interest : tinyint(1)
* favorite : tinyint(1)
v prestashop q2duq_module_shop
* id_module : int(11) unsigned
* id_shop : int(11) unsigned
* enable_device : tinyint(1)
v prestashop q2duq_mutation
* id_mutation : int(10) unsigned
* mutation_table : varchar(255)
* mutation_row_id : bigint(20)
* mutation_action : enum('create','update','delete')
* mutator_type : enum('employee','api_client','module')
* mutator_identifier : varchar(255)
* mutation_details : varchar(255)
* date_add : datetime
v prestashop q2duq_operating_system
* id_operating_system : int(10) unsigned
* name : varchar(64)
v prestashop q2duq_orders
* id_order : int(10) unsigned
* reference : varchar(255)
* id_shop_group : int(11) unsigned
* id_shop : int(11) unsigned
* id_carrier : int(10) unsigned
* id_lang : int(10) unsigned
* id_customer : int(10) unsigned
* id_cart : int(10) unsigned
* id_currency : int(10) unsigned
* id_address_delivery : int(10) unsigned
* id_address_invoice : int(10) unsigned
* current_state : int(10) unsigned
* secure_key : varchar(32)
* payment : varchar(255)
* conversion_rate : decimal(13,6)
* module : varchar(255)
* recyclable : tinyint(1) unsigned
* gift : tinyint(1) unsigned
* gift_message : mediumtext
* mobile_theme : tinyint(1)
* total_discounts : decimal(20,6)
* total_discounts_tax_incl : decimal(20,6)
* total_discounts_tax_excl : decimal(20,6)
* total_paid : decimal(20,6)
* total_paid_tax_incl : decimal(20,6)
* total_paid_tax_excl : decimal(20,6)
* total_paid_real : decimal(20,6)
* total_products : decimal(20,6)
* total_products_wt : decimal(20,6)
* total_shipping : decimal(20,6)
* total_shipping_tax_incl : decimal(20,6)
* total_shipping_tax_excl : decimal(20,6)
* carrier_tax_rate : decimal(10,3)
* total_wrapping : decimal(20,6)
* total_wrapping_tax_incl : decimal(20,6)
* total_wrapping_tax_excl : decimal(20,6)
* round_mode : tinyint(1)
* round_type : tinyint(1)
* invoice_number : int(10) unsigned
* delivery_number : int(10) unsigned
* invoice_date : datetime
* delivery_date : datetime
* valid : int(1) unsigned
* date_add : datetime
* date_upd : datetime
* note : mediumtext
v prestashop q2duq_order_carrier
* id_order_carrier : int(11)
* id_order : int(11) unsigned
* id_carrier : int(11) unsigned
* id_order_invoice : int(11) unsigned
* weight : decimal(20,6)
* shipping_cost_tax_excl : decimal(20,6)
* shipping_cost_tax_incl : decimal(20,6)
* tracking_number : varchar(64)
* date_add : datetime
v prestashop q2duq_order_cart_rule
* id_order_cart_rule : int(10) unsigned
* id_order : int(10) unsigned
* id_cart_rule : int(10) unsigned
* id_order_invoice : int(10) unsigned
* name : varchar(254)
* value : decimal(20,6)
* value_tax_excl : decimal(20,6)
* free_shipping : tinyint(1)
* deleted : tinyint(1) unsigned
v prestashop q2duq_order_detail
* id_order_detail : int(10) unsigned
* id_order : int(10) unsigned
* id_order_invoice : int(11)
* id_warehouse : int(10) unsigned
* id_shop : int(11) unsigned
* product_id : int(10) unsigned
* product_attribute_id : int(10) unsigned
* id_customization : int(10) unsigned
* product_name : mediumtext
* product_quantity : int(10) unsigned
* product_quantity_in_stock : int(10)
* product_quantity_refunded : int(10) unsigned
* product_quantity_return : int(10) unsigned
* product_quantity_reinjected : int(10) unsigned
* product_price : decimal(20,6)
* reduction_percent : decimal(5,2)
* reduction_amount : decimal(20,6)
* reduction_amount_tax_incl : decimal(20,6)
* reduction_amount_tax_excl : decimal(20,6)
* group_reduction : decimal(5,2)
* product_quantity_discount : decimal(20,6)
* product_ean13 : varchar(20)
* product_isbn : varchar(32)
* product_upc : varchar(12)
* product_mpn : varchar(40)
* product_reference : varchar(64)
* product_supplier_reference : varchar(64)
* product_weight : decimal(20,6)
* id_tax_rules_group : int(11) unsigned
* tax_computation_method : tinyint(1) unsigned
* tax_name : varchar(16)
* tax_rate : decimal(10,3)
* ecotax : decimal(17,6)
* ecotax_tax_rate : decimal(5,3)
* discount_quantity_applied : tinyint(1)
* download_hash : varchar(255)
* download_nb : int(10) unsigned
* download_deadline : datetime
* total_price_tax_incl : decimal(20,6)
* total_price_tax_excl : decimal(20,6)
* unit_price_tax_incl : decimal(20,6)
* unit_price_tax_excl : decimal(20,6)
* total_shipping_price_tax_incl : decimal(20,6)
* total_shipping_price_tax_excl : decimal(20,6)
* purchase_supplier_price : decimal(20,6)
* original_product_price : decimal(20,6)
* original_wholesale_price : decimal(20,6)
* total_refunded_tax_excl : decimal(20,6)
* total_refunded_tax_incl : decimal(20,6)
v prestashop q2duq_order_detail_tax
* id_order_detail : int(11)
* id_tax : int(11)
* unit_amount : decimal(16,6)
* total_amount : decimal(16,6)
v prestashop q2duq_order_history
* id_order_history : int(10) unsigned
* id_employee : int(10) unsigned
* id_order : int(10) unsigned
* id_order_state : int(10) unsigned
* date_add : datetime
v prestashop q2duq_order_invoice
* id_order_invoice : int(11) unsigned
* id_order : int(11)
* number : int(11)
* delivery_number : int(11)
* delivery_date : datetime
* total_discount_tax_excl : decimal(20,6)
* total_discount_tax_incl : decimal(20,6)
* total_paid_tax_excl : decimal(20,6)
* total_paid_tax_incl : decimal(20,6)
* total_products : decimal(20,6)
* total_products_wt : decimal(20,6)
* total_shipping_tax_excl : decimal(20,6)
* total_shipping_tax_incl : decimal(20,6)
* shipping_tax_computation_method : int(10) unsigned
* total_wrapping_tax_excl : decimal(20,6)
* total_wrapping_tax_incl : decimal(20,6)
* shop_address : mediumtext
* note : mediumtext
* date_add : datetime
v prestashop q2duq_order_invoice_payment
* id_order_invoice : int(11) unsigned
* id_order_payment : int(11) unsigned
* id_order : int(11) unsigned
v prestashop q2duq_order_invoice_tax
* id_order_invoice : int(11)
* type : varchar(15)
* id_tax : int(11)
* amount : decimal(10,6)
v prestashop q2duq_order_message
* id_order_message : int(10) unsigned
* date_add : datetime
v prestashop q2duq_order_message_lang
* id_order_message : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(128)
* message : mediumtext
v prestashop q2duq_order_payment
* id_order_payment : int(11)
* order_reference : varchar(255)
* id_currency : int(10) unsigned
* amount : decimal(20,6)
* payment_method : varchar(255)
* conversion_rate : decimal(13,6)
* transaction_id : varchar(254)
* card_number : varchar(254)
* card_brand : varchar(254)
* card_expiration : char(7)
* card_holder : varchar(254)
* date_add : datetime
* id_employee : int(11)
v prestashop q2duq_order_return
* id_order_return : int(10) unsigned
* id_customer : int(10) unsigned
* id_order : int(10) unsigned
* state : tinyint(1) unsigned
* question : mediumtext
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_order_return_detail
* id_order_return : int(10) unsigned
* id_order_detail : int(10) unsigned
* id_customization : int(10) unsigned
* product_quantity : int(10) unsigned
v prestashop q2duq_order_return_state
* id_order_return_state : int(10) unsigned
* color : varchar(32)
v prestashop q2duq_order_return_state_lang
* id_order_return_state : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(64)
v prestashop q2duq_order_slip
* id_order_slip : int(10) unsigned
* conversion_rate : decimal(13,6)
* id_customer : int(10) unsigned
* id_order : int(10) unsigned
* total_products_tax_excl : decimal(20,6)
* total_products_tax_incl : decimal(20,6)
* total_shipping_tax_excl : decimal(20,6)
* total_shipping_tax_incl : decimal(20,6)
* shipping_cost : tinyint(3) unsigned
* amount : decimal(20,6)
* shipping_cost_amount : decimal(20,6)
* partial : tinyint(1)
* order_slip_type : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_order_slip_detail
* id_order_slip : int(10) unsigned
* id_order_detail : int(10) unsigned
* product_quantity : int(10) unsigned
* unit_price_tax_excl : decimal(20,6)
* unit_price_tax_incl : decimal(20,6)
* total_price_tax_excl : decimal(20,6)
* total_price_tax_incl : decimal(20,6)
* amount_tax_excl : decimal(20,6)
* amount_tax_incl : decimal(20,6)
v prestashop q2duq_order_state
* id_order_state : int(10) unsigned
* invoice : tinyint(1) unsigned
* send_email : tinyint(1) unsigned
* module_name : varchar(255)
* color : varchar(32)
* unremovable : tinyint(1) unsigned
* hidden : tinyint(1) unsigned
* logable : tinyint(1)
* delivery : tinyint(1) unsigned
* shipped : tinyint(1) unsigned
* paid : tinyint(1) unsigned
* pdf_invoice : tinyint(1) unsigned
* pdf_delivery : tinyint(1) unsigned
* deleted : tinyint(1) unsigned
v prestashop q2duq_order_state_lang
* id_order_state : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(64)
* template : varchar(64)
v prestashop q2duq_pack
* id_product_pack : int(10) unsigned
* id_product_item : int(10) unsigned
* id_product_attribute_item : int(10) unsigned
* quantity : int(10) unsigned
v prestashop q2duq_page
* id_page : int(10) unsigned
* id_page_type : int(10) unsigned
* id_object : int(10) unsigned
v prestashop q2duq_pagenotfound
* id_pagenotfound : int(10) unsigned
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* request_uri : varchar(256)
* http_referer : varchar(256)
* date_add : datetime
v prestashop q2duq_page_type
* id_page_type : int(10) unsigned
* name : varchar(255)
v prestashop q2duq_page_viewed
* id_page : int(10) unsigned
* id_shop_group : int(10) unsigned
* id_shop : int(10) unsigned
* id_date_range : int(10) unsigned
* counter : int(10) unsigned
v prestashop q2duq_product
* id_product : int(10) unsigned
* id_supplier : int(10) unsigned
* id_manufacturer : int(10) unsigned
* id_category_default : int(10) unsigned
* id_shop_default : int(10) unsigned
* id_tax_rules_group : int(11) unsigned
* on_sale : tinyint(1) unsigned
* online_only : tinyint(1) unsigned
* ean13 : varchar(20)
* isbn : varchar(32)
* upc : varchar(12)
* mpn : varchar(40)
* ecotax : decimal(17,6)
* quantity : int(10)
* minimal_quantity : int(10) unsigned
* low_stock_threshold : int(10)
* low_stock_alert : tinyint(1)
* price : decimal(20,6)
* wholesale_price : decimal(20,6)
* unity : varchar(255)
* unit_price : decimal(20,6)
* unit_price_ratio : decimal(20,6)
* additional_shipping_cost : decimal(20,6)
* reference : varchar(64)
* supplier_reference : varchar(64)
* location : varchar(255)
* width : decimal(20,6)
* height : decimal(20,6)
* depth : decimal(20,6)
* weight : decimal(20,6)
* out_of_stock : int(10) unsigned
* additional_delivery_times : tinyint(1) unsigned
* quantity_discount : tinyint(1)
* customizable : tinyint(2)
* uploadable_files : tinyint(4)
* text_fields : tinyint(4)
* active : tinyint(1) unsigned
* redirect_type : enum('404','410','301-product','302-product','301-category','302-category','200-displayed','404-displayed','410-displayed','default')
* id_type_redirected : int(10) unsigned
* available_for_order : tinyint(1)
* available_date : date
* show_condition : tinyint(1)
* condition : enum('new','used','refurbished')
* show_price : tinyint(1)
* indexed : tinyint(1)
* visibility : enum('both','catalog','search','none')
* cache_is_pack : tinyint(1)
* cache_has_attachments : tinyint(1)
* is_virtual : tinyint(1)
* cache_default_attribute : int(10) unsigned
* date_add : datetime
* date_upd : datetime
* advanced_stock_management : tinyint(1)
* pack_stock_type : int(11) unsigned
* state : int(11) unsigned
* product_type : enum('standard','pack','virtual','combinations','')
v prestashop q2duq_product_attachment
* id_product : int(10) unsigned
* id_attachment : int(10) unsigned
v prestashop q2duq_product_attribute
* id_product_attribute : int(10) unsigned
* id_product : int(10) unsigned
* reference : varchar(64)
* supplier_reference : varchar(64)
* ean13 : varchar(20)
* isbn : varchar(32)
* upc : varchar(12)
* mpn : varchar(40)
* wholesale_price : decimal(20,6)
* price : decimal(20,6)
* ecotax : decimal(17,6)
* weight : decimal(20,6)
* unit_price_impact : decimal(20,6)
* default_on : tinyint(1) unsigned
* minimal_quantity : int(10) unsigned
* low_stock_threshold : int(10)
* low_stock_alert : tinyint(1)
* available_date : date
v prestashop q2duq_product_attribute_combination
* id_attribute : int(10) unsigned
* id_product_attribute : int(10) unsigned
v prestashop q2duq_product_attribute_image
* id_product_attribute : int(10) unsigned
* id_image : int(10) unsigned
v prestashop q2duq_product_attribute_lang
* id_product_attribute : int(10) unsigned
* id_lang : int(10) unsigned
* available_now : varchar(255)
* available_later : varchar(255)
v prestashop q2duq_product_attribute_shop
* id_product : int(10) unsigned
* id_product_attribute : int(10) unsigned
* id_shop : int(10) unsigned
* wholesale_price : decimal(20,6)
* price : decimal(20,6)
* ecotax : decimal(17,6)
* weight : decimal(20,6)
* unit_price_impact : decimal(20,6)
* default_on : tinyint(1) unsigned
* minimal_quantity : int(10) unsigned
* low_stock_threshold : int(10)
* low_stock_alert : tinyint(1)
* available_date : date
v prestashop q2duq_product_carrier
* id_product : int(10) unsigned
* id_carrier_reference : int(10) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_product_comment
* id_product_comment : int(10) unsigned
* id_product : int(10) unsigned
* id_customer : int(10) unsigned
* id_guest : int(10) unsigned
* title : varchar(64)
* content : text
* customer_name : varchar(64)
* grade : float unsigned
* validate : tinyint(1)
* deleted : tinyint(1)
* date_add : datetime
v prestashop q2duq_product_comment_criterion
* id_product_comment_criterion : int(10) unsigned
* id_product_comment_criterion_type : tinyint(1)
* active : tinyint(1)
v prestashop q2duq_product_comment_criterion_category
* id_product_comment_criterion : int(10) unsigned
* id_category : int(10) unsigned
v prestashop q2duq_product_comment_criterion_lang
* id_product_comment_criterion : int(11) unsigned
* id_lang : int(11) unsigned
* name : varchar(64)
v prestashop q2duq_product_comment_criterion_product
* id_product : int(10) unsigned
* id_product_comment_criterion : int(10) unsigned
v prestashop q2duq_product_comment_grade
* id_product_comment : int(10) unsigned
* id_product_comment_criterion : int(10) unsigned
* grade : int(10) unsigned
v prestashop q2duq_product_comment_report
* id_product_comment : int(10) unsigned
* id_customer : int(10) unsigned
v prestashop q2duq_product_comment_usefulness
* id_product_comment : int(10) unsigned
* id_customer : int(10) unsigned
* usefulness : tinyint(1) unsigned
v prestashop q2duq_product_country_tax
* id_product : int(11)
* id_country : int(11)
* id_tax : int(11)
v prestashop q2duq_product_download
* id_product_download : int(10) unsigned
* id_product : int(10) unsigned
* display_filename : varchar(255)
* filename : varchar(255)
* date_add : datetime
* date_expiration : datetime
* nb_days_accessible : int(10) unsigned
* nb_downloadable : int(10) unsigned
* active : tinyint(1) unsigned
* is_shareable : tinyint(1) unsigned
v prestashop q2duq_product_group_reduction_cache
* id_product : int(10) unsigned
* id_group : int(10) unsigned
* reduction : decimal(5,4)
v prestashop q2duq_product_lang
* id_product : int(10) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* description : mediumtext
* description_short : mediumtext
* meta_description : varchar(512)
* meta_title : varchar(128)
* name : varchar(128)
* available_now : varchar(255)
* available_later : varchar(255)
* delivery_in_stock : varchar(255)
* delivery_out_stock : varchar(255)
v prestashop q2duq_product_sale
* id_product : int(10) unsigned
* quantity : int(10) unsigned
* sale_nbr : int(10) unsigned
* date_upd : date
v prestashop q2duq_product_shop
* id_product : int(10) unsigned
* id_shop : int(10) unsigned
* id_category_default : int(10) unsigned
* id_tax_rules_group : int(11) unsigned
* on_sale : tinyint(1) unsigned
* online_only : tinyint(1) unsigned
* ecotax : decimal(17,6)
* minimal_quantity : int(10) unsigned
* low_stock_threshold : int(10)
* low_stock_alert : tinyint(1)
* price : decimal(20,6)
* wholesale_price : decimal(20,6)
* unity : varchar(255)
* unit_price : decimal(20,6)
* unit_price_ratio : decimal(20,6)
* additional_shipping_cost : decimal(20,6)
* customizable : tinyint(2)
* uploadable_files : tinyint(4)
* text_fields : tinyint(4)
* active : tinyint(1) unsigned
* redirect_type : enum('404','410','301-product','302-product','301-category','302-category','200-displayed','404-displayed','410-displayed','default')
* id_type_redirected : int(10) unsigned
* available_for_order : tinyint(1)
* available_date : date
* show_condition : tinyint(1)
* condition : enum('new','used','refurbished')
* show_price : tinyint(1)
* indexed : tinyint(1)
* visibility : enum('both','catalog','search','none')
* cache_default_attribute : int(10) unsigned
* advanced_stock_management : tinyint(1)
* date_add : datetime
* date_upd : datetime
* pack_stock_type : int(11) unsigned
v prestashop q2duq_product_supplier
* id_product_supplier : int(11) unsigned
* id_product : int(11) unsigned
* id_product_attribute : int(11) unsigned
* id_supplier : int(11) unsigned
* product_supplier_reference : varchar(64)
* product_supplier_price_te : decimal(20,6)
* id_currency : int(11) unsigned
v prestashop q2duq_product_tag
* id_product : int(10) unsigned
* id_tag : int(10) unsigned
* id_lang : int(10) unsigned
v prestashop q2duq_profile
* id_profile : int(10) unsigned
v prestashop q2duq_profile_lang
* id_lang : int(10) unsigned
* id_profile : int(10) unsigned
* name : varchar(128)
v prestashop q2duq_pscheckout_authorization
* id : varchar(50)
* id_order : varchar(50)
* status : varchar(30)
* expiration_time : varchar(50)
* seller_protection : text
v prestashop q2duq_pscheckout_capture
* id : varchar(50)
* id_order : varchar(50)
* status : varchar(30)
* final_capture : tinyint(1)
* created_at : varchar(50)
* updated_at : varchar(50)
* seller_protection : text
* seller_receivable_breakdown : text
v prestashop q2duq_pscheckout_cart
* id_pscheckout_cart : int(10) unsigned
* id_cart : int(10) unsigned
* paypal_intent : varchar(20)
* paypal_order : varchar(20)
* paypal_status : varchar(30)
* paypal_funding : varchar(20)
* paypal_token : text
* paypal_token_expire : datetime
* paypal_authorization_expire : datetime
* environment : varchar(20)
* isExpressCheckout : tinyint(1) unsigned
* isHostedFields : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_pscheckout_customer
* id_customer : int(10) unsigned
* paypal_customer_id : varchar(50)
v prestashop q2duq_pscheckout_funding_source
* name : varchar(20)
* active : tinyint(1) unsigned
* position : tinyint(2) unsigned
* id_shop : int(10) unsigned
v prestashop q2duq_pscheckout_order
* id : varchar(50)
* id_cart : int(10) unsigned
* status : varchar(30)
* intent : varchar(50)
* funding_source : varchar(50)
* payment_source : text
* environment : varchar(50)
* is_card_fields : tinyint(1)
* is_express_checkout : tinyint(1)
* customer_intent : varchar(50)
* payment_token_id : varchar(50)
* tags : varchar(255)
v prestashop q2duq_pscheckout_order_matrice
* id_order_matrice : int(10) unsigned
* id_order_prestashop : int(10) unsigned
* id_order_paypal : varchar(20)
v prestashop q2duq_pscheckout_payment_token
* id : int(10) unsigned
* token_id : varchar(50)
* paypal_customer_id : varchar(50)
* payment_source : varchar(50)
* data : text
* merchant_id : varchar(50)
* status : varchar(50)
* is_favorite : tinyint(1) unsigned
v prestashop q2duq_pscheckout_purchase_unit
* id_order : varchar(50)
* checksum : varchar(50)
* reference_id : varchar(50)
* items : text
v prestashop q2duq_pscheckout_refund
* id : varchar(50)
* id_order : varchar(50)
* status : varchar(30)
* invoice_id : varchar(50)
* custom_id : varchar(50)
* acquirer_reference_number : varchar(50)
* seller_payable_breakdown : text
* id_order_slip : int(10) unsigned
v prestashop q2duq_pscheckout_tracking
* id : int(10) unsigned
* id_order : int(10) unsigned
* tracking_number : varchar(64)
* carrier_id : int(10) unsigned
* carrier_name : varchar(64)
* paypal_order_id : varchar(50)
* paypal_capture_id : varchar(50)
* tracker_id : varchar(64)
* items : text
* status : varchar(20)
* paypal_tracking_status : varchar(20)
* payload_checksum : varchar(64)
* sent_to_paypal : tinyint(1)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_psgdpr_log
* id_gdpr_log : int(10) unsigned
* id_customer : int(10) unsigned
* id_guest : int(10) unsigned
* client_name : varchar(250)
* id_module : int(10) unsigned
* request_type : int(10)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_psreassurance
* id_psreassurance : int(10) unsigned
* icon : varchar(255)
* custom_icon : varchar(255)
* status : int(10) unsigned
* position : int(10) unsigned
* id_cms : int(10) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_psreassurance_lang
* id_psreassurance : int(10) unsigned
* id_lang : int(10) unsigned
* title : varchar(255)
* description : varchar(255)
v prestashop q2duq_psshipping_address
* id_address : int(11)
* pickup_point_id : int(11)
* network_code : varchar(20)
* code : varchar(255)
* description : varchar(255)
* address : varchar(255)
* city : varchar(255)
* zip_code : varchar(255)
* department : varchar(255)
* country : varchar(255)
v prestashop q2duq_psshipping_address_orders
* id_order : int(11)
* id_shop : int(11)
* id_address : int(11)
v prestashop q2duq_quick_access
* id_quick_access : int(10) unsigned
* new_window : tinyint(1)
v prestashop q2duq_quick_access_lang
* id_quick_access : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(32)
v prestashop q2duq_range_price
* id_range_price : int(10) unsigned
* id_carrier : int(10) unsigned
* delimiter1 : decimal(20,6)
* delimiter2 : decimal(20,6)
v prestashop q2duq_range_weight
* id_range_weight : int(10) unsigned
* id_carrier : int(10) unsigned
* delimiter1 : decimal(20,6)
* delimiter2 : decimal(20,6)
v prestashop q2duq_request_sql
* id_request_sql : int(11)
* name : varchar(200)
* sql : mediumtext
v prestashop q2duq_required_field
* id_required_field : int(11)
* object_name : varchar(32)
* field_name : varchar(32)
v prestashop q2duq_risk
* id_risk : int(11) unsigned
* percent : tinyint(3)
* color : varchar(32)
v prestashop q2duq_risk_lang
* id_risk : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(20)
v prestashop q2duq_search_engine
* id_search_engine : int(10) unsigned
* server : varchar(64)
* getvar : varchar(16)
v prestashop q2duq_search_index
* id_product : int(11) unsigned
* id_word : int(11) unsigned
* weight : smallint(4) unsigned
v prestashop q2duq_search_word
* id_word : int(10) unsigned
* id_shop : int(11) unsigned
* id_lang : int(10) unsigned
* word : varchar(30)
v prestashop q2duq_shipment
* id_shipment : int(10)
* id_order : int(10)
* id_carrier : int(10)
* id_delivery_address : int(10)
* shipping_cost_tax_excl : decimal(20,6)
* shipping_cost_tax_incl : decimal(20,6)
* packed_at : datetime
* shipped_at : datetime
* delivered_at : datetime
* cancelled_at : datetime
* tracking_number : varchar(255)
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_shipment_product
* id_shipment_product : int(11)
* id_shipment : int(10)
* id_order_detail : int(10)
* quantity : int(10)
v prestashop q2duq_shop
* id_shop : int(11)
* id_shop_group : int(11)
* name : varchar(64)
* color : varchar(50)
* id_category : int(11)
* theme_name : varchar(255)
* active : tinyint(1)
* deleted : tinyint(1)
v prestashop q2duq_shop_group
* id_shop_group : int(11)
* name : varchar(64)
* color : varchar(50)
* share_customer : tinyint(1)
* share_order : tinyint(1)
* share_stock : tinyint(1)
* active : tinyint(1)
* deleted : tinyint(1)
v prestashop q2duq_shop_url
* id_shop_url : int(11) unsigned
* id_shop : int(11) unsigned
* domain : varchar(255)
* domain_ssl : varchar(255)
* physical_uri : varchar(64)
* virtual_uri : varchar(64)
* main : tinyint(1)
* active : tinyint(1)
v prestashop q2duq_smarty_cache
* id_smarty_cache : char(40)
* name : char(40)
* cache_id : varchar(254)
* modified : timestamp
* content : longtext
v prestashop q2duq_smarty_last_flush
* type : enum('compile','template')
* last_flush : datetime
v prestashop q2duq_smarty_lazy_cache
* template_hash : varchar(32)
* cache_id : varchar(191)
* compile_id : varchar(32)
* filepath : varchar(255)
* last_update : datetime
v prestashop q2duq_specific_price
* id_specific_price : int(10) unsigned
* id_specific_price_rule : int(11) unsigned
* id_cart : int(11) unsigned
* id_product : int(10) unsigned
* id_shop : int(11) unsigned
* id_shop_group : int(11) unsigned
* id_currency : int(10) unsigned
* id_country : int(10) unsigned
* id_group : int(10) unsigned
* id_customer : int(10) unsigned
* id_product_attribute : int(10) unsigned
* price : decimal(20,6)
* from_quantity : mediumint(8) unsigned
* reduction : decimal(20,6)
* reduction_tax : tinyint(1)
* reduction_type : enum('amount','percentage')
* from : datetime
* to : datetime
v prestashop q2duq_specific_price_priority
* id_specific_price_priority : int(11)
* id_product : int(11)
* priority : varchar(80)
v prestashop q2duq_specific_price_rule
* id_specific_price_rule : int(10) unsigned
* name : varchar(255)
* id_shop : int(11) unsigned
* id_currency : int(10) unsigned
* id_country : int(10) unsigned
* id_group : int(10) unsigned
* from_quantity : mediumint(8) unsigned
* price : decimal(20,6)
* reduction : decimal(20,6)
* reduction_tax : tinyint(1)
* reduction_type : enum('amount','percentage')
* from : datetime
* to : datetime
v prestashop q2duq_specific_price_rule_condition
* id_specific_price_rule_condition : int(11) unsigned
* id_specific_price_rule_condition_group : int(11) unsigned
* type : varchar(255)
* value : varchar(255)
v prestashop q2duq_specific_price_rule_condition_group
* id_specific_price_rule_condition_group : int(11) unsigned
* id_specific_price_rule : int(11) unsigned
v prestashop q2duq_state
* id_state : int(10) unsigned
* id_country : int(11) unsigned
* id_zone : int(11) unsigned
* name : varchar(80)
* iso_code : varchar(7)
* tax_behavior : smallint(1)
* active : tinyint(1)
v prestashop q2duq_statssearch
* id_statssearch : int(10) unsigned
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* keywords : varchar(255)
* results : int(6)
* date_add : datetime
v prestashop q2duq_stock
* id_stock : int(11) unsigned
* id_warehouse : int(11) unsigned
* id_product : int(11) unsigned
* id_product_attribute : int(11) unsigned
* reference : varchar(64)
* ean13 : varchar(20)
* isbn : varchar(32)
* upc : varchar(12)
* mpn : varchar(40)
* physical_quantity : int(11) unsigned
* usable_quantity : int(11) unsigned
* price_te : decimal(20,6)
v prestashop q2duq_stock_available
* id_stock_available : int(11) unsigned
* id_product : int(11) unsigned
* id_product_attribute : int(11) unsigned
* id_shop : int(11) unsigned
* id_shop_group : int(11) unsigned
* quantity : int(10)
* physical_quantity : int(11)
* reserved_quantity : int(11)
* depends_on_stock : tinyint(1) unsigned
* out_of_stock : tinyint(1) unsigned
* location : varchar(255)
v prestashop q2duq_stock_mvt
* id_stock_mvt : bigint(20)
* id_stock : int(11)
* id_order : int(11)
* id_supply_order : int(11)
* id_stock_mvt_reason : int(11)
* id_employee : int(11)
* employee_lastname : varchar(255)
* employee_firstname : varchar(255)
* physical_quantity : int(10) unsigned
* date_add : datetime
* sign : smallint(6)
* price_te : decimal(20,6)
* last_wa : decimal(20,6)
* current_wa : decimal(20,6)
* referer : bigint(20)
v prestashop q2duq_stock_mvt_reason
* id_stock_mvt_reason : int(11) unsigned
* sign : tinyint(1)
* date_add : datetime
* date_upd : datetime
* deleted : tinyint(1) unsigned
v prestashop q2duq_stock_mvt_reason_lang
* id_stock_mvt_reason : int(11) unsigned
* id_lang : int(11) unsigned
* name : varchar(255)
v prestashop q2duq_store
* id_store : int(10) unsigned
* id_country : int(10) unsigned
* id_state : int(10) unsigned
* city : varchar(64)
* postcode : varchar(12)
* latitude : decimal(13,8)
* longitude : decimal(13,8)
* phone : varchar(16)
* fax : varchar(16)
* email : varchar(255)
* active : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_store_lang
* id_store : int(11) unsigned
* id_lang : int(11) unsigned
* name : varchar(255)
* address1 : varchar(255)
* address2 : varchar(255)
* hours : mediumtext
* note : mediumtext
v prestashop q2duq_store_shop
* id_store : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_supplier
* id_supplier : int(10) unsigned
* name : varchar(64)
* date_add : datetime
* date_upd : datetime
* active : tinyint(1)
v prestashop q2duq_supplier_lang
* id_supplier : int(10) unsigned
* id_lang : int(10) unsigned
* description : mediumtext
* meta_title : varchar(255)
* meta_description : varchar(512)
v prestashop q2duq_supplier_shop
* id_supplier : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_supply_order
* id_supply_order : int(11) unsigned
* id_supplier : int(11) unsigned
* supplier_name : varchar(64)
* id_lang : int(11) unsigned
* id_warehouse : int(11) unsigned
* id_supply_order_state : int(11) unsigned
* id_currency : int(11) unsigned
* id_ref_currency : int(11) unsigned
* reference : varchar(64)
* date_add : datetime
* date_upd : datetime
* date_delivery_expected : datetime
* total_te : decimal(20,6)
* total_with_discount_te : decimal(20,6)
* total_tax : decimal(20,6)
* total_ti : decimal(20,6)
* discount_rate : decimal(20,6)
* discount_value_te : decimal(20,6)
* is_template : tinyint(1)
v prestashop q2duq_supply_order_detail
* id_supply_order_detail : int(11) unsigned
* id_supply_order : int(11) unsigned
* id_currency : int(11) unsigned
* id_product : int(11) unsigned
* id_product_attribute : int(11) unsigned
* reference : varchar(64)
* supplier_reference : varchar(64)
* name : varchar(128)
* ean13 : varchar(20)
* isbn : varchar(32)
* upc : varchar(12)
* mpn : varchar(40)
* exchange_rate : decimal(20,6)
* unit_price_te : decimal(20,6)
* quantity_expected : int(11) unsigned
* quantity_received : int(11) unsigned
* price_te : decimal(20,6)
* discount_rate : decimal(20,6)
* discount_value_te : decimal(20,6)
* price_with_discount_te : decimal(20,6)
* tax_rate : decimal(20,6)
* tax_value : decimal(20,6)
* price_ti : decimal(20,6)
* tax_value_with_order_discount : decimal(20,6)
* price_with_order_discount_te : decimal(20,6)
v prestashop q2duq_supply_order_history
* id_supply_order_history : int(11) unsigned
* id_supply_order : int(11) unsigned
* id_employee : int(11) unsigned
* employee_lastname : varchar(255)
* employee_firstname : varchar(255)
* id_state : int(11) unsigned
* date_add : datetime
v prestashop q2duq_supply_order_receipt_history
* id_supply_order_receipt_history : int(11) unsigned
* id_supply_order_detail : int(11) unsigned
* id_employee : int(11) unsigned
* employee_lastname : varchar(255)
* employee_firstname : varchar(255)
* id_supply_order_state : int(11) unsigned
* quantity : int(11) unsigned
* date_add : datetime
v prestashop q2duq_supply_order_state
* id_supply_order_state : int(11) unsigned
* delivery_note : tinyint(1)
* editable : tinyint(1)
* receipt_state : tinyint(1)
* pending_receipt : tinyint(1)
* enclosed : tinyint(1)
* color : varchar(32)
v prestashop q2duq_supply_order_state_lang
* id_supply_order_state : int(11) unsigned
* id_lang : int(11) unsigned
* name : varchar(128)
v prestashop q2duq_tab
* id_tab : int(11)
* id_parent : int(11)
* position : int(11)
* module : varchar(64)
* class_name : varchar(64)
* route_name : varchar(256)
* active : tinyint(1)
* enabled : tinyint(1)
* icon : varchar(32)
* wording : varchar(255)
* wording_domain : varchar(255)
v prestashop q2duq_tab_lang
* id_tab : int(11)
* id_lang : int(11)
* name : varchar(128)
v prestashop q2duq_tab_module_preference
* id_tab_module_preference : int(11)
* id_employee : int(11)
* id_tab : int(11)
* module : varchar(191)
v prestashop q2duq_tag
* id_tag : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(32)
v prestashop q2duq_tag_count
* id_group : int(10) unsigned
* id_tag : int(10) unsigned
* id_lang : int(10) unsigned
* id_shop : int(11) unsigned
* counter : int(10) unsigned
v prestashop q2duq_tax
* id_tax : int(10) unsigned
* rate : decimal(10,3)
* active : tinyint(1) unsigned
* deleted : tinyint(1) unsigned
v prestashop q2duq_tax_lang
* id_tax : int(10) unsigned
* id_lang : int(10) unsigned
* name : varchar(32)
v prestashop q2duq_tax_rule
* id_tax_rule : int(11)
* id_tax_rules_group : int(11)
* id_country : int(11)
* id_state : int(11)
* zipcode_from : varchar(12)
* zipcode_to : varchar(12)
* id_tax : int(11)
* behavior : int(11)
* description : varchar(100)
v prestashop q2duq_tax_rules_group
* id_tax_rules_group : int(11)
* name : varchar(64)
* active : int(11)
* deleted : tinyint(1) unsigned
* date_add : datetime
* date_upd : datetime
v prestashop q2duq_tax_rules_group_shop
* id_tax_rules_group : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_timezone
* id_timezone : int(10) unsigned
* name : varchar(32)
v prestashop q2duq_translation
* id_translation : int(11)
* id_lang : int(11)
* key : text
* translation : text
* domain : varchar(80)
* theme : varchar(32)
v prestashop q2duq_warehouse
* id_warehouse : int(11) unsigned
* id_currency : int(11) unsigned
* id_address : int(11) unsigned
* id_employee : int(11) unsigned
* reference : varchar(64)
* name : varchar(45)
* management_type : enum('WA','FIFO','LIFO')
* deleted : tinyint(1) unsigned
v prestashop q2duq_warehouse_carrier
* id_carrier : int(11) unsigned
* id_warehouse : int(11) unsigned
v prestashop q2duq_warehouse_product_location
* id_warehouse_product_location : int(11) unsigned
* id_product : int(11) unsigned
* id_product_attribute : int(11) unsigned
* id_warehouse : int(11) unsigned
* location : varchar(64)
v prestashop q2duq_warehouse_shop
* id_shop : int(11) unsigned
* id_warehouse : int(11) unsigned
v prestashop q2duq_webservice_account
* id_webservice_account : int(11)
* key : varchar(32)
* description : mediumtext
* class_name : varchar(50)
* is_module : tinyint(2)
* module_name : varchar(50)
* active : tinyint(2)
v prestashop q2duq_webservice_account_shop
* id_webservice_account : int(11) unsigned
* id_shop : int(11) unsigned
v prestashop q2duq_webservice_permission
* id_webservice_permission : int(11)
* resource : varchar(50)
* method : enum('GET','POST','PUT','PATCH','DELETE','HEAD')
* id_webservice_account : int(11)
v prestashop q2duq_web_browser
* id_web_browser : int(10) unsigned
* name : varchar(64)
v prestashop q2duq_wishlist
* id_wishlist : int(10) unsigned
* id_customer : int(10) unsigned
* id_shop : int(10) unsigned
* id_shop_group : int(10) unsigned
* token : varchar(64)
* name : varchar(64)
* counter : int(10) unsigned
* date_add : datetime
* date_upd : datetime
* default : int(10) unsigned
v prestashop q2duq_wishlist_product
* id_wishlist_product : int(10)
* id_wishlist : int(10) unsigned
* id_product : int(10) unsigned
* id_product_attribute : int(10) unsigned
* quantity : int(10) unsigned
* priority : int(10) unsigned
v prestashop q2duq_wishlist_product_cart
* id_wishlist_product : int(10) unsigned
* id_cart : int(10) unsigned
* quantity : int(10) unsigned
* date_add : datetime
v prestashop q2duq_zone
* id_zone : int(10) unsigned
* name : varchar(64)
* active : tinyint(1) unsigned
v prestashop q2duq_zone_shop
* id_zone : int(11) unsigned
* id_shop : int(11) unsigned
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship