91.160.157.7:8080 / 127.0.0.1 / prestashop

Pas de tables préférées.

Personnaliser l'apparence du panneau de navigation.

Panneau de navigation

Afficher la navigation des bases de données en tant qu'arborescence Dans le volet de navigation, remplacer l'arborescence de la base de données par un sélecteur
Relier au panneau principal Relier au panneau principal en mettant en surbrillance la base de données ou la table active.
Afficher le logo Afficher le logo dans le panneau de navigation.
URL du lien sous le logo L'URL vers lequel pointera le logo dans le panneau de navigation.
Fenêtre cible pour la page ouverte lors d'un clic sur le logo Ouvrir la page en lien dans la fenêtre principale, (`main`) ou dans une nouvelle fenêtre, (`new`).
Active la surbrillance Faire ressortir le nom du serveur dans le panneau de navigation.
Nombre maximum d'éléments au premier niveau Le nombre d'éléments qui peuvent être affichés pour chaque page du premier niveau de l'arborescence de navigation.
Nombre minimum d'éléments pour afficher la boîte de filtrage Définir le nombre minimum d'éléments (tables, vues, procédures et événements) nécessaires pour afficher la boîte de filtrage.
Tables récemment utilisées Nombre maximum de tables récentes ; définir à 0 pour désactiver.
Tables préférées Le nombre maximum de tables préférées ; définir à 0 pour désactiver.
Largeur du panneau de navigation Définir à 0 pour replier le panneau de navigation.

Personnaliser l'arborescence de navigation.

Arborescence de navigation

Nombre maximum d'éléments dans la branche Le nombre d'éléments qui peuvent être affichés pour chaque page de l'arborescence de navigation.
Regrouper les éléments dans l'arborescence Regrouper les éléments dans l'arborescence de navigation (déterminé par le séparateur défini dans les onglets Bases de données et Tables ci-dessus).
Activer l'expansion de l'arborescence de navigation Pour offrir la possibilité d'expansion de l'arborescence dans le panneau de navigation.
Afficher les tables dans l'arborescence Pour afficher les tables dans l'arborescence de navigation
Afficher les vues dans l'arborescence Pour afficher les vues dans l'arborescence de navigation
Afficher les fonctions dans l'arborescence Pour afficher les fonctions dans l'arborescence de navigation
Afficher les procédures dans l'arborescence Pour afficher les procédures dans l'arborescence de navigation
Afficher les évènements dans l'arborescence Pour afficher les événements dans l'arborescence de navigation
Expansion d'une seule base de données S'il faut développer automatiquement une base de données unique dans l'arborescence de navigation.

Options d'affichage des serveurs.

Serveurs

Afficher la liste des serveurs Afficher le choix de serveurs au haut du panneau de navigation.
Afficher les serveurs sous forme de liste Afficher la liste des serveurs au lieu d'un menu déroulant.

Options d'affichage des bases de données.

Bases de données

Nombre minimum de bases de données pour activer le filtre
Séparateur pour l'arborescence des bases de données Chaîne qui sépare les noms de bases de données en niveaux.

Options d'affichage des tables.

Tables

Cible de l'icône d'accès rapide
Cible de la deuxième icône d'accès rapide
Séparateur pour l'arborescence des noms de tables Chaîne qui sépare les noms de table en niveaux.
Nombre de niveaux pour l'arborescence des tables

Déposer des fichiers ici

Téléversement SQL ( 0 ) x -

Cliquer sur la barre pour faire défiler en haut de page

Faire Ctrl+Entrée pour exécuter la requête

Réduire Développer Afficher le suivi Masquer le suivi Temps nécessaire :

Aucun signet

Intitulé: Base de données cible: Partager ce signet

Toujours développer les messages
Afficher l'historique des requêtes au démarrage
Afficher la requête de navigation courante
Exécuter les requêtes avec Entrée et insérer une nouvelle ligne avec Maj+Entrée. Ce choix peut être rendu permanent via les paramètres.
Passer au thème sombre

Réduire Développer Exécuter la requête à nouveau Éditer Expliquer Profilage Signet La requête a échoué Base de données : Daté du :

Sans titre *

v		prestashop ps2_access
id_profile : int(10) unsigned
id_tab : int(10) unsigned
view : int(11)
add : int(11)
edit : int(11)
delete : int(11)

v		prestashop ps2_accessory
id_product_1 : int(10) unsigned
id_product_2 : int(10) unsigned

v		prestashop ps2_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
alias : varchar(32)
company : varchar(32)
lastname : varchar(32)
firstname : varchar(32)
address1 : varchar(128)
address2 : varchar(128)
postcode : varchar(12)
city : varchar(64)
other : text
phone : varchar(16)
phone_mobile : varchar(16)
date_add : datetime
date_upd : datetime
active : tinyint(1) unsigned
deleted : tinyint(1) unsigned

v		prestashop ps2_alias
id_alias : int(10) unsigned
alias : varchar(255)
search : varchar(255)
active : tinyint(1)

v		prestashop ps2_attachment
id_attachment : int(10) unsigned
file : varchar(40)
mime : varchar(32)

v		prestashop ps2_attachment_lang
id_attachment : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)
description : text

v		prestashop ps2_attribute
id_attribute : int(10) unsigned
id_attribute_group : int(10) unsigned
color : varchar(32)

v		prestashop ps2_attribute_group
id_attribute_group : int(10) unsigned
is_color_group : tinyint(1)

v		prestashop ps2_attribute_group_lang
id_attribute_group : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
public_name : varchar(64)

v		prestashop ps2_attribute_impact
id_attribute_impact : int(10) unsigned
id_product : int(11)
id_attribute : int(11)
weight : float
price : decimal(10,2)

v		prestashop ps2_attribute_lang
id_attribute : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)

v		prestashop ps2_block_cms
id_block : int(10)
id_cms : int(10)

v		prestashop ps2_carrier
id_carrier : int(10) unsigned
id_tax : 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

v		prestashop ps2_carrier_lang
id_carrier : int(10) unsigned
id_lang : int(10) unsigned
delay : varchar(128)

v		prestashop ps2_carrier_zone
id_carrier : int(10) unsigned
id_zone : int(10) unsigned

v		prestashop ps2_cart
id_cart : int(10) unsigned
id_carrier : int(10) unsigned
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
recyclable : tinyint(1) unsigned
gift : tinyint(1) unsigned
gift_message : text
date_add : datetime
date_upd : datetime

v		prestashop ps2_cart_discount
id_cart : int(10) unsigned
id_discount : int(10) unsigned

v		prestashop ps2_cart_product
id_cart : int(10) unsigned
id_product : int(10) unsigned
id_product_attribute : int(10) unsigned
quantity : int(10) unsigned
date_add : datetime

v		prestashop ps2_category
id_category : int(10) unsigned
id_parent : int(10) unsigned
level_depth : tinyint(3) unsigned
active : tinyint(1) unsigned
date_add : datetime
date_upd : datetime

v		prestashop ps2_category_group
id_category : int(10) unsigned
id_group : int(10) unsigned

v		prestashop ps2_category_lang
id_category : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
description : text
link_rewrite : varchar(128)
meta_title : varchar(128)
meta_keywords : varchar(128)
meta_description : varchar(128)

v		prestashop ps2_category_product
id_category : int(10) unsigned
id_product : int(10) unsigned
position : int(10) unsigned

v		prestashop ps2_cms
id_cms : int(10) unsigned

v		prestashop ps2_cms_lang
id_cms : int(10) unsigned
id_lang : int(10) unsigned
meta_title : varchar(128)
meta_description : varchar(255)
meta_keywords : varchar(255)
content : longtext
link_rewrite : varchar(128)

v		prestashop ps2_configuration
id_configuration : int(10) unsigned
name : varchar(32)
value : text
date_add : datetime
date_upd : datetime

v		prestashop ps2_configuration_lang
id_configuration : int(10) unsigned
id_lang : int(10) unsigned
value : text
date_upd : datetime

v		prestashop ps2_connections
id_connections : int(10) unsigned
id_guest : int(10) unsigned
id_page : int(10) unsigned
ip_address : varchar(16)
date_add : datetime
http_referer : varchar(255)

v		prestashop ps2_connections_page
id_connections : int(10) unsigned
id_page : int(10) unsigned
time_start : datetime
time_end : datetime

v		prestashop ps2_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 ps2_contact
id_contact : int(10) unsigned
email : varchar(128)
position : tinyint(2) unsigned

v		prestashop ps2_contact_lang
id_contact : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)
description : text

v		prestashop ps2_country
id_country : int(10) unsigned
id_zone : int(10) unsigned
iso_code : varchar(3)
active : tinyint(1) unsigned
contains_states : tinyint(1)

v		prestashop ps2_country_lang
id_country : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps2_currency
id_currency : int(10) unsigned
name : varchar(32)
iso_code : varchar(3)
sign : varchar(8)
blank : tinyint(1) unsigned
format : tinyint(1) unsigned
decimals : tinyint(1) unsigned
conversion_rate : decimal(13,6)
deleted : tinyint(1) unsigned

v		prestashop ps2_customer
id_customer : int(10) unsigned
id_gender : int(10) unsigned
secure_key : varchar(32)
email : varchar(128)
passwd : varchar(32)
last_passwd_gen : timestamp
birthday : date
lastname : varchar(32)
newsletter : tinyint(1) unsigned
ip_registration_newsletter : varchar(15)
newsletter_date_add : datetime
optin : tinyint(1) unsigned
firstname : varchar(32)
active : tinyint(1) unsigned
deleted : tinyint(1)
date_add : datetime
date_upd : datetime

v		prestashop ps2_customer_group
id_customer : int(10) unsigned
id_group : int(10) unsigned

v		prestashop ps2_customization
id_customization : int(10) unsigned
id_product_attribute : int(10)
id_cart : int(10)
id_product : int(10)
quantity : int(10)
quantity_refunded : int(11)
quantity_returned : int(11)

v		prestashop ps2_customization_field
id_customization_field : int(10) unsigned
id_product : int(10)
type : tinyint(1)
required : tinyint(1)

v		prestashop ps2_customization_field_lang
id_customization_field : int(10)
id_lang : int(10)
name : varchar(255)

v		prestashop ps2_customized_data
id_customization : int(10)
type : tinyint(1)
index : int(3)
value : varchar(255)

v		prestashop ps2_date_range
id_date_range : int(10) unsigned
time_start : datetime
time_end : datetime

v		prestashop ps2_delivery
id_delivery : 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(10,2)

v		prestashop ps2_discount
id_discount : int(10) unsigned
id_discount_type : int(10) unsigned
id_customer : int(10) unsigned
name : varchar(32)
value : decimal(10,2)
quantity : int(10) unsigned
quantity_per_user : int(10) unsigned
cumulable : tinyint(1) unsigned
cumulable_reduction : tinyint(1) unsigned
date_from : datetime
date_to : datetime
minimal : decimal(10,2)
active : tinyint(1) unsigned

v		prestashop ps2_discount_category
id_category : int(11)
id_discount : int(11)

v		prestashop ps2_discount_lang
id_discount : int(10) unsigned
id_lang : int(10) unsigned
description : text

v		prestashop ps2_discount_quantity
id_discount_quantity : int(10) unsigned
id_discount_type : int(10) unsigned
id_product : int(10) unsigned
id_product_attribute : int(10) unsigned
quantity : int(10) unsigned
value : decimal(10,2) unsigned

v		prestashop ps2_discount_type
id_discount_type : int(10) unsigned

v		prestashop ps2_discount_type_lang
id_discount_type : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps2_employee
id_employee : int(10) unsigned
id_profile : int(10) unsigned
lastname : varchar(32)
firstname : varchar(32)
email : varchar(128)
passwd : varchar(32)
last_passwd_gen : timestamp
stats_date_from : date
stats_date_to : date
active : tinyint(1) unsigned

v		prestashop ps2_feature
id_feature : int(10) unsigned

v		prestashop ps2_feature_lang
id_feature : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)

v		prestashop ps2_feature_product
id_feature : int(10) unsigned
id_product : int(10) unsigned
id_feature_value : int(10) unsigned

v		prestashop ps2_feature_value
id_feature_value : int(10) unsigned
id_feature : int(10) unsigned
custom : tinyint(3) unsigned

v		prestashop ps2_feature_value_lang
id_feature_value : int(10) unsigned
id_lang : int(10) unsigned
value : varchar(255)

v		prestashop ps2_group
id_group : int(10) unsigned
reduction : decimal(10,2)
date_add : datetime
date_upd : datetime

v		prestashop ps2_group_lang
id_group : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps2_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)

v		prestashop ps2_hook
id_hook : int(10) unsigned
name : varchar(64)
title : varchar(64)
description : text
position : tinyint(1)

v		prestashop ps2_hook_module
id_module : int(10) unsigned
id_hook : int(10) unsigned
position : tinyint(2) unsigned

v		prestashop ps2_hook_module_exceptions
id_hook_module_exceptions : int(10) unsigned
id_module : int(10) unsigned
id_hook : int(10) unsigned
file_name : varchar(255)

v		prestashop ps2_image
id_image : int(10) unsigned
id_product : int(10) unsigned
position : tinyint(2) unsigned
cover : tinyint(1) unsigned

v		prestashop ps2_image_lang
id_image : int(10) unsigned
id_lang : int(10) unsigned
legend : varchar(128)

v		prestashop ps2_image_type
id_image_type : int(10) unsigned
name : varchar(16)
width : int(10) unsigned
height : int(10) unsigned
products : tinyint(1)
categories : tinyint(1)
manufacturers : tinyint(1)
suppliers : tinyint(1)
scenes : tinyint(1)

v		prestashop ps2_lang
id_lang : int(10) unsigned
name : varchar(32)
active : tinyint(3) unsigned
iso_code : char(2)

v		prestashop ps2_manufacturer
id_manufacturer : int(10) unsigned
name : varchar(64)
date_add : datetime
date_upd : datetime

v		prestashop ps2_manufacturer_lang
id_manufacturer : int(10) unsigned
id_lang : int(10) unsigned
description : text
short_description : varchar(254)
meta_title : varchar(254)
meta_keywords : varchar(254)
meta_description : varchar(254)

v		prestashop ps2_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 : text
private : tinyint(1) unsigned
date_add : datetime

v		prestashop ps2_message_readed
id_message : int(10) unsigned
id_employee : int(10) unsigned
date_add : datetime

v		prestashop ps2_meta
id_meta : int(10) unsigned
page : varchar(64)

v		prestashop ps2_meta_lang
id_meta : int(10) unsigned
id_lang : int(10) unsigned
title : varchar(255)
description : varchar(255)
keywords : varchar(255)

v		prestashop ps2_module
id_module : int(10) unsigned
name : varchar(64)
active : tinyint(1) unsigned

v		prestashop ps2_module_country
id_module : int(10) unsigned
id_country : int(10) unsigned

v		prestashop ps2_module_currency
id_module : int(10) unsigned
id_currency : int(11)

v		prestashop ps2_module_group
id_module : int(10) unsigned
id_group : int(11)

v		prestashop ps2_operating_system
id_operating_system : int(10) unsigned
name : varchar(64)

v		prestashop ps2_orders
id_order : int(10) 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
secure_key : varchar(32)
payment : varchar(255)
module : varchar(255)
recyclable : tinyint(1) unsigned
gift : tinyint(1) unsigned
gift_message : text
shipping_number : varchar(32)
total_discounts : decimal(10,2)
total_paid : decimal(10,2)
total_paid_real : decimal(10,2)
total_products : decimal(10,2)
total_shipping : decimal(10,2)
total_wrapping : decimal(10,2)
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

v		prestashop ps2_order_detail
id_order_detail : int(10) unsigned
id_order : int(10) unsigned
product_id : int(10) unsigned
product_attribute_id : int(10) unsigned
product_name : varchar(255)
product_quantity : int(10) unsigned
product_quantity_in_stock : int(10) unsigned
product_quantity_refunded : int(10) unsigned
product_quantity_return : int(10) unsigned
product_quantity_reinjected : int(10) unsigned
product_price : decimal(13,6)
product_quantity_discount : decimal(13,6)
product_ean13 : varchar(13)
product_reference : varchar(32)
product_supplier_reference : varchar(32)
product_weight : float
tax_name : varchar(16)
tax_rate : decimal(10,2)
ecotax : decimal(10,2)
download_hash : varchar(255)
download_nb : int(10) unsigned
download_deadline : datetime

v		prestashop ps2_order_discount
id_order_discount : int(10) unsigned
id_order : int(10) unsigned
id_discount : int(10) unsigned
name : varchar(32)
value : decimal(10,2)

v		prestashop ps2_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 ps2_order_message
id_order_message : int(10) unsigned
date_add : datetime

v		prestashop ps2_order_message_lang
id_order_message : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
message : text

v		prestashop ps2_order_return
id_order_return : int(10) unsigned
id_customer : int(10) unsigned
id_order : int(10) unsigned
state : tinyint(1) unsigned
question : text
date_add : datetime
date_upd : datetime

v		prestashop ps2_order_return_detail
id_order_return : int(10) unsigned
id_order_detail : int(10) unsigned
id_customization : int(10)
product_quantity : int(10) unsigned

v		prestashop ps2_order_return_state
id_order_return_state : int(10) unsigned
color : varchar(32)

v		prestashop ps2_order_return_state_lang
id_order_return_state : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps2_order_slip
id_order_slip : int(10) unsigned
id_customer : int(10) unsigned
id_order : int(10) unsigned
shipping_cost : tinyint(3) unsigned
date_add : datetime
date_upd : datetime

v		prestashop ps2_order_slip_detail
id_order_slip : int(10) unsigned
id_order_detail : int(10) unsigned
product_quantity : int(10) unsigned

v		prestashop ps2_order_state
id_order_state : int(10) unsigned
invoice : tinyint(1) unsigned
send_email : tinyint(1) unsigned
color : varchar(32)
unremovable : tinyint(1) unsigned
hidden : tinyint(1) unsigned
logable : tinyint(1)
delivery : tinyint(1) unsigned

v		prestashop ps2_order_state_lang
id_order_state : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)
template : varchar(64)

v		prestashop ps2_pack
id_product_pack : int(10) unsigned
id_product_item : int(10) unsigned
quantity : int(10) unsigned

v		prestashop ps2_page
id_page : int(10) unsigned
id_page_type : int(10) unsigned
id_object : int(10) unsigned

v		prestashop ps2_pagenotfound
id_pagenotfound : int(10) unsigned
request_uri : varchar(256)
http_referer : varchar(256)
date_add : datetime

v		prestashop ps2_page_type
id_page_type : int(10) unsigned
name : varchar(255)

v		prestashop ps2_page_viewed
id_page : int(10) unsigned
id_date_range : int(10) unsigned
counter : int(10) unsigned

v		prestashop ps2_product
id_product : int(10) unsigned
id_supplier : int(10) unsigned
id_manufacturer : int(10) unsigned
id_tax : int(10) unsigned
id_category_default : int(10) unsigned
id_color_default : int(10) unsigned
on_sale : tinyint(1) unsigned
ean13 : varchar(13)
ecotax : decimal(10,2)
quantity : int(10) unsigned
price : decimal(13,6)
wholesale_price : decimal(13,6)
reduction_price : decimal(10,2)
reduction_percent : float
reduction_from : date
reduction_to : date
reference : varchar(32)
supplier_reference : varchar(32)
location : varchar(64)
weight : float
out_of_stock : int(10) unsigned
quantity_discount : tinyint(1)
customizable : tinyint(2)
uploadable_files : tinyint(4)
text_fields : tinyint(4)
active : tinyint(1) unsigned
indexed : tinyint(1)
date_add : datetime
date_upd : datetime

v		prestashop ps2_product_attachment
id_product : int(10)
id_attachment : int(10)

v		prestashop ps2_product_attribute
id_product_attribute : int(10) unsigned
id_product : int(10) unsigned
reference : varchar(32)
supplier_reference : varchar(32)
location : varchar(64)
ean13 : varchar(13)
wholesale_price : decimal(13,6)
price : decimal(10,2)
ecotax : decimal(10,2)
quantity : int(10) unsigned
weight : float
default_on : tinyint(1) unsigned

v		prestashop ps2_product_attribute_combination
id_attribute : int(10) unsigned
id_product_attribute : int(10) unsigned

v		prestashop ps2_product_attribute_image
id_product_attribute : int(10)
id_image : int(10)

v		prestashop ps2_product_download
id_product_download : int(10) unsigned
id_product : int(10) unsigned
display_filename : varchar(255)
physically_filename : varchar(255)
date_deposit : datetime
date_expiration : datetime
nb_days_accessible : int(10) unsigned
nb_downloadable : int(10) unsigned
active : tinyint(1) unsigned

v		prestashop ps2_product_lang
id_product : int(10) unsigned
id_lang : int(10) unsigned
description : text
description_short : text
link_rewrite : varchar(128)
meta_description : varchar(255)
meta_keywords : varchar(255)
meta_title : varchar(128)
name : varchar(128)
available_now : varchar(255)
available_later : varchar(255)

v		prestashop ps2_product_sale
id_product : int(10) unsigned
quantity : int(10) unsigned
sale_nbr : int(10) unsigned
date_upd : date

v		prestashop ps2_product_tag
id_product : int(10) unsigned
id_tag : int(10) unsigned

v		prestashop ps2_profile
id_profile : int(10) unsigned

v		prestashop ps2_profile_lang
id_lang : int(10) unsigned
id_profile : int(10) unsigned
name : varchar(128)

v		prestashop ps2_quick_access
id_quick_access : int(10) unsigned
new_window : tinyint(1)
link : varchar(128)

v		prestashop ps2_quick_access_lang
id_quick_access : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps2_range_price
id_range_price : int(10) unsigned
id_carrier : int(10) unsigned
delimiter1 : decimal(13,6)
delimiter2 : decimal(13,6)

v		prestashop ps2_range_weight
id_range_weight : int(10) unsigned
id_carrier : int(10) unsigned
delimiter1 : decimal(13,6)
delimiter2 : decimal(13,6)

v		prestashop ps2_referrer
id_referrer : int(10) unsigned
name : varchar(64)
passwd : varchar(32)
http_referer_regexp : varchar(64)
http_referer_like : varchar(64)
request_uri_regexp : varchar(64)
request_uri_like : varchar(64)
http_referer_regexp_not : varchar(64)
http_referer_like_not : varchar(64)
request_uri_regexp_not : varchar(64)
request_uri_like_not : varchar(64)
base_fee : decimal(5,2)
percent_fee : decimal(5,2)
click_fee : decimal(5,2)
cache_visitors : int(11)
cache_visits : int(11)
cache_pages : int(11)
cache_registrations : int(11)
cache_orders : int(11)
cache_sales : decimal(10,2)
cache_reg_rate : decimal(5,4)
cache_order_rate : decimal(5,4)
date_add : datetime

v		prestashop ps2_referrer_cache
id_connections_source : int(11)
id_referrer : int(11)

v		prestashop ps2_scene
id_scene : int(10) unsigned
active : tinyint(1)

v		prestashop ps2_scene_category
id_scene : int(10)
id_category : int(10)

v		prestashop ps2_scene_lang
id_scene : int(10)
id_lang : int(10)
name : varchar(100)

v		prestashop ps2_scene_products
id_scene : int(10)
id_product : int(10)
x_axis : int(4)
y_axis : int(4)
zone_width : int(3)
zone_height : int(3)

v		prestashop ps2_search_engine
id_search_engine : int(10) unsigned
server : varchar(64)
getvar : varchar(16)

v		prestashop ps2_search_index
id_product : int(11)
id_word : int(11)
weight : tinyint(4)

v		prestashop ps2_search_word
id_word : int(10) unsigned
id_lang : int(10) unsigned
word : varchar(15)

v		prestashop ps2_sekeyword
id_sekeyword : int(10) unsigned
keyword : varchar(256)
date_add : datetime

v		prestashop ps2_state
id_state : int(10) unsigned
id_country : int(11)
id_zone : int(11)
name : varchar(64)
iso_code : char(4)
tax_behavior : smallint(1)
active : tinyint(1)

v		prestashop ps2_statssearch
id_statssearch : int(10) unsigned
keywords : varchar(255)
results : int(6)
date_add : datetime

v		prestashop ps2_subdomain
id_subdomain : int(10) unsigned
name : varchar(16)

v		prestashop ps2_supplier
id_supplier : int(10) unsigned
name : varchar(64)
date_add : datetime
date_upd : datetime

v		prestashop ps2_supplier_lang
id_supplier : int(10) unsigned
id_lang : int(10) unsigned
description : text
meta_title : varchar(254)
meta_keywords : varchar(254)
meta_description : varchar(254)

v		prestashop ps2_tab
id_tab : int(10) unsigned
id_parent : int(11)
class_name : varchar(64)
module : varchar(64)
position : int(10) unsigned

v		prestashop ps2_tab_lang
id_lang : int(10) unsigned
id_tab : int(10) unsigned
name : varchar(32)

v		prestashop ps2_tag
id_tag : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps2_tax
id_tax : int(10) unsigned
rate : float

v		prestashop ps2_tax_lang
id_tax : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps2_tax_state
id_tax : int(10) unsigned
id_state : int(10) unsigned

v		prestashop ps2_tax_zone
id_tax : int(10) unsigned
id_zone : int(10) unsigned

v		prestashop ps2_timezone
id_timezone : int(10) unsigned
name : varchar(32)

v		prestashop ps2_web_browser
id_web_browser : int(10) unsigned
name : varchar(64)

v		prestashop ps2_zone
id_zone : int(10) unsigned
name : varchar(64)
active : tinyint(1) unsigned
enabled : tinyint(1) unsigned

v		prestashop ps_access
id_profile : int(10) unsigned
id_tab : int(10) unsigned
view : int(11)
add : int(11)
edit : int(11)
delete : int(11)

v		prestashop ps_accessory
id_product_1 : int(10) unsigned
id_product_2 : int(10) unsigned

v		prestashop ps_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
alias : varchar(32)
company : varchar(32)
lastname : varchar(32)
firstname : varchar(32)
address1 : varchar(128)
address2 : varchar(128)
postcode : varchar(12)
city : varchar(64)
other : text
phone : varchar(16)
phone_mobile : varchar(16)
date_add : datetime
date_upd : datetime
active : tinyint(1) unsigned
deleted : tinyint(1) unsigned

v		prestashop ps_alias
id_alias : int(10) unsigned
alias : varchar(255)
search : varchar(255)
active : tinyint(1)

v		prestashop ps_attachment
id_attachment : int(10) unsigned
file : varchar(40)
mime : varchar(32)

v		prestashop ps_attachment_lang
id_attachment : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)
description : text

v		prestashop ps_attribute
id_attribute : int(10) unsigned
id_attribute_group : int(10) unsigned
color : varchar(32)

v		prestashop ps_attribute_group
id_attribute_group : int(10) unsigned
is_color_group : tinyint(1)

v		prestashop ps_attribute_group_lang
id_attribute_group : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
public_name : varchar(64)

v		prestashop ps_attribute_impact
id_attribute_impact : int(10) unsigned
id_product : int(11)
id_attribute : int(11)
weight : float
price : decimal(10,2)

v		prestashop ps_attribute_lang
id_attribute : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)

v		prestashop ps_block_cms
id_block : int(10)
id_cms : int(10)

v		prestashop ps_carrier
id_carrier : int(10) unsigned
id_tax : 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

v		prestashop ps_carrier_lang
id_carrier : int(10) unsigned
id_lang : int(10) unsigned
delay : varchar(128)

v		prestashop ps_carrier_zone
id_carrier : int(10) unsigned
id_zone : int(10) unsigned

v		prestashop ps_cart
id_cart : int(10) unsigned
id_carrier : int(10) unsigned
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
recyclable : tinyint(1) unsigned
gift : tinyint(1) unsigned
gift_message : text
date_add : datetime
date_upd : datetime

v		prestashop ps_cart_discount
id_cart : int(10) unsigned
id_discount : int(10) unsigned

v		prestashop ps_cart_product
id_cart : int(10) unsigned
id_product : int(10) unsigned
id_product_attribute : int(10) unsigned
quantity : int(10) unsigned
date_add : datetime

v		prestashop ps_category
id_category : int(10) unsigned
id_parent : int(10) unsigned
level_depth : tinyint(3) unsigned
active : tinyint(1) unsigned
date_add : datetime
date_upd : datetime

v		prestashop ps_category_group
id_category : int(10) unsigned
id_group : int(10) unsigned

v		prestashop ps_category_lang
id_category : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
description : text
link_rewrite : varchar(128)
meta_title : varchar(128)
meta_keywords : varchar(128)
meta_description : varchar(128)

v		prestashop ps_category_product
id_category : int(10) unsigned
id_product : int(10) unsigned
position : int(10) unsigned

v		prestashop ps_cms
id_cms : int(10) unsigned

v		prestashop ps_cms_lang
id_cms : int(10) unsigned
id_lang : int(10) unsigned
meta_title : varchar(128)
meta_description : varchar(255)
meta_keywords : varchar(255)
content : longtext
link_rewrite : varchar(128)

v		prestashop ps_configuration
id_configuration : int(10) unsigned
name : varchar(32)
value : text
date_add : datetime
date_upd : datetime

v		prestashop ps_configuration_lang
id_configuration : int(10) unsigned
id_lang : int(10) unsigned
value : text
date_upd : datetime

v		prestashop ps_connections
id_connections : int(10) unsigned
id_guest : int(10) unsigned
id_page : int(10) unsigned
ip_address : varchar(16)
date_add : datetime
http_referer : varchar(255)

v		prestashop ps_connections_page
id_connections : int(10) unsigned
id_page : int(10) unsigned
time_start : datetime
time_end : datetime

v		prestashop ps_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 ps_contact
id_contact : int(10) unsigned
email : varchar(128)
position : tinyint(2) unsigned

v		prestashop ps_contact_lang
id_contact : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)
description : text

v		prestashop ps_country
id_country : int(10) unsigned
id_zone : int(10) unsigned
iso_code : varchar(3)
active : tinyint(1) unsigned
contains_states : tinyint(1)

v		prestashop ps_country_lang
id_country : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps_currency
id_currency : int(10) unsigned
name : varchar(32)
iso_code : varchar(3)
sign : varchar(8)
blank : tinyint(1) unsigned
format : tinyint(1) unsigned
decimals : tinyint(1) unsigned
conversion_rate : decimal(13,6)
deleted : tinyint(1) unsigned

v		prestashop ps_customer
id_customer : int(10) unsigned
id_gender : int(10) unsigned
secure_key : varchar(32)
email : varchar(128)
passwd : varchar(32)
last_passwd_gen : timestamp
birthday : date
lastname : varchar(32)
newsletter : tinyint(1) unsigned
ip_registration_newsletter : varchar(15)
newsletter_date_add : datetime
optin : tinyint(1) unsigned
firstname : varchar(32)
active : tinyint(1) unsigned
deleted : tinyint(1)
date_add : datetime
date_upd : datetime

v		prestashop ps_customer_group
id_customer : int(10) unsigned
id_group : int(10) unsigned

v		prestashop ps_customization
id_customization : int(10) unsigned
id_product_attribute : int(10)
id_cart : int(10)
id_product : int(10)
quantity : int(10)
quantity_refunded : int(11)
quantity_returned : int(11)

v		prestashop ps_customization_field
id_customization_field : int(10) unsigned
id_product : int(10)
type : tinyint(1)
required : tinyint(1)

v		prestashop ps_customization_field_lang
id_customization_field : int(10)
id_lang : int(10)
name : varchar(255)

v		prestashop ps_customized_data
id_customization : int(10)
type : tinyint(1)
index : int(3)
value : varchar(255)

v		prestashop ps_date_range
id_date_range : int(10) unsigned
time_start : datetime
time_end : datetime

v		prestashop ps_delivery
id_delivery : 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(10,2)

v		prestashop ps_discount
id_discount : int(10) unsigned
id_discount_type : int(10) unsigned
id_customer : int(10) unsigned
name : varchar(32)
value : decimal(10,2)
quantity : int(10) unsigned
quantity_per_user : int(10) unsigned
cumulable : tinyint(1) unsigned
cumulable_reduction : tinyint(1) unsigned
date_from : datetime
date_to : datetime
minimal : decimal(10,2)
active : tinyint(1) unsigned

v		prestashop ps_discount_category
id_category : int(11)
id_discount : int(11)

v		prestashop ps_discount_lang
id_discount : int(10) unsigned
id_lang : int(10) unsigned
description : text

v		prestashop ps_discount_quantity
id_discount_quantity : int(10) unsigned
id_discount_type : int(10) unsigned
id_product : int(10) unsigned
id_product_attribute : int(10) unsigned
quantity : int(10) unsigned
value : decimal(10,2) unsigned

v		prestashop ps_discount_type
id_discount_type : int(10) unsigned

v		prestashop ps_discount_type_lang
id_discount_type : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps_employee
id_employee : int(10) unsigned
id_profile : int(10) unsigned
lastname : varchar(32)
firstname : varchar(32)
email : varchar(128)
passwd : varchar(32)
last_passwd_gen : timestamp
stats_date_from : date
stats_date_to : date
active : tinyint(1) unsigned

v		prestashop ps_feature
id_feature : int(10) unsigned

v		prestashop ps_feature_lang
id_feature : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)

v		prestashop ps_feature_product
id_feature : int(10) unsigned
id_product : int(10) unsigned
id_feature_value : int(10) unsigned

v		prestashop ps_feature_value
id_feature_value : int(10) unsigned
id_feature : int(10) unsigned
custom : tinyint(3) unsigned

v		prestashop ps_feature_value_lang
id_feature_value : int(10) unsigned
id_lang : int(10) unsigned
value : varchar(255)

v		prestashop ps_group
id_group : int(10) unsigned
reduction : decimal(10,2)
date_add : datetime
date_upd : datetime

v		prestashop ps_group_lang
id_group : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps_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)

v		prestashop ps_hook
id_hook : int(10) unsigned
name : varchar(64)
title : varchar(64)
description : text
position : tinyint(1)

v		prestashop ps_hook_module
id_module : int(10) unsigned
id_hook : int(10) unsigned
position : tinyint(2) unsigned

v		prestashop ps_hook_module_exceptions
id_hook_module_exceptions : int(10) unsigned
id_module : int(10) unsigned
id_hook : int(10) unsigned
file_name : varchar(255)

v		prestashop ps_image
id_image : int(10) unsigned
id_product : int(10) unsigned
position : tinyint(2) unsigned
cover : tinyint(1) unsigned

v		prestashop ps_image_lang
id_image : int(10) unsigned
id_lang : int(10) unsigned
legend : varchar(128)

v		prestashop ps_image_type
id_image_type : int(10) unsigned
name : varchar(16)
width : int(10) unsigned
height : int(10) unsigned
products : tinyint(1)
categories : tinyint(1)
manufacturers : tinyint(1)
suppliers : tinyint(1)
scenes : tinyint(1)

v		prestashop ps_lang
id_lang : int(10) unsigned
name : varchar(32)
active : tinyint(3) unsigned
iso_code : char(2)

v		prestashop ps_manufacturer
id_manufacturer : int(10) unsigned
name : varchar(64)
date_add : datetime
date_upd : datetime

