/**
 * SocialEngine
 *
 * @category   Application_Extensions
 * @package    Elpis
 * @copyright  Copyright 2006-2022 Webligo Developments
 * @license    http://www.socialengine.com/license/
 * @version    $Id: my.sql 2022-06-20
 */


INSERT IGNORE INTO `engine4_core_menuitems` (`name`, `module`, `label`, `plugin`, `params`, `menu`, `submenu`, `order`) VALUES
("core_admin_main_plugins_elpis", "elpis", "Elpis Theme", "", '{"route":"admin_default","module":"elpis","controller":"settings"}', "core_admin_main_plugins", "", 999),
("core_admin_main_elpis", "elpis", "Elpis Theme", "", '{"route":"admin_default","module":"elpis","controller":"settings"}', "core_admin_main", "", 999),
("elpis_admin_main_settings", "elpis", "Global Settings", "", '{"route":"admin_default","module":"elpis","controller":"settings"}', "elpis_admin_main", "", 1),
("elpis_admin_main_styling", "elpis", "Color Schemes", "", '{"route":"admin_default","module":"elpis","controller":"settings", "action":"styling"}', "elpis_admin_main", "", 2),
("elpis_admin_main_managefonts", "elpis", "Manage Fonts", "", '{"route":"admin_default","module":"elpis","controller":"settings", "action":"manage-fonts"}', "elpis_admin_main", "", 3);

