catalog_product_entity_text

catalog_product_entity_text Spalte: entity_type_id fehlt in der Version 2.1.2 SQL

REPLACE INTO mage2pd.catalog_product_entity_text
(value_id, attribute_id,store_id,entity_id,value) 
SELECT
value_id, attribute_id,store_id,entity_id,value
FROM pool5.catalog_product_entity_text;

Reihenfolge beachten!

Es werden FOREIGN KEY constraint verwendet, d.h die entsprechenden Tabellen müssen entsprechend vorher importiert werden. catalog_product_entity

SQL Fehler (1452): 
Cannot add or update a child row: a foreign key constraint fails (`mage2pd`.`catalog_product_entity_text`, CONSTRAINT `CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCA ...