1 -- ---------------------------------------------------------------------------------------------------------------
2 -- This is add script #1 for the 3_1 Version of Ecomp Portal database called portal.
3 -- It upgrades the database from the 1911 version.
4 -- note to database admin: must set the mysql system variable called lower_case_table_names.
5 -- it can be set 3 different ways:
6 -- command-line options (cmd-line),
7 -- options valid in configuration files (option file), or
8 -- server system variables (system var).
9 -- it needs to be set to 1, then table names are stored in lowercase on disk and comparisons are not case sensitive.
10 -- -----------------------------------------------------------------------------------------------------------------
13 set foreign_key_checks=1;
18 ACTION = 'applicationsHome',
21 active_yn = 'Y' AND label = 'Home';
27 ACTION = 'appCatalog',
30 active_yn = 'Y' AND label = 'Application Catalog';
36 ACTION = 'widgetCatalog',
39 active_yn = 'Y' AND label = 'Widget Catalog';
47 active_yn = 'Y' AND label = 'Admins';
55 active_yn = 'Y' AND label = 'Roles';
64 active_yn = 'Y' AND label = 'Users';
70 ACTION = 'portalAdmins',
73 active_yn = 'Y' AND label = 'Portal Admins';
79 ACTION = 'applications',
82 active_yn = 'Y' AND label = 'Application Onboarding';
87 ACTION = 'widgetOnboarding',
90 active_yn = 'Y' AND label = 'Widget Onboarding';
95 ACTION = 'functionalMenu',
98 active_yn = 'Y' AND label = 'Edit Functional Menu';
104 ACTION = 'userNotifications',
105 image_src= 'settings'
107 active_yn = 'Y' AND label = 'User Notifications';
113 ACTION = 'microserviceOnboarding',
116 active_yn = 'Y' AND label = 'Microservice Onboarding';
123 ACTION = 'webAnalytics',
126 active_yn = 'Y' AND label = 'Web Analytics';
132 ACTION = 'webAnlayticsSource',
135 active_yn = 'Y' AND label = 'Web Analytics Onboarding';
140 ACTION = 'accountOnboarding',
143 active_yn = 'Y' AND label = 'App Account Management';