DROP TABLE IF EXISTS `engine4_elpis_customthemes`;
CREATE TABLE IF NOT EXISTS `engine4_elpis_customthemes` (
  `customtheme_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(128) NOT NULL,
  `value` varchar(32) NOT NULL,
  `column_key` varchar(128) NOT NULL,
  `theme_id` int(11) NOT NULL,
  `default` TINYINT(1) NOT NULL DEFAULT "0" ,
  PRIMARY KEY (`customtheme_id`),
  UNIQUE KEY `UNIQUEKEY` (`column_key`,`theme_id`,`default`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1;

INSERT IGNORE INTO `engine4_elpis_customthemes` (`name`, `value`, `column_key`, `theme_id`, `default`) VALUES
("Theme - 1", "1", "theme_color", 1, 0),
("Theme - 1", "1", "custom_theme_color", 1, 0),
("Theme - 1", "#ffffff", "elpis_header_background_color", 1, 0),
("Theme - 1", "#ffffff", "elpis_mainmenu_background_color", 1, 0),
("Theme - 1", "#002646", "elpis_mainmenu_links_color", 1, 0),
("Theme - 1", "#ffffff", "elpis_mainmenu_links_hover_color", 1, 0),
("Theme - 1", "#2491EB", "elpis_mainmenu_links_hover_background_color", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_minimenu_links_color", 1, 0),
("Theme - 1", "#2491eb", "elpis_minimenu_links_background_color", 1, 0),
("Theme - 1", "#002646", "elpis_minimenu_signup_background_color", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_minimenu_signup_font_color", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_footer_background_color", 1, 0),
("Theme - 1", "#676767", "elpis_footer_font_color", 1, 0),
("Theme - 1", "#676767", "elpis_footer_links_color", 1, 0),
("Theme - 1", "#e4e4e4", "elpis_footer_border_color", 1, 0),
("Theme - 1", "#2491EB", "elpis_theme_color", 1, 0),
("Theme - 1", "#EFF4FB", "elpis_body_background_color", 1, 0),
("Theme - 1", "#111111", "elpis_font_color", 1, 0),
("Theme - 1", "#808D97", "elpis_font_color_light", 1, 0),
("Theme - 1", "#2491EB", "elpis_links_color", 1, 0),
("Theme - 1", "#2491EB", "elpis_links_hover_color", 1, 0),
("Theme - 1", "#1c2735", "elpis_headline_color", 1, 0),
("Theme - 1", "#e2e4e6", "elpis_border_color", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_box_background_color", 1, 0),
("Theme - 1", "#f2f2f2", "elpis_box_background_color_alt", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_input_background_color", 1, 0),
("Theme - 1", "#111111", "elpis_input_font_color", 1, 0),
("Theme - 1", "#e4e4e4", "elpis_input_border_color", 1, 0),
("Theme - 1", "#2491EB", "elpis_button_background_color", 1, 0),
("Theme - 1", "#59b4ff", "elpis_button_background_color_hover", 1, 0),
("Theme - 1", "#ffffff", "elpis_button_font_color", 1, 0),
("Theme - 1", "#2491eb", "elpis_button_border_color", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_button_font_color_hover", 1, 0),
("Theme - 1", "#59B4FF", "elpis_button_border_color_hover", 1, 0),
("Theme - 1", "#f2f2f2", "elpis_secondary_button_background_color", 1, 0),
("Theme - 1", "#e5e5e5", "elpis_secondary_button_background_color_hover", 1, 0),
("Theme - 1", "#212529", "elpis_secondary_button_font_color", 1, 0),
("Theme - 1", "#212529", "elpis_secondary_button_font_color_hover", 1, 0),
("Theme - 1", "#E4E6EB", "elpis_secondary_button_border_color", 1, 0),
("Theme - 1", "#d8dadf", "elpis_secondary_button_border_color_hover", 1, 0),
("Theme - 1", "#FFFFFF", "elpis_comments_background_color", 1, 0),
("Theme - 2", "2", "theme_color", 2, 0),
("Theme - 2", "2", "custom_theme_color", 2, 0),
("Theme - 2", "#ffffff", "elpis_header_background_color", 2, 0),
("Theme - 2", "#ffffff", "elpis_mainmenu_background_color", 2, 0),
("Theme - 2", "#002646", "elpis_mainmenu_links_color", 2, 0),
("Theme - 2", "#ffffff", "elpis_mainmenu_links_hover_color", 2, 0),
("Theme - 2", "#CC0821", "elpis_mainmenu_links_hover_background_color", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_minimenu_links_color", 2, 0),
("Theme - 2", "#CC0821", "elpis_minimenu_links_background_color", 2, 0),
("Theme - 2", "#002646", "elpis_minimenu_signup_background_color", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_minimenu_signup_font_color", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_footer_background_color", 2, 0),
("Theme - 2", "#676767", "elpis_footer_font_color", 2, 0),
("Theme - 2", "#676767", "elpis_footer_links_color", 2, 0),
("Theme - 2", "#e4e4e4", "elpis_footer_border_color", 2, 0),
("Theme - 2", "#CC0821", "elpis_theme_color", 2, 0),
("Theme - 2", "#EFF4FB", "elpis_body_background_color", 2, 0),
("Theme - 2", "#111111", "elpis_font_color", 2, 0),
("Theme - 2", "#808D97", "elpis_font_color_light", 2, 0),
("Theme - 2", "#CC0821", "elpis_links_color", 2, 0),
("Theme - 2", "#a9081c", "elpis_links_hover_color", 2, 0),
("Theme - 2", "#1c2735", "elpis_headline_color", 2, 0),
("Theme - 2", "#e2e4e6", "elpis_border_color", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_box_background_color", 2, 0),
("Theme - 2", "#f2f2f2", "elpis_box_background_color_alt", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_input_background_color", 2, 0),
("Theme - 2", "#111111", "elpis_input_font_color", 2, 0),
("Theme - 2", "#e4e4e4", "elpis_input_border_color", 2, 0),
("Theme - 2", "#CC0821", "elpis_button_background_color", 2, 0),
("Theme - 2", "#a9081c", "elpis_button_background_color_hover", 2, 0),
("Theme - 2", "#ffffff", "elpis_button_font_color", 2, 0),
("Theme - 2", "#CC0821", "elpis_button_border_color", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_button_font_color_hover", 2, 0),
("Theme - 2", "#A9081C", "elpis_button_border_color_hover", 2, 0),
("Theme - 2", "#f2f2f2", "elpis_secondary_button_background_color", 2, 0),
("Theme - 2", "#e5e5e5", "elpis_secondary_button_background_color_hover", 2, 0),
("Theme - 2", "#212529", "elpis_secondary_button_font_color", 2, 0),
("Theme - 2", "#212529", "elpis_secondary_button_font_color_hover", 2, 0),
("Theme - 2", "#F2F2F2", "elpis_secondary_button_border_color", 2, 0),
("Theme - 2", "#d8dadf", "elpis_secondary_button_border_color_hover", 2, 0),
("Theme - 2", "#FFFFFF", "elpis_comments_background_color", 2, 0),
("Theme - 3", "3", "theme_color", 3, 0),
("Theme - 3", "3", "custom_theme_color", 3, 0),
("Theme - 3", "#242526", "elpis_header_background_color", 3, 0),
("Theme - 3", "#242526", "elpis_mainmenu_background_color", 3, 0),
("Theme - 3", "#fff", "elpis_mainmenu_links_color", 3, 0),
("Theme - 3", "#fff", "elpis_mainmenu_links_hover_color", 3, 0),
("Theme - 3", "#2491EB", "elpis_mainmenu_links_hover_background_color", 3, 0),
("Theme - 3", "#DDDDDD", "elpis_minimenu_links_color", 3, 0),
("Theme - 3", "#2491eb", "elpis_minimenu_links_background_color", 3, 0),
("Theme - 3", "#2491eb", "elpis_minimenu_signup_background_color", 3, 0),
("Theme - 3", "#FFFFFF", "elpis_minimenu_signup_font_color", 3, 0),
("Theme - 3", "#151515", "elpis_footer_background_color", 3, 0),
("Theme - 3", "#FFFFFF", "elpis_footer_font_color", 3, 0),
("Theme - 3", "#999999", "elpis_footer_links_color", 3, 0),
("Theme - 3", "#151515", "elpis_footer_border_color", 3, 0),
("Theme - 3", "#2491eb", "elpis_theme_color", 3, 0),
("Theme - 3", "#18191a", "elpis_body_background_color", 3, 0),
("Theme - 3", "#DDDDDD", "elpis_font_color", 3, 0),
("Theme - 3", "#CCCCCC", "elpis_font_color_light", 3, 0),
("Theme - 3", "#2491EB", "elpis_links_color", 3, 0),
("Theme - 3", "#2491EB", "elpis_links_hover_color", 3, 0),
("Theme - 3", "#DDDDDD", "elpis_headline_color", 3, 0),
("Theme - 3", "#343434", "elpis_border_color", 3, 0),
("Theme - 3", "#242526", "elpis_box_background_color", 3, 0),
("Theme - 3", "#343536", "elpis_box_background_color_alt", 3, 0),
("Theme - 3", "#2f3132", "elpis_input_background_color", 3, 0),
("Theme - 3", "#DDDDDD", "elpis_input_font_color", 3, 0),
("Theme - 3", "#343434", "elpis_input_border_color", 3, 0),
("Theme - 3", "#2491eb", "elpis_button_background_color", 3, 0),
("Theme - 3", "#59b4ff", "elpis_button_background_color_hover", 3, 0),
("Theme - 3", "#FFFFFF", "elpis_button_font_color", 3, 0),
("Theme - 3", "#2491eb", "elpis_button_border_color", 3, 0),
("Theme - 3", "#FFFFFF", "elpis_button_font_color_hover", 3, 0),
("Theme - 3", "#59B4FF", "elpis_button_border_color_hover", 3, 0),
("Theme - 3", "#343536", "elpis_secondary_button_background_color", 3, 0),
("Theme - 3", "#4c4d4e", "elpis_secondary_button_background_color_hover", 3, 0),
("Theme - 3", "#e4e6eb", "elpis_secondary_button_font_color", 3, 0),
("Theme - 3", "#e4e6eb", "elpis_secondary_button_font_color_hover", 3, 0),
("Theme - 3", "#343536", "elpis_secondary_button_border_color", 3, 0),
("Theme - 3", "#4c4d4e", "elpis_secondary_button_border_color_hover", 3, 0),
("Theme - 3", "#4c4d4e", "elpis_comments_background_color", 3, 0);

UPDATE `engine4_core_menuitems` SET `params` = '{"icon":"far fa-bell"}' WHERE `engine4_core_menuitems`.`name` = "core_mini_update";
UPDATE `engine4_core_menuitems` SET `params` = '' WHERE `engine4_core_menuitems`.`name` = "core_mini_profile";
UPDATE `engine4_core_menuitems` SET `params` = '{"icon":"fa-sign-in-alt"}' WHERE `engine4_core_menuitems`.`name` = "core_mini_auth";
UPDATE `engine4_core_menuitems` SET `params` = '{"icon":"fa-user-plus"}' WHERE `engine4_core_menuitems`.`name` = "core_mini_signup";
UPDATE `engine4_core_menuitems` SET `params` = '{"icon":"far fa-envelope"}' WHERE `engine4_core_menuitems`.`name` = "core_mini_messages";