summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql
blob: 1db43db88aecbeef49ee8553344c743730867ed5 (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
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;