v		prestashop ps_manufacturer_lang
id_manufacturer : int(10) unsigned
id_lang : int(10) unsigned
description : text
short_description : varchar(254)
meta_title : varchar(254)
meta_keywords : varchar(254)
meta_description : varchar(254)

v		prestashop ps_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 : text
private : tinyint(1) unsigned
date_add : datetime

v		prestashop ps_message_readed
id_message : int(10) unsigned
id_employee : int(10) unsigned
date_add : datetime

v		prestashop ps_meta
id_meta : int(10) unsigned
page : varchar(64)

v		prestashop ps_meta_lang
id_meta : int(10) unsigned
id_lang : int(10) unsigned
title : varchar(255)
description : varchar(255)
keywords : varchar(255)

v		prestashop ps_module
id_module : int(10) unsigned
name : varchar(64)
active : tinyint(1) unsigned

v		prestashop ps_module_country
id_module : int(10) unsigned
id_country : int(10) unsigned

v		prestashop ps_module_currency
id_module : int(10) unsigned
id_currency : int(11)

v		prestashop ps_module_group
id_module : int(10) unsigned
id_group : int(11)

v		prestashop ps_operating_system
id_operating_system : int(10) unsigned
name : varchar(64)

v		prestashop ps_orders
id_order : int(10) 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
secure_key : varchar(32)
payment : varchar(255)
module : varchar(255)
recyclable : tinyint(1) unsigned
gift : tinyint(1) unsigned
gift_message : text
shipping_number : varchar(32)
total_discounts : decimal(10,2)
total_paid : decimal(10,2)
total_paid_real : decimal(10,2)
total_products : decimal(10,2)
total_shipping : decimal(10,2)
total_wrapping : decimal(10,2)
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

v		prestashop ps_order_detail
id_order_detail : int(10) unsigned
id_order : int(10) unsigned
product_id : int(10) unsigned
product_attribute_id : int(10) unsigned
product_name : varchar(255)
product_quantity : int(10) unsigned
product_quantity_in_stock : int(10) unsigned
product_quantity_refunded : int(10) unsigned
product_quantity_return : int(10) unsigned
product_quantity_reinjected : int(10) unsigned
product_price : decimal(13,6)
product_quantity_discount : decimal(13,6)
product_ean13 : varchar(13)
product_reference : varchar(32)
product_supplier_reference : varchar(32)
product_weight : float
tax_name : varchar(16)
tax_rate : decimal(10,2)
ecotax : decimal(10,2)
download_hash : varchar(255)
download_nb : int(10) unsigned
download_deadline : datetime

v		prestashop ps_order_discount
id_order_discount : int(10) unsigned
id_order : int(10) unsigned
id_discount : int(10) unsigned
name : varchar(32)
value : decimal(10,2)

v		prestashop ps_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 ps_order_message
id_order_message : int(10) unsigned
date_add : datetime

v		prestashop ps_order_message_lang
id_order_message : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(128)
message : text

v		prestashop ps_order_return
id_order_return : int(10) unsigned
id_customer : int(10) unsigned
id_order : int(10) unsigned
state : tinyint(1) unsigned
question : text
date_add : datetime
date_upd : datetime

v		prestashop ps_order_return_detail
id_order_return : int(10) unsigned
id_order_detail : int(10) unsigned
id_customization : int(10)
product_quantity : int(10) unsigned

v		prestashop ps_order_return_state
id_order_return_state : int(10) unsigned
color : varchar(32)

v		prestashop ps_order_return_state_lang
id_order_return_state : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)

v		prestashop ps_order_slip
id_order_slip : int(10) unsigned
id_customer : int(10) unsigned
id_order : int(10) unsigned
shipping_cost : tinyint(3) unsigned
date_add : datetime
date_upd : datetime

v		prestashop ps_order_slip_detail
id_order_slip : int(10) unsigned
id_order_detail : int(10) unsigned
product_quantity : int(10) unsigned

v		prestashop ps_order_state
id_order_state : int(10) unsigned
invoice : tinyint(1) unsigned
send_email : tinyint(1) unsigned
color : varchar(32)
unremovable : tinyint(1) unsigned
hidden : tinyint(1) unsigned
logable : tinyint(1)
delivery : tinyint(1) unsigned

v		prestashop ps_order_state_lang
id_order_state : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(64)
template : varchar(64)

v		prestashop ps_pack
id_product_pack : int(10) unsigned
id_product_item : int(10) unsigned
quantity : int(10) unsigned

v		prestashop ps_page
id_page : int(10) unsigned
id_page_type : int(10) unsigned
id_object : int(10) unsigned

v		prestashop ps_pagenotfound
id_pagenotfound : int(10) unsigned
request_uri : varchar(256)
http_referer : varchar(256)
date_add : datetime

v		prestashop ps_page_type
id_page_type : int(10) unsigned
name : varchar(255)

v		prestashop ps_page_viewed
id_page : int(10) unsigned
id_date_range : int(10) unsigned
counter : int(10) unsigned

v		prestashop ps_product
id_product : int(10) unsigned
id_supplier : int(10) unsigned
id_manufacturer : int(10) unsigned
id_tax : int(10) unsigned
id_category_default : int(10) unsigned
id_color_default : int(10) unsigned
on_sale : tinyint(1) unsigned
ean13 : varchar(13)
ecotax : decimal(10,2)
quantity : int(10) unsigned
price : decimal(13,6)
wholesale_price : decimal(13,6)
reduction_price : decimal(10,2)
reduction_percent : float
reduction_from : date
reduction_to : date
reference : varchar(32)
supplier_reference : varchar(32)
location : varchar(64)
weight : float
out_of_stock : int(10) unsigned
quantity_discount : tinyint(1)
customizable : tinyint(2)
uploadable_files : tinyint(4)
text_fields : tinyint(4)
active : tinyint(1) unsigned
indexed : tinyint(1)
date_add : datetime
date_upd : datetime

v		prestashop ps_product_attachment
id_product : int(10)
id_attachment : int(10)

