/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 (1355.43ms)