Update successful
Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TypesMigrateColumns.php Migrate type columns Add new type columns Checking table "mshop_attribute": -> ALTER TABLE mshop_attribute ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_attribute_list": -> ALTER TABLE mshop_attribute_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_attribute_property": -> ALTER TABLE mshop_attribute_property ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_catalog_list": -> ALTER TABLE mshop_catalog_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_customer_list": -> ALTER TABLE mshop_customer_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_customer_property": -> ALTER TABLE mshop_customer_property ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media": -> ALTER TABLE mshop_media ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media_list": -> ALTER TABLE mshop_media_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_media_property": -> ALTER TABLE mshop_media_property ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_plugin": -> ALTER TABLE mshop_plugin ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_price": -> ALTER TABLE mshop_price ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_price_list": -> ALTER TABLE mshop_price_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product": -> ALTER TABLE mshop_product ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product_list": -> ALTER TABLE mshop_product_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_product_property": -> ALTER TABLE mshop_product_property ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_service": -> ALTER TABLE mshop_service ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_service_list": -> ALTER TABLE mshop_service_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_stock": -> ALTER TABLE mshop_stock ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_supplier_list": -> ALTER TABLE mshop_supplier_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_tag": -> ALTER TABLE mshop_tag ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_text": -> ALTER TABLE mshop_text ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "mshop_text_list": -> ALTER TABLE mshop_text_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Drop old unique indexes Checking index "unq_msattr_sid_dom_cod_tid": -> DROP INDEX unq_msattr_sid_dom_cod_tid ON mshop_attribute Checking index "unq_msattli_sid_dm_rid_tid_pid": -> DROP INDEX unq_msattli_sid_dm_rid_tid_pid ON mshop_attribute_list Checking index "unq_msattpr_sid_tid_lid_value": -> DROP INDEX unq_msattpr_sid_tid_lid_value ON mshop_attribute_property Checking index "unq_mscatli_sid_dm_rid_tid_pid": -> DROP INDEX unq_mscatli_sid_dm_rid_tid_pid ON mshop_catalog_list Checking index "unq_mscusli_sid_dm_rid_tid_pid": -> DROP INDEX unq_mscusli_sid_dm_rid_tid_pid ON mshop_customer_list Checking index "unq_mcuspr_sid_tid_lid_value": -> DROP INDEX unq_mcuspr_sid_tid_lid_value ON mshop_customer_property Checking index "unq_msmedli_sid_dm_rid_tid_pid": -> DROP INDEX unq_msmedli_sid_dm_rid_tid_pid ON mshop_media_list Checking index "unq_msmedpr_sid_tid_lid_value": -> DROP INDEX unq_msmedpr_sid_tid_lid_value ON mshop_media_property Checking index "unq_msplu_sid_tid_prov": -> DROP INDEX unq_msplu_sid_tid_prov ON mshop_plugin Checking index "unq_msprili_sid_dm_rid_tid_pid": -> DROP INDEX unq_msprili_sid_dm_rid_tid_pid ON mshop_price_list Checking index "unq_msproli_sid_dm_rid_tid_pid": -> DROP INDEX unq_msproli_sid_dm_rid_tid_pid ON mshop_product_list Checking index "unq_mspropr_sid_tid_lid_value": -> DROP INDEX unq_mspropr_sid_tid_lid_value ON mshop_product_property Checking index "unq_msserli_sid_dm_rid_tid_pid": -> DROP INDEX unq_msserli_sid_dm_rid_tid_pid ON mshop_service_list Checking index "unq_mssto_sid_pcode_tid": -> DROP INDEX unq_mssto_sid_pcode_tid ON mshop_stock Checking index "unq_mssupli_sid_dm_rid_tid_pid": -> DROP INDEX unq_mssupli_sid_dm_rid_tid_pid ON mshop_supplier_list Checking index "unq_mstag_sid_dom_tid_lid_lab": -> DROP INDEX unq_mstag_sid_dom_tid_lid_lab ON mshop_tag Checking index "unq_mstexli_sid_dm_rid_tid_pid": -> DROP INDEX unq_mstexli_sid_dm_rid_tid_pid ON mshop_text_list Migrate typeid to type Checking table "mshop_attribute": Checking table "mshop_attribute_list": Checking table "mshop_attribute_property": Checking table "mshop_catalog_list": Checking table "mshop_customer_list": Checking table "mshop_customer_property": Checking table "mshop_media": Checking table "mshop_media_list": Checking table "mshop_media_property": Checking table "mshop_plugin": Checking table "mshop_price": Checking table "mshop_price_list": Checking table "mshop_product": Checking table "mshop_product_list": Checking table "mshop_product_property": Checking table "mshop_service": Checking table "mshop_service_list": Checking table "mshop_stock": Checking table "mshop_supplier_list": Checking table "mshop_tag": Checking table "mshop_text": Checking table "mshop_text_list": Drop typeid columns Checking table "mshop_attribute": -> ALTER TABLE mshop_attribute DROP FOREIGN KEY fk_msatt_typeid -> ALTER TABLE mshop_attribute DROP typeid Checking table "mshop_attribute_list": -> ALTER TABLE mshop_attribute_list DROP FOREIGN KEY fk_msattli_typeid -> ALTER TABLE mshop_attribute_list DROP typeid Checking table "mshop_attribute_property": -> ALTER TABLE mshop_attribute_property DROP typeid Checking table "mshop_catalog_list": -> ALTER TABLE mshop_catalog_list DROP FOREIGN KEY fk_mscatli_typeid -> ALTER TABLE mshop_catalog_list DROP typeid Checking table "mshop_customer_list": -> ALTER TABLE mshop_customer_list DROP FOREIGN KEY fk_mscusli_typeid -> ALTER TABLE mshop_customer_list DROP typeid Checking table "mshop_customer_property": -> ALTER TABLE mshop_customer_property DROP typeid Checking table "mshop_media": -> ALTER TABLE mshop_media DROP FOREIGN KEY fk_msmed_typeid -> ALTER TABLE mshop_media DROP typeid Checking table "mshop_media_list": -> ALTER TABLE mshop_media_list DROP FOREIGN KEY fk_msmedli_typeid -> ALTER TABLE mshop_media_list DROP typeid Checking table "mshop_media_property": -> ALTER TABLE mshop_media_property DROP typeid Checking table "mshop_plugin": -> ALTER TABLE mshop_plugin DROP FOREIGN KEY fk_msplu_typeid -> ALTER TABLE mshop_plugin DROP typeid Checking table "mshop_price": -> ALTER TABLE mshop_price DROP FOREIGN KEY fk_mspri_typeid -> ALTER TABLE mshop_price DROP typeid Checking table "mshop_price_list": -> ALTER TABLE mshop_price_list DROP FOREIGN KEY fk_msprili_typeid -> ALTER TABLE mshop_price_list DROP typeid Checking table "mshop_product": -> ALTER TABLE mshop_product DROP FOREIGN KEY fk_mspro_typeid -> ALTER TABLE mshop_product DROP typeid Checking table "mshop_product_list": -> ALTER TABLE mshop_product_list DROP FOREIGN KEY fk_msproli_typeid -> ALTER TABLE mshop_product_list DROP typeid Checking table "mshop_product_property": -> ALTER TABLE mshop_product_property DROP FOREIGN KEY fk_mspropr_typeid -> ALTER TABLE mshop_product_property DROP typeid Checking table "mshop_service": -> ALTER TABLE mshop_service DROP FOREIGN KEY fk_msser_typeid -> ALTER TABLE mshop_service DROP typeid Checking table "mshop_service_list": -> ALTER TABLE mshop_service_list DROP FOREIGN KEY fk_msserli_typeid -> ALTER TABLE mshop_service_list DROP typeid Checking table "mshop_stock": -> ALTER TABLE mshop_stock DROP FOREIGN KEY fk_mssto_typeid -> ALTER TABLE mshop_stock DROP typeid Checking table "mshop_supplier_list": -> ALTER TABLE mshop_supplier_list DROP FOREIGN KEY fk_mssupli_typeid -> ALTER TABLE mshop_supplier_list DROP typeid Checking table "mshop_tag": -> ALTER TABLE mshop_tag DROP FOREIGN KEY fk_mstag_typeid -> ALTER TABLE mshop_tag DROP typeid Checking table "mshop_text": -> ALTER TABLE mshop_text DROP FOREIGN KEY fk_mstex_typeid -> ALTER TABLE mshop_text DROP typeid Checking table "mshop_text_list": -> ALTER TABLE mshop_text_list DROP FOREIGN KEY fk_mstexli_typeid -> ALTER TABLE mshop_text_list DROP typeid Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TypesMigrateColumns.php (12516.59ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeMigrateKey.php (89.25ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php Clear property "key" columns Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesClearPropertyKey.php (88.82ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php Migrate mshop_index_text table engine to InnoDB Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexMigrateTextInnodb.php (622.46ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php Update fe_users "siteid" columns Checking table fe_users_list_type -> ALTER TABLE fe_users_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table fe_users_property_type -> ALTER TABLE fe_users_property_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table fe_users_property -> ALTER TABLE fe_users_property CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table fe_users_list -> ALTER TABLE fe_users_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table fe_users_address -> ALTER TABLE fe_users_address CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table fe_users -> ALTER TABLE fe_users CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TablesMigrateSiteidTypo3.php (1455.03ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php Update "siteid" columns -> ALTER TABLE mshop_locale_site ADD `siteid` INT DEFAULT 0 NOT NULL -> ALTER TABLE mshop_locale DROP FOREIGN KEY fk_msloc_siteid Checking table mshop_attribute_type -> ALTER TABLE mshop_attribute_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_attribute_list_type -> ALTER TABLE mshop_attribute_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_attribute_property_type -> ALTER TABLE mshop_attribute_property_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_attribute_list -> ALTER TABLE mshop_attribute_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_attribute_property -> ALTER TABLE mshop_attribute_property CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_attribute -> ALTER TABLE mshop_attribute CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table madmin_cache_tag -> ALTER TABLE madmin_cache_tag DROP FOREIGN KEY fk_macac_tid_tsid -> ALTER TABLE madmin_cache_tag CHANGE tsiteid tsiteid VARCHAR(255) DEFAULT NULL Checking table madmin_cache -> ALTER TABLE madmin_cache CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_catalog_list_type -> ALTER TABLE mshop_catalog_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_catalog_list -> ALTER TABLE mshop_catalog_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_catalog -> ALTER TABLE mshop_catalog CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_coupon_code -> ALTER TABLE mshop_coupon_code CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_coupon -> ALTER TABLE mshop_coupon CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_customer_list_type -> ALTER TABLE mshop_customer_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_customer_property_type -> ALTER TABLE mshop_customer_property_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_customer_group -> ALTER TABLE mshop_customer_group CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_customer_property -> ALTER TABLE mshop_customer_property CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_customer_list -> ALTER TABLE mshop_customer_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_customer_address -> ALTER TABLE mshop_customer_address CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_customer -> ALTER TABLE mshop_customer CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table madmin_job -> ALTER TABLE madmin_job CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_locale_site -> ALTER TABLE mshop_locale_site CHANGE `siteid` `siteid` VARCHAR(255) DEFAULT '0' NOT NULL Checking table mshop_locale -> ALTER TABLE mshop_locale CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table madmin_log -> ALTER TABLE madmin_log CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_media_type -> ALTER TABLE mshop_media_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_media_list_type -> ALTER TABLE mshop_media_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_media_property_type -> ALTER TABLE mshop_media_property_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_media_list -> ALTER TABLE mshop_media_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_media_property -> ALTER TABLE mshop_media_property CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_media -> ALTER TABLE mshop_media CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_order_base_product_attr -> ALTER TABLE mshop_order_base_product_attr CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base_service_attr -> ALTER TABLE mshop_order_base_service_attr CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base_coupon -> ALTER TABLE mshop_order_base_coupon CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base_product -> ALTER TABLE mshop_order_base_product CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base_service -> ALTER TABLE mshop_order_base_service CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base_address -> ALTER TABLE mshop_order_base_address CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_base -> ALTER TABLE mshop_order_base CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order_status -> ALTER TABLE mshop_order_status CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_order -> ALTER TABLE mshop_order CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_plugin_type -> ALTER TABLE mshop_plugin_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_plugin -> ALTER TABLE mshop_plugin CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_price_type -> ALTER TABLE mshop_price_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_price_list_type -> ALTER TABLE mshop_price_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_price_list -> ALTER TABLE mshop_price_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_price -> ALTER TABLE mshop_price CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_index_attribute -> ALTER TABLE mshop_index_attribute CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_index_catalog -> ALTER TABLE mshop_index_catalog CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_index_price -> ALTER TABLE mshop_index_price CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_index_supplier -> ALTER TABLE mshop_index_supplier CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_index_text -> ALTER TABLE mshop_index_text CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product_list_type -> ALTER TABLE mshop_product_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product_property_type -> ALTER TABLE mshop_product_property_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product_type -> ALTER TABLE mshop_product_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product_list -> ALTER TABLE mshop_product_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product_property -> ALTER TABLE mshop_product_property CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_product -> ALTER TABLE mshop_product CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_service_type -> ALTER TABLE mshop_service_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_service_list_type -> ALTER TABLE mshop_service_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_service_list -> ALTER TABLE mshop_service_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_service -> ALTER TABLE mshop_service CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_stock_type -> ALTER TABLE mshop_stock_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_stock -> ALTER TABLE mshop_stock CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_subscription -> ALTER TABLE mshop_subscription CHANGE siteid siteid VARCHAR(255) DEFAULT NULL Checking table mshop_supplier_list_type -> ALTER TABLE mshop_supplier_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_supplier_list -> ALTER TABLE mshop_supplier_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_supplier_address -> ALTER TABLE mshop_supplier_address CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_supplier -> ALTER TABLE mshop_supplier CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_tag_type -> ALTER TABLE mshop_tag_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_tag -> ALTER TABLE mshop_tag CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_text_type -> ALTER TABLE mshop_text_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_text_list_type -> ALTER TABLE mshop_text_list_type CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_text_list -> ALTER TABLE mshop_text_list CHANGE siteid siteid VARCHAR(255) NOT NULL Checking table mshop_text -> ALTER TABLE mshop_text CHANGE siteid siteid VARCHAR(255) NOT NULL Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateSiteid.php (17069.83ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php Migrate typeid to type for Laravel Add new type columns for Laravel Checking table "fe_users_list": -> ALTER TABLE fe_users_list ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Checking table "fe_users_property": -> ALTER TABLE fe_users_property ADD `type` VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` Drop old unique indexes for Laravel Checking index "unq_t3feuli_sid_dm_rid_tid_pid": -> DROP INDEX unq_t3feuli_sid_dm_rid_tid_pid ON fe_users_list Checking index "unq_t3feupr_sid_tid_lid_value": -> DROP INDEX unq_t3feupr_sid_tid_lid_value ON fe_users_property Migrate typeid to type for Laravel Checking table "fe_users_list": Checking table "fe_users_property": Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/TypesMigrateColumnsTypo3.php (586.73ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php Creating attribute schema -> ALTER TABLE mshop_attribute ADD `key` VARCHAR(255) DEFAULT '' NOT NULL, ADD `cgroups` INT DEFAULT NULL, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msatt_dom_type_code_sid` ON mshop_attribute (`domain`, `type`, `code`, `siteid`) -> CREATE INDEX `idx_msatt_dom_sid_stat_typ_pos` ON mshop_attribute (`domain`, `siteid`, `status`, `type`, `pos`) -> CREATE INDEX `idx_msatt_status_sid` ON mshop_attribute (`status`, `siteid`) -> CREATE INDEX `idx_msatt_label_sid` ON mshop_attribute (`label`, `siteid`) -> CREATE INDEX `idx_msatt_code_sid` ON mshop_attribute (`code`, `siteid`) -> CREATE INDEX `idx_msatt_type_sid` ON mshop_attribute (`type`, `siteid`) -> CREATE INDEX `idx_msatt_key_sid` ON mshop_attribute (`key`, `siteid`) -> ALTER TABLE mshop_attribute_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msattli_pid_dm_ty_rid_sid` ON mshop_attribute_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_msattli_key_sid` ON mshop_attribute_list (`key`, `siteid`) -> ALTER TABLE mshop_attribute_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msattlity_dom_code_sid` ON mshop_attribute_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattlity_status_sid_pos` ON mshop_attribute_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattlity_label_sid` ON mshop_attribute_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msattlity_code_sid` ON mshop_attribute_list_type (`code`, `siteid`) -> ALTER TABLE mshop_attribute_property ADD `key` VARCHAR(255) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_msattpr_ty_lid_value_sid` ON mshop_attribute_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_msattpr_key_sid` ON mshop_attribute_property (`key`, `siteid`) -> ALTER TABLE mshop_attribute_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msattprty_dom_code_sid` ON mshop_attribute_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattprty_status_sid_pos` ON mshop_attribute_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattprty_label_sid` ON mshop_attribute_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msattprty_code_sid` ON mshop_attribute_property_type (`code`, `siteid`) -> ALTER TABLE mshop_attribute_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msattty_dom_code_sid` ON mshop_attribute_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msattty_status_sid_pos` ON mshop_attribute_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msattty_label_sid` ON mshop_attribute_type (`label`, `siteid`) -> CREATE INDEX `idx_msattty_code_sid` ON mshop_attribute_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Attribute.php (924.49ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php Remove attribute indexes with siteid column first -> DROP INDEX unq_msattty_sid_dom_code ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_status_pos ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_label ON mshop_attribute_type -> DROP INDEX idx_msattty_sid_code ON mshop_attribute_type -> DROP INDEX unq_msattlity_sid_dom_code ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_status_pos ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_label ON mshop_attribute_list_type -> DROP INDEX idx_msattlity_sid_code ON mshop_attribute_list_type -> DROP INDEX unq_msattprty_sid_dom_code ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_status_pos ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_label ON mshop_attribute_property_type -> DROP INDEX idx_msattprty_sid_code ON mshop_attribute_property_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/AttributeRemoveIndexes.php (2196.57ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php Remove foreign key "fk_macac_tid_tsid" from "madmin_cache_tag" Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveForeignkey.php (187.63ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php Remove wrong "idx_majob_expire" and "fk_macac_tid" cache indexes -> DROP INDEX idx_majob_expire ON madmin_cache Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CacheRemoveIndexes.php (297.49ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php Creating cache schema -> ALTER TABLE madmin_cache ADD PRIMARY KEY (`id`) -> CREATE INDEX `idx_macac_expire` ON madmin_cache (`expire`) -> ALTER TABLE madmin_cache_tag ADD CONSTRAINT `fk_macacta_tid` FOREIGN KEY (`tid`) REFERENCES `madmin_cache` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_macacta_tid_tname` ON madmin_cache_tag (`tid`, `tname`) -> CREATE INDEX `unq_macacta_tname` ON madmin_cache_tag (`tname`) -> CREATE INDEX `fk_macacta_tid` ON madmin_cache_tag (`tid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Cache.php (182.97ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php Creating catalog schema -> ALTER TABLE mshop_catalog ADD `url` VARCHAR(255) DEFAULT '' NOT NULL, ADD `cgroups` INT DEFAULT NULL, CHANGE parentid parentid INT DEFAULT NULL, CHANGE level level SMALLINT DEFAULT 0 NOT NULL, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL, CHANGE target target VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE UNIQUE INDEX `unq_mscat_code_sid` ON mshop_catalog (`code`, `siteid`) -> CREATE INDEX `idx_mscat_nlt_nrt_lvl_pid_sid` ON mshop_catalog (`nleft`, `nright`, `level`, `parentid`, `siteid`) -> CREATE INDEX `idx_mscat_status_sid` ON mshop_catalog (`status`, `siteid`) -> ALTER TABLE mshop_catalog_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscatli_pid_dm_ty_rid_sid` ON mshop_catalog_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_mscatli_key_sid` ON mshop_catalog_list (`key`, `siteid`) -> ALTER TABLE mshop_catalog_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscatlity_dom_code_sid` ON mshop_catalog_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscatlity_status_sid_pos` ON mshop_catalog_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscatlity_label_sid` ON mshop_catalog_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mscatlity_code_sid` ON mshop_catalog_list_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Catalog.php (484.25ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php Remove catalog indexes with siteid column first -> DROP INDEX unq_mscat_sid_code ON mshop_catalog -> DROP INDEX idx_mscat_sid_nlt_nrt_lvl_pid ON mshop_catalog -> DROP INDEX idx_mscat_sid_status ON mshop_catalog -> DROP INDEX unq_mscatlity_sid_dom_code ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_status_pos ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_label ON mshop_catalog_list_type -> DROP INDEX idx_mscatlity_sid_code ON mshop_catalog_list_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CatalogRemoveIndexes.php (1393.45ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php Drop "fk_mscouco_parentid" in coupon code table -> ALTER TABLE mshop_coupon_code DROP FOREIGN KEY fk_mscouco_parentid Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponDropCodeForeign.php (295.04ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php Migrating basketvalues configuration in coupon table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponMigrateBasetValues.php (114.41ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php Drop "fk_mscusad_parentid" in customer address table -> ALTER TABLE mshop_customer_address DROP FOREIGN KEY fk_mscusad_parentid Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerDropAddressForeign.php (307.75ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php Creating coupon schema -> ALTER TABLE mshop_coupon CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_mscou_stat_start_end_sid` ON mshop_coupon (`status`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_mscou_provider_sid` ON mshop_coupon (`provider`, `siteid`) -> CREATE INDEX `idx_mscou_label_sid` ON mshop_coupon (`label`, `siteid`) -> CREATE INDEX `idx_mscou_start_sid` ON mshop_coupon (`start`, `siteid`) -> CREATE INDEX `idx_mscou_end_sid` ON mshop_coupon (`end`, `siteid`) -> ALTER TABLE mshop_coupon_code CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE ref ref VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_coupon_code ADD CONSTRAINT `fk_mscouco_pid` FOREIGN KEY (`parentid`) REFERENCES `mshop_coupon` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_mscouco_code_sid` ON mshop_coupon_code (`code`, `siteid`) -> CREATE INDEX `idx_mscouco_ct_start_end_sid` ON mshop_coupon_code (`count`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_mscouco_start_sid` ON mshop_coupon_code (`start`, `siteid`) -> CREATE INDEX `idx_mscouco_end_sid` ON mshop_coupon_code (`end`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Coupon.php (355.07ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php Remove coupon indexes with siteid column first -> DROP INDEX idx_mscou_sid_stat_start_end ON mshop_coupon -> DROP INDEX idx_mscou_sid_provider ON mshop_coupon -> DROP INDEX idx_mscou_sid_label ON mshop_coupon -> DROP INDEX idx_mscou_sid_start ON mshop_coupon -> DROP INDEX idx_mscou_sid_end ON mshop_coupon -> DROP INDEX unq_mscouco_sid_code ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_ct_start_end ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_start ON mshop_coupon_code -> DROP INDEX idx_mscouco_sid_end ON mshop_coupon_code Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CouponRemoveIndexes.php (1081.91ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php Remove left over TYPO3 fe_users references Remove records from fe_users_address Remove records from fe_users_list Remove records from fe_users_property Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveLostUserDataTypo3.php (103.8ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php Migrating "static_info_country" column in "fe_users" table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/FEUsersMigrateCountryTypo3.php (512.54ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php Creating customer schema -> ALTER TABLE fe_users_address ADD `birthday` DATE DEFAULT NULL, CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0', CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0', CHANGE pos pos SMALLINT DEFAULT 0 NOT NULL -> ALTER TABLE fe_users_address ADD CONSTRAINT `fk_t3feuad_pid` FOREIGN KEY (`parentid`) REFERENCES `fe_users` (`uid`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE INDEX `idx_t3feuad_langid_sid` ON fe_users_address (`langid`, `siteid`) -> CREATE INDEX `idx_t3feuad_post_ci` ON fe_users_address (`postal`, `city`) -> CREATE INDEX `fk_t3feuad_pid` ON fe_users_address (`parentid`) -> ALTER TABLE fe_users_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE status status SMALLINT DEFAULT 0 NOT NULL -> ALTER TABLE fe_users_list ADD CONSTRAINT `fk_t3feuli_pid` FOREIGN KEY (`parentid`) REFERENCES `fe_users` (`uid`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_t3feuli_pid_dm_ty_rid_sid` ON fe_users_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_t3feuli_key_sid` ON fe_users_list (`key`, `siteid`) -> CREATE INDEX `fk_t3feuli_pid` ON fe_users_list (`parentid`) -> ALTER TABLE fe_users_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE status status SMALLINT DEFAULT 0 NOT NULL -> CREATE UNIQUE INDEX `unq_t3feulity_dom_code_sid` ON fe_users_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_t3feulity_status_sid_pos` ON fe_users_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_t3feulity_label_sid` ON fe_users_list_type (`label`, `siteid`) -> CREATE INDEX `idx_t3feulity_code_sid` ON fe_users_list_type (`code`, `siteid`) -> ALTER TABLE fe_users_property ADD `key` VARCHAR(255) DEFAULT '' NOT NULL -> ALTER TABLE fe_users_property ADD CONSTRAINT `fk_t3feupr_pid` FOREIGN KEY (`parentid`) REFERENCES `fe_users` (`uid`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_t3feupr_pid_ty_lid_val_sid` ON fe_users_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_t3feupr_key_sid` ON fe_users_property (`key`, `siteid`) -> ALTER TABLE fe_users_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE status status SMALLINT DEFAULT 0 NOT NULL -> CREATE UNIQUE INDEX `unq_t3feuprty_dom_code_sid` ON fe_users_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_t3feuprty_status_sid_pos` ON fe_users_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_t3feuprty_label_sid` ON fe_users_property_type (`label`, `siteid`) -> CREATE INDEX `idx_t3feuprty_code_sid` ON fe_users_property_type (`code`, `siteid`) -> ALTER TABLE mshop_customer CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE salutation salutation VARCHAR(8) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE company company VARCHAR(100) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE vatid vatid VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE title title VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE firstname firstname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE lastname lastname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE postal postal VARCHAR(16) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telephone telephone VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE email email VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE website website VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0', CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0', CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscus_code_sid` ON mshop_customer (`code`, `siteid`) -> CREATE INDEX `idx_mscus_langid_sid` ON mshop_customer (`langid`, `siteid`) -> CREATE INDEX `idx_mscus_last_first` ON mshop_customer (`lastname`, `firstname`) -> CREATE INDEX `idx_mscus_post_addr1` ON mshop_customer (`postal`, `address1`) -> CREATE INDEX `idx_mscus_post_city` ON mshop_customer (`postal`, `city`) -> CREATE INDEX `idx_mscus_city` ON mshop_customer (`city`) -> CREATE INDEX `idx_mscus_email` ON mshop_customer (`email`) -> ALTER TABLE mshop_customer_address ADD `birthday` DATE DEFAULT NULL, CHANGE company company VARCHAR(100) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE vatid vatid VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE salutation salutation VARCHAR(8) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE title title VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE firstname firstname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE lastname lastname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE postal postal VARCHAR(16) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telephone telephone VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE email email VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE website website VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0', CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0', CHANGE pos pos SMALLINT DEFAULT 0 NOT NULL -> ALTER TABLE mshop_customer_address ADD CONSTRAINT `fk_mscusad_pid` FOREIGN KEY (`parentid`) REFERENCES `mshop_customer` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE INDEX `idx_mscusad_langid_sid` ON mshop_customer_address (`langid`, `siteid`) -> CREATE INDEX `idx_mscusad_last_first` ON mshop_customer_address (`lastname`, `firstname`) -> CREATE INDEX `idx_mscusad_post_addr1` ON mshop_customer_address (`postal`, `address1`) -> CREATE INDEX `idx_mscusad_post_city` ON mshop_customer_address (`postal`, `city`) -> CREATE INDEX `idx_mscusad_city` ON mshop_customer_address (`city`) -> CREATE INDEX `idx_mscusad_email` ON mshop_customer_address (`email`) -> ALTER TABLE mshop_customer_group CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE UNIQUE INDEX `unq_mscusgr_code_sid` ON mshop_customer_group (`code`, `siteid`) -> CREATE INDEX `idx_mscusgr_label_sid` ON mshop_customer_group (`label`, `siteid`) -> ALTER TABLE mshop_customer_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscusli_pid_dm_ty_rid_sid` ON mshop_customer_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_mscusli_key_sid` ON mshop_customer_list (`key`, `siteid`) -> ALTER TABLE mshop_customer_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscuslity_dom_code_sid` ON mshop_customer_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscuslity_status_sid_pos` ON mshop_customer_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscuslity_label_sid` ON mshop_customer_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mscuslity_code_sid` ON mshop_customer_list_type (`code`, `siteid`) -> ALTER TABLE mshop_customer_property ADD `key` VARCHAR(255) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_mscuspr_pid_ty_lid_val_sid` ON mshop_customer_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_mscuspr_key_sid` ON mshop_customer_property (`key`, `siteid`) -> ALTER TABLE mshop_customer_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mscusprty_dom_code_sid` ON mshop_customer_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mscusprty_status_sid_pos` ON mshop_customer_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mscusprty_label_sid` ON mshop_customer_property_type (`label`, `siteid`) -> CREATE INDEX `idx_mscusprty_code_sid` ON mshop_customer_property_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Customer.php (1424.9ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php Creating media schema -> ALTER TABLE mshop_media ADD `fsname` VARCHAR(32) DEFAULT '' NOT NULL, ADD `cgroups` INT DEFAULT NULL, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE preview preview TEXT CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE mimetype mimetype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_msmed_dom_mime_sid` ON mshop_media (`domain`, `mimetype`, `siteid`) -> CREATE INDEX `idx_msmed_label_sid` ON mshop_media (`label`, `siteid`) -> CREATE INDEX `idx_msmed_link_sid` ON mshop_media (`link`, `siteid`) -> ALTER TABLE mshop_media_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msmedli_pid_dm_ty_rid_sid` ON mshop_media_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_msmedli_key_sid` ON mshop_media_list (`key`, `siteid`) -> ALTER TABLE mshop_media_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msmedlity_dom_code_sid` ON mshop_media_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedlity_status_sid_pos` ON mshop_media_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedlity_label_sid` ON mshop_media_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedlity_code_sid` ON mshop_media_list_type (`code`, `siteid`) -> ALTER TABLE mshop_media_property ADD `key` VARCHAR(255) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_msmedpr_pid_ty_lid_val_sid` ON mshop_media_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_msmedpr_key_sid` ON mshop_media_property (`key`, `siteid`) -> ALTER TABLE mshop_media_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msmedprty_dom_code_sid` ON mshop_media_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedprty_status_sid_pos` ON mshop_media_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedprty_label_sid` ON mshop_media_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedprty_code_sid` ON mshop_media_property_type (`code`, `siteid`) -> ALTER TABLE mshop_media_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msmedty_dom_code_sid` ON mshop_media_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msmedty_status_sid_pos` ON mshop_media_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msmedty_label_sid` ON mshop_media_type (`label`, `siteid`) -> CREATE INDEX `idx_msmedty_code_sid` ON mshop_media_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Media.php (764.09ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php Creating price schema -> ALTER TABLE mshop_price ADD `cgroups` INT DEFAULT NULL, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE quantity quantity DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE value value NUMERIC(12, 2) DEFAULT '0', CHANGE costs costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE rebate rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE taxrate taxrate VARCHAR(255) DEFAULT '{}' NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_mspri_dom_cid_val_sid` ON mshop_price (`domain`, `currencyid`, `value`, `siteid`) -> ALTER TABLE mshop_price_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msprili_pid_dm_ty_rid_sid` ON mshop_price_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_msprili_key_sid` ON mshop_price_list (`key`, `siteid`) -> ALTER TABLE mshop_price_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msprility_dom_code_sid` ON mshop_price_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprility_status_sid_pos` ON mshop_price_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprility_label_sid` ON mshop_price_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msprility_code_sid` ON mshop_price_list_type (`code`, `siteid`) -> ALTER TABLE mshop_price_property ADD CONSTRAINT `fk_mspripr_pid` FOREIGN KEY (`parentid`) REFERENCES `mshop_price` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> ALTER TABLE mshop_price_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msprity_dom_code_sid` ON mshop_price_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprity_status_sid_pos` ON mshop_price_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprity_label_sid` ON mshop_price_type (`label`, `siteid`) -> CREATE INDEX `idx_msprity_code_sid` ON mshop_price_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Price.php (580.89ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php Creating product schema -> ALTER TABLE mshop_product ADD `dataset` VARCHAR(64) DEFAULT '' NOT NULL, ADD `url` VARCHAR(255) DEFAULT '' NOT NULL, ADD `scale` DOUBLE PRECISION DEFAULT '0' NOT NULL, ADD `rating` NUMERIC(4, 2) DEFAULT '0' NOT NULL, ADD `ratings` INT DEFAULT 0 NOT NULL, ADD `instock` SMALLINT DEFAULT 0 NOT NULL, ADD `cgroups` INT DEFAULT NULL, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL, CHANGE target target VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE UNIQUE INDEX `unq_mspro_siteid_code_sid` ON mshop_product (`code`, `siteid`) -> CREATE INDEX `idx_mspro_id_stat_st_end_rt_sid` ON mshop_product (`id`, `status`, `start`, `end`, `rating`, `siteid`) -> CREATE INDEX `idx_mspro_stat_st_end_rt_sid` ON mshop_product (`status`, `start`, `end`, `rating`, `siteid`) -> CREATE INDEX `idx_mspro_rating_sid` ON mshop_product (`rating`, `siteid`) -> CREATE INDEX `idx_mspro_label_sid` ON mshop_product (`label`, `siteid`) -> CREATE INDEX `idx_mspro_start_sid` ON mshop_product (`start`, `siteid`) -> CREATE INDEX `idx_mspro_type_sid` ON mshop_product (`type`, `siteid`) -> CREATE INDEX `idx_mspro_end_sid` ON mshop_product (`end`, `siteid`) -> ALTER TABLE mshop_product_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msproli_pid_dm_ty_rid_sid` ON mshop_product_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_msproli_key_sid` ON mshop_product_list (`key`, `siteid`) -> ALTER TABLE mshop_product_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msprolity_dom_code_sid` ON mshop_product_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msprolity_status_sid_pos` ON mshop_product_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msprolity_label_sid` ON mshop_product_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msprolity_code_sid` ON mshop_product_list_type (`code`, `siteid`) -> ALTER TABLE mshop_product_property ADD `key` VARCHAR(255) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_mspropr_pid_ty_lid_val_sid` ON mshop_product_property (`parentid`, `type`, `langid`, `value`, `siteid`) -> CREATE INDEX `idx_mspropr_key_sid` ON mshop_product_property (`key`, `siteid`) -> ALTER TABLE mshop_product_property_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msproprty_dom_code_sid` ON mshop_product_property_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msproprty_status_sid_pos` ON mshop_product_property_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msproprty_label_sid` ON mshop_product_property_type (`label`, `siteid`) -> CREATE INDEX `idx_msproprty_code_sid` ON mshop_product_property_type (`code`, `siteid`) -> ALTER TABLE mshop_product_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msproty_dom_code_sid` ON mshop_product_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msproty_status_sid_pos` ON mshop_product_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msproty_label_sid` ON mshop_product_type (`label`, `siteid`) -> CREATE INDEX `idx_msproty_code_sid` ON mshop_product_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Product.php (1608.93ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerClearPropertyKeyTypo3.php (308.28ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php Ensure unique codes in mshop_service Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceUniqueCode.php (98.97ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php Creating service schema -> ALTER TABLE mshop_service ADD `cgroups` INT DEFAULT NULL, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msser_siteid_code_sid` ON mshop_service (`code`, `siteid`) -> CREATE INDEX `idx_msser_stat_start_end_sid` ON mshop_service (`status`, `start`, `end`, `siteid`) -> CREATE INDEX `idx_msser_prov_sid` ON mshop_service (`provider`, `siteid`) -> CREATE INDEX `idx_msser_code_sid` ON mshop_service (`code`, `siteid`) -> CREATE INDEX `idx_msser_label_sid` ON mshop_service (`label`, `siteid`) -> CREATE INDEX `idx_msser_pos_sid` ON mshop_service (`pos`, `siteid`) -> ALTER TABLE mshop_service_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE config config VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '{}' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msserli_pid_dm_ty_rid_sid` ON mshop_service_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_msserli_key_sid` ON mshop_service_list (`key`, `siteid`) -> ALTER TABLE mshop_service_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msserlity_dom_code_sid` ON mshop_service_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msserlity_status_sid_pos` ON mshop_service_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msserlity_label_sid` ON mshop_service_list_type (`label`, `siteid`) -> CREATE INDEX `idx_msserlity_code_sid` ON mshop_service_list_type (`code`, `siteid`) -> ALTER TABLE mshop_service_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msserty_dom_code_sid` ON mshop_service_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msserty_status_sid_pos` ON mshop_service_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msserty_label_sid` ON mshop_service_type (`label`, `siteid`) -> CREATE INDEX `idx_msserty_code_sid` ON mshop_service_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Service.php (601.51ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php Creating supplier schema -> ALTER TABLE mshop_supplier ADD `pos` INT DEFAULT 0 NOT NULL, ADD `cgroups` INT DEFAULT NULL, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mssup_code_sid` ON mshop_supplier (`code`, `siteid`) -> CREATE INDEX `idx_mssup_label_sid` ON mshop_supplier (`label`, `siteid`) -> CREATE INDEX `idx_mssup_sid_stat_pos_label` ON mshop_supplier (`siteid`, `status`, `pos`, `label`) -> ALTER TABLE mshop_supplier_address ADD `birthday` DATE DEFAULT NULL, CHANGE company company VARCHAR(100) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE vatid vatid VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE salutation salutation VARCHAR(8) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE title title VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE firstname firstname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE lastname lastname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE postal postal VARCHAR(16) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telephone telephone VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE email email VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE website website VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0', CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0', CHANGE pos pos SMALLINT DEFAULT 0 NOT NULL -> ALTER TABLE mshop_supplier_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mssupli_pid_dm_ty_rid_sid` ON mshop_supplier_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_mssupli_key_sid` ON mshop_supplier_list (`key`, `siteid`) -> ALTER TABLE mshop_supplier_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mssuplity_dom_code_sid` ON mshop_supplier_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mssuplity_status_sid_pos` ON mshop_supplier_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mssuplity_sid_label_sid` ON mshop_supplier_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mssuplity_sid_code_sid` ON mshop_supplier_list_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Supplier.php (382.23ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php Creating text schema -> ALTER TABLE mshop_text ADD `cgroups` INT DEFAULT NULL, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_mstex_dom_stat_sid` ON mshop_text (`domain`, `status`, `siteid`) -> CREATE INDEX `idx_mstex_langid_sid` ON mshop_text (`langid`, `siteid`) -> CREATE INDEX `idx_mstex_label_sid` ON mshop_text (`label`, `siteid`) -> ALTER TABLE mshop_text_list ADD `key` VARCHAR(134) DEFAULT '' NOT NULL, CHANGE refid refid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mstexli_pid_dm_ty_rid_sid` ON mshop_text_list (`parentid`, `domain`, `type`, `refid`, `siteid`) -> CREATE INDEX `idx_mstexli_key_sid` ON mshop_text_list (`key`, `siteid`) -> ALTER TABLE mshop_text_list_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mstexlity_dom_code_sid` ON mshop_text_list_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mstexlity_status_sid_pos` ON mshop_text_list_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mstexlity_label` ON mshop_text_list_type (`label`, `siteid`) -> CREATE INDEX `idx_mstexlity_code` ON mshop_text_list_type (`code`, `siteid`) -> ALTER TABLE mshop_text_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mstexty_dom_code_sid` ON mshop_text_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mstexty_status_sid_pos` ON mshop_text_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mstexty_label_sid` ON mshop_text_type (`label`, `siteid`) -> CREATE INDEX `idx_mstexty_code_sid` ON mshop_text_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Text.php (660.7ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php Update lists "key" columns Checking table mshop_attribute_list Checking table mshop_catalog_list Checking table mshop_customer_list Checking table mshop_media_list Checking table mshop_price_list Checking table mshop_product_list Checking table mshop_service_list Checking table mshop_supplier_list Checking table mshop_text_list Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigrateListsKey.php (26433.37ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php Update TYPO3 lists "key" columns Checking table fe_users_list Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigrateListsKeyTypo3.php (1162.99ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php Update property "key" columns Checking table fe_users_property Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerMigratePropertyKeyTypo3.php (309.48ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php Remove customer indexes with siteid column first -> DROP INDEX unq_mscus_sid_code ON mshop_customer -> DROP INDEX idx_mscus_sid_langid ON mshop_customer -> DROP INDEX idx_mscus_sid_last_first ON mshop_customer -> DROP INDEX idx_mscus_sid_post_addr1 ON mshop_customer -> DROP INDEX idx_mscus_sid_post_city ON mshop_customer -> DROP INDEX idx_mscus_sid_city ON mshop_customer -> DROP INDEX idx_mscus_sid_email ON mshop_customer -> DROP INDEX idx_mscusad_sid_last_first ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_post_addr1 ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_post_ci ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_city ON mshop_customer_address -> DROP INDEX idx_mscusad_sid_email ON mshop_customer_address -> DROP INDEX unq_mscuslity_sid_dom_code ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_status_pos ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_label ON mshop_customer_list_type -> DROP INDEX idx_mscuslity_sid_code ON mshop_customer_list_type -> DROP INDEX unq_mcusprty_sid_dom_code ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_status_pos ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_label ON mshop_customer_property_type -> DROP INDEX idx_mcusprty_sid_code ON mshop_customer_property_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/CustomerRemoveIndexes.php (2710.86ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php Remove customer indexes with siteid column first -> DROP INDEX unq_t3feulity_sid_dom_code ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_status_pos ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_label ON fe_users_list_type -> DROP INDEX idx_t3feulity_sid_code ON fe_users_list_type -> DROP INDEX unq_t3feuprty_sid_dom_code ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_status_pos ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_label ON fe_users_property_type -> DROP INDEX idx_t3feuprty_sid_code ON fe_users_property_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/ai-typo3/setup/CustomerRemoveIndexesTypo3.php (1992.67ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php Use "id" column in "mshop_locale_site" -> DROP INDEX unq_msloc_sid_lang_curr ON mshop_locale -> DROP INDEX idx_msloc_sid_curid ON mshop_locale -> DROP INDEX idx_msloc_sid_status ON mshop_locale -> DROP INDEX idx_msloc_sid_pos ON mshop_locale -> ALTER TABLE mshop_locale ADD `site_id` INT DEFAULT NULL => UPDATE {"mshop_locale"} SET {"site_id":"1"} WHERE {"siteid":"1."} Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleMigrateSite.php (1037.47ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php Remove mshop_locale char constraints Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveCharConstraints.php (95.64ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRenameSiteSupplier.php (97.45ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php Creating locale schema -> ALTER TABLE mshop_locale_currency CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_msloccu_status` ON mshop_locale_currency (`status`) -> CREATE INDEX `idx_msloccu_label` ON mshop_locale_currency (`label`) -> ALTER TABLE mshop_locale_language CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_mslocla_status` ON mshop_locale_language (`status`) -> CREATE INDEX `idx_mslocla_label` ON mshop_locale_language (`label`) -> ALTER TABLE mshop_locale_site ADD `icon` VARCHAR(255) DEFAULT '' NOT NULL, ADD `logo` VARCHAR(255) DEFAULT '{}' NOT NULL, ADD `refid` VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, ADD `theme` VARCHAR(32) DEFAULT NULL, ADD `rating` NUMERIC(4, 2) DEFAULT '0' NOT NULL, ADD `ratings` INT DEFAULT 0 NOT NULL, ADD `invoiceno` INT DEFAULT 1 NOT NULL, CHANGE parentid parentid INT DEFAULT NULL, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE level level SMALLINT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mslocsi_siteid` ON mshop_locale_site (`siteid`) -> CREATE INDEX `idx_mslocsi_rating` ON mshop_locale_site (`rating`) -> CREATE INDEX `idx_mslocsi_label` ON mshop_locale_site (`label`) -> ALTER TABLE mshop_locale CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL, CHANGE `site_id` `site_id` INT NOT NULL -> ALTER TABLE mshop_locale ADD CONSTRAINT `fk_msloc_siteid` FOREIGN KEY (`site_id`) REFERENCES `mshop_locale_site` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_msloc_lang_curr_sid` ON mshop_locale (`langid`, `currencyid`, `site_id`) -> CREATE INDEX `fk_msloc_siteid` ON mshop_locale (`site_id`) -> CREATE INDEX `fk_msloc_langid` ON mshop_locale (`langid`) -> CREATE INDEX `fk_msloc_currid` ON mshop_locale (`currencyid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Locale.php (898.57ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php Add locale data for languages and currencies Adding data for MShop locale languages Adding data for MShop locale currencies Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleLangCurData.php (110.56ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php Creating log schema -> ALTER TABLE madmin_log CHANGE siteid siteid VARCHAR(255) DEFAULT '', CHANGE facility facility VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE priority priority SMALLINT DEFAULT 3 NOT NULL, CHANGE request request VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE INDEX `idx_malog_time_sid` ON madmin_log (`timestamp`, `siteid`) -> CREATE INDEX `idx_malog_facility_sid` ON madmin_log (`facility`, `siteid`) -> CREATE INDEX `idx_malog_prio_sid` ON madmin_log (`priority`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Log.php (200.73ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php Adding data for MShop locale domain Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddLocaleDataDefault.php (102.87ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php Adding locale data if not yet present Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddLocaleData.php (106.48ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php Setting locale to "default" Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopSetLocale.php (107.61ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php Processing catalog demo data Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCatalogData.php (98.59ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCouponData.php (96.63ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php Creating plugin schema -> ALTER TABLE mshop_plugin CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE pos pos INT DEFAULT 0 NOT NULL, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msplu_ty_prov_sid` ON mshop_plugin (`type`, `provider`, `siteid`) -> CREATE INDEX `idx_msplu_prov_sid` ON mshop_plugin (`provider`, `siteid`) -> CREATE INDEX `idx_msplu_status_sid` ON mshop_plugin (`status`, `siteid`) -> CREATE INDEX `idx_msplu_label_sid` ON mshop_plugin (`label`, `siteid`) -> CREATE INDEX `idx_msplu_pos_sid` ON mshop_plugin (`pos`, `siteid`) -> ALTER TABLE mshop_plugin_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mspluty_dom_code_sid` ON mshop_plugin_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mspluty_status_pos_sid` ON mshop_plugin_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mspluty_label_sid` ON mshop_plugin_type (`label`, `siteid`) -> CREATE INDEX `idx_mspluty_code_sid` ON mshop_plugin_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Plugin.php (312.18ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php Creating rule schema Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Rule.php (100.91ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php Migrate product code to product ID in stock table -> ALTER TABLE mshop_stock ADD `prodid` VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_stock DROP productcode Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockMigrateProductId.php (494.54ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php Creating stock schema -> ALTER TABLE mshop_stock ADD `timeframe` VARCHAR(16) DEFAULT '' NOT NULL -> CREATE UNIQUE INDEX `unq_mssto_pid_ty_sid` ON mshop_stock (`prodid`, `type`, `siteid`) -> CREATE INDEX `idx_mssto_stocklevel_sid` ON mshop_stock (`stocklevel`, `siteid`) -> CREATE INDEX `idx_mssto_backdate_sid` ON mshop_stock (`backdate`, `siteid`) -> ALTER TABLE mshop_stock_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msstoty_dom_code_sid` ON mshop_stock_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_msstoty_status_sid_pos` ON mshop_stock_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_msstoty_label_sid` ON mshop_stock_type (`label`, `siteid`) -> CREATE INDEX `idx_msstoty_code_sid` ON mshop_stock_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Stock.php (317.37ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php Creating tag schema -> CREATE UNIQUE INDEX `unq_mstag_dom_ty_lid_lab_sid` ON mshop_tag (`domain`, `type`, `langid`, `label`, `siteid`) -> CREATE INDEX `idx_mstag_dom_langid_sid` ON mshop_tag (`langid`, `domain`, `siteid`) -> CREATE INDEX `idx_mstag_dom_label_sid` ON mshop_tag (`label`, `domain`, `siteid`) -> ALTER TABLE mshop_tag_type CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_mstagty_dom_code_sid` ON mshop_tag_type (`domain`, `code`, `siteid`) -> CREATE INDEX `idx_mstagty_status_sid_pos` ON mshop_tag_type (`status`, `siteid`, `pos`) -> CREATE INDEX `idx_mstagty_label_sid` ON mshop_tag_type (`label`, `siteid`) -> CREATE INDEX `idx_mstagty_code_sid` ON mshop_tag_type (`code`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Tag.php (235.41ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddTypeData.php (98.43ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php Adding MShop type data for site "default" Checking "attribute/type" type data Checking "attribute/lists/type" type data Checking "catalog/lists/type" type data Checking "customer/lists/type" type data Checking "media/type" type data Checking "media/property/type" type data Checking "plugin/type" type data Checking "price/type" type data Checking "product/type" type data Checking "product/lists/type" type data Checking "product/property/type" type data Checking "rule/type" type data Checking "stock/type" type data Checking "service/type" type data Checking "service/lists/type" type data Checking "supplier/lists/type" type data Checking "tag/type" type data Checking "text/type" type data Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddTypeDataDefault.php (177.98ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddCodeData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddCodeData.php (100.66ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php Adding default code data for site "default" Checking "customer/group" codes Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCodeDataDefault.php (97.82ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddCustomerData.php (106.04ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddTypeData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddTypeData.php (95.22ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddSupplierData.php (95.81ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddProductData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddProductData.php (103.64ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddServiceData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoAddServiceData.php (99.26ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php Prepare mshop_index_price table for simplification Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimplePrice.php (1781.52ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php Prepare mshop_index_text table for simplification Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexPrepareSimpleText.php (1700.2ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveCtimeEditor.php Remove ctime/editor from index tables Checking table "mshop_index_attribute": -> ALTER TABLE mshop_index_attribute DROP ctime -> ALTER TABLE mshop_index_attribute DROP editor Checking table "mshop_index_catalog": -> ALTER TABLE mshop_index_catalog DROP ctime -> ALTER TABLE mshop_index_catalog DROP editor Checking table "mshop_index_price": Checking table "mshop_index_supplier": -> ALTER TABLE mshop_index_supplier DROP ctime -> ALTER TABLE mshop_index_supplier DROP editor Checking table "mshop_index_text": Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveCtimeEditor.php (1194.6ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php Remove old indexes from mshop_index_* tables -> DROP INDEX unq_msindsup_p_sid_supid_lt_po ON mshop_index_supplier Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexRemoveIndexes.php (225.05ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php Creating index schema -> CREATE TABLE `mshop_index_price` (`prodid` INT NOT NULL, `siteid` VARCHAR(255) NOT NULL, `currencyid` VARCHAR(3) NOT NULL, `value` NUMERIC(12, 2) DEFAULT '0', `mtime` DATETIME NOT NULL, UNIQUE INDEX `unq_msindpr_pid_sid_cid` (`prodid`, `siteid`, `currencyid`), INDEX `idx_msindpr_sid_cid_val` (`siteid`, `currencyid`, `value`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_0900_ai_ci` ENGINE = InnoDB -> CREATE TABLE `mshop_index_text` (`id` INT AUTO_INCREMENT NOT NULL, `prodid` INT NOT NULL, `siteid` VARCHAR(255) NOT NULL, `langid` VARCHAR(5) DEFAULT NULL, `url` VARCHAR(255) NOT NULL, `name` VARCHAR(255) NOT NULL, `content` MEDIUMTEXT NOT NULL, `mtime` DATETIME NOT NULL, UNIQUE INDEX `unq_msindte_pid_sid_lid_url` (`prodid`, `siteid`, `langid`, `url`), INDEX `idx_msindte_pid_sid_lid_name` (`prodid`, `siteid`, `langid`, `name`), PRIMARY KEY(`id`)) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_0900_ai_ci` ENGINE = InnoDB -> ALTER TABLE mshop_index_attribute ADD `artid` INT DEFAULT NULL, CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_index_catalog CHANGE catid catid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> ALTER TABLE mshop_index_cgroup CHANGE siteid siteid VARCHAR(255) NOT NULL -> CREATE INDEX `fk_msindcg_prodid` ON mshop_index_cgroup (`prodid`) -> ALTER TABLE mshop_index_customer CHANGE siteid siteid VARCHAR(255) NOT NULL -> CREATE INDEX `fk_msindcu_prodid` ON mshop_index_customer (`prodid`) -> ALTER TABLE mshop_index_supplier ADD `latitude` DOUBLE PRECISION DEFAULT '0', ADD `longitude` DOUBLE PRECISION DEFAULT '0', CHANGE supid supid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE listtype listtype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> CREATE UNIQUE INDEX `unq_msindsu_p_s_lt_si_po_la_lo` ON mshop_index_supplier (`prodid`, `supid`, `listtype`, `siteid`, `pos`, `latitude`, `longitude`) -> CREATE INDEX `idx_msindsup_p_lat_lon_sid` ON mshop_index_supplier (`prodid`, `latitude`, `longitude`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Index.php (574.82ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php Rebuilding index for demo data Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/DemoRebuildIndex.php (99.1ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexCreateSQLSrvFulltext.php (108.94ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/IndexDropTextWithoutId.php (106.48ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php Creating job schema -> ALTER TABLE madmin_job ADD `path` VARCHAR(255) NOT NULL, CHANGE label label VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE status status SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_majob_ctime_sid` ON madmin_job (`ctime`, `siteid`) -> CREATE INDEX `idx_majob_status_sid` ON madmin_job (`status`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Job.php (127.32ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobMigratePath.php Migrating path in job table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobMigratePath.php (110.42ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobRemoveIndexes.php Remove job indexes with siteid column first -> DROP INDEX idx_majob_sid_ctime ON madmin_job -> DROP INDEX idx_majob_sid_status ON madmin_job Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/JobRemoveIndexes.php (335.91ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos_ext/Resources/Private/Extensions/ai-customergroups/setup/ListsMigrateCgroups.php Updating "cgroups" column values Migrated: /var/www/typo3/typo3conf/ext/aimeos_ext/Resources/Private/Extensions/ai-customergroups/setup/ListsMigrateCgroups.php (497.21ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php Remove indexes from mshop_locale -> DROP INDEX fk_mslocsi_id ON mshop_locale -> DROP INDEX fk_mslocla_id ON mshop_locale -> DROP INDEX fk_msloccu_id ON mshop_locale -> DROP INDEX IDX_628DFA7F2271845 ON mshop_locale -> DROP INDEX IDX_628DFA7F4842F28 ON mshop_locale Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes.php (675.98ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php Remove locale indexes with siteid column first Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleRemoveIndexes2.php (526.38ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php Allow NULL for "theme" column in "mshop_locale_site" => UPDATE {"mshop_locale_site"} SET {"theme":null} WHERE {"theme":""} Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LocaleUpdateSiteTheme.php (105.55ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LogRemoveIndexes.php Remove log indexes with siteid column first -> DROP INDEX idx_malog_sid_time_facility_prio ON madmin_log Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/LogRemoveIndexes.php (226.93ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddAttributeData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddAttributeData.php (105.78ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddAttributeDataDefault.php (100.76ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php Adding MShop catalog data for site "default" Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddCatalogDataDefault.php (109.6ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddDataAbstract.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddDataAbstract.php (106.27ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddPluginData.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MShopAddPluginData.php (98.68ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php Adding default plugin data Adding data for MShop plugins Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/default/MShopAddPluginDataDefault.php (128.68ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos_ext/Resources/Private/Extensions/ai-customergroups/setup/MShopAddTypeDataCustomerGroups.php Adding ai-customergroups types to site "default" Adding MShop type data for site "default" Checking "attribute/lists/type" type data Checking "catalog/lists/type" type data Checking "media/lists/type" type data Checking "price/lists/type" type data Checking "product/lists/type" type data Checking "service/lists/type" type data Checking "text/lists/type" type data Migrated: /var/www/typo3/typo3conf/ext/aimeos_ext/Resources/Private/Extensions/ai-customergroups/setup/MShopAddTypeDataCustomerGroups.php (111.47ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaAddFsname.php Populating "fsname" column in media table => UPDATE {"mshop_media"} SET {"fsname":"fs-media"} WHERE {"fsname":""} Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaAddFsname.php (152.29ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaMigratePreview.php Migrating preview column in media table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaMigratePreview.php (2363.27ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaRemoveIndexes.php Remove media indexes with siteid column first -> DROP INDEX idx_msmed_sid_dom_langid ON mshop_media -> DROP INDEX idx_msmed_sid_dom_label ON mshop_media -> DROP INDEX idx_msmed_sid_dom_mime ON mshop_media -> DROP INDEX idx_msmed_sid_dom_link ON mshop_media -> DROP INDEX unq_msmedty_sid_dom_code ON mshop_media_type -> DROP INDEX idx_msmedty_sid_status_pos ON mshop_media_type -> DROP INDEX idx_msmedty_sid_label ON mshop_media_type -> DROP INDEX idx_msmedty_sid_code ON mshop_media_type -> DROP INDEX unq_msmedlity_sid_dom_code ON mshop_media_list_type -> DROP INDEX idx_msmedlity_sid_status_pos ON mshop_media_list_type -> DROP INDEX idx_msmedlity_sid_label ON mshop_media_list_type -> DROP INDEX idx_msmedlity_sid_code ON mshop_media_list_type -> DROP INDEX unq_msmedprty_sid_dom_code ON mshop_media_property_type -> DROP INDEX idx_msmedprty_sid_status_pos ON mshop_media_property_type -> DROP INDEX idx_msmedprty_sid_label ON mshop_media_property_type -> DROP INDEX idx_msmedprty_sid_code ON mshop_media_property_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/MediaRemoveIndexes.php (2310.54ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddProductParentid.php (110.45ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateStatus.php Migrate order product payment/delivery status => UPDATE {"mshop_order"} SET {"statuspayment":-1} WHERE {"statuspayment":null} => UPDATE {"mshop_order"} SET {"statusdelivery":-1} WHERE {"statusdelivery":null} Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateStatus.php (105.71ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php Rename "ordprodid" to "parentid" in "mshop_order_base_product_attr" table -> ALTER TABLE mshop_order_base_product_attr DROP FOREIGN KEY fk_msordbaprat_ordprodid -> DROP INDEX fk_msordbaprat_ordprodid ON mshop_order_base_product_attr -> DROP INDEX unq_msordbaprat_oid_aid_ty_cd ON mshop_order_base_product_attr Rename "ordservid" to "parentid" in "mshop_order_base_service_attr" table -> ALTER TABLE mshop_order_base_service_attr DROP FOREIGN KEY fk_msordbaseat_ordservid -> DROP INDEX fk_msordbaseat_ordservid ON mshop_order_base_service_attr -> DROP INDEX unq_msordbaseat_oid_aid_ty_cd ON mshop_order_base_service_attr Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameAttributeParentid.php (4192.69ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php Rename "status" to "statusdelivery" in "mshop_order_base_product" table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductStatus.php (1824.31ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php Rename "suppliername" to "vendor" in "mshop_order_base_product" table -> ALTER TABLE mshop_order_base_product DROP suppliercode Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameProductSupplier.php (1977.43ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php Rename "type" to "channel" in "mshop_order" table -> DROP INDEX idx_msord_sid_type ON mshop_order Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRenameType.php (1915.01ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php Creating order schema -> ALTER TABLE mshop_order ADD `invoiceno` VARCHAR(32) DEFAULT '' NOT NULL, CHANGE channel channel VARCHAR(16) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE relatedid relatedid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' COLLATE `utf8mb3_bin`, CHANGE cdate cdate VARCHAR(10) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE cmonth cmonth VARCHAR(7) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE cweek cweek VARCHAR(7) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE cwday cwday VARCHAR(1) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE chour chour VARCHAR(2) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE INDEX `idx_msord_channel_sid` ON mshop_order (`channel`, `siteid`) -> CREATE INDEX `idx_msord_ctime_pstat_sid` ON mshop_order (`ctime`, `statuspayment`, `siteid`) -> CREATE INDEX `idx_msord_mtime_pstat_sid` ON mshop_order (`mtime`, `statuspayment`, `siteid`) -> CREATE INDEX `idx_msord_mtime_dstat_sid` ON mshop_order (`mtime`, `statusdelivery`, `siteid`) -> CREATE INDEX `idx_msord_dstat_sid` ON mshop_order (`statusdelivery`, `siteid`) -> CREATE INDEX `idx_msord_ddate_sid` ON mshop_order (`datedelivery`, `siteid`) -> CREATE INDEX `idx_msord_pdate_sid` ON mshop_order (`datepayment`, `siteid`) -> CREATE INDEX `idx_msord_editor_sid` ON mshop_order (`editor`, `siteid`) -> CREATE INDEX `idx_msord_cdate_sid` ON mshop_order (`cdate`, `siteid`) -> CREATE INDEX `idx_msord_cmonth_sid` ON mshop_order (`cmonth`, `siteid`) -> CREATE INDEX `idx_msord_cweek_sid` ON mshop_order (`cweek`, `siteid`) -> CREATE INDEX `idx_msord_cwday_sid` ON mshop_order (`cwday`, `siteid`) -> CREATE INDEX `idx_msord_chour_sid` ON mshop_order (`chour`, `siteid`) -> ALTER TABLE mshop_order_base ADD `customerref` VARCHAR(255) DEFAULT '' NOT NULL, CHANGE customerid customerid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE sitecode sitecode VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' COLLATE `utf8mb3_bin`, CHANGE price price NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE costs costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE rebate rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE tax tax NUMERIC(14, 4) DEFAULT '0.000' NOT NULL, CHANGE taxflag taxflag SMALLINT DEFAULT 1 NOT NULL -> CREATE INDEX `idx_msordba_custid_scode` ON mshop_order_base (`customerid`, `sitecode`) -> CREATE INDEX `idx_msordba_custid_sid` ON mshop_order_base (`customerid`, `siteid`) -> CREATE INDEX `idx_msordba_ctime_sid` ON mshop_order_base (`ctime`, `siteid`) -> ALTER TABLE mshop_order_base_address ADD `birthday` DATE DEFAULT NULL, ADD `pos` INT DEFAULT 0 NOT NULL, CHANGE addrid addrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE salutation salutation VARCHAR(8) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE company company VARCHAR(100) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE vatid vatid VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE title title VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE firstname firstname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE lastname lastname VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address1 address1 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address2 address2 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE address3 address3 VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE postal postal VARCHAR(16) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE city city VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE state state VARCHAR(200) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telephone telephone VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE telefax telefax VARCHAR(32) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE email email VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE website website VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE longitude longitude DOUBLE PRECISION DEFAULT '0', CHANGE latitude latitude DOUBLE PRECISION DEFAULT '0' -> CREATE INDEX `idx_msordbaad_bid_lname` ON mshop_order_base_address (`baseid`, `lastname`) -> CREATE INDEX `idx_msordbaad_bid_addr1` ON mshop_order_base_address (`baseid`, `address1`) -> CREATE INDEX `idx_msordbaad_bid_postal` ON mshop_order_base_address (`baseid`, `postal`) -> CREATE INDEX `idx_msordbaad_bid_city` ON mshop_order_base_address (`baseid`, `city`) -> CREATE INDEX `idx_msordbaad_bid_email` ON mshop_order_base_address (`baseid`, `email`) -> ALTER TABLE mshop_order_base_coupon CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin` -> CREATE INDEX `idx_msordbaco_bid_code` ON mshop_order_base_coupon (`baseid`, `code`) -> ALTER TABLE mshop_order_base_product ADD `ordaddrid` BIGINT DEFAULT NULL, ADD `parentprodid` VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, ADD `vendor` VARCHAR(255) DEFAULT '' NOT NULL, ADD `description` TEXT NOT NULL, ADD `timeframe` VARCHAR(16) DEFAULT '' NOT NULL, ADD `qtyopen` DOUBLE PRECISION DEFAULT '0' NOT NULL, ADD `scale` DOUBLE PRECISION DEFAULT '1' NOT NULL, ADD `statuspayment` SMALLINT DEFAULT -1 NOT NULL, ADD `notes` TEXT NOT NULL, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE prodid prodid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE prodcode prodcode VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE stocktype stocktype VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT 'default' NOT NULL COLLATE `utf8mb3_bin`, CHANGE name name VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE mediaurl mediaurl VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE target target VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE quantity quantity DOUBLE PRECISION DEFAULT '1' NOT NULL, CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE costs costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE rebate rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE tax tax NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, CHANGE taxrate taxrate VARCHAR(255) DEFAULT '{}' NOT NULL, CHANGE taxflag taxflag SMALLINT DEFAULT 1 NOT NULL, CHANGE flags flags INT DEFAULT 0 NOT NULL, CHANGE pos pos INT DEFAULT 0 NOT NULL -> CREATE INDEX `idx_msordbapr_bid_pid` ON mshop_order_base_product (`baseid`, `prodid`) -> CREATE INDEX `idx_msordbapr_bid_pcd` ON mshop_order_base_product (`baseid`, `prodcode`) -> CREATE INDEX `idx_msordbapr_bid_qtyo` ON mshop_order_base_product (`baseid`, `qtyopen`) -> CREATE INDEX `idx_msordbapr_ct_pid_bid` ON mshop_order_base_product (`ctime`, `prodid`, `baseid`) -> ALTER TABLE mshop_order_base_product_attr ADD `price` NUMERIC(12, 2) DEFAULT '0', CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE name name VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE quantity quantity DOUBLE PRECISION DEFAULT '1' NOT NULL -> ALTER TABLE mshop_order_base_product_attr ADD CONSTRAINT `fk_msordbaprat_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_base_product` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_msordbaprat_oid_aid_ty_cd` ON mshop_order_base_product_attr (`parentid`, `attrid`, `type`, `code`) -> CREATE INDEX `fk_msordbaprat_parentid` ON mshop_order_base_product_attr (`parentid`) -> ALTER TABLE mshop_order_base_service ADD `pos` INT DEFAULT 0 NOT NULL, CHANGE servid servid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE name name VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE mediaurl mediaurl VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE price price NUMERIC(12, 2) DEFAULT '0', CHANGE costs costs NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE rebate rebate NUMERIC(12, 2) DEFAULT '0.00' NOT NULL, CHANGE tax tax NUMERIC(14, 4) DEFAULT '0.0000' NOT NULL, CHANGE taxrate taxrate VARCHAR(255) DEFAULT '{}' NOT NULL, CHANGE taxflag taxflag SMALLINT DEFAULT 1 NOT NULL -> CREATE UNIQUE INDEX `unq_msordbase_bid_cd_typ_sid` ON mshop_order_base_service (`baseid`, `code`, `type`, `siteid`) -> CREATE INDEX `idx_msordbase_code_type_sid` ON mshop_order_base_service (`code`, `type`, `siteid`) -> ALTER TABLE mshop_order_base_service_attr ADD `price` NUMERIC(12, 2) DEFAULT '0', CHANGE attrid attrid VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE code code VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE name name VARCHAR(255) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE quantity quantity DOUBLE PRECISION DEFAULT '1' NOT NULL -> ALTER TABLE mshop_order_base_service_attr ADD CONSTRAINT `fk_msordbaseat_parentid` FOREIGN KEY (`parentid`) REFERENCES `mshop_order_base_service` (`id`) ON UPDATE CASCADE ON DELETE CASCADE -> CREATE UNIQUE INDEX `unq_msordbaseat_oid_aid_ty_cd` ON mshop_order_base_service_attr (`parentid`, `attrid`, `type`, `code`) -> CREATE INDEX `fk_msordbaseat_parentid` ON mshop_order_base_service_attr (`parentid`) -> ALTER TABLE mshop_order_status CHANGE type type VARCHAR(64) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, CHANGE value value VARCHAR(64) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci` -> CREATE INDEX `idx_msordst_pid_typ_val_sid` ON mshop_order_status (`parentid`, `type`, `value`, `siteid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Order.php (2323.11ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php Adding currency ID to order base product table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseProductCurrencyid.php (113.96ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php Adding currency ID to order base service table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddBaseServiceCurrencyid.php (117.95ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddWeekday.php Populate weekday column in order table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderAddWeekday.php (123.45ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateTaxrate.php Migrating taxrate columns in order tables Migrating taxrate column in order base product table Migrating taxrate column in order base service table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderMigrateTaxrate.php (4748.68ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRemoveIndexes.php Remove order indexes with siteid column first -> DROP INDEX idx_msord_sid_mtime_pstat ON mshop_order -> DROP INDEX idx_msord_sid_mtime_dstat ON mshop_order -> DROP INDEX idx_msord_sid_dstatus ON mshop_order -> DROP INDEX idx_msord_sid_ddate ON mshop_order -> DROP INDEX idx_msord_sid_pdate ON mshop_order -> DROP INDEX idx_msord_sid_editor ON mshop_order -> DROP INDEX idx_msord_sid_cdate ON mshop_order -> DROP INDEX idx_msord_sid_cmonth ON mshop_order -> DROP INDEX idx_msord_sid_cweek ON mshop_order -> DROP INDEX idx_msord_sid_cwday ON mshop_order -> DROP INDEX idx_msord_sid_chour ON mshop_order -> DROP INDEX idx_msordba_sid_ctime ON mshop_order_base -> DROP INDEX idx_msordstatus_val_sid ON mshop_order_status -> DROP INDEX idx_msordbaad_sid_bid_typ ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_sid_lname ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_sid_addr1 ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_sid_postal ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_sid_city ON mshop_order_base_address -> DROP INDEX idx_msordbaad_bid_sid_email ON mshop_order_base_address -> DROP INDEX idx_msordbase_sid_code_type ON mshop_order_base_service Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/OrderRemoveIndexes.php (3892.83ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PluginRemoveIndexes.php Remove plugin indexes with siteid column first -> DROP INDEX idx_msplu_sid_prov ON mshop_plugin -> DROP INDEX idx_msplu_sid_status ON mshop_plugin -> DROP INDEX idx_msplu_sid_label ON mshop_plugin -> DROP INDEX idx_msplu_sid_pos ON mshop_plugin -> DROP INDEX unq_mspluty_sid_dom_code ON mshop_plugin_type -> DROP INDEX idx_mspluty_sid_status_pos ON mshop_plugin_type -> DROP INDEX idx_mspluty_sid_label ON mshop_plugin_type -> DROP INDEX idx_mspluty_sid_code ON mshop_plugin_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PluginRemoveIndexes.php (1234.01ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php Migrating taxrate column in price table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxrate.php (3571.25ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php Migrating taxrate name in price table Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceMigrateTaxRateName.php (207.03ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceRemoveIndexes.php Remove price indexes with siteid column first -> DROP INDEX idx_mspri_sid_dom_currid ON mshop_price -> DROP INDEX idx_mspri_sid_dom_quantity ON mshop_price -> DROP INDEX idx_mspri_sid_dom_value ON mshop_price -> DROP INDEX idx_mspri_sid_dom_costs ON mshop_price -> DROP INDEX idx_mspri_sid_dom_rebate ON mshop_price -> DROP INDEX unq_msprity_sid_dom_code ON mshop_price_type -> DROP INDEX idx_msprity_sid_status_pos ON mshop_price_type -> DROP INDEX idx_msprity_sid_label ON mshop_price_type -> DROP INDEX idx_msprity_sid_code ON mshop_price_type -> DROP INDEX unq_msprility_sid_dom_code ON mshop_price_list_type -> DROP INDEX idx_msprility_sid_status_pos ON mshop_price_list_type -> DROP INDEX idx_msprility_sid_label ON mshop_price_list_type -> DROP INDEX idx_msprility_sid_code ON mshop_price_list_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/PriceRemoveIndexes.php (2577.28ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateCatalog.php Migrating category references to product domain Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateCatalog.php (3215.63ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateSupplier.php Migrating supplier references to product domain Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductMigrateSupplier.php (105.88ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductRemoveIndexes.php Remove product indexes with siteid column first -> DROP INDEX unq_mspro_siteid_code ON mshop_product -> DROP INDEX idx_mspro_sid_label ON mshop_product -> DROP INDEX idx_mspro_sid_start ON mshop_product -> DROP INDEX idx_mspro_sid_end ON mshop_product -> DROP INDEX unq_msproty_sid_dom_code ON mshop_product_type -> DROP INDEX idx_msproty_sid_status_pos ON mshop_product_type -> DROP INDEX idx_msproty_sid_label ON mshop_product_type -> DROP INDEX idx_msproty_sid_code ON mshop_product_type -> DROP INDEX unq_msprolity_sid_dom_code ON mshop_product_list_type -> DROP INDEX idx_msprolity_sid_status_pos ON mshop_product_list_type -> DROP INDEX idx_msprolity_sid_label ON mshop_product_list_type -> DROP INDEX idx_msprolity_sid_code ON mshop_product_list_type -> DROP INDEX unq_msproprty_sid_dom_code ON mshop_product_property_type -> DROP INDEX idx_msproprty_sid_status_pos ON mshop_product_property_type -> DROP INDEX idx_msproprty_sid_label ON mshop_product_property_type -> DROP INDEX idx_msproprty_sid_code ON mshop_product_property_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ProductRemoveIndexes.php (2887.9ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php Creating queue schema -> CREATE INDEX `idx_maque_queue_rtime_cname` ON madmin_queue (`queue`, `rtime`, `cname`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Queue.php (137.39ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php Creating review schema Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Review.php (116.48ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php Remove review indexes with siteid column first Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ReviewRemoveIndexes.php (665.47ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/RuleRemoveIndexes.php Remove rule indexes with siteid column first Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/RuleRemoveIndexes.php (1241.92ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php Remove service indexes with siteid column first -> DROP INDEX unq_msser_siteid_code ON mshop_service -> DROP INDEX idx_msser_sid_stat_start_end ON mshop_service -> DROP INDEX idx_msser_sid_prov ON mshop_service -> DROP INDEX idx_msser_sid_code ON mshop_service -> DROP INDEX idx_msser_sid_label ON mshop_service -> DROP INDEX idx_msser_sid_pos ON mshop_service -> DROP INDEX unq_msserty_sid_dom_code ON mshop_service_type -> DROP INDEX idx_msserty_sid_status_pos ON mshop_service_type -> DROP INDEX idx_msserty_sid_label ON mshop_service_type -> DROP INDEX idx_msserty_sid_code ON mshop_service_type -> DROP INDEX unq_msserlity_sid_dom_code ON mshop_service_list_type -> DROP INDEX idx_msserlity_sid_status_pos ON mshop_service_list_type -> DROP INDEX idx_msserlity_sid_label ON mshop_service_list_type -> DROP INDEX idx_msserlity_sid_code ON mshop_service_list_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/ServiceRemoveIndexes.php (1957.72ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php Add stock type domain values Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockAddTypeDomainValue.php (108.74ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockRemoveIndexes.php Remove stock indexes with siteid column first -> DROP INDEX idx_mssto_sid_stocklevel ON mshop_stock -> DROP INDEX idx_mssto_sid_backdate ON mshop_stock -> DROP INDEX unq_msstoty_sid_dom_code ON mshop_stock_type -> DROP INDEX idx_msstoty_sid_status_pos ON mshop_stock_type -> DROP INDEX idx_msstoty_sid_label ON mshop_stock_type -> DROP INDEX idx_msstoty_sid_code ON mshop_stock_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/StockRemoveIndexes.php (968.28ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php Creating subscription schema -> ALTER TABLE mshop_subscription ADD `productid` VARCHAR(36) CHARACTER SET utf8mb3 DEFAULT '' NOT NULL COLLATE `utf8mb3_bin`, ADD `period` SMALLINT DEFAULT 0 NOT NULL, CHANGE `interval` `interval` VARCHAR(32) CHARACTER SET utf8mb3 NOT NULL COLLATE `utf8mb3_general_ci`, CHANGE reason reason SMALLINT DEFAULT 0 -> CREATE INDEX `idx_mssub_pid_period_sid` ON mshop_subscription (`productid`, `period`, `siteid`) -> CREATE INDEX `idx_mssub_next_stat_sid` ON mshop_subscription (`next`, `status`, `siteid`) -> CREATE INDEX `idx_mssub_opid` ON mshop_subscription (`ordprodid`) -> CREATE INDEX `idx_mssub_baseid` ON mshop_subscription (`baseid`) Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/Subscription.php (175.14ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php Updating period count in subscriptions Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigratePeriod.php (117.1ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php Updating product ID in subscriptions Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionMigrateProductId.php (123.92ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php Remove subscription indexes with siteid column first -> DROP INDEX idx_mssub_sid_next_stat ON mshop_subscription -> DROP INDEX idx_mssub_sid_baseid ON mshop_subscription -> DROP INDEX idx_mssub_sid_opid ON mshop_subscription Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SubscriptionRemoveIndexes.php (640.43ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php Remove supplier indexes with siteid column first -> DROP INDEX unq_mssup_sid_code ON mshop_supplier -> DROP INDEX idx_mssup_sid_label ON mshop_supplier -> DROP INDEX idx_mssupad_sid_rid ON mshop_supplier_address -> DROP INDEX unq_mssuplity_sid_dom_code ON mshop_supplier_list_type -> DROP INDEX idx_mssuplity_sid_status_pos ON mshop_supplier_list_type -> DROP INDEX idx_mssuplity_sid_label ON mshop_supplier_list_type -> DROP INDEX idx_mssuplity_sid_code ON mshop_supplier_list_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/SupplierRemoveIndexes.php (1952.93ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigratePropertyKey.php Update property "key" columns Checking table mshop_attribute_property Checking table mshop_customer_property Checking table mshop_media_property Checking table mshop_price_property Checking table mshop_product_property Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TablesMigratePropertyKey.php (1281.93ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TagRemoveIndexes.php Remove tag indexes with siteid column first -> DROP INDEX idx_mstag_sid_dom_langid ON mshop_tag -> DROP INDEX idx_mstag_sid_dom_label ON mshop_tag -> DROP INDEX unq_mstagty_sid_dom_code ON mshop_tag_type -> DROP INDEX idx_mstagty_sid_status_pos ON mshop_tag_type -> DROP INDEX idx_mstagty_sid_label ON mshop_tag_type -> DROP INDEX idx_mstagty_sid_code ON mshop_tag_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TagRemoveIndexes.php (913.27ms) Migrating: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TextRemoveIndexes.php Remove text indexes with siteid column first -> DROP INDEX idx_mstex_sid_domain_status ON mshop_text -> DROP INDEX idx_mstex_sid_domain_langid ON mshop_text -> DROP INDEX idx_mstex_sid_dom_label ON mshop_text -> DROP INDEX unq_mstexty_sid_dom_code ON mshop_text_type -> DROP INDEX idx_mstexty_sid_status_pos ON mshop_text_type -> DROP INDEX idx_mstexty_sid_label ON mshop_text_type -> DROP INDEX idx_mstexty_sid_code ON mshop_text_type -> DROP INDEX unq_mstexlity_sid_dom_code ON mshop_text_list_type -> DROP INDEX idx_mstexlity_sid_status_pos ON mshop_text_list_type -> DROP INDEX idx_mstexlity_sid_label ON mshop_text_list_type -> DROP INDEX idx_mstexlity_sid_code ON mshop_text_list_type Migrated: /var/www/typo3/typo3conf/ext/aimeos/Resources/Libraries/aimeos/aimeos-core/setup/TextRemoveIndexes.php (1494.25ms) Setup process lasted 146.450785 sec 