Datenstruktur Unterschiede PrestaShop 1.3 und Version 1.4

Wir vergleichen die MySQL-Datenstrukturen zwischen dem alten PrestaShop 1.3 und dem neuen PrestaShop 1.4.

Es geht hierbei um die Tabellenstruktur von MySQL und den manuellen Transfer von alten zu neuen Daten, z.B. über Excel oder csv-Daten.

Was hat sich geändert?

Kategorien Tabelle ps_category

2 neue Felder:

  • nleft (1)
  • nright (1)

Kategorien Tabelle: ps_category_group

Die Tabelle ps_category_group ist gleich geblieben.

Kategorien Tabelle: ps_category_lang

Die Tabelle ps_category_lang ist gleich geblieben.

Kategorien Tabelle: ps_category_product

Die Tabelle ps_category_product ist gleich geblieben.

PrestaShop 1.3 PrestaShop 1.4
CREATE TABLE `ps_category` (
`id_category` int(10) unsigned NOT NULL auto_increment,
`id_parent` int(10) unsigned NOT NULL,
`level_depth` tinyint(3) unsigned NOT NULL default ‚0‘,
`active` tinyint(1) unsigned NOT NULL default ‚0‘,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`position` int(10) unsigned NOT NULL default ‚0‘,
PRIMARY KEY  (`id_category`),
KEY `category_parent` (`id_parent`),
KEY `nleftright` (`nleft`,`nright`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_category` (
`id_category` int(10) unsigned NOT NULL auto_increment,
`id_parent` int(10) unsigned NOT NULL,
`level_depth` tinyint(3) unsigned NOT NULL default ‚0‘,
`nleft` int(10) unsigned NOT NULL default ‚0‘,
`nright` int(10) unsigned NOT NULL default ‚0‘,

`active` tinyint(1) unsigned NOT NULL default ‚0‘,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
`position` int(10) unsigned NOT NULL default ‚0‘,
PRIMARY KEY  (`id_category`),
KEY `category_parent` (`id_parent`),
KEY `nleftright` (`nleft`,`nright`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_category_group` (
`id_category` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
KEY `category_group_index` (`id_category`,`id_group`),
KEY `id_category` (`id_category`),
KEY `id_group` (`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_category_lang` (
`id_category` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`name` varchar(128) NOT NULL,
`description` text,
`link_rewrite` varchar(128) NOT NULL,
`meta_title` varchar(128) default NULL,
`meta_keywords` varchar(255) default NULL,
`meta_description` varchar(255) default NULL,
UNIQUE KEY `category_lang_index` (`id_category`,`id_lang`),
KEY `category_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_category_product` (
`id_category` int(10) unsigned NOT NULL,
`id_product` int(10) unsigned NOT NULL,
`position` int(10) unsigned NOT NULL default ‚0‘,
KEY `category_product_index` (`id_category`,`id_product`),
KEY `id_product` (`id_product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3

Produkte Tabelle: ps_product

Die Werte in Klammern können als Standardwerte oder sinnvolle Werte zur Übernahme der alten Tabellen gesetzt werden.

16 neue Felder:

  • id_tax_rules_group (1)
  • online_only (0)
  • upc (NULL)
  • minimal_quantity (1)
  • unity (NULL)
  • unit_price (0.000000)
  • additional_shipping_cost (0.00)
  • width (0)
  • height (0)
  • depth (0)
  • available_for_order (1)
  • condition (new)
  • show_price (1)
  • cache_is_pack 0)
  • cache_has_attachments (0)
  • cache_default_attribute (NULL)

4 entfernte / verschobene Felder:

  • id_tax
  • reduction_price
  • reduction_percent
  • reduction_from
  • reduction_to

Produkte Tabelle: ps_product_attachment

Die Tabelle ps_product_attachment ist gleich geblieben.

Produkte Tabelle: ps_product_attribute

3 neue Felder:

  • upc (NULL)
  • unit_price_impact (0.00)
  • minimal_quantity (1)

0 entfernte / verschobene Felder:

  • keine

Produkte Tabelle: ps_product_attribute_combination

Die Tabelle ps_product_attribute_combination ist gleich geblieben.

Produkte Tabelle: ps_product_attribute_image

Die Tabelle ps_product_attribute_image ist gleich geblieben.

Produkte Tabelle: ps_product_country_tax

Die Tabelle ps_product_country_tax ist komplett NEU!

Produkte Tabelle: ps_product_download

Die Tabelle ps_product_download ist gleich geblieben.

Produkte Tabelle: ps_product_group_reduction_cache

Die Tabelle ps_product_group_reduction_cache ist komplett NEU!

Produkte Tabelle: ps_product_lang

Die Tabelle ps_product_lang ist gleich geblieben.

Produkte Tabelle: ps_product_sale

Die Tabelle ps_product_sale ist gleich geblieben.

Produkte Tabelle: ps_product_tag

Die Tabelle ps_product_tag ist gleich geblieben.

Gegenüberstellung der veränderten Produkt-Tabellen PrestaShop 1.3 und 1.4

PrestaShop 1.3 PrestaShop 1.4
CREATE TABLE `ps_product` (
`id_product` int(10) unsigned NOT NULL auto_increment,
`id_supplier` int(10) unsigned default NULL,
`id_manufacturer` int(10) unsigned default NULL,
`id_tax` int(10) unsigned NOT NULL,
`id_category_default` int(10) unsigned default NULL,
`id_color_default` int(10) unsigned default NULL,
`on_sale` tinyint(1) unsigned NOT NULL default ‚0‘,
`ean13` varchar(13) default NULL,
`ecotax` decimal(17,2) NOT NULL default ‚0.00‘,
`quantity` int(10) unsigned NOT NULL default ‚0‘,
`price` decimal(20,6) NOT NULL default ‚0.000000‘,
`wholesale_price` decimal(20,6) NOT NULL default ‚0.000000‘,
`reduction_price` decimal(17,2) default NULL,
`reduction_percent` float default NULL,
`reduction_from` datetime NOT NULL default ‚1970-01-01 00:00:00‘,
`reduction_to` datetime NOT NULL default ‚1970-01-01 00:00:00‘,

`reference` varchar(32) default NULL,
`supplier_reference` varchar(32) default NULL,
`location` varchar(64) default NULL,
`weight` float NOT NULL default ‚0‘,
`out_of_stock` int(10) unsigned NOT NULL default ‚2‘,
`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‘,
`indexed` tinyint(1) NOT NULL default ‚0‘,
`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY  (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`),
KEY `id_tax` (`id_tax`),
KEY `id_category_default` (`id_category_default`),
KEY `id_color_default` (`id_color_default`),
KEY `date_add` (`date_add`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product` (
`id_product` int(10) unsigned NOT NULL auto_increment,
`id_supplier` int(10) unsigned default NULL,
`id_manufacturer` int(10) unsigned default NULL,
`id_tax_rules_group` int(10) unsigned NOT NULL,
`id_category_default` int(10) unsigned default NULL,
`id_color_default` int(10) unsigned default NULL,
`on_sale` tinyint(1) unsigned NOT NULL default ‚0‘,
`online_only` tinyint(1) unsigned NOT NULL default ‚0‘,
`ean13` varchar(13) default NULL,
`upc` varchar(12) default NULL,
`ecotax` decimal(17,2) NOT NULL default ‚0.00‘,
`quantity` int(10) NOT NULL default ‚0‘,
`minimal_quantity` int(10) unsigned NOT NULL default ‚1‘,
`price` decimal(20,6) NOT NULL default ‚0.000000‘,
`wholesale_price` decimal(20,6) NOT NULL default ‚0.000000‘,
`unity` varchar(255) default NULL,
`unit_price` decimal(20,6) NOT NULL default ‚0.000000‘,
`additional_shipping_cost` decimal(20,2) NOT NULL default ‚0.00‘,
`reference` varchar(32) default NULL,
`supplier_reference` varchar(32) default NULL,
`location` varchar(64) default NULL,
`width` float NOT NULL default ‚0‘,
`height` float NOT NULL default ‚0‘,
`depth` float NOT NULL default ‚0‘,

`weight` float NOT NULL default ‚0‘,
`out_of_stock` int(10) unsigned NOT NULL default ‚2‘,
`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‘,
`available_for_order` 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‘,
`cache_is_pack` tinyint(1) NOT NULL default ‚0‘,
`cache_has_attachments` tinyint(1) NOT NULL default ‚0‘,
`cache_default_attribute` int(10) unsigned default NULL,

`date_add` datetime NOT NULL,
`date_upd` datetime NOT NULL,
PRIMARY KEY  (`id_product`),
KEY `product_supplier` (`id_supplier`),
KEY `product_manufacturer` (`id_manufacturer`),
KEY `id_category_default` (`id_category_default`),
KEY `id_color_default` (`id_color_default`),
KEY `date_add` (`date_add`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product_attachment` (
`id_product` int(10) unsigned NOT NULL,
`id_attachment` int(10) unsigned NOT NULL,
PRIMARY KEY  (`id_product`,`id_attachment`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_product_attribute` (
`id_product_attribute` int(10) unsigned NOT NULL auto_increment,
`id_product` int(10) unsigned NOT NULL,
`reference` varchar(32) default NULL,
`supplier_reference` varchar(32) default NULL,
`location` varchar(64) default NULL,
`ean13` varchar(13) default NULL,
`wholesale_price` decimal(20,6) NOT NULL default ‚0.000000‘,
`price` decimal(17,2) NOT NULL default ‚0.00‘,
`ecotax` decimal(17,2) NOT NULL default ‚0.00‘,
`quantity` int(10) unsigned NOT NULL default ‚0‘,
`weight` float NOT NULL default ‚0‘,
`default_on` tinyint(1) unsigned NOT NULL default ‚0‘,
PRIMARY KEY  (`id_product_attribute`),
KEY `product_attribute_product` (`id_product`),
KEY `reference` (`reference`),
KEY `supplier_reference` (`supplier_reference`),
KEY `product_default` (`id_product`,`default_on`),
KEY `id_product_id_product_attribute` (`id_product_attribute`,`id_product`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product_attribute` (
`id_product_attribute` int(10) unsigned NOT NULL auto_increment,
`id_product` int(10) unsigned NOT NULL,
`reference` varchar(32) default NULL,
`supplier_reference` varchar(32) default NULL,
`location` varchar(64) default NULL,
`ean13` varchar(13) 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‘,
`ecotax` decimal(17,2) NOT NULL default ‚0.00‘,
`quantity` int(10) NOT NULL default ‚0‘,
`weight` float NOT NULL default ‚0‘,
`unit_price_impact` decimal(17,2) NOT NULL default ‚0.00‘,
`default_on` tinyint(1) unsigned NOT NULL default ‚0‘,
`minimal_quantity` int(10) unsigned NOT NULL default ‚1‘,
PRIMARY KEY  (`id_product_attribute`),
KEY `product_attribute_product` (`id_product`),
KEY `reference` (`reference`),
KEY `supplier_reference` (`supplier_reference`),
KEY `product_default` (`id_product`,`default_on`),
KEY `id_product_id_product_attribute` (`id_product_attribute`,`id_product`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product_attribute_combination` (
`id_attribute` int(10) unsigned NOT NULL,
`id_product_attribute` int(10) unsigned NOT NULL,
PRIMARY KEY  (`id_attribute`,`id_product_attribute`),
KEY `id_product_attribute` (`id_product_attribute`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_product_attribute_image` (
`id_product_attribute` int(10) unsigned NOT NULL,
`id_image` int(10) unsigned NOT NULL,
PRIMARY KEY  (`id_product_attribute`,`id_image`),
KEY `id_image` (`id_image`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
komplett neu ab PrestaShop 1.4 CREATE TABLE `ps_product_country_tax` (
`id_product` int(11) NOT NULL,
`id_country` int(11) NOT NULL,
`id_tax` int(11) NOT NULL,
UNIQUE KEY `id_product` (`id_product`,`id_country`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product_download` (
`id_product_download` int(10) unsigned NOT NULL auto_increment,
`id_product` int(10) unsigned NOT NULL,
`display_filename` varchar(255) default NULL,
`physically_filename` varchar(255) default NULL,
`date_deposit` datetime NOT NULL,
`date_expiration` datetime default NULL,
`nb_days_accessible` int(10) unsigned default NULL,
`nb_downloadable` int(10) unsigned default ‚1‘,
`active` tinyint(1) unsigned NOT NULL default ‚1‘,
PRIMARY KEY  (`id_product_download`),
KEY `product_active` (`id_product`,`active`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
komplett neu ab PrestaShop 1.4 CREATE TABLE `ps_product_group_reduction_cache` (
`id_product` int(10) unsigned NOT NULL,
`id_group` int(10) unsigned NOT NULL,
`reduction` decimal(4,3) NOT NULL,
PRIMARY KEY  (`id_product`,`id_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
CREATE TABLE `ps_product_lang` (
`id_product` int(10) unsigned NOT NULL,
`id_lang` int(10) unsigned NOT NULL,
`description` text,
`description_short` text,
`link_rewrite` varchar(128) NOT NULL,
`meta_description` varchar(255) default NULL,
`meta_keywords` varchar(255) default NULL,
`meta_title` varchar(128) default NULL,
`name` varchar(128) NOT NULL,
`available_now` varchar(255) default NULL,
`available_later` varchar(255) default NULL,
UNIQUE KEY `product_lang_index` (`id_product`,`id_lang`),
KEY `id_lang` (`id_lang`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_product_sale` (
`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,
PRIMARY KEY  (`id_product`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
CREATE TABLE `ps_product_tag` (
`id_product` int(10) unsigned NOT NULL,
`id_tag` int(10) unsigned NOT NULL,
PRIMARY KEY  (`id_product`,`id_tag`),
KEY `id_tag` (`id_tag`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
wie in PrestaShop 1.3
Filed under: Artikel — Schlagwörter: , , , , , , , , , , , — @

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert