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
139
140
141
142
143
144
|
-- This is rollback script #1 for the 3_1 Version of Ecomp Portal database called portal.
-- It upgrades the database from the 1911 version.
-- note to database admin: must set the mysql system variable called lower_case_table_names.
-- it can be set 3 different ways:
-- command-line options (cmd-line),
-- options valid in configuration files (option file), or
-- server system variables (system var).
-- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive.
-- -----------------------------------------------------------------------------------------------------------------
use portal;
set foreign_key_checks=1;
UPDATE
fn_menu
SET
ACTION = 'root.applicationsHome',
image_src = 'icon-building-home'
WHERE
active_yn = 'Y' AND label = 'Home';
UPDATE
fn_menu
SET
ACTION = 'root.appCatalog',
image_src= 'icon-apps-marketplace'
WHERE
active_yn = 'Y' AND label = 'Application Catalog';
UPDATE
fn_menu
SET
ACTION = 'root.widgetCatalog',
image_src= 'icon-apps-marketplace'
WHERE
active_yn = 'Y' AND label = 'Widget Catalog';
UPDATE
fn_menu
SET
ACTION = 'root.admins' ,
image_src= 'icon-star'
WHERE
active_yn = 'Y' AND label = 'Admins';
UPDATE
fn_menu
SET
ACTION = 'root.roles' ,
image_src= 'icon-user'
WHERE
active_yn = 'Y' AND label = 'Roles';
UPDATE
fn_menu
SET
ACTION = 'root.users',
image_src= 'icon-user'
WHERE
active_yn = 'Y' AND label = 'Users';
UPDATE
fn_menu
SET
ACTION = 'root.portalAdmins',
image_src= 'icon-settings'
WHERE
active_yn = 'Y' AND label = 'Portal Admins';
UPDATE
fn_menu
SET
ACTION = 'root.applications',
image_src= 'icon-add-widget'
WHERE
active_yn = 'Y' AND label = 'Application Onboarding';
UPDATE
fn_menu
SET
ACTION = 'root.widgetOnboarding',
image_src= 'icon-add-widget'
WHERE
active_yn = 'Y' AND label = 'Widget Onboarding';
UPDATE
fn_menu
SET
ACTION = 'root.functionalMenu',
image_src= 'icon-edit'
WHERE
active_yn = 'Y' AND label = 'Edit Functional Menu';
UPDATE
fn_menu
SET
ACTION = 'root.userNotifications',
image_src= 'icon-settings'
WHERE
active_yn = 'Y' AND label = 'User Notifications';
UPDATE
fn_menu
SET
ACTION = 'root.microserviceOnboarding',
image_src= 'icon-add-widget'
WHERE
active_yn = 'Y' AND label = 'Microservice Onboarding';
UPDATE
fn_menu
SET
ACTION = 'root.webAnalytics',
image_src= 'icon-misc-piechart'
WHERE
active_yn = 'Y' AND label = 'Web Analytics';
UPDATE
fn_menu
SET
ACTION = 'root.webAnlayticsSource',
image_src= 'icon-misc-piechart'
WHERE
active_yn = 'Y' AND label = 'Web Analytics Onboarding';
UPDATE
fn_menu
SET
ACTION = 'root.accountOnboarding',
image_src= 'icon-add-widget'
WHERE
active_yn = 'Y' AND label = 'App Account Management';
commit;
|
