diff options
Diffstat (limited to 'ecomp-portal-DB-os')
-rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql | 145 | ||||
-rw-r--r-- | ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql | 144 |
2 files changed, 289 insertions, 0 deletions
diff --git a/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql b/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql new file mode 100644 index 00000000..a2483f23 --- /dev/null +++ b/ecomp-portal-DB-os/PortalMySql_3_1_Add_1.sql @@ -0,0 +1,145 @@ +-- --------------------------------------------------------------------------------------------------------------- +-- This is add 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 = '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;
\ No newline at end of file diff --git a/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql b/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql new file mode 100644 index 00000000..98a06994 --- /dev/null +++ b/ecomp-portal-DB-os/PortalMySql_3_1_Rollback_1.sql @@ -0,0 +1,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;
\ No newline at end of file |