use ecomp_sdk;

SET FOREIGN_KEY_CHECKS=0;

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

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

UPDATE fn_menu 
SET ACTION='v2/userProfile/post_search'
WHERE LABEL='Import from WEBPHONE';

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

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

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

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

UPDATE fn_menu 
SET ACTION='v2/admin/cache_admin'
WHERE LABEL='Cache Admin';

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

UPDATE fn_menu 
SET ACTION='v2/create' 
WHERE LABEL='Create Reports';

UPDATE fn_menu 
SET ACTION='v2/report-list' 
WHERE LABEL='All Reports';

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

UPDATE fn_menu 
SET `IMAGE_SRC`='icon ion-md-pie' 
WHERE  `LABEL`='Reports';

UPDATE fn_menu 
SET `IMAGE_SRC`='ion-md-person' 
WHERE  `LABEL`='Profile';

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

-- Added new update for fn_restricted_url -
insert into fn_restricted_url values ('v2','menu_home');

commit;