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
You can’t perform that action at this time.