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
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
|
-- --------------------------------------------------------------------------------------------
-- This is the common default data for 3.1.0 Version of Portal database called portal
use portal;
set foreign_key_checks=1;
UPDATE
fn_menu
SET
ACTION = 'applicationsHome',
image_src = 'home'
WHERE
active_yn = 'Y' AND label = 'Home';
UPDATE
fn_menu
SET
ACTION = 'appCatalog',
image_src= 'apps'
WHERE
active_yn = 'Y' AND label = 'Application Catalog';
UPDATE
fn_menu
SET
ACTION = 'widgetCatalog',
image_src= 'apps'
WHERE
active_yn = 'Y' AND label = 'Widget Catalog';
UPDATE
fn_menu
SET
ACTION = 'admins' ,
image_src= 'star'
WHERE
active_yn = 'Y' AND label = 'Admins';
UPDATE
fn_menu
SET
ACTION = 'roles' ,
image_src= 'person'
WHERE
active_yn = 'Y' AND label = 'Roles';
UPDATE
fn_menu
SET
ACTION = 'users',
image_src= 'person'
WHERE
active_yn = 'Y' AND label = 'Users';
UPDATE
fn_menu
SET
ACTION = 'portalAdmins',
image_src= 'settings'
WHERE
active_yn = 'Y' AND label = 'Portal Admins';
UPDATE
fn_menu
SET
ACTION = 'applications',
image_src= 'filing'
WHERE
active_yn = 'Y' AND label = 'Application Onboarding';
UPDATE
fn_menu
SET
ACTION = 'widgetOnboarding',
image_src= 'filing'
WHERE
active_yn = 'Y' AND label = 'Widget Onboarding';
UPDATE
fn_menu
SET
ACTION = 'functionalMenu',
image_src= 'menu'
WHERE
active_yn = 'Y' AND label = 'Edit Functional Menu';
UPDATE
fn_menu
SET
ACTION = 'userNotifications',
image_src= 'settings'
WHERE
active_yn = 'Y' AND label = 'User Notifications';
UPDATE
fn_menu
SET
ACTION = 'microserviceOnboarding',
image_src= 'filing'
WHERE
active_yn = 'Y' AND label = 'Microservice Onboarding';
UPDATE
fn_menu
SET
ACTION = 'webAnalytics',
image_src= 'pie'
WHERE
active_yn = 'Y' AND label = 'Web Analytics';
UPDATE
fn_menu
SET
ACTION = 'webAnlayticsSource',
image_src= 'pie'
WHERE
active_yn = 'Y' AND label = 'Web Analytics Onboarding';
UPDATE
fn_menu
SET
ACTION = 'accountOnboarding',
image_src= 'filing'
WHERE
active_yn = 'Y' AND label = 'App Account Management';
commit;
|
