1 -- This is rollback script #1 for the 3_1 Version of Ecomp Portal database called portal.
2 -- It upgrades the database from the 1911 version.
3 -- note to database admin: must set the mysql system variable called lower_case_table_names.
4 -- it can be set 3 different ways:
5 -- command-line options (cmd-line),
6 -- options valid in configuration files (option file), or
7 -- server system variables (system var).
8 -- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive.
9 -- -----------------------------------------------------------------------------------------------------------------
12 set foreign_key_checks=1;
17 ACTION = 'root.applicationsHome',
18 image_src = 'icon-building-home'
20 active_yn = 'Y' AND label = 'Home';
26 ACTION = 'root.appCatalog',
27 image_src= 'icon-apps-marketplace'
29 active_yn = 'Y' AND label = 'Application Catalog';
35 ACTION = 'root.widgetCatalog',
36 image_src= 'icon-apps-marketplace'
38 active_yn = 'Y' AND label = 'Widget Catalog';
43 ACTION = 'root.admins' ,
44 image_src= 'icon-star'
46 active_yn = 'Y' AND label = 'Admins';
51 ACTION = 'root.roles' ,
52 image_src= 'icon-user'
54 active_yn = 'Y' AND label = 'Roles';
60 ACTION = 'root.users',
61 image_src= 'icon-user'
63 active_yn = 'Y' AND label = 'Users';
69 ACTION = 'root.portalAdmins',
70 image_src= 'icon-settings'
72 active_yn = 'Y' AND label = 'Portal Admins';
78 ACTION = 'root.applications',
79 image_src= 'icon-add-widget'
81 active_yn = 'Y' AND label = 'Application Onboarding';
86 ACTION = 'root.widgetOnboarding',
87 image_src= 'icon-add-widget'
89 active_yn = 'Y' AND label = 'Widget Onboarding';
94 ACTION = 'root.functionalMenu',
95 image_src= 'icon-edit'
97 active_yn = 'Y' AND label = 'Edit Functional Menu';
103 ACTION = 'root.userNotifications',
104 image_src= 'icon-settings'
106 active_yn = 'Y' AND label = 'User Notifications';
112 ACTION = 'root.microserviceOnboarding',
113 image_src= 'icon-add-widget'
115 active_yn = 'Y' AND label = 'Microservice Onboarding';
122 ACTION = 'root.webAnalytics',
123 image_src= 'icon-misc-piechart'
125 active_yn = 'Y' AND label = 'Web Analytics';
131 ACTION = 'root.webAnlayticsSource',
132 image_src= 'icon-misc-piechart'
134 active_yn = 'Y' AND label = 'Web Analytics Onboarding';
139 ACTION = 'root.accountOnboarding',
140 image_src= 'icon-add-widget'
142 active_yn = 'Y' AND label = 'App Account Management';