/**
 * SocialEngine
 *
 * @category   Application_Extensions
 * @package    Sunshine
 * @copyright  Copyright 2006-2021 Webligo Developments
 * @license    http://www.socialengine.com/license/
 */

/**
 * @category   Application_Extensions
 * @package    Sunshine
 * @copyright  Copyright 2006-2021 Webligo Developments
 * @license    http://www.socialengine.com/license/
 */


INSERT IGNORE INTO `engine4_core_modules` (`name`, `title`, `description`, `version`, `enabled`, `type`) VALUES  ('sunshine', 'Sunshine', 'Sunshine Theme Module', '4.0.0', 1, 'extra') ;

INSERT IGNORE INTO `engine4_core_menuitems` (`name`, `module`, `label`, `plugin`, `params`, `menu`, `submenu`, `order`) VALUES
("core_admin_main_sunshine", "sunshine", "Sunshine Theme", "", '{"route":"admin_default","module":"sunshine","controller":"settings"}', "core_admin_main", "", 999),
("sunshine_admin_main_settings", "sunshine", "Global Settings", "", '{"route":"admin_default","module":"sunshine","controller":"settings"}', "sunshine_admin_main", "", 1),
("sunshine_admin_main_managefonts", "sunshine", "Manage Fonts", "", '{"route":"admin_default","module":"sunshine","controller":"settings", "action":"manage-fonts"}', "sunshine_admin_main", "", 2),
("sunshine_admin_main_styling", "sunshine", "Color Schemes", "", '{"route":"admin_default","module":"sunshine","controller":"settings", "action":"styling"}', "sunshine_admin_main", "", 3);

DROP TABLE IF EXISTS `engine4_sunshine_customthemes`;
CREATE TABLE IF NOT EXISTS `engine4_sunshine_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_sunshine_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", "#fb8c0b", "sunshine_header_background_color", 1, 0),
("Theme - 1", "#ffffff", "sunshine_mainmenu_background_color", 1, 0),
("Theme - 1", "#060606", "sunshine_mainmenu_links_color", 1, 0),
("Theme - 1", "#060606", "sunshine_mainmenu_links_hover_color", 1, 0),
("Theme - 1", "#f5dfc5", "sunshine_mainmenu_links_hover_background_color", 1, 0),
("Theme - 1", "#000000", "sunshine_menu_tip_color", 1, 0),
("Theme - 1", "#FFFFFF", "sunshine_minimenu_links_color", 1, 0),
("Theme - 1", "#e7e7e6", "sunshine_footer_background_color", 1, 0),
("Theme - 1", "#393838", "sunshine_footer_font_color", 1, 0),
("Theme - 1", "#393838", "sunshine_footer_links_color", 1, 0),
("Theme - 1", "#E4E4E4", "sunshine_footer_border_color", 1, 0),
("Theme - 1", "#fb8c0b", "sunshine_theme_color", 1, 0),
("Theme - 1", "#f2f2f2", "sunshine_body_background_color", 1, 0),
("Theme - 1", "#161616", "sunshine_font_color", 1, 0),
("Theme - 1", "#808D97", "sunshine_font_color_light", 1, 0),
("Theme - 1", "#fb8c0b", "sunshine_links_color", 1, 0),
("Theme - 1", "#F2870B", "sunshine_links_hover_color", 1, 0),
("Theme - 1", "#111111", "sunshine_headline_color", 1, 0),
("Theme - 1", "#E2E4E6", "sunshine_border_color", 1, 0),
("Theme - 1", "#FFFFFF", "sunshine_box_background_color", 1, 0),
("Theme - 1", "#F1F1F1", "sunshine_box_background_alt_color", 1, 0),
("Theme - 1", "#455B6B", "sunshine_form_label_color", 1, 0),
("Theme - 1", "#ffffff", "sunshine_input_background_color", 1, 0),
("Theme - 1", "#868686", "sunshine_input_font_color", 1, 0),
("Theme - 1", "#dcdcdc", "sunshine_input_border_color", 1, 0),
("Theme - 1", "#fb8c0b", "sunshine_button_background_color", 1, 0),
("Theme - 1", "#F2870B", "sunshine_button_background_color_hover", 1, 0),
("Theme - 1", "#ffffff", "sunshine_button_font_color", 1, 0),
("Theme - 1", "#FFFFFF", "sunshine_button_font_color_hover", 1, 0),
("Theme - 1", "#fb8c0b", "sunshine_button_border_color", 1, 0),
("Theme - 1", "#F2870B", "sunshine_button_border_color_hover", 1, 0),
("Theme - 1", "#f2f2f2", "sunshine_secondary_button_background_color", 1, 0),
("Theme - 1", "#e5e5e5", "sunshine_secondary_button_background_color_hover", 1, 0),
("Theme - 1", "#212529", "sunshine_secondary_button_font_color", 1, 0),
("Theme - 1", "#212529", "sunshine_secondary_button_font_color_hover", 1, 0),
("Theme - 1", "#E4E6EB", "sunshine_secondary_button_border_color", 1, 0),
("Theme - 1", "#d8dadf", "sunshine_secondary_button_border_color_hover", 1, 0),
("Theme - 1", "#f7f7f7", "sunshine_comments_background_color", 1, 0),
("Theme - 2", "2", "theme_color", 2, 0),
("Theme - 2", "2", "custom_theme_color", 2, 0),
("Theme - 2", "#CC0821", "sunshine_header_background_color", 2, 0),
("Theme - 2", "#ffffff", "sunshine_mainmenu_background_color", 2, 0),
("Theme - 2", "#060606", "sunshine_mainmenu_links_color", 2, 0),
("Theme - 2", "#060606", "sunshine_mainmenu_links_hover_color", 2, 0),
("Theme - 2", "#f9c4cb", "sunshine_mainmenu_links_hover_background_color", 2, 0),
("Theme - 2", "#000000", "sunshine_menu_tip_color", 2, 0),
("Theme - 2", "#FFFFFF", "sunshine_minimenu_links_color", 2, 0),
("Theme - 2", "#e7e7e6", "sunshine_footer_background_color", 2, 0),
("Theme - 2", "#393838", "sunshine_footer_font_color", 2, 0),
("Theme - 2", "#393838", "sunshine_footer_links_color", 2, 0),
("Theme - 2", "#E4E4E4", "sunshine_footer_border_color", 2, 0),
("Theme - 2", "#CC0821", "sunshine_theme_color", 2, 0),
("Theme - 2", "#f2f2f2", "sunshine_body_background_color", 2, 0),
("Theme - 2", "#161616", "sunshine_font_color", 2, 0),
("Theme - 2", "#808D97", "sunshine_font_color_light", 2, 0),
("Theme - 2", "#CC0821", "sunshine_links_color", 2, 0),
("Theme - 2", "#dd102a", "sunshine_links_hover_color", 2, 0),
("Theme - 2", "#111111", "sunshine_headline_color", 2, 0),
("Theme - 2", "#E2E4E6", "sunshine_border_color", 2, 0),
("Theme - 2", "#FFFFFF", "sunshine_box_background_color", 2, 0),
("Theme - 2", "#F1F1F1", "sunshine_box_background_alt_color", 2, 0),
("Theme - 2", "#455B6B", "sunshine_form_label_color", 2, 0),
("Theme - 2", "#ffffff", "sunshine_input_background_color", 2, 0),
("Theme - 2", "#868686", "sunshine_input_font_color", 2, 0),
("Theme - 2", "#dcdcdc", "sunshine_input_border_color", 2, 0),
("Theme - 2", "#CC0821", "sunshine_button_background_color", 2, 0),
("Theme - 2", "#dd102a", "sunshine_button_background_color_hover", 2, 0),
("Theme - 2", "#ffffff", "sunshine_button_font_color", 2, 0),
("Theme - 2", "#FFFFFF", "sunshine_button_font_color_hover", 2, 0),
("Theme - 2", "#CC0821", "sunshine_button_border_color", 2, 0),
("Theme - 2", "#dd102a", "sunshine_button_border_color_hover", 2, 0),
("Theme - 2", "#f2f2f2", "sunshine_secondary_button_background_color", 2, 0),
("Theme - 2", "#e5e5e5", "sunshine_secondary_button_background_color_hover", 2, 0),
("Theme - 2", "#212529", "sunshine_secondary_button_font_color", 2, 0),
("Theme - 2", "#212529", "sunshine_secondary_button_font_color_hover", 2, 0),
("Theme - 2", "#E4E6EB", "sunshine_secondary_button_border_color", 2, 0),
("Theme - 2", "#d8dadf", "sunshine_secondary_button_border_color_hover", 2, 0),
("Theme - 2", "#f7f7f7", "sunshine_comments_background_color", 2, 0),
("Theme - 3", "3", "theme_color", 3, 0),
("Theme - 3", "3", "custom_theme_color", 3, 0),
("Theme - 3", "#2f2f2f", "sunshine_header_background_color", 3, 0),
("Theme - 3", "#0D0D0D", "sunshine_mainmenu_background_color", 3, 0),
("Theme - 3", "#ffffff", "sunshine_mainmenu_links_color", 3, 0),
("Theme - 3", "#ffffff", "sunshine_mainmenu_links_hover_color", 3, 0),
("Theme - 3", "#2F2F2F", "sunshine_mainmenu_links_hover_background_color", 3, 0),
("Theme - 3", "#222222", "sunshine_menu_tip_color", 3, 0),
("Theme - 3", "#DDDDDD", "sunshine_minimenu_links_color", 3, 0),
("Theme - 3", "#151515", "sunshine_footer_background_color", 3, 0),
("Theme - 3", "#FFFFFF", "sunshine_footer_font_color", 3, 0),
("Theme - 3", "#999999", "sunshine_footer_links_color", 3, 0),
("Theme - 3", "#151515", "sunshine_footer_border_color", 3, 0),
("Theme - 3", "#fb8c0b", "sunshine_theme_color", 3, 0),
("Theme - 3", "#222222", "sunshine_body_background_color", 3, 0),
("Theme - 3", "#DDDDDD", "sunshine_font_color", 3, 0),
("Theme - 3", "#CCCCCC", "sunshine_font_color_light", 3, 0),
("Theme - 3", "#fb8c0b", "sunshine_links_color", 3, 0),
("Theme - 3", "#f9941f", "sunshine_links_hover_color", 3, 0),
("Theme - 3", "#DDDDDD", "sunshine_headline_color", 3, 0),
("Theme - 3", "#383838", "sunshine_border_color", 3, 0),
("Theme - 3", "#2F2F2F", "sunshine_box_background_color", 3, 0),
("Theme - 3", "#4C4C4C", "sunshine_box_background_alt_color", 3, 0),
("Theme - 3", "#DDDDDD", "sunshine_form_label_color", 3, 0),
("Theme - 3", "#4C4C4C", "sunshine_input_background_color", 3, 0),
("Theme - 3", "#DDDDDD", "sunshine_input_font_color", 3, 0),
("Theme - 3", "#666666", "sunshine_input_border_color", 3, 0),
("Theme - 3", "#fb8c0b", "sunshine_button_background_color", 3, 0),
("Theme - 3", "#f9941f", "sunshine_button_background_color_hover", 3, 0),
("Theme - 3", "#FFFFFF", "sunshine_button_font_color", 3, 0),
("Theme - 3", "#FFFFFF", "sunshine_button_font_color_hover", 3, 0),
("Theme - 3", "#fb8c0b", "sunshine_button_border_color", 3, 0),
("Theme - 3", "#f9941f", "sunshine_button_border_color_hover", 3, 0),
("Theme - 3", "#343536", "sunshine_secondary_button_background_color", 3, 0),
("Theme - 3", "#4c4d4e", "sunshine_secondary_button_background_color_hover", 3, 0),
("Theme - 3", "#e4e6eb", "sunshine_secondary_button_font_color", 3, 0),
("Theme - 3", "#dbdbdb", "sunshine_secondary_button_font_color_hover", 3, 0),
("Theme - 3", "#5c5c5c", "sunshine_secondary_button_border_color", 3, 0),
("Theme - 3", "#FDFDFD", "sunshine_secondary_button_border_color_hover", 3, 0),
("Theme - 3", "#4C4C4C", "sunshine_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";