UPDATE acm_group_role_menu SET STATUS = 1 WHERE (menus_id  = 5 OR menus_id = 38  OR menus_id = 125  OR menus_id = 127  OR menus_id = 128);
UPDATE acm_group_role_menu SET STATUS = 0 WHERE (menus_id  = 36 OR menus_id  = 39  OR  menus_id  = 40 OR  menus_id  = 41 OR  menus_id  = 42 OR  menus_id  = 339 OR  menus_id  = 372
OR  menus_id  = 387 OR  menus_id  = 392 OR  menus_id  = 131 OR  menus_id  = 132 OR  menus_id  = 133 OR  menus_id  = 134 OR  menus_id  = 135 OR  menus_id  = 205 
OR  menus_id  = 207 OR  menus_id  = 313 OR  menus_id  = 341 OR  menus_id  = 391
) ;

UPDATE acm_group_role_association SET component_name = "roster/checkInOut" WHERE menu_id = 128 AND group_role_id = 10; 
UPDATE acm_group_role_association SET component_name = "roster/rosterCPL" WHERE menu_id = 128 AND group_role_id = 16; 
UPDATE acm_group_role_association SET component_name = "roster/rosterCPL" WHERE menu_id = 128 AND group_role_id = 22;
UPDATE acm_group_role_association SET component_name = "roster/rosterCPL" WHERE menu_id = 128 AND group_role_id = 17;
UPDATE acm_group_role_association SET component_name = "roster/shiftAllocation" WHERE menu_id = 127 AND group_role_id = 16; 
UPDATE acm_group_role_association SET component_name = "roster/shiftcalender" WHERE menu_id = 125 AND group_role_id = 22; 
UPDATE acm_group_role_association SET component_name = "roster/shiftcalender" WHERE menu_id = 125 AND group_role_id = 17; 
UPDATE acm_group_role_association SET component_name = "roster/shiftsetup" WHERE menu_id = 130 AND group_role_id = 22; 
UPDATE acm_group_role_association SET component_name = "roster/shiftsetup" WHERE menu_id = 130 AND group_role_id = 17; 
UPDATE acm_group_role_association SET component_name = "roster/RequestLM" WHERE menu_id = 134 AND group_role_id = 16; 

ALTER TABLE proll_client_weekends
ADD COLUMN `wday_color` VARCHAR(50) NULL DEFAULT '#FB5F5F' ,
ADD COLUMN `half_day_color` VARCHAR(50) NULL DEFAULT '#3080EA';
