ALTER TABLE `engine4_core_emailtemplates` CHANGE `header_logo` `header_logo` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

ALTER TABLE `engine4_core_themes` ADD `clone` TINYINT(1) NOT NULL DEFAULT '0';

ALTER TABLE `engine4_core_dashboardlinks` CHANGE `sublink` `sublink` INT(11) NOT NULL DEFAULT '0';

INSERT IGNORE INTO `engine4_core_menus` (`name`, `type`, `title`, `order`) VALUES
('core_main_quickcreate', 'standard', 'Content Create Quick Link Menu', 999);

ALTER TABLE `engine4_core_menuitems` ADD `description` VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE `engine4_core_menuitems` ADD `file_id` INT(11) NOT NULL DEFAULT '0';

UPDATE `engine4_core_menuitems` SET `params` = '{"icon":"fi fi-rr-home"}' WHERE `engine4_core_menuitems`.`name` = 'core_main_home';

UPDATE `engine4_core_menuitems` SET `params` = '{"route":"user_extended","module":"user","controller":"settings","action":"general", "icon":"fi fi-rr-settings"}' WHERE `engine4_core_menuitems`.`name` = 'core_minimenu_settings';

UPDATE `engine4_core_menuitems` SET `params` = '{"route":"user_support","module":"user","controller":"support","action":"index", "icon":"fi fi-rr-user-headset"}' WHERE `engine4_core_menuitems`.`name` = 'core_minimenu_supportinbox';

UPDATE `engine4_core_menuitems` SET `description` = "Browse what's new feed, post, and quick links
" WHERE `engine4_core_menuitems`.`name` = 'core_main_home';