CPM-691: with column removal deploy env

[SamirBoulil]

trafficstars

• Removes DB triggers introduced during the uuid migration
• Removes the DB column that references pim_catalog_product.id columns
• Cleans up the versioning table from resource_uuid information for non product related versions.

Regarding the DB structure changes, here is an example of what is going to be executed on the environments

-- Version Pim\Upgrade\Schema\Version_7_0_20220823121643_remove_uuid_triggers
DROP TRIGGER IF EXISTS pim_catalog_association_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_association_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_association_product_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_association_product_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_association_product_model_to_product_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_association_product_model_to_product_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_category_product_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_category_product_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_group_product_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_group_product_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_product_unique_data_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_product_unique_data_uuid_update;
DROP TRIGGER IF EXISTS pim_catalog_completeness_uuid_insert;
DROP TRIGGER IF EXISTS pim_catalog_completeness_uuid_update;
DROP TRIGGER IF EXISTS pim_dqi_product_criteria_evaluation_uuid_insert;
DROP TRIGGER IF EXISTS pim_dqi_product_criteria_evaluation_uuid_update;
DROP TRIGGER IF EXISTS pim_dqi_product_score_uuid_insert;
DROP TRIGGER IF EXISTS pim_dqi_product_score_uuid_update;
DROP TRIGGER IF EXISTS pim_versioning_version_uuid_insert;
DROP TRIGGER IF EXISTS pim_versioning_version_uuid_update;
DROP TRIGGER IF EXISTS pim_comment_comment_uuid_insert;
DROP TRIGGER IF EXISTS pim_comment_comment_uuid_update;
DROP TRIGGER IF EXISTS pimee_workflow_product_draft_uuid_insert;
DROP TRIGGER IF EXISTS pimee_workflow_product_draft_uuid_update;
DROP TRIGGER IF EXISTS pimee_workflow_published_product_uuid_insert;
DROP TRIGGER IF EXISTS pimee_workflow_published_product_uuid_update;
DROP TRIGGER IF EXISTS pimee_twa_completeness_per_attribute_group_uuid_insert;
DROP TRIGGER IF EXISTS pimee_twa_completeness_per_attribute_group_uuid_update;
DROP TRIGGER IF EXISTS pimee_twa_project_product_uuid_insert;
DROP TRIGGER IF EXISTS pimee_twa_project_product_uuid_update;
ALTER TABLE pim_catalog_category_product DROP FOREIGN KEY FK_512179C14584665A;;
DROP INDEX IDX_512179C14584665A ON pim_catalog_category_product;;
ALTER TABLE pim_catalog_category_product DROP COLUMN product_id;
ALTER TABLE pim_catalog_group_product DROP FOREIGN KEY FK_7AC0C83A4584665A;;
DROP INDEX IDX_7AC0C83A4584665A ON pim_catalog_group_product;;
ALTER TABLE pim_catalog_group_product DROP COLUMN product_id;
ALTER TABLE pim_catalog_product_unique_data DROP FOREIGN KEY FK_E0768BA34584665A;;
DROP INDEX IDX_E0768BA34584665A ON pim_catalog_product_unique_data;;
ALTER TABLE pim_catalog_product_unique_data DROP COLUMN product_id;
DROP INDEX IDX_113BA8544584665A ON pim_catalog_completeness;;
DROP INDEX searchunique_idx ON pim_catalog_completeness;;
ALTER TABLE pim_catalog_completeness DROP COLUMN product_id;
ALTER TABLE pim_data_quality_insights_product_criteria_evaluation DROP COLUMN product_id;
ALTER TABLE pim_data_quality_insights_product_score DROP COLUMN product_id;
ALTER TABLE pimee_teamwork_assistant_completeness_per_attribute_group DROP FOREIGN KEY attr_grp_completeness_product_foreign_key;;
DROP INDEX attr_grp_completeness_product_index ON pimee_teamwork_assistant_completeness_per_attribute_group;;
ALTER TABLE pimee_teamwork_assistant_completeness_per_attribute_group DROP COLUMN product_id;
ALTER TABLE pimee_teamwork_assistant_project_product DROP FOREIGN KEY product_selection_product_foreign_key;;
DROP INDEX product_selection_product_index ON pimee_teamwork_assistant_project_product;;
ALTER TABLE pimee_teamwork_assistant_project_product DROP COLUMN product_id;
ALTER TABLE pimee_workflow_product_draft DROP FOREIGN KEY FK_6F63A25F4584665A;;
DROP INDEX IDX_6F63A25F4584665A ON pimee_workflow_product_draft;;
DROP INDEX unique_idx ON pimee_workflow_product_draft;;
ALTER TABLE pimee_workflow_product_draft DROP COLUMN product_id;
ALTER TABLE pimee_workflow_published_product DROP FOREIGN KEY FK_E3566E69283311CE;;
DROP INDEX UNIQ_E3566E69283311CE ON pimee_workflow_published_product;;
ALTER TABLE pimee_workflow_published_product DROP COLUMN original_product_id;
ALTER TABLE pim_catalog_association DROP FOREIGN KEY FK_CC2710017E3C61F9;;
DROP INDEX IDX_CC2710017E3C61F9 ON pim_catalog_association;;
DROP INDEX locale_foreign_key_idx ON pim_catalog_association;;
ALTER TABLE pim_catalog_association DROP COLUMN owner_id;
ALTER TABLE pim_catalog_association_product DROP FOREIGN KEY FK_3A3A49D44584665A;;
DROP INDEX IDX_3A3A49D44584665A ON pim_catalog_association_product;;
ALTER TABLE pim_catalog_association_product DROP COLUMN product_id;
ALTER TABLE pim_catalog_association_product_model_to_product DROP FOREIGN KEY FK_3FF3ED194584665A;;
DROP INDEX IDX_3FF3ED194584665A ON pim_catalog_association_product_model_to_product;;
ALTER TABLE pim_catalog_association_product_model_to_product DROP COLUMN product_id;

Definition Of Done (for Core Developer only)

• [x] Tests
• [x] Migration & Installer