summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql
blob: 4139a7a5dfd4eec8fe8d4f2bcec62c5c3401e823 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
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';


-- 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;