v		prestashop ps_product_attribute
id_product_attribute : int(10) unsigned
id_product : int(10) unsigned
reference : varchar(32)
supplier_reference : varchar(32)
location : varchar(64)
ean13 : varchar(13)
wholesale_price : decimal(13,6)
price : decimal(10,2)
ecotax : decimal(10,2)
quantity : int(10) unsigned
weight : float
default_on : tinyint(1) unsigned

v		prestashop ps_product_attribute_combination
id_attribute : int(10) unsigned
id_product_attribute : int(10) unsigned

v		prestashop ps_product_attribute_image
id_product_attribute : int(10)
id_image : int(10)

v		prestashop ps_product_download
id_product_download : int(10) unsigned
id_product : int(10) unsigned
display_filename : varchar(255)
physically_filename : varchar(255)
date_deposit : datetime
date_expiration : datetime
nb_days_accessible : int(10) unsigned
nb_downloadable : int(10) unsigned
active : tinyint(1) unsigned

v		prestashop ps_product_lang
id_product : int(10) unsigned
id_lang : int(10) unsigned
description : text
description_short : text
link_rewrite : varchar(128)
meta_description : varchar(255)
meta_keywords : varchar(255)
meta_title : varchar(128)
name : varchar(128)
available_now : varchar(255)
available_later : varchar(255)

v		prestashop ps_product_sale
id_product : int(10) unsigned
quantity : int(10) unsigned
sale_nbr : int(10) unsigned
date_upd : date

v		prestashop ps_product_tag
id_product : int(10) unsigned
id_tag : int(10) unsigned

v		prestashop ps_profile
id_profile : int(10) unsigned

v		prestashop ps_profile_lang
id_lang : int(10) unsigned
id_profile : int(10) unsigned
name : varchar(128)

v		prestashop ps_quick_access
id_quick_access : int(10) unsigned
new_window : tinyint(1)
link : varchar(128)

v		prestashop ps_quick_access_lang
id_quick_access : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps_range_price
id_range_price : int(10) unsigned
id_carrier : int(10) unsigned
delimiter1 : decimal(13,6)
delimiter2 : decimal(13,6)

v		prestashop ps_range_weight
id_range_weight : int(10) unsigned
id_carrier : int(10) unsigned
delimiter1 : decimal(13,6)
delimiter2 : decimal(13,6)

v		prestashop ps_referrer
id_referrer : int(10) unsigned
name : varchar(64)
passwd : varchar(32)
http_referer_regexp : varchar(64)
http_referer_like : varchar(64)
request_uri_regexp : varchar(64)
request_uri_like : varchar(64)
http_referer_regexp_not : varchar(64)
http_referer_like_not : varchar(64)
request_uri_regexp_not : varchar(64)
request_uri_like_not : varchar(64)
base_fee : decimal(5,2)
percent_fee : decimal(5,2)
click_fee : decimal(5,2)
cache_visitors : int(11)
cache_visits : int(11)
cache_pages : int(11)
cache_registrations : int(11)
cache_orders : int(11)
cache_sales : decimal(10,2)
cache_reg_rate : decimal(5,4)
cache_order_rate : decimal(5,4)
date_add : datetime

v		prestashop ps_referrer_cache
id_connections_source : int(11)
id_referrer : int(11)

v		prestashop ps_scene
id_scene : int(10) unsigned
active : tinyint(1)

v		prestashop ps_scene_category
id_scene : int(10)
id_category : int(10)

v		prestashop ps_scene_lang
id_scene : int(10)
id_lang : int(10)
name : varchar(100)

v		prestashop ps_scene_products
id_scene : int(10)
id_product : int(10)
x_axis : int(4)
y_axis : int(4)
zone_width : int(3)
zone_height : int(3)

v		prestashop ps_search_engine
id_search_engine : int(10) unsigned
server : varchar(64)
getvar : varchar(16)

v		prestashop ps_search_index
id_product : int(11)
id_word : int(11)
weight : tinyint(4)

v		prestashop ps_search_word
id_word : int(10) unsigned
id_lang : int(10) unsigned
word : varchar(15)

v		prestashop ps_sekeyword
id_sekeyword : int(10) unsigned
keyword : varchar(256)
date_add : datetime

v		prestashop ps_state
id_state : int(10) unsigned
id_country : int(11)
id_zone : int(11)
name : varchar(64)
iso_code : char(4)
tax_behavior : smallint(1)
active : tinyint(1)

v		prestashop ps_statssearch
id_statssearch : int(10) unsigned
keywords : varchar(255)
results : int(6)
date_add : datetime

v		prestashop ps_subdomain
id_subdomain : int(10) unsigned
name : varchar(16)

v		prestashop ps_supplier
id_supplier : int(10) unsigned
name : varchar(64)
date_add : datetime
date_upd : datetime

v		prestashop ps_supplier_lang
id_supplier : int(10) unsigned
id_lang : int(10) unsigned
description : text
meta_title : varchar(254)
meta_keywords : varchar(254)
meta_description : varchar(254)

v		prestashop ps_tab
id_tab : int(10) unsigned
id_parent : int(11)
class_name : varchar(64)
module : varchar(64)
position : int(10) unsigned

v		prestashop ps_tab_lang
id_lang : int(10) unsigned
id_tab : int(10) unsigned
name : varchar(32)

v		prestashop ps_tag
id_tag : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps_tax
id_tax : int(10) unsigned
rate : float

v		prestashop ps_tax_lang
id_tax : int(10) unsigned
id_lang : int(10) unsigned
name : varchar(32)

v		prestashop ps_tax_state
id_tax : int(10) unsigned
id_state : int(10) unsigned

v		prestashop ps_tax_zone
id_tax : int(10) unsigned
id_zone : int(10) unsigned

v		prestashop ps_timezone
id_timezone : int(10) unsigned
name : varchar(32)

v		prestashop ps_web_browser
id_web_browser : int(10) unsigned
name : varchar(64)

v		prestashop ps_zone
id_zone : int(10) unsigned
name : varchar(64)
active : tinyint(1) unsigned
enabled : tinyint(1) unsigned

Nouvelle relation
FOREIGN KEY
on delete
on update