use ecomp_sdk;

SET FOREIGN_KEY_CHECKS=0;

UPDATE fn_menu 
SET ACTION='welcome'
WHERE LABEL='Home';

UPDATE fn_menu 
SET ACTION='userProfile#/self_profile'
WHERE LABEL='Self';

UPDATE fn_menu 
SET ACTION='admin#/role_function_list'
WHERE LABEL='Role Functions';


UPDATE fn_menu 
SET ACTION='admin#/usage_list'
WHERE LABEL='Usage';


UPDATE fn_menu 
SET ACTION='admin#/admin'
WHERE LABEL='Roles';

UPDATE fn_menu 
SET ACTION='admin#/jcs_admin'
WHERE LABEL='Cache Admin';

UPDATE fn_menu 
SET ACTION='userProfile'
WHERE LABEL='Search';

UPDATE fn_menu 
SET ACTION='admin#/admin_menu_edit'
WHERE LABEL='Menus';

-- fn_menu - update menu icon
UPDATE fn_menu 
SET `IMAGE_SRC`='icon-building-home' 
WHERE  `LABEL`='Home';

UPDATE fn_menu 
SET `IMAGE_SRC`='icon-misc-piechart' 
WHERE  `LABEL`='Reports';

UPDATE fn_menu 
SET `IMAGE_SRC`='icon-people-oneperson' 
WHERE  `LABEL`='Profile';

UPDATE fn_menu 
SET `IMAGE_SRC`='icon-content-star' 
WHERE  `LABEL`='Admin';

delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2';

commit;