Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
MySQL diff PrestaShop 1.6 >> 1.7
# server1 on 127.0.0.1: ... connected.
# WARNING: Objects in server1.prestashop16 but not in server1.prestashop:
# TABLE: ps_scene_lang
# TABLE: ps_compare
# TABLE: ps_scene_products
# TABLE: ps_scene_category
# TABLE: ps_scene_shop
# TABLE: ps_cms_block_shop
# TABLE: ps_themeconfigurator
# TABLE: ps_theme_specific
# TABLE: ps_layered_friendly_url
# TABLE: ps_scene
# TABLE: ps_modules_perfs
# TABLE: ps_compare_product
# TABLE: ps_newsletter
# TABLE: ps_cms_block
# TABLE: ps_theme_meta
# TABLE: ps_theme
# TABLE: ps_cms_block_page
# TABLE: ps_cms_block_lang
# WARNING: Objects in server1.prestashop but not in server1.prestashop16:
# TABLE: ps_link_block
# TABLE: ps_authorization_role
# TABLE: ps_emailsubscription
# TABLE: ps_reassurance_lang
# TABLE: ps_store_lang
# TABLE: ps_reassurance
# TABLE: ps_translation
# TABLE: ps_currency_lang
# TABLE: ps_admin_filter
# TABLE: ps_link_block_lang
# TABLE: ps_module_history
# TABLE: ps_link_block_shop
# TABLE: ps_module_carrier
# Comparing `prestashop16` to `prestashop` [PASS]
# Comparing `prestashop16`.`ps_access` to `prestashop`.`ps_access` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_access`
+++ `prestashop`.`ps_access`
@@ -1,9 +1,5 @@
CREATE TABLE `ps_access` (
`id_profile` int(10) unsigned NOT NULL,
- `id_tab` int(10) unsigned NOT NULL,
- `view` int(11) NOT NULL,
- `add` int(11) NOT NULL,
- `edit` int(11) NOT NULL,
- `delete` int(11) NOT NULL,
- PRIMARY KEY (`id_profile`,`id_tab`)
+ `id_authorization_role` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id_profile`,`id_authorization_role`)
)
# Comparing `prestashop16`.`ps_accessory` to `prestashop`.`ps_accessory` [PASS]
# Comparing `prestashop16`.`ps_address` to `prestashop`.`ps_address` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_address`
+++ `prestashop`.`ps_address`
@@ -8,8 +8,8 @@
`id_warehouse` int(10) unsigned NOT NULL DEFAULT '0',
`alias` varchar(32) NOT NULL,
`company` varchar(255) DEFAULT NULL,
- `lastname` varchar(32) NOT NULL,
- `firstname` varchar(32) NOT NULL,
+ `lastname` varchar(255) NOT NULL,
+ `firstname` varchar(255) NOT NULL,
`address1` varchar(128) NOT NULL,
`address2` varchar(128) DEFAULT NULL,
`postcode` varchar(12) DEFAULT NULL,
# Comparing `prestashop16`.`ps_address_format` to `prestashop`.`ps_address_format` [PASS]
# Comparing `prestashop16`.`ps_alias` to `prestashop`.`ps_alias` [PASS]
# Comparing `prestashop16`.`ps_attachment` to `prestashop`.`ps_attachment` [PASS]
# Comparing `prestashop16`.`ps_attachment_lang` to `prestashop`.`ps_attachment_lang` [PASS]
# Comparing `prestashop16`.`ps_attribute` to `prestashop`.`ps_attribute` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute`
+++ `prestashop`.`ps_attribute`
@@ -1,8 +1,8 @@
CREATE TABLE `ps_attribute` (
- `id_attribute` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `id_attribute_group` int(10) unsigned NOT NULL,
- `color` varchar(32) DEFAULT NULL,
- `position` int(10) unsigned NOT NULL DEFAULT '0',
+ `id_attribute` int(11) NOT NULL AUTO_INCREMENT,
+ `id_attribute_group` int(11) NOT NULL,
+ `color` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `position` int(11) NOT NULL,
PRIMARY KEY (`id_attribute`),
KEY `attribute_group` (`id_attribute_group`)
)
# Comparing `prestashop16`.`ps_attribute_group` to `prestashop`.`ps_attribute_group` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute_group`
+++ `prestashop`.`ps_attribute_group`
@@ -1,7 +1,7 @@
CREATE TABLE `ps_attribute_group` (
- `id_attribute_group` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `is_color_group` tinyint(1) NOT NULL DEFAULT '0',
- `group_type` enum('select','radio','color') NOT NULL DEFAULT 'select',
- `position` int(10) unsigned NOT NULL DEFAULT '0',
+ `id_attribute_group` int(11) NOT NULL AUTO_INCREMENT,
+ `is_color_group` tinyint(1) NOT NULL,
+ `group_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `position` int(11) NOT NULL,
PRIMARY KEY (`id_attribute_group`)
)
# Comparing `prestashop16`.`ps_attribute_group_lang` to `prestashop`.`ps_attribute_group_lang` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute_group_lang`
+++ `prestashop`.`ps_attribute_group_lang`
@@ -1,7 +1,8 @@
CREATE TABLE `ps_attribute_group_lang` (
- `id_attribute_group` int(10) unsigned NOT NULL,
- `id_lang` int(10) unsigned NOT NULL,
- `name` varchar(128) NOT NULL,
- `public_name` varchar(64) NOT NULL,
- PRIMARY KEY (`id_attribute_group`,`id_lang`)
+ `id_attribute_group` int(11) NOT NULL,
+ `id_lang` int(11) NOT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+ `public_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id_attribute_group`,`id_lang`),
+ KEY `IDX_4653726C67A664FB` (`id_attribute_group`)
)
# Comparing `prestashop16`.`ps_attribute_group_shop` to `prestashop`.`ps_attribute_group_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute_group_shop`
+++ `prestashop`.`ps_attribute_group_shop`
@@ -1,6 +1,7 @@
CREATE TABLE `ps_attribute_group_shop` (
- `id_attribute_group` int(11) unsigned NOT NULL,
- `id_shop` int(11) unsigned NOT NULL,
+ `id_attribute_group` int(11) NOT NULL,
+ `id_shop` int(11) NOT NULL,
PRIMARY KEY (`id_attribute_group`,`id_shop`),
- KEY `id_shop` (`id_shop`)
+ KEY `IDX_DB30BAAC67A664FB` (`id_attribute_group`),
+ KEY `IDX_DB30BAAC274A50A0` (`id_shop`)
)
# Comparing `prestashop16`.`ps_attribute_impact` to `prestashop`.`ps_attribute_impact` [PASS]
# Comparing `prestashop16`.`ps_attribute_lang` to `prestashop`.`ps_attribute_lang` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute_lang`
+++ `prestashop`.`ps_attribute_lang`
@@ -1,7 +1,7 @@
CREATE TABLE `ps_attribute_lang` (
- `id_attribute` int(10) unsigned NOT NULL,
- `id_lang` int(10) unsigned NOT NULL,
- `name` varchar(128) NOT NULL,
+ `id_attribute` int(11) NOT NULL,
+ `id_lang` int(11) NOT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_attribute`,`id_lang`),
- KEY `id_lang` (`id_lang`,`name`)
+ KEY `IDX_3ABE46A77A4F53DC` (`id_attribute`)
)
# Comparing `prestashop16`.`ps_attribute_shop` to `prestashop`.`ps_attribute_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_attribute_shop`
+++ `prestashop`.`ps_attribute_shop`
@@ -1,6 +1,7 @@
CREATE TABLE `ps_attribute_shop` (
- `id_attribute` int(11) unsigned NOT NULL,
- `id_shop` int(11) unsigned NOT NULL,
+ `id_attribute` int(11) NOT NULL,
+ `id_shop` int(11) NOT NULL,
PRIMARY KEY (`id_attribute`,`id_shop`),
- KEY `id_shop` (`id_shop`)
+ KEY `IDX_A7DD8E677A4F53DC` (`id_attribute`),
+ KEY `IDX_A7DD8E67274A50A0` (`id_shop`)
)
# Comparing `prestashop16`.`ps_carrier` to `prestashop`.`ps_carrier` [PASS]
# Comparing `prestashop16`.`ps_carrier_group` to `prestashop`.`ps_carrier_group` [PASS]
# Comparing `prestashop16`.`ps_carrier_lang` to `prestashop`.`ps_carrier_lang` [PASS]
# Comparing `prestashop16`.`ps_carrier_shop` to `prestashop`.`ps_carrier_shop` [PASS]
# Comparing `prestashop16`.`ps_carrier_tax_rules_group_shop` to `prestashop`.`ps_carrier_tax_rules_group_shop` [PASS]
# Comparing `prestashop16`.`ps_carrier_zone` to `prestashop`.`ps_carrier_zone` [PASS]
# Comparing `prestashop16`.`ps_cart` to `prestashop`.`ps_cart` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_cart`
+++ `prestashop`.`ps_cart`
@@ -18,6 +18,7 @@
`allow_seperated_package` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
+ `checkout_session_data` mediumtext,
PRIMARY KEY (`id_cart`),
KEY `cart_customer` (`id_customer`),
KEY `id_address_delivery` (`id_address_delivery`),
# Comparing `prestashop16`.`ps_cart_cart_rule` to `prestashop`.`ps_cart_cart_rule` [PASS]
# Comparing `prestashop16`.`ps_cart_product` to `prestashop`.`ps_cart_product` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_cart_product`
+++ `prestashop`.`ps_cart_product`
@@ -4,9 +4,10 @@
`id_address_delivery` int(10) unsigned NOT NULL DEFAULT '0',
`id_shop` int(10) unsigned NOT NULL DEFAULT '1',
`id_product_attribute` int(10) unsigned NOT NULL DEFAULT '0',
+ `id_customization` int(10) unsigned NOT NULL DEFAULT '0',
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
- PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`),
+ PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_customization`,`id_address_delivery`),
KEY `id_product_attribute` (`id_product_attribute`),
KEY `id_cart_order` (`id_cart`,`date_add`,`id_product`,`id_product_attribute`)
)
# Comparing `prestashop16`.`ps_cart_rule` to `prestashop`.`ps_cart_rule` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_cart_rule`
+++ `prestashop`.`ps_cart_rule`
@@ -25,6 +25,7 @@
`reduction_tax` tinyint(1) unsigned NOT NULL DEFAULT '0',
`reduction_currency` int(10) unsigned NOT NULL DEFAULT '0',
`reduction_product` int(10) NOT NULL DEFAULT '0',
+ `reduction_exclude_special` tinyint(1) unsigned NOT NULL DEFAULT '0',
`gift_product` int(10) unsigned NOT NULL DEFAULT '0',
`gift_product_attribute` int(10) unsigned NOT NULL DEFAULT '0',
`highlight` tinyint(1) unsigned NOT NULL DEFAULT '0',
# Comparing `prestashop16`.`ps_cart_rule_carrier` to `prestashop`.`ps_cart_rule_carrier` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_combination` to `prestashop`.`ps_cart_rule_combination` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_country` to `prestashop`.`ps_cart_rule_country` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_group` to `prestashop`.`ps_cart_rule_group` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_lang` to `prestashop`.`ps_cart_rule_lang` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_product_rule` to `prestashop`.`ps_cart_rule_product_rule` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_product_rule_group` to `prestashop`.`ps_cart_rule_product_rule_group` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_product_rule_value` to `prestashop`.`ps_cart_rule_product_rule_value` [PASS]
# Comparing `prestashop16`.`ps_cart_rule_shop` to `prestashop`.`ps_cart_rule_shop` [PASS]
# Comparing `prestashop16`.`ps_category` to `prestashop`.`ps_category` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_category`
# +++ `prestashop`.`ps_category`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=12
# +AUTO_INCREMENT=30
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_category_group` to `prestashop`.`ps_category_group` [PASS]
# Comparing `prestashop16`.`ps_category_lang` to `prestashop`.`ps_category_lang` [PASS]
# Comparing `prestashop16`.`ps_category_product` to `prestashop`.`ps_category_product` [PASS]
# Comparing `prestashop16`.`ps_category_shop` to `prestashop`.`ps_category_shop` [PASS]
# Comparing `prestashop16`.`ps_cms` to `prestashop`.`ps_cms` [PASS]
# Comparing `prestashop16`.`ps_cms_category` to `prestashop`.`ps_cms_category` [PASS]
# Comparing `prestashop16`.`ps_cms_category_lang` to `prestashop`.`ps_cms_category_lang` [PASS]
# Comparing `prestashop16`.`ps_cms_category_shop` to `prestashop`.`ps_cms_category_shop` [PASS]
# Comparing `prestashop16`.`ps_cms_lang` to `prestashop`.`ps_cms_lang` [PASS]
# Comparing `prestashop16`.`ps_cms_role` to `prestashop`.`ps_cms_role` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_cms_role`
# +++ `prestashop`.`ps_cms_role`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=3
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_cms_role_lang` to `prestashop`.`ps_cms_role_lang` [PASS]
# Comparing `prestashop16`.`ps_cms_shop` to `prestashop`.`ps_cms_shop` [PASS]
# Comparing `prestashop16`.`ps_configuration` to `prestashop`.`ps_configuration` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_configuration`
# +++ `prestashop`.`ps_configuration`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=348
# +AUTO_INCREMENT=342
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_configuration_kpi` to `prestashop`.`ps_configuration_kpi` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_configuration_kpi`
# +++ `prestashop`.`ps_configuration_kpi`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=37
# +AUTO_INCREMENT=73
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_configuration_kpi_lang` to `prestashop`.`ps_configuration_kpi_lang` [PASS]
# Comparing `prestashop16`.`ps_configuration_lang` to `prestashop`.`ps_configuration_lang` [PASS]
# Comparing `prestashop16`.`ps_connections` to `prestashop`.`ps_connections` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_connections`
# +++ `prestashop`.`ps_connections`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=2
# +AUTO_INCREMENT=13
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_connections_page` to `prestashop`.`ps_connections_page` [PASS]
# Comparing `prestashop16`.`ps_connections_source` to `prestashop`.`ps_connections_source` [PASS]
# Comparing `prestashop16`.`ps_contact` to `prestashop`.`ps_contact` [PASS]
# Comparing `prestashop16`.`ps_contact_lang` to `prestashop`.`ps_contact_lang` [PASS]
# Comparing `prestashop16`.`ps_contact_shop` to `prestashop`.`ps_contact_shop` [PASS]
# Comparing `prestashop16`.`ps_country` to `prestashop`.`ps_country` [PASS]
# Comparing `prestashop16`.`ps_country_lang` to `prestashop`.`ps_country_lang` [PASS]
# Comparing `prestashop16`.`ps_country_shop` to `prestashop`.`ps_country_shop` [PASS]
# Comparing `prestashop16`.`ps_currency` to `prestashop`.`ps_currency` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_currency`
+++ `prestashop`.`ps_currency`
@@ -1,14 +1,12 @@
CREATE TABLE `ps_currency` (
`id_currency` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
+ `name` varchar(64) NOT NULL,
`iso_code` varchar(3) NOT NULL DEFAULT '0',
- `iso_code_num` varchar(3) NOT NULL DEFAULT '0',
- `sign` varchar(8) NOT NULL,
- `blank` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `format` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `decimals` tinyint(1) unsigned NOT NULL DEFAULT '1',
+ `numeric_iso_code` varchar(3) DEFAULT NULL,
+ `precision` int(2) NOT NULL DEFAULT '6',
`conversion_rate` decimal(13,6) NOT NULL,
`deleted` tinyint(1) unsigned NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '1',
- PRIMARY KEY (`id_currency`)
+ PRIMARY KEY (`id_currency`),
+ KEY `currency_iso_code` (`iso_code`)
)
# Comparing `prestashop16`.`ps_currency_shop` to `prestashop`.`ps_currency_shop` [PASS]
# Comparing `prestashop16`.`ps_customer` to `prestashop`.`ps_customer` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_customer`
+++ `prestashop`.`ps_customer`
@@ -9,10 +9,10 @@
`company` varchar(64) DEFAULT NULL,
`siret` varchar(14) DEFAULT NULL,
`ape` varchar(5) DEFAULT NULL,
- `firstname` varchar(32) NOT NULL,
- `lastname` varchar(32) NOT NULL,
+ `firstname` varchar(255) NOT NULL,
+ `lastname` varchar(255) NOT NULL,
`email` varchar(128) NOT NULL,
- `passwd` varchar(32) NOT NULL,
+ `passwd` varchar(60) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`birthday` date DEFAULT NULL,
`newsletter` tinyint(1) unsigned NOT NULL DEFAULT '0',
@@ -30,6 +30,8 @@
`deleted` tinyint(1) NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
+ `reset_password_token` varchar(40) DEFAULT NULL,
+ `reset_password_validity` datetime DEFAULT NULL,
PRIMARY KEY (`id_customer`),
KEY `customer_email` (`email`),
KEY `customer_login` (`email`,`passwd`),
# Comparing `prestashop16`.`ps_customer_group` to `prestashop`.`ps_customer_group` [PASS]
# Comparing `prestashop16`.`ps_customer_message` to `prestashop`.`ps_customer_message` [PASS]
# Comparing `prestashop16`.`ps_customer_message_sync_imap` to `prestashop`.`ps_customer_message_sync_imap` [PASS]
# Comparing `prestashop16`.`ps_customer_thread` to `prestashop`.`ps_customer_thread` [PASS]
# Comparing `prestashop16`.`ps_customization` to `prestashop`.`ps_customization` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_customization`
# +++ `prestashop`.`ps_customization`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=2
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_customization_field` to `prestashop`.`ps_customization_field` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_customization_field`
+++ `prestashop`.`ps_customization_field`
@@ -3,6 +3,8 @@
`id_product` int(10) unsigned NOT NULL,
`type` tinyint(1) NOT NULL,
`required` tinyint(1) NOT NULL,
+ `is_module` tinyint(1) NOT NULL DEFAULT '0',
+ `is_deleted` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_customization_field`),
KEY `id_product` (`id_product`)
)
# Comparing `prestashop16`.`ps_customization_field_lang` to `prestashop`.`ps_customization_field_lang` [PASS]
# Comparing `prestashop16`.`ps_customized_data` to `prestashop`.`ps_customized_data` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_customized_data`
+++ `prestashop`.`ps_customized_data`
@@ -3,5 +3,8 @@
`type` tinyint(1) NOT NULL,
`index` int(3) NOT NULL,
`value` varchar(255) NOT NULL,
+ `id_module` int(10) NOT NULL DEFAULT '0',
+ `price` decimal(20,6) NOT NULL DEFAULT '0.000000',
+ `weight` decimal(20,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (`id_customization`,`type`,`index`)
)
# Comparing `prestashop16`.`ps_date_range` to `prestashop`.`ps_date_range` [PASS]
# Comparing `prestashop16`.`ps_delivery` to `prestashop`.`ps_delivery` [PASS]
# Comparing `prestashop16`.`ps_employee` to `prestashop`.`ps_employee` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_employee`
+++ `prestashop`.`ps_employee`
@@ -5,7 +5,7 @@
`lastname` varchar(32) NOT NULL,
`firstname` varchar(32) NOT NULL,
`email` varchar(128) NOT NULL,
- `passwd` varchar(32) NOT NULL,
+ `passwd` varchar(60) NOT NULL,
`last_passwd_gen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`stats_date_from` date DEFAULT NULL,
`stats_date_to` date DEFAULT NULL,
@@ -24,7 +24,9 @@
`id_last_order` int(10) unsigned NOT NULL DEFAULT '0',
`id_last_customer_message` int(10) unsigned NOT NULL DEFAULT '0',
`id_last_customer` int(10) unsigned NOT NULL DEFAULT '0',
- `last_connection_date` date DEFAULT '0000-00-00',
+ `last_connection_date` date DEFAULT NULL,
+ `reset_password_token` varchar(40) DEFAULT NULL,
+ `reset_password_validity` datetime DEFAULT NULL,
PRIMARY KEY (`id_employee`),
KEY `employee_login` (`email`,`passwd`),
KEY `id_employee_passwd` (`id_employee`,`passwd`),
# Comparing `prestashop16`.`ps_employee_shop` to `prestashop`.`ps_employee_shop` [PASS]
# Comparing `prestashop16`.`ps_feature` to `prestashop`.`ps_feature` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_feature`
# +++ `prestashop`.`ps_feature`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=8
# +AUTO_INCREMENT=6
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_feature_lang` to `prestashop`.`ps_feature_lang` [PASS]
# Comparing `prestashop16`.`ps_feature_product` to `prestashop`.`ps_feature_product` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_feature_product`
+++ `prestashop`.`ps_feature_product`
@@ -2,7 +2,7 @@
`id_feature` int(10) unsigned NOT NULL,
`id_product` int(10) unsigned NOT NULL,
`id_feature_value` int(10) unsigned NOT NULL,
- PRIMARY KEY (`id_feature`,`id_product`),
+ PRIMARY KEY (`id_feature`,`id_product`,`id_feature_value`),
KEY `id_feature_value` (`id_feature_value`),
KEY `id_product` (`id_product`)
)
# Comparing `prestashop16`.`ps_feature_shop` to `prestashop`.`ps_feature_shop` [PASS]
# Comparing `prestashop16`.`ps_feature_value` to `prestashop`.`ps_feature_value` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_feature_value`
# +++ `prestashop`.`ps_feature_value`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=34
# +AUTO_INCREMENT=19
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_feature_value_lang` to `prestashop`.`ps_feature_value_lang` [PASS]
# Comparing `prestashop16`.`ps_gender` to `prestashop`.`ps_gender` [PASS]
# Comparing `prestashop16`.`ps_gender_lang` to `prestashop`.`ps_gender_lang` [PASS]
# Comparing `prestashop16`.`ps_group` to `prestashop`.`ps_group` [PASS]
# Comparing `prestashop16`.`ps_group_lang` to `prestashop`.`ps_group_lang` [PASS]
# Comparing `prestashop16`.`ps_group_reduction` to `prestashop`.`ps_group_reduction` [PASS]
# Comparing `prestashop16`.`ps_group_shop` to `prestashop`.`ps_group_shop` [PASS]
# Comparing `prestashop16`.`ps_guest` to `prestashop`.`ps_guest` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_guest`
# +++ `prestashop`.`ps_guest`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=2
# +AUTO_INCREMENT=11
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_homeslider` to `prestashop`.`ps_homeslider` [PASS]
# Comparing `prestashop16`.`ps_homeslider_slides` to `prestashop`.`ps_homeslider_slides` [PASS]
# Comparing `prestashop16`.`ps_homeslider_slides_lang` to `prestashop`.`ps_homeslider_slides_lang` [PASS]
# Comparing `prestashop16`.`ps_hook` to `prestashop`.`ps_hook` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_hook`
+++ `prestashop`.`ps_hook`
@@ -4,7 +4,6 @@
`title` varchar(64) NOT NULL,
`description` text,
`position` tinyint(1) NOT NULL DEFAULT '1',
- `live_edit` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id_hook`),
UNIQUE KEY `hook_name` (`name`)
)
# Comparing `prestashop16`.`ps_hook_alias` to `prestashop`.`ps_hook_alias` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_hook_alias`
# +++ `prestashop`.`ps_hook_alias`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=87
# +AUTO_INCREMENT=84
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_hook_module` to `prestashop`.`ps_hook_module` [PASS]
# Comparing `prestashop16`.`ps_hook_module_exceptions` to `prestashop`.`ps_hook_module_exceptions` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_hook_module_exceptions`
# +++ `prestashop`.`ps_hook_module_exceptions`
# @@ -1,4 +1,3 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=8
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_image` to `prestashop`.`ps_image` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_image`
# +++ `prestashop`.`ps_image`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=24
# +AUTO_INCREMENT=2899
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_image_lang` to `prestashop`.`ps_image_lang` [PASS]
# Comparing `prestashop16`.`ps_image_shop` to `prestashop`.`ps_image_shop` [PASS]
# Comparing `prestashop16`.`ps_image_type` to `prestashop`.`ps_image_type` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_image_type`
+++ `prestashop`.`ps_image_type`
@@ -7,7 +7,6 @@
`categories` tinyint(1) NOT NULL DEFAULT '1',
`manufacturers` tinyint(1) NOT NULL DEFAULT '1',
`suppliers` tinyint(1) NOT NULL DEFAULT '1',
- `scenes` tinyint(1) NOT NULL DEFAULT '1',
`stores` tinyint(1) NOT NULL DEFAULT '1',
PRIMARY KEY (`id_image_type`),
KEY `image_type_name` (`name`)
# Comparing `prestashop16`.`ps_import_match` to `prestashop`.`ps_import_match` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_import_match`
# +++ `prestashop`.`ps_import_match`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=3
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_info` to `prestashop`.`ps_info` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_info`
# +++ `prestashop`.`ps_info`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=3
# +AUTO_INCREMENT=2
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_info_lang` to `prestashop`.`ps_info_lang` [PASS]
# Comparing `prestashop16`.`ps_lang` to `prestashop`.`ps_lang` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_lang`
+++ `prestashop`.`ps_lang`
@@ -1,12 +1,12 @@
CREATE TABLE `ps_lang` (
- `id_lang` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(32) NOT NULL,
- `active` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `iso_code` char(2) NOT NULL,
- `language_code` char(5) NOT NULL,
- `date_format_lite` char(32) NOT NULL DEFAULT 'Y-m-d',
- `date_format_full` char(32) NOT NULL DEFAULT 'Y-m-d H:i:s',
- `is_rtl` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id_lang`),
- KEY `lang_iso_code` (`iso_code`)
+ `id_lang` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `active` tinyint(1) NOT NULL,
+ `iso_code` varchar(2) COLLATE utf8_unicode_ci NOT NULL,
+ `language_code` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
+ `locale` varchar(5) COLLATE utf8_unicode_ci NOT NULL,
+ `date_format_lite` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `date_format_full` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
+ `is_rtl` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id_lang`)
)
# Comparing `prestashop16`.`ps_lang_shop` to `prestashop`.`ps_lang_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_lang_shop`
+++ `prestashop`.`ps_lang_shop`
@@ -1,6 +1,7 @@
CREATE TABLE `ps_lang_shop` (
- `id_lang` int(11) unsigned NOT NULL,
- `id_shop` int(11) unsigned NOT NULL,
+ `id_lang` int(11) NOT NULL,
+ `id_shop` int(11) NOT NULL,
PRIMARY KEY (`id_lang`,`id_shop`),
- KEY `id_shop` (`id_shop`)
+ KEY `IDX_2F43BFC7BA299860` (`id_lang`),
+ KEY `IDX_2F43BFC7274A50A0` (`id_shop`)
)
# Comparing `prestashop16`.`ps_layered_category` to `prestashop`.`ps_layered_category` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_layered_category`
# +++ `prestashop`.`ps_layered_category`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=100
# +AUTO_INCREMENT=89
# DEFAULT
# CHARSET=latin1
# Comparing `prestashop16`.`ps_layered_filter` to `prestashop`.`ps_layered_filter` [PASS]
# Comparing `prestashop16`.`ps_layered_filter_shop` to `prestashop`.`ps_layered_filter_shop` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_attribute_group` to `prestashop`.`ps_layered_indexable_attribute_group` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_attribute_group_lang_value` to `prestashop`.`ps_layered_indexable_attribute_group_lang_value` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_attribute_lang_value` to `prestashop`.`ps_layered_indexable_attribute_lang_value` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_feature` to `prestashop`.`ps_layered_indexable_feature` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_feature_lang_value` to `prestashop`.`ps_layered_indexable_feature_lang_value` [PASS]
# Comparing `prestashop16`.`ps_layered_indexable_feature_value_lang_value` to `prestashop`.`ps_layered_indexable_feature_value_lang_value` [PASS]
# Comparing `prestashop16`.`ps_layered_price_index` to `prestashop`.`ps_layered_price_index` [PASS]
# Comparing `prestashop16`.`ps_layered_product_attribute` to `prestashop`.`ps_layered_product_attribute` [PASS]
# Comparing `prestashop16`.`ps_linksmenutop` to `prestashop`.`ps_linksmenutop` [PASS]
# Comparing `prestashop16`.`ps_linksmenutop_lang` to `prestashop`.`ps_linksmenutop_lang` [PASS]
# Comparing `prestashop16`.`ps_log` to `prestashop`.`ps_log` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_log`
# +++ `prestashop`.`ps_log`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=180
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_mail` to `prestashop`.`ps_mail` [PASS]
# Comparing `prestashop16`.`ps_manufacturer` to `prestashop`.`ps_manufacturer` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_manufacturer`
# +++ `prestashop`.`ps_manufacturer`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=2
# +AUTO_INCREMENT=3
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_manufacturer_lang` to `prestashop`.`ps_manufacturer_lang` [PASS]
# Comparing `prestashop16`.`ps_manufacturer_shop` to `prestashop`.`ps_manufacturer_shop` [PASS]
# Comparing `prestashop16`.`ps_memcached_servers` to `prestashop`.`ps_memcached_servers` [PASS]
# Comparing `prestashop16`.`ps_message` to `prestashop`.`ps_message` [PASS]
# Comparing `prestashop16`.`ps_message_readed` to `prestashop`.`ps_message_readed` [PASS]
# Comparing `prestashop16`.`ps_meta` to `prestashop`.`ps_meta` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_meta`
# +++ `prestashop`.`ps_meta`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=37
# +AUTO_INCREMENT=41
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_meta_lang` to `prestashop`.`ps_meta_lang` [PASS]
# Comparing `prestashop16`.`ps_module` to `prestashop`.`ps_module` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_module`
+++ `prestashop`.`ps_module`
@@ -4,5 +4,6 @@
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`version` varchar(8) NOT NULL,
PRIMARY KEY (`id_module`),
+ UNIQUE KEY `name_UNIQUE` (`name`),
KEY `name` (`name`)
)
# Comparing `prestashop16`.`ps_module_access` to `prestashop`.`ps_module_access` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_module_access`
+++ `prestashop`.`ps_module_access`
@@ -1,8 +1,5 @@
CREATE TABLE `ps_module_access` (
`id_profile` int(10) unsigned NOT NULL,
- `id_module` int(10) unsigned NOT NULL,
- `view` tinyint(1) NOT NULL DEFAULT '0',
- `configure` tinyint(1) NOT NULL DEFAULT '0',
- `uninstall` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id_profile`,`id_module`)
+ `id_authorization_role` int(10) unsigned NOT NULL,
+ PRIMARY KEY (`id_profile`,`id_authorization_role`)
)
# Comparing `prestashop16`.`ps_module_country` to `prestashop`.`ps_module_country` [PASS]
# Comparing `prestashop16`.`ps_module_currency` to `prestashop`.`ps_module_currency` [PASS]
# Comparing `prestashop16`.`ps_module_group` to `prestashop`.`ps_module_group` [PASS]
# Comparing `prestashop16`.`ps_module_preference` to `prestashop`.`ps_module_preference` [PASS]
# Comparing `prestashop16`.`ps_module_shop` to `prestashop`.`ps_module_shop` [PASS]
# Comparing `prestashop16`.`ps_operating_system` to `prestashop`.`ps_operating_system` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_operating_system`
# +++ `prestashop`.`ps_operating_system`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=8
# +AUTO_INCREMENT=10
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_order_carrier` to `prestashop`.`ps_order_carrier` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_order_carrier`
# +++ `prestashop`.`ps_order_carrier`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=6
# +AUTO_INCREMENT=7
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_order_cart_rule` to `prestashop`.`ps_order_cart_rule` [PASS]
# Comparing `prestashop16`.`ps_order_detail` to `prestashop`.`ps_order_detail` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_order_detail`
+++ `prestashop`.`ps_order_detail`
@@ -6,6 +6,7 @@
`id_shop` int(11) unsigned NOT NULL,
`product_id` int(10) unsigned NOT NULL,
`product_attribute_id` int(10) unsigned DEFAULT NULL,
+ `id_customization` int(10) unsigned DEFAULT '0',
`product_name` varchar(255) NOT NULL,
`product_quantity` int(10) unsigned NOT NULL DEFAULT '0',
`product_quantity_in_stock` int(10) NOT NULL DEFAULT '0',
@@ -20,6 +21,7 @@
`group_reduction` decimal(10,2) NOT NULL DEFAULT '0.00',
`product_quantity_discount` decimal(20,6) NOT NULL DEFAULT '0.000000',
`product_ean13` varchar(13) DEFAULT NULL,
+ `product_isbn` varchar(32) DEFAULT NULL,
`product_upc` varchar(12) DEFAULT NULL,
`product_reference` varchar(32) DEFAULT NULL,
`product_supplier_reference` varchar(32) DEFAULT NULL,
@@ -45,7 +47,7 @@
`original_wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
PRIMARY KEY (`id_order_detail`),
KEY `order_detail_order` (`id_order`),
- KEY `product_id` (`product_id`),
+ KEY `product_id` (`product_id`,`product_attribute_id`),
KEY `product_attribute_id` (`product_attribute_id`),
KEY `id_tax_rules_group` (`id_tax_rules_group`),
KEY `id_order_id_order_detail` (`id_order`,`id_order_detail`)
# Comparing `prestashop16`.`ps_order_detail_tax` to `prestashop`.`ps_order_detail_tax` [PASS]
# Comparing `prestashop16`.`ps_order_history` to `prestashop`.`ps_order_history` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_order_history`
# +++ `prestashop`.`ps_order_history`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=8
# +AUTO_INCREMENT=9
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_order_invoice` to `prestashop`.`ps_order_invoice` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_order_invoice`
+++ `prestashop`.`ps_order_invoice`
@@ -16,8 +16,6 @@
`total_wrapping_tax_excl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`total_wrapping_tax_incl` decimal(20,6) NOT NULL DEFAULT '0.000000',
`shop_address` text,
- `invoice_address` text,
- `delivery_address` text,
`note` text,
`date_add` datetime NOT NULL,
PRIMARY KEY (`id_order_invoice`),
# Comparing `prestashop16`.`ps_order_invoice_payment` to `prestashop`.`ps_order_invoice_payment` [PASS]
# Comparing `prestashop16`.`ps_order_invoice_tax` to `prestashop`.`ps_order_invoice_tax` [PASS]
# Comparing `prestashop16`.`ps_order_message` to `prestashop`.`ps_order_message` [PASS]
# Comparing `prestashop16`.`ps_order_message_lang` to `prestashop`.`ps_order_message_lang` [PASS]
# Comparing `prestashop16`.`ps_order_payment` to `prestashop`.`ps_order_payment` [PASS]
# Comparing `prestashop16`.`ps_order_return` to `prestashop`.`ps_order_return` [PASS]
# Comparing `prestashop16`.`ps_order_return_detail` to `prestashop`.`ps_order_return_detail` [PASS]
# Comparing `prestashop16`.`ps_order_return_state` to `prestashop`.`ps_order_return_state` [PASS]
# Comparing `prestashop16`.`ps_order_return_state_lang` to `prestashop`.`ps_order_return_state_lang` [PASS]
# Comparing `prestashop16`.`ps_order_slip` to `prestashop`.`ps_order_slip` [PASS]
# Comparing `prestashop16`.`ps_order_slip_detail` to `prestashop`.`ps_order_slip_detail` [PASS]
# Comparing `prestashop16`.`ps_order_slip_detail_tax` to `prestashop`.`ps_order_slip_detail_tax` [PASS]
# Comparing `prestashop16`.`ps_order_state` to `prestashop`.`ps_order_state` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_order_state`
# +++ `prestashop`.`ps_order_state`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=15
# +AUTO_INCREMENT=16
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_order_state_lang` to `prestashop`.`ps_order_state_lang` [PASS]
# Comparing `prestashop16`.`ps_orders` to `prestashop`.`ps_orders` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_orders`
# +++ `prestashop`.`ps_orders`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=6
# +AUTO_INCREMENT=7
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_pack` to `prestashop`.`ps_pack` [PASS]
# Comparing `prestashop16`.`ps_page` to `prestashop`.`ps_page` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_page`
# +++ `prestashop`.`ps_page`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=3
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_page_type` to `prestashop`.`ps_page_type` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_page_type`
# +++ `prestashop`.`ps_page_type`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=3
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_page_viewed` to `prestashop`.`ps_page_viewed` [PASS]
# Comparing `prestashop16`.`ps_pagenotfound` to `prestashop`.`ps_pagenotfound` [PASS]
# Comparing `prestashop16`.`ps_product` to `prestashop`.`ps_product` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product`
+++ `prestashop`.`ps_product`
@@ -8,10 +8,13 @@
`on_sale` tinyint(1) unsigned NOT NULL DEFAULT '0',
`online_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ean13` varchar(13) DEFAULT NULL,
+ `isbn` varchar(32) DEFAULT NULL,
`upc` varchar(12) DEFAULT NULL,
`ecotax` decimal(17,6) NOT NULL DEFAULT '0.000000',
`quantity` int(10) NOT NULL DEFAULT '0',
`minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
+ `low_stock_threshold` int(10) DEFAULT NULL,
+ `low_stock_alert` tinyint(1) NOT NULL DEFAULT '0',
`price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`unity` varchar(255) DEFAULT NULL,
@@ -25,15 +28,17 @@
`depth` decimal(20,6) NOT NULL DEFAULT '0.000000',
`weight` decimal(20,6) NOT NULL DEFAULT '0.000000',
`out_of_stock` int(10) unsigned NOT NULL DEFAULT '2',
+ `additional_delivery_times` tinyint(1) unsigned NOT NULL DEFAULT '1',
`quantity_discount` tinyint(1) DEFAULT '0',
`customizable` tinyint(2) NOT NULL DEFAULT '0',
`uploadable_files` tinyint(4) NOT NULL DEFAULT '0',
`text_fields` tinyint(4) NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `redirect_type` enum('','404','301','302') NOT NULL DEFAULT '',
- `id_product_redirected` int(10) unsigned NOT NULL DEFAULT '0',
+ `redirect_type` enum('','404','301-product','302-product','301-category','302-category') NOT NULL DEFAULT '',
+ `id_type_redirected` int(10) unsigned NOT NULL DEFAULT '0',
`available_for_order` tinyint(1) NOT NULL DEFAULT '1',
- `available_date` date NOT NULL DEFAULT '0000-00-00',
+ `available_date` date DEFAULT NULL,
+ `show_condition` tinyint(1) NOT NULL DEFAULT '0',
`condition` enum('new','used','refurbished') NOT NULL DEFAULT 'new',
`show_price` tinyint(1) NOT NULL DEFAULT '1',
`indexed` tinyint(1) NOT NULL DEFAULT '0',
@@ -46,10 +51,12 @@
`date_upd` datetime NOT NULL,
`advanced_stock_management` tinyint(1) NOT NULL DEFAULT '0',
`pack_stock_type` int(11) unsigned NOT NULL DEFAULT '3',
+ `state` int(11) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`,`id_product`),
KEY `id_category_default` (`id_category_default`),
KEY `indexed` (`indexed`),
- KEY `date_add` (`date_add`)
+ KEY `date_add` (`date_add`),
+ KEY `state` (`state`,`date_upd`)
)
# Comparing `prestashop16`.`ps_product_attachment` to `prestashop`.`ps_product_attachment` [PASS]
# Comparing `prestashop16`.`ps_product_attribute` to `prestashop`.`ps_product_attribute` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product_attribute`
+++ `prestashop`.`ps_product_attribute`
@@ -5,6 +5,7 @@
`supplier_reference` varchar(32) DEFAULT NULL,
`location` varchar(64) DEFAULT NULL,
`ean13` varchar(13) DEFAULT NULL,
+ `isbn` varchar(32) DEFAULT NULL,
`upc` varchar(12) DEFAULT NULL,
`wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`price` decimal(20,6) NOT NULL DEFAULT '0.000000',
@@ -14,7 +15,9 @@
`unit_price_impact` decimal(20,6) NOT NULL DEFAULT '0.000000',
`default_on` tinyint(1) unsigned DEFAULT NULL,
`minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
- `available_date` date NOT NULL DEFAULT '0000-00-00',
+ `low_stock_threshold` int(10) DEFAULT NULL,
+ `low_stock_alert` tinyint(1) NOT NULL DEFAULT '0',
+ `available_date` date DEFAULT NULL,
PRIMARY KEY (`id_product_attribute`),
UNIQUE KEY `product_default` (`id_product`,`default_on`),
KEY `product_attribute_product` (`id_product`),
# Comparing `prestashop16`.`ps_product_attribute_combination` to `prestashop`.`ps_product_attribute_combination` [PASS]
# Comparing `prestashop16`.`ps_product_attribute_image` to `prestashop`.`ps_product_attribute_image` [PASS]
# Comparing `prestashop16`.`ps_product_attribute_shop` to `prestashop`.`ps_product_attribute_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product_attribute_shop`
+++ `prestashop`.`ps_product_attribute_shop`
@@ -9,7 +9,9 @@
`unit_price_impact` decimal(20,6) NOT NULL DEFAULT '0.000000',
`default_on` tinyint(1) unsigned DEFAULT NULL,
`minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
- `available_date` date NOT NULL DEFAULT '0000-00-00',
+ `low_stock_threshold` int(10) DEFAULT NULL,
+ `low_stock_alert` tinyint(1) NOT NULL DEFAULT '0',
+ `available_date` date DEFAULT NULL,
PRIMARY KEY (`id_product_attribute`,`id_shop`),
UNIQUE KEY `id_product` (`id_product`,`id_shop`,`default_on`)
)
# Comparing `prestashop16`.`ps_product_carrier` to `prestashop`.`ps_product_carrier` [PASS]
# Comparing `prestashop16`.`ps_product_country_tax` to `prestashop`.`ps_product_country_tax` [PASS]
# Comparing `prestashop16`.`ps_product_download` to `prestashop`.`ps_product_download` [PASS]
# Comparing `prestashop16`.`ps_product_group_reduction_cache` to `prestashop`.`ps_product_group_reduction_cache` [PASS]
# Comparing `prestashop16`.`ps_product_lang` to `prestashop`.`ps_product_lang` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product_lang`
+++ `prestashop`.`ps_product_lang`
@@ -11,6 +11,8 @@
`name` varchar(128) NOT NULL,
`available_now` varchar(255) DEFAULT NULL,
`available_later` varchar(255) DEFAULT NULL,
+ `delivery_in_stock` varchar(255) DEFAULT NULL,
+ `delivery_out_stock` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id_product`,`id_shop`,`id_lang`),
KEY `id_lang` (`id_lang`),
KEY `name` (`name`)
# Comparing `prestashop16`.`ps_product_sale` to `prestashop`.`ps_product_sale` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product_sale`
+++ `prestashop`.`ps_product_sale`
@@ -2,7 +2,7 @@
`id_product` int(10) unsigned NOT NULL,
`quantity` int(10) unsigned NOT NULL DEFAULT '0',
`sale_nbr` int(10) unsigned NOT NULL DEFAULT '0',
- `date_upd` date NOT NULL,
+ `date_upd` date DEFAULT NULL,
PRIMARY KEY (`id_product`),
KEY `quantity` (`quantity`)
)
# Comparing `prestashop16`.`ps_product_shop` to `prestashop`.`ps_product_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_product_shop`
+++ `prestashop`.`ps_product_shop`
@@ -7,6 +7,8 @@
`online_only` tinyint(1) unsigned NOT NULL DEFAULT '0',
`ecotax` decimal(17,6) NOT NULL DEFAULT '0.000000',
`minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1',
+ `low_stock_threshold` int(10) DEFAULT NULL,
+ `low_stock_alert` tinyint(1) NOT NULL DEFAULT '0',
`price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000',
`unity` varchar(255) DEFAULT NULL,
@@ -16,10 +18,11 @@
`uploadable_files` tinyint(4) NOT NULL DEFAULT '0',
`text_fields` tinyint(4) NOT NULL DEFAULT '0',
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
- `redirect_type` enum('','404','301','302') NOT NULL DEFAULT '',
- `id_product_redirected` int(10) unsigned NOT NULL DEFAULT '0',
+ `redirect_type` enum('','404','301-product','302-product','301-category','302-category') NOT NULL DEFAULT '',
+ `id_type_redirected` int(10) unsigned NOT NULL DEFAULT '0',
`available_for_order` tinyint(1) NOT NULL DEFAULT '1',
- `available_date` date NOT NULL DEFAULT '0000-00-00',
+ `available_date` date DEFAULT NULL,
+ `show_condition` tinyint(1) NOT NULL DEFAULT '1',
`condition` enum('new','used','refurbished') NOT NULL DEFAULT 'new',
`show_price` tinyint(1) NOT NULL DEFAULT '1',
`indexed` tinyint(1) NOT NULL DEFAULT '0',
# Comparing `prestashop16`.`ps_product_supplier` to `prestashop`.`ps_product_supplier` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_product_supplier`
# +++ `prestashop`.`ps_product_supplier`
# @@ -1,4 +1,3 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=8
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_product_tag` to `prestashop`.`ps_product_tag` [PASS]
# Comparing `prestashop16`.`ps_profile` to `prestashop`.`ps_profile` [PASS]
# Comparing `prestashop16`.`ps_profile_lang` to `prestashop`.`ps_profile_lang` [PASS]
# Comparing `prestashop16`.`ps_quick_access` to `prestashop`.`ps_quick_access` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_quick_access`
# +++ `prestashop`.`ps_quick_access`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=4
# +AUTO_INCREMENT=7
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_quick_access_lang` to `prestashop`.`ps_quick_access_lang` [PASS]
# Comparing `prestashop16`.`ps_range_price` to `prestashop`.`ps_range_price` [PASS]
# Comparing `prestashop16`.`ps_range_weight` to `prestashop`.`ps_range_weight` [PASS]
# Comparing `prestashop16`.`ps_referrer` to `prestashop`.`ps_referrer` [PASS]
# Comparing `prestashop16`.`ps_referrer_cache` to `prestashop`.`ps_referrer_cache` [PASS]
# Comparing `prestashop16`.`ps_referrer_shop` to `prestashop`.`ps_referrer_shop` [PASS]
# Comparing `prestashop16`.`ps_request_sql` to `prestashop`.`ps_request_sql` [PASS]
# Comparing `prestashop16`.`ps_required_field` to `prestashop`.`ps_required_field` [PASS]
# Comparing `prestashop16`.`ps_risk` to `prestashop`.`ps_risk` [PASS]
# Comparing `prestashop16`.`ps_risk_lang` to `prestashop`.`ps_risk_lang` [PASS]
# Comparing `prestashop16`.`ps_search_engine` to `prestashop`.`ps_search_engine` [PASS]
# Comparing `prestashop16`.`ps_search_index` to `prestashop`.`ps_search_index` [PASS]
# Comparing `prestashop16`.`ps_search_word` to `prestashop`.`ps_search_word` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_search_word`
# +++ `prestashop`.`ps_search_word`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=977
# +AUTO_INCREMENT=714
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_sekeyword` to `prestashop`.`ps_sekeyword` [PASS]
# Comparing `prestashop16`.`ps_shop` to `prestashop`.`ps_shop` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_shop`
+++ `prestashop`.`ps_shop`
@@ -1,13 +1,11 @@
CREATE TABLE `ps_shop` (
- `id_shop` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `id_shop_group` int(11) unsigned NOT NULL,
- `name` varchar(64) NOT NULL,
- `id_category` int(11) unsigned NOT NULL DEFAULT '1',
- `id_theme` int(1) unsigned NOT NULL,
- `active` tinyint(1) NOT NULL DEFAULT '1',
- `deleted` tinyint(1) NOT NULL DEFAULT '0',
+ `id_shop` int(11) NOT NULL AUTO_INCREMENT,
+ `id_shop_group` int(11) NOT NULL,
+ `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
+ `id_category` int(11) NOT NULL,
+ `theme_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+ `active` tinyint(1) NOT NULL,
+ `deleted` tinyint(1) NOT NULL,
PRIMARY KEY (`id_shop`),
- KEY `id_shop_group` (`id_shop_group`,`deleted`),
- KEY `id_category` (`id_category`),
- KEY `id_theme` (`id_theme`)
+ KEY `IDX_CBDFBB9EF5C9E40` (`id_shop_group`)
)
# Comparing `prestashop16`.`ps_shop_group` to `prestashop`.`ps_shop_group` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_shop_group`
+++ `prestashop`.`ps_shop_group`
@@ -1,11 +1,10 @@
CREATE TABLE `ps_shop_group` (
- `id_shop_group` int(11) unsigned NOT NULL AUTO_INCREMENT,
- `name` varchar(64) NOT NULL,
+ `id_shop_group` int(11) NOT NULL AUTO_INCREMENT,
+ `name` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
`share_customer` tinyint(1) NOT NULL,
`share_order` tinyint(1) NOT NULL,
`share_stock` tinyint(1) NOT NULL,
- `active` tinyint(1) NOT NULL DEFAULT '1',
- `deleted` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id_shop_group`),
- KEY `deleted` (`deleted`,`name`)
+ `active` tinyint(1) NOT NULL,
+ `deleted` tinyint(1) NOT NULL,
+ PRIMARY KEY (`id_shop_group`)
)
# Comparing `prestashop16`.`ps_shop_url` to `prestashop`.`ps_shop_url` [PASS]
# Comparing `prestashop16`.`ps_smarty_cache` to `prestashop`.`ps_smarty_cache` [PASS]
# Comparing `prestashop16`.`ps_smarty_last_flush` to `prestashop`.`ps_smarty_last_flush` [PASS]
# Comparing `prestashop16`.`ps_smarty_lazy_cache` to `prestashop`.`ps_smarty_lazy_cache` [PASS]
# Comparing `prestashop16`.`ps_specific_price` to `prestashop`.`ps_specific_price` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_specific_price`
# +++ `prestashop`.`ps_specific_price`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=3
# +AUTO_INCREMENT=691
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_specific_price_priority` to `prestashop`.`ps_specific_price_priority` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_specific_price_priority`
# +++ `prestashop`.`ps_specific_price_priority`
# @@ -1,3 +1,4 @@
# ENGINE=InnoDB
# +AUTO_INCREMENT=2
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_specific_price_rule` to `prestashop`.`ps_specific_price_rule` [PASS]
# Comparing `prestashop16`.`ps_specific_price_rule_condition` to `prestashop`.`ps_specific_price_rule_condition` [PASS]
# Comparing `prestashop16`.`ps_specific_price_rule_condition_group` to `prestashop`.`ps_specific_price_rule_condition_group` [PASS]
# Comparing `prestashop16`.`ps_state` to `prestashop`.`ps_state` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_state`
# +++ `prestashop`.`ps_state`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=313
# +AUTO_INCREMENT=325
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_statssearch` to `prestashop`.`ps_statssearch` [PASS]
# Comparing `prestashop16`.`ps_stock` to `prestashop`.`ps_stock` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_stock`
+++ `prestashop`.`ps_stock`
@@ -5,6 +5,7 @@
`id_product_attribute` int(11) unsigned NOT NULL,
`reference` varchar(32) NOT NULL,
`ean13` varchar(13) DEFAULT NULL,
+ `isbn` varchar(32) DEFAULT NULL,
`upc` varchar(12) DEFAULT NULL,
`physical_quantity` int(11) unsigned NOT NULL,
`usable_quantity` int(11) unsigned NOT NULL,
# Comparing `prestashop16`.`ps_stock_available` to `prestashop`.`ps_stock_available` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_stock_available`
+++ `prestashop`.`ps_stock_available`
@@ -5,6 +5,8 @@
`id_shop` int(11) unsigned NOT NULL,
`id_shop_group` int(11) unsigned NOT NULL,
`quantity` int(10) NOT NULL DEFAULT '0',
+ `physical_quantity` int(11) NOT NULL DEFAULT '0',
+ `reserved_quantity` int(11) NOT NULL DEFAULT '0',
`depends_on_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
`out_of_stock` tinyint(1) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id_stock_available`),
# Comparing `prestashop16`.`ps_stock_mvt` to `prestashop`.`ps_stock_mvt` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_stock_mvt`
+++ `prestashop`.`ps_stock_mvt`
@@ -1,19 +1,19 @@
CREATE TABLE `ps_stock_mvt` (
- `id_stock_mvt` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `id_stock` int(11) unsigned NOT NULL,
- `id_order` int(11) unsigned DEFAULT NULL,
- `id_supply_order` int(11) unsigned DEFAULT NULL,
- `id_stock_mvt_reason` int(11) unsigned NOT NULL,
- `id_employee` int(11) unsigned NOT NULL,
- `employee_lastname` varchar(32) DEFAULT '',
- `employee_firstname` varchar(32) DEFAULT '',
- `physical_quantity` int(11) unsigned NOT NULL,
+ `id_stock_mvt` bigint(20) NOT NULL AUTO_INCREMENT,
+ `id_stock` int(11) NOT NULL,
+ `id_order` int(11) DEFAULT NULL,
+ `id_supply_order` int(11) DEFAULT NULL,
+ `id_stock_mvt_reason` int(11) NOT NULL,
+ `id_employee` int(11) NOT NULL,
+ `employee_lastname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `employee_firstname` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `physical_quantity` int(11) NOT NULL,
`date_add` datetime NOT NULL,
- `sign` tinyint(1) NOT NULL DEFAULT '1',
+ `sign` smallint(6) NOT NULL DEFAULT '1',
`price_te` decimal(20,6) DEFAULT '0.000000',
`last_wa` decimal(20,6) DEFAULT '0.000000',
`current_wa` decimal(20,6) DEFAULT '0.000000',
- `referer` bigint(20) unsigned DEFAULT NULL,
+ `referer` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id_stock_mvt`),
KEY `id_stock` (`id_stock`),
KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`)
# Comparing `prestashop16`.`ps_stock_mvt_reason` to `prestashop`.`ps_stock_mvt_reason` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_stock_mvt_reason`
# +++ `prestashop`.`ps_stock_mvt_reason`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=9
# +AUTO_INCREMENT=13
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_stock_mvt_reason_lang` to `prestashop`.`ps_stock_mvt_reason_lang` [PASS]
# Comparing `prestashop16`.`ps_store` to `prestashop`.`ps_store` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_store`
+++ `prestashop`.`ps_store`
@@ -2,18 +2,13 @@
`id_store` int(10) unsigned NOT NULL AUTO_INCREMENT,
`id_country` int(10) unsigned NOT NULL,
`id_state` int(10) unsigned DEFAULT NULL,
- `name` varchar(128) NOT NULL,
- `address1` varchar(128) NOT NULL,
- `address2` varchar(128) DEFAULT NULL,
`city` varchar(64) NOT NULL,
`postcode` varchar(12) NOT NULL,
`latitude` decimal(13,8) DEFAULT NULL,
`longitude` decimal(13,8) DEFAULT NULL,
- `hours` varchar(254) DEFAULT NULL,
`phone` varchar(16) DEFAULT NULL,
`fax` varchar(16) DEFAULT NULL,
`email` varchar(128) DEFAULT NULL,
- `note` text,
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
# Comparing `prestashop16`.`ps_store_shop` to `prestashop`.`ps_store_shop` [PASS]
# Comparing `prestashop16`.`ps_supplier` to `prestashop`.`ps_supplier` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_supplier`
# +++ `prestashop`.`ps_supplier`
# @@ -1,4 +1,3 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=2
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_supplier_lang` to `prestashop`.`ps_supplier_lang` [PASS]
# Comparing `prestashop16`.`ps_supplier_shop` to `prestashop`.`ps_supplier_shop` [PASS]
# Comparing `prestashop16`.`ps_supply_order` to `prestashop`.`ps_supply_order` [PASS]
# Comparing `prestashop16`.`ps_supply_order_detail` to `prestashop`.`ps_supply_order_detail` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_supply_order_detail`
+++ `prestashop`.`ps_supply_order_detail`
@@ -8,6 +8,7 @@
`supplier_reference` varchar(32) NOT NULL,
`name` varchar(128) NOT NULL,
`ean13` varchar(13) DEFAULT NULL,
+ `isbn` varchar(32) DEFAULT NULL,
`upc` varchar(12) DEFAULT NULL,
`exchange_rate` decimal(20,6) DEFAULT '0.000000',
`unit_price_te` decimal(20,6) DEFAULT '0.000000',
# Comparing `prestashop16`.`ps_supply_order_history` to `prestashop`.`ps_supply_order_history` [PASS]
# Comparing `prestashop16`.`ps_supply_order_receipt_history` to `prestashop`.`ps_supply_order_receipt_history` [PASS]
# Comparing `prestashop16`.`ps_supply_order_state` to `prestashop`.`ps_supply_order_state` [PASS]
# Comparing `prestashop16`.`ps_supply_order_state_lang` to `prestashop`.`ps_supply_order_state_lang` [PASS]
# Comparing `prestashop16`.`ps_tab` to `prestashop`.`ps_tab` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_tab`
+++ `prestashop`.`ps_tab`
@@ -1,12 +1,11 @@
CREATE TABLE `ps_tab` (
- `id_tab` int(10) unsigned NOT NULL AUTO_INCREMENT,
+ `id_tab` int(11) NOT NULL AUTO_INCREMENT,
`id_parent` int(11) NOT NULL,
- `class_name` varchar(64) NOT NULL,
- `module` varchar(64) DEFAULT NULL,
- `position` int(10) unsigned NOT NULL,
- `active` tinyint(1) NOT NULL DEFAULT '1',
- `hide_host_mode` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id_tab`),
- KEY `class_name` (`class_name`),
- KEY `id_parent` (`id_parent`)
+ `position` int(11) NOT NULL,
+ `module` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `class_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL,
+ `active` tinyint(1) NOT NULL,
+ `hide_host_mode` tinyint(1) NOT NULL,
+ `icon` varchar(32) COLLATE utf8_unicode_ci DEFAULT NULL,
+ PRIMARY KEY (`id_tab`)
)
# Comparing `prestashop16`.`ps_tab_lang` to `prestashop`.`ps_tab_lang` [FAIL]
# Object definitions differ. (--changes-for=server1)
#
--- `prestashop16`.`ps_tab_lang`
+++ `prestashop`.`ps_tab_lang`
@@ -1,6 +1,7 @@
CREATE TABLE `ps_tab_lang` (
- `id_tab` int(10) unsigned NOT NULL,
- `id_lang` int(10) unsigned NOT NULL,
- `name` varchar(64) DEFAULT NULL,
- PRIMARY KEY (`id_tab`,`id_lang`)
+ `id_tab` int(11) NOT NULL,
+ `id_lang` int(11) NOT NULL,
+ `name` varchar(128) COLLATE utf8_unicode_ci NOT NULL,
+ PRIMARY KEY (`id_tab`,`id_lang`),
+ KEY `IDX_CFD9262DED47AB56` (`id_tab`)
)
# Comparing `prestashop16`.`ps_tab_module_preference` to `prestashop`.`ps_tab_module_preference` [PASS]
# Comparing `prestashop16`.`ps_tag` to `prestashop`.`ps_tag` [PASS]
# Comparing `prestashop16`.`ps_tag_count` to `prestashop`.`ps_tag_count` [PASS]
# Comparing `prestashop16`.`ps_tax` to `prestashop`.`ps_tax` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_tax`
# +++ `prestashop`.`ps_tax`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=32
# +AUTO_INCREMENT=33
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_tax_lang` to `prestashop`.`ps_tax_lang` [PASS]
# Comparing `prestashop16`.`ps_tax_rule` to `prestashop`.`ps_tax_rule` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_tax_rule`
# +++ `prestashop`.`ps_tax_rule`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=133
# +AUTO_INCREMENT=187
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_tax_rules_group` to `prestashop`.`ps_tax_rules_group` [PASS]
# WARNING: Table options are ignored and differences were found:
# --- `prestashop16`.`ps_tax_rules_group`
# +++ `prestashop`.`ps_tax_rules_group`
# @@ -1,4 +1,4 @@
# ENGINE=InnoDB
# -AUTO_INCREMENT=6
# +AUTO_INCREMENT=8
# DEFAULT
# CHARSET=utf8
# Comparing `prestashop16`.`ps_tax_rules_group_shop` to `prestashop`.`ps_tax_rules_group_shop` [PASS]
# Comparing `prestashop16`.`ps_timezone` to `prestashop`.`ps_timezone` [PASS]
# Comparing `prestashop16`.`ps_warehouse` to `prestashop`.`ps_warehouse` [PASS]
# Comparing `prestashop16`.`ps_warehouse_carrier` to `prestashop`.`ps_warehouse_carrier` [PASS]
# Comparing `prestashop16`.`ps_warehouse_product_location` to `prestashop`.`ps_warehouse_product_location` [PASS]
# Comparing `prestashop16`.`ps_warehouse_shop` to `prestashop`.`ps_warehouse_shop` [PASS]
# Comparing `prestashop16`.`ps_web_browser` to `prestashop`.`ps_web_browser` [PASS]
# Comparing `prestashop16`.`ps_webservice_account` to `prestashop`.`ps_webservice_account` [PASS]
# Comparing `prestashop16`.`ps_webservice_account_shop` to `prestashop`.`ps_webservice_account_shop` [PASS]
# Comparing `prestashop16`.`ps_webservice_permission` to `prestashop`.`ps_webservice_permission` [PASS]
# Comparing `prestashop16`.`ps_zone` to `prestashop`.`ps_zone` [PASS]
# Comparing `prestashop16`.`ps_zone_shop` to `prestashop`.`ps_zone_shop` [PASS]
Compare failed. One or more differences found.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment