-- Adding new columns to theme table
ALTER TABLE `ohrm_theme` ADD `power_logo` BLOB ,
ADD `footer_images` varchar(5) NOT NULL ,
ADD `banner_placement` varchar(6) NOT NULL ,
ADD `banner_width`  INT(4) ;

UPDATE `ohrm_theme` SET  `colors`=  REPLACE(`colors`, '"}', '","breadcrumbBorder": "f9f9f9","menuLevelHighlightFont": "ffffff","menuLevel2HighlightFont": "ffffff","menuLeftHighlightFont": "ffffff"}' );

UPDATE `ohrm_theme` SET  `login_image_colors`=  REPLACE(`login_image_colors`, '"}', '","loginPanelHeadingFontColor":"544B3C"}' ) ;

UPDATE `ohrm_theme` SET `power_logo` = '[encoded data, 4636 characters]',`footer_images`  ='show',`banner_placement`='center',`banner_width`='33' ;

-- REPLACE INTO `ohrm_theme` (`theme_id`, `name`, `short_name`, `is_default`, `colors`, `login_image_colors`, `login_banner`, `client_logo`,`power_logo`,`footer_images`,`banner_placement`,`banner_width`) VALUES
-- ('1', 'Default', 'default', true, '{"menuTopBackground":"f3f3f3","menuTopFont":"5d5d5d","menuTopHighlight":"f28c38","menuLevel2Background":"f28c38","menuLevel2Font":"333333","menuLevel2Highlight":"555657","menuLevel3Background":"555657","menuLevel3Font":"ababab","menuLevel3Highlight":"555657","menuLeftBackground":"f28c38","menuLeftFont":"ffffff","menuLeftHighlight":"ce6d1d","bodyTextFont":"5d5d5d","boxHeaderBackground":"f3f3f3","boxHeaderFont":"5d5d5d","boxBodyBackground":"f7f6f6","tableHeaderBackground":"f28c38","tableHeaderFont":"fff","tableRowOddBackground":"eaeaea","tableRowEvenBackground":"ffffff","tableRowHoverBackground":"cccccc","tableRowFont":"5d5d5d","formLabelFont":"5d5d5d","formInputBackground":"ffffff","formInputBorder":"d2d1d1","formInputFont":"5d5d5d","buttonCommonRegular":"33ac3f","buttonCommonHover":"086912","buttonCancelRegular":"848484","buttonCancelHover":"4d4d4d","buttonDeleteRegular":"aa4935","buttonDeleteHover":"782918","buttonResetRegular":"848484","buttonResetHover":"4d4d4d","modalHeaderBackground":"f28c38","modalBodyBackground":"f7f6f6","modalFooterBackground":"f7f6f6","paginationLinkCurrentBackground":"33ac3f","paginationLinkHoverBackground":"eaeaea","paginationLinkFont":"5d5d5d","dashboardBorderBackground": "F28C38","menuLevel3HighlightFont":"ffffff", "pimTabLine":"adff2f","loginPanelTextFont": "33ac2f",
--   "logInPanelHeadingFont": "548b2c",
-- "breadcrumbBackground": "d4d4d4",
-- "breadcrumbFont": "555657",
-- "breadcrumbBorder": "f9f9f9","menuLevelHighlightFont": "ffffff",
-- "menuLevel2HighlightFont": "ffffff",
-- "menuLeftHighlightFont": "ffffff"}',
-- '{"inner":"ff9300","outer":"ff5f00","loginPanelHeadingFontColor":"544B3C"}',
-- '[encoded data, 17912 characters]',
-- '[encoded data, 12260 characters]',
--
-- '[encoded data, 4636 characters]','show','center','33');
