ALTER TABLE `CubeCart_extension_info` ADD INDEX(`seller_id`); #EOQ
ALTER TABLE `CubeCart_extension_info` ADD `keep_current` BOOLEAN NOT NULL DEFAULT FALSE AFTER `modified`; #EOQ
ALTER TABLE `CubeCart_filemanager` ADD `alt` TEXT NOT NULL; #EOQ
ALTER TABLE `CubeCart_order_summary` CHANGE `ship_tracking` `ship_tracking` TEXT NULL DEFAULT NULL; #EOQ
UPDATE `CubeCart_email_content` SET `content_html` = CONCAT(`content_html`,'{if !empty($DATA.ship_tracking)}<p>Track your order:<br>{$DATA.ship_tracking}</p>{/if}') WHERE `content_type` = 'cart.order_complete' AND `content_html` NOT LIKE '%{$DATA.ship_tracking}%'; #EOQ
UPDATE `CubeCart_email_content` SET `content_text` = CONCAT(`content_text`,'{if !empty($DATA.ship_tracking)}\r\n\r\nTrack your order:\r\n{$DATA.ship_tracking}{/if}') WHERE `content_type` = 'cart.order_complete' AND `content_text` NOT LIKE '%{$DATA.ship_tracking}%'; #EOQ
ALTER TABLE `CubeCart_inventory_language` ADD INDEX(`language`); #EOQ
CREATE TABLE `CubeCart_domains` (
	`id` int UNSIGNED NOT NULL,
	`language` varchar(5) NOT NULL,
	`domain` varchar(255) NOT NULL,
	PRIMARY KEY (`id`),
	KEY `language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; #EOQ
UPDATE `CubeCart_customer` SET `order_count` = (SELECT COUNT(*) FROM `CubeCart_order_summary` WHERE `CubeCart_customer`.`customer_id` = `CubeCart_order_summary`.`customer_id`); #EOQ