summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-os/db-scripts
diff options
context:
space:
mode:
Diffstat (limited to 'ecomp-sdk/epsdk-app-os/db-scripts')
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1707_OS.sql12
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1710_OS.sql12
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1707_OS.sql39
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1710_OS.sql39
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Rollback_1707_to_1610.2_OS.sql159
-rw-r--r--ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Upgrade_1610.2_to_1707_OS.sql162
6 files changed, 0 insertions, 423 deletions
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1707_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1707_OS.sql
deleted file mode 100644
index 1b1ce059..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1707_OS.sql
+++ /dev/null
@@ -1,12 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This script adds tables for the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
--- The DDL 1707 COMMON script must be executed first!
--- ---------------------------------------------------------------------------------------------------------------
-
-SET FOREIGN_KEY_CHECKS=1;
-
-USE ecomp_sdk;
-
--- No additional tables required at this time
-
-commit;
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1710_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1710_OS.sql
deleted file mode 100644
index 1b1ce059..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDDLMySql_1710_OS.sql
+++ /dev/null
@@ -1,12 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This script adds tables for the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
--- The DDL 1707 COMMON script must be executed first!
--- ---------------------------------------------------------------------------------------------------------------
-
-SET FOREIGN_KEY_CHECKS=1;
-
-USE ecomp_sdk;
-
--- No additional tables required at this time
-
-commit;
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1707_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1707_OS.sql
deleted file mode 100644
index 1c4a926a..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1707_OS.sql
+++ /dev/null
@@ -1,39 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This script populates tables in the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
--- The DML 1707 COMMON script must be executed first!
--- ---------------------------------------------------------------------------------------------------------------
-
-SET FOREIGN_KEY_CHECKS=1;
-USE ecomp_sdk;
-
--- fn_menu
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (1, 'Root', NULL, 10, NULL, 'menu_home', 'N', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); -- we need even though it's inactive
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (5000, 'Sample Pages', 1, 30, 'sample.htm', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-documents-book');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (2, 'Home', 1, 10, 'welcome.htm', 'menu_home', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-building-home');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (8, 'Reports', 1, 40, 'report.htm', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-misc-piechart');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (9, 'Profile', 1, 90, 'userProfile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-people-oneperson');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (10, 'Admin', 1, 110, 'role_list.htm', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-content-star');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (84, 'All Reports', 8, 50, 'report', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/reports.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) values (87, 'Create Reports', 8, 120, 'report#/report_wizard', 'menu_reports', 'Y', NULL, 'r_action=report.create', NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) values (88, 'Sample Dashboard', 8, 130, 'report_dashboard', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (89, 'Import', 8, 140, 'report#/report_import', 'menu_reports', 'N', null, null, null, null, 'APP', 'N', null);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (94, 'Self', 9, 40,'userProfile#/self_profile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/profile.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (101, 'Roles', 10, 20, 'admin#/admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (102, 'Role Functions', 10, 30, 'admin#/role_function_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (105, 'Cache Admin', 10, 40, 'admin#/jcs_admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/cache.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (108, 'Usage', 10, 80, 'admin#/usage_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (121, 'Collaboration', 5000, 100, 'samplePage#/collaborate_list', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/bubble.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (930, 'Search', 9, 15, 'userProfile', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/search_profile.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150022, 'Menus', 10, 60, 'admin#/admin_menu_edit', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150038,'Notebook',5000,135,'samplePage#/notebook','menu_sample','Y',NULL,NULL,NULL,NULL,'APP','N',NULL);
-
--- fn_user
-Insert into fn_user (USER_ID,ORG_ID,MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS) values (1,null,null,'Demo',null,'User',null,null,null,'demo@email.com',null,null,null,'demo',null,'demo','demo',str_to_date('24-OCT-16','%d-%M-%Y'),'Y',null,str_to_date('17-OCT-16','%d-%M-%Y'),1,str_to_date('24-OCT-16','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
-
--- fn_app
-Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_URL,APP_ALTERNATE_URL,APP_REST_ENDPOINT,ML_APP_NAME,ML_APP_ADMIN_ID,MOTS_ID,APP_PASSWORD,OPEN,ENABLED,THUMBNAIL,APP_USERNAME,UEB_KEY,UEB_SECRET,UEB_TOPIC_NAME) VALUES (1,'Default',null,'Some Default Description','Some Default Note',null,null,null,'ECPP','?','1','okYTaDrhzibcbGVq5mjkVQ==','N','N',null,'Default',null,null,'ECOMP-PORTAL-INBOX');
-
--- fn_user_role
-Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1);
-
-commit;
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1710_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1710_OS.sql
deleted file mode 100644
index 460da4b2..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkDMLMySql_1710_OS.sql
+++ /dev/null
@@ -1,39 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This script populates tables in the 1707 OPEN-SOURCE version of the ECOMP SDK application database.
--- The DML 1707 COMMON script must be executed first!
--- ---------------------------------------------------------------------------------------------------------------
-
-SET FOREIGN_KEY_CHECKS=1;
-USE ecomp_sdk;
-
--- fn_menu
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (1, 'Root', NULL, 10, NULL, 'menu_home', 'N', NULL, NULL, NULL, NULL, 'APP', 'N', NULL); -- we need even though it's inactive
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (5000, 'Sample Pages', 1, 30, 'sample.htm', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-documents-book');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (2, 'Home', 1, 10, 'welcome.htm', 'menu_home', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-building-home');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (8, 'Reports', 1, 40, 'report.htm', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-misc-piechart');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (9, 'Profile', 1, 90, 'userProfile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-people-oneperson');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (10, 'Admin', 1, 110, 'role_list.htm', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-content-star');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (84, 'All Reports', 8, 50, 'report', 'menu_reports', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/reports.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) values (87, 'Create Reports', 8, 120, 'report#/report_wizard', 'menu_reports', 'Y', NULL, 'r_action=report.create', NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) values (88, 'Sample Dashboard', 8, 130, 'report_dashboard', 'menu_reports', 'N', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (89, 'Import', 8, 140, 'report#/report_import', 'menu_reports', 'N', null, null, null, null, 'APP', 'N', null);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (94, 'Self', 9, 40,'userProfile#/self_profile', 'menu_profile', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/profile.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (101, 'Roles', 10, 20, 'admin#/admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (102, 'Role Functions', 10, 30, 'admin#/role_function_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (105, 'Cache Admin', 10, 40, 'admin#/jcs_admin', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/cache.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (108, 'Usage', 10, 80, 'admin#/usage_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/users.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (121, 'Collaboration', 5000, 100, 'samplePage#/collaborate_list', 'menu_sample', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/bubble.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (930, 'Search', 9, 15, 'userProfile', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/search_profile.png');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150022, 'Menus', 10, 60, 'admin#/admin_menu_edit', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150038,'Notebook',5000,135,'samplePage#/notebook','menu_sample','Y',NULL,NULL,NULL,NULL,'APP','N',NULL);
-
--- fn_user
-Insert into fn_user (USER_ID,ORG_ID,MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS) values (1,null,null,'Demo',null,'User',null,null,null,'demo@email.com',null,null,null,'demo',null,'demo','demo',str_to_date('24-OCT-16','%d-%M-%Y'),'Y',null,str_to_date('17-OCT-16','%d-%M-%Y'),1,str_to_date('24-OCT-16','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null);
-
--- fn_app
-Insert into fn_app (APP_ID,APP_NAME,APP_IMAGE_URL,APP_DESCRIPTION,APP_NOTES,APP_URL,APP_ALTERNATE_URL,APP_REST_ENDPOINT,ML_APP_NAME,ML_APP_ADMIN_ID,MOTS_ID,APP_PASSWORD,OPEN,ENABLED,THUMBNAIL,APP_USERNAME,UEB_KEY,UEB_SECRET,UEB_TOPIC_NAME) VALUES (1,'Default',null,'Some Default Description','Some Default Note',null,null,null,'ECPP','?','1','okYTaDrhzibcbGVq5mjkVQ==','N','N',null,'Default',null,null,'ECOMP-PORTAL-INBOX');
-
--- fn_user_role
-Insert into fn_user_role (USER_ID,ROLE_ID,PRIORITY,APP_ID) values (1,1,null,1);
-
-commit;
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Rollback_1707_to_1610.2_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Rollback_1707_to_1610.2_OS.sql
deleted file mode 100644
index ce3565f6..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Rollback_1707_to_1610.2_OS.sql
+++ /dev/null
@@ -1,159 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This rollback script is for the OpenSource ECOMP SDK App database from version 1707 to 1610.2.
--- change size on 3 name columns from fn_user for the Opensource version
--- changed DS1 icon names to DS2 icon names
--- removed unnecessary fn_menu entries, updated fn_menu actions; changes the schema name from ecomp_sdk to ecomp_sdk_os_os
--- ---------------------------------------------------------------------------------------------------------------
-SET FOREIGN_KEY_CHECKS=1;
-CREATE DATABASE IF NOT EXISTS ecomp_sdk_os;
-
-rename table ecomp_sdk.cr_favorite_reports to ecomp_sdk_os.cr_favorite_reports;
-rename table ecomp_sdk.cr_filehist_log to ecomp_sdk_os.cr_filehist_log;
-rename table ecomp_sdk.cr_folder to ecomp_sdk_os.cr_folder;
-rename table ecomp_sdk.cr_folder_access to ecomp_sdk_os.cr_folder_access;
-rename table ecomp_sdk.cr_hist_user_map to ecomp_sdk_os.cr_hist_user_map;
-rename table ecomp_sdk.cr_lu_file_type to ecomp_sdk_os.cr_lu_file_type;
-rename table ecomp_sdk.cr_raptor_action_img to ecomp_sdk_os.cr_raptor_action_img;
-rename table ecomp_sdk.cr_raptor_pdf_img to ecomp_sdk_os.cr_raptor_pdf_img;
-rename table ecomp_sdk.cr_remote_schema_info to ecomp_sdk_os.cr_remote_schema_info;
-rename table ecomp_sdk.cr_report to ecomp_sdk_os.cr_report;
-rename table ecomp_sdk.cr_report_access to ecomp_sdk_os.cr_report_access;
-rename table ecomp_sdk.cr_report_dwnld_log to ecomp_sdk_os.cr_report_dwnld_log;
-rename table ecomp_sdk.cr_report_email_sent_log to ecomp_sdk_os.cr_report_email_sent_log;
-rename table ecomp_sdk.cr_report_file_history to ecomp_sdk_os.cr_report_file_history;
-rename table ecomp_sdk.cr_report_log to ecomp_sdk_os.cr_report_log;
-rename table ecomp_sdk.cr_report_schedule to ecomp_sdk_os.cr_report_schedule;
-rename table ecomp_sdk.cr_report_schedule_users to ecomp_sdk_os.cr_report_schedule_users;
-rename table ecomp_sdk.cr_report_template_map to ecomp_sdk_os.cr_report_template_map;
-rename table ecomp_sdk.cr_schedule_activity_log to ecomp_sdk_os.cr_schedule_activity_log;
-rename table ecomp_sdk.cr_table_join to ecomp_sdk_os.cr_table_join;
-rename table ecomp_sdk.cr_table_role to ecomp_sdk_os.cr_table_role;
-rename table ecomp_sdk.cr_table_source to ecomp_sdk_os.cr_table_source;
-rename table ecomp_sdk.fn_lu_timezone to ecomp_sdk_os.fn_lu_timezone;
-rename table ecomp_sdk.fn_user to ecomp_sdk_os.fn_user;
-rename table ecomp_sdk.fn_role to ecomp_sdk_os.fn_role;
-rename table ecomp_sdk.fn_audit_action to ecomp_sdk_os.fn_audit_action;
-rename table ecomp_sdk.fn_audit_action_log to ecomp_sdk_os.fn_audit_action_log;
-rename table ecomp_sdk.fn_lu_activity to ecomp_sdk_os.fn_lu_activity;
-rename table ecomp_sdk.fn_audit_log to ecomp_sdk_os.fn_audit_log;
-rename table ecomp_sdk.fn_broadcast_message to ecomp_sdk_os.fn_broadcast_message;
-rename table ecomp_sdk.fn_chat_logs to ecomp_sdk_os.fn_chat_logs;
-rename table ecomp_sdk.fn_chat_room to ecomp_sdk_os.fn_chat_room;
-rename table ecomp_sdk.fn_chat_users to ecomp_sdk_os.fn_chat_users;
-rename table ecomp_sdk.fn_datasource to ecomp_sdk_os.fn_datasource;
-rename table ecomp_sdk.fn_function to ecomp_sdk_os.fn_function;
-rename table ecomp_sdk.fn_lu_alert_method to ecomp_sdk_os.fn_lu_alert_method;
-rename table ecomp_sdk.fn_lu_broadcast_site to ecomp_sdk_os.fn_lu_broadcast_site;
-rename table ecomp_sdk.fn_lu_menu_set to ecomp_sdk_os.fn_lu_menu_set;
-rename table ecomp_sdk.fn_lu_priority to ecomp_sdk_os.fn_lu_priority;
-rename table ecomp_sdk.fn_lu_role_type to ecomp_sdk_os.fn_lu_role_type;
-rename table ecomp_sdk.fn_lu_tab_set to ecomp_sdk_os.fn_lu_tab_set;
-rename table ecomp_sdk.fn_lu_message_location to ecomp_sdk_os.fn_lu_message_location;
-rename table ecomp_sdk.fn_menu to ecomp_sdk_os.fn_menu;
-rename table ecomp_sdk.fn_org to ecomp_sdk_os.fn_org;
-rename table ecomp_sdk.fn_restricted_url to ecomp_sdk_os.fn_restricted_url;
-rename table ecomp_sdk.fn_role_composite to ecomp_sdk_os.fn_role_composite;
-rename table ecomp_sdk.fn_role_function to ecomp_sdk_os.fn_role_function;
-rename table ecomp_sdk.fn_tab to ecomp_sdk_os.fn_tab;
-rename table ecomp_sdk.fn_tab_selected to ecomp_sdk_os.fn_tab_selected;
-rename table ecomp_sdk.fn_user_pseudo_role to ecomp_sdk_os.fn_user_pseudo_role;
-rename table ecomp_sdk.fn_user_role to ecomp_sdk_os.fn_user_role;
-rename table ecomp_sdk.schema_info to ecomp_sdk_os.schema_info;
-rename table ecomp_sdk.fn_app to ecomp_sdk_os.fn_app;
-rename table ecomp_sdk.fn_workflow to ecomp_sdk_os.fn_workflow;
-rename table ecomp_sdk.fn_schedule_workflows to ecomp_sdk_os.fn_schedule_workflows;
-rename table ecomp_sdk.demo_bar_chart to ecomp_sdk_os.demo_bar_chart;
-rename table ecomp_sdk.demo_bar_chart_inter to ecomp_sdk_os.demo_bar_chart_inter;
-rename table ecomp_sdk.demo_line_chart to ecomp_sdk_os.demo_line_chart;
-rename table ecomp_sdk.demo_pie_chart to ecomp_sdk_os.demo_pie_chart;
-rename table ecomp_sdk.demo_util_chart to ecomp_sdk_os.demo_util_chart;
-rename table ecomp_sdk.demo_scatter_chart to ecomp_sdk_os.demo_scatter_chart;
-rename table ecomp_sdk.demo_scatter_plot to ecomp_sdk_os.demo_scatter_plot;
-rename table ecomp_sdk.fn_qz_job_details to ecomp_sdk_os.fn_qz_job_details;
-rename table ecomp_sdk.fn_qz_triggers to ecomp_sdk_os.fn_qz_triggers;
-rename table ecomp_sdk.fn_qz_simple_triggers to ecomp_sdk_os.fn_qz_simple_triggers;
-rename table ecomp_sdk.fn_qz_cron_triggers to ecomp_sdk_os.fn_qz_cron_triggers;
-rename table ecomp_sdk.fn_qz_simprop_triggers to ecomp_sdk_os.fn_qz_simprop_triggers;
-rename table ecomp_sdk.fn_qz_blob_triggers to ecomp_sdk_os.fn_qz_blob_triggers;
-rename table ecomp_sdk.fn_qz_calendars to ecomp_sdk_os.fn_qz_calendars;
-rename table ecomp_sdk.fn_qz_paused_trigger_grps to ecomp_sdk_os.fn_qz_paused_trigger_grps;
-rename table ecomp_sdk.fn_qz_fired_triggers to ecomp_sdk_os.fn_qz_fired_triggers;
-rename table ecomp_sdk.fn_qz_scheduler_state to ecomp_sdk_os.fn_qz_scheduler_state;
-rename table ecomp_sdk.fn_qz_locks to ecomp_sdk_os.fn_qz_locks;
-rename table ecomp_sdk.rcloudinvocation to ecomp_sdk_os.rcloudinvocation;
-rename table ecomp_sdk.rcloudnotebook to ecomp_sdk_os.rcloudnotebook;
-
-USE ecomp_sdk_os;
-
---
--- NAME: V_URL_ACCESS; TYPE: VIEW
---
-CREATE VIEW v_url_access AS
- SELECT DISTINCT M.ACTION AS URL,
- M.FUNCTION_CD
- FROM FN_MENU M
- WHERE (M.ACTION IS NOT NULL)
-UNION
- SELECT DISTINCT T.ACTION AS URL,
- T.FUNCTION_CD
- FROM FN_TAB T
- WHERE (T.ACTION IS NOT NULL)
-UNION
- SELECT R.RESTRICTED_URL AS URL,
- R.FUNCTION_CD
- FROM FN_RESTRICTED_URL R;
-
-update fn_menu
-set image_src = 'ion-home'
-where menu_id = 2 and label = 'Home';
-
-update fn_menu
-set image_src = 'ion-android-apps'
-where menu_id = 5000 and label = 'Sample Pages';
-
-update fn_menu
-set image_src = 'ion-ios-paper'
-where menu_id = 8 and label = 'Reports';
-
-update fn_menu
-set image_src = 'ion-person'
-where menu_id = 9 and label = 'Profile';
-
-update fn_menu
-set image_src = 'ion-gear-a'
-where menu_id = 10 and label = 'Admin';
-
-update fn_menu
-set action = 'collaborate_list.htm'
-where menu_id = 121 and label = 'Collaboration';
-
-update fn_menu
-set action = 'notebook.htm'
-where menu_id = 150038 and label = 'Notebook';
-
-update fn_menu
-set action = 'admin'
-where menu_id = 101 and label = 'Roles';
-
-update fn_menu
-set action = 'report_wizard.htm?r_action=report.create'
-where menu_id = 87 and label = 'Create Reports';
-
-delete from fn_menu
-where menu_id = 150022 and label = 'Menus';
-
-delete from fn_menu
-where menu_id = 89 and label = 'Import';
-
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (13, 'Application Logout', 1, 130, 'app_logout.htm', 'menu_logout', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', 'icon-sign-out');
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (92, 'Import User', 9, 30, null, 'menu_profile_import', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (103, 'Broadcast Messages', 10, 50, 'admin#/broadcast_list', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', '/static/fusion/images/bubble.png');
-
-alter table fn_user
- CHANGE COLUMN FIRST_NAME FIRST_NAME VARCHAR(25) NULL DEFAULT NULL ,
- CHANGE COLUMN MIDDLE_NAME MIDDLE_NAME VARCHAR(25) NULL DEFAULT NULL ,
- CHANGE COLUMN LAST_NAME LAST_NAME VARCHAR(25) NULL DEFAULT NULL;
-
-drop schema ecomp_sdk;
-
-commit;
diff --git a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Upgrade_1610.2_to_1707_OS.sql b/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Upgrade_1610.2_to_1707_OS.sql
deleted file mode 100644
index c45ad9c5..00000000
--- a/ecomp-sdk/epsdk-app-os/db-scripts/EcompSdkMySql_Upgrade_1610.2_to_1707_OS.sql
+++ /dev/null
@@ -1,162 +0,0 @@
--- ---------------------------------------------------------------------------------------------------------------
--- This script upgrades the OpenSource ECOMP SDK App database from version 1610.2 to 1707.
--- change size on 3 name columns from fn_user for the Opensource version
--- changed DS1 icon names to DS2 icon names
--- removed unnecessary fn_menu entries, updated fn_menu actions; changes the schema name from ecomp_sdk_os to ecomp_sdk
--- ---------------------------------------------------------------------------------------------------------------
-
-SET FOREIGN_KEY_CHECKS=1;
-CREATE DATABASE IF NOT EXISTS ecomp_sdk;
-
-rename table ecomp_sdk_os.cr_favorite_reports to ecomp_sdk.cr_favorite_reports;
-rename table ecomp_sdk_os.cr_filehist_log to ecomp_sdk.cr_filehist_log;
-rename table ecomp_sdk_os.cr_folder to ecomp_sdk.cr_folder;
-rename table ecomp_sdk_os.cr_folder_access to ecomp_sdk.cr_folder_access;
-rename table ecomp_sdk_os.cr_hist_user_map to ecomp_sdk.cr_hist_user_map;
-rename table ecomp_sdk_os.cr_lu_file_type to ecomp_sdk.cr_lu_file_type;
-rename table ecomp_sdk_os.cr_raptor_action_img to ecomp_sdk.cr_raptor_action_img;
-rename table ecomp_sdk_os.cr_raptor_pdf_img to ecomp_sdk.cr_raptor_pdf_img;
-rename table ecomp_sdk_os.cr_remote_schema_info to ecomp_sdk.cr_remote_schema_info;
-rename table ecomp_sdk_os.cr_report to ecomp_sdk.cr_report;
-rename table ecomp_sdk_os.cr_report_access to ecomp_sdk.cr_report_access;
-rename table ecomp_sdk_os.cr_report_dwnld_log to ecomp_sdk.cr_report_dwnld_log;
-rename table ecomp_sdk_os.cr_report_email_sent_log to ecomp_sdk.cr_report_email_sent_log;
-rename table ecomp_sdk_os.cr_report_file_history to ecomp_sdk.cr_report_file_history;
-rename table ecomp_sdk_os.cr_report_log to ecomp_sdk.cr_report_log;
-rename table ecomp_sdk_os.cr_report_schedule to ecomp_sdk.cr_report_schedule;
-rename table ecomp_sdk_os.cr_report_schedule_users to ecomp_sdk.cr_report_schedule_users;
-rename table ecomp_sdk_os.cr_report_template_map to ecomp_sdk.cr_report_template_map;
-rename table ecomp_sdk_os.cr_schedule_activity_log to ecomp_sdk.cr_schedule_activity_log;
-rename table ecomp_sdk_os.cr_table_join to ecomp_sdk.cr_table_join;
-rename table ecomp_sdk_os.cr_table_role to ecomp_sdk.cr_table_role;
-rename table ecomp_sdk_os.cr_table_source to ecomp_sdk.cr_table_source;
-rename table ecomp_sdk_os.fn_lu_timezone to ecomp_sdk.fn_lu_timezone;
-rename table ecomp_sdk_os.fn_user to ecomp_sdk.fn_user;
-rename table ecomp_sdk_os.fn_role to ecomp_sdk.fn_role;
-rename table ecomp_sdk_os.fn_audit_action to ecomp_sdk.fn_audit_action;
-rename table ecomp_sdk_os.fn_audit_action_log to ecomp_sdk.fn_audit_action_log;
-rename table ecomp_sdk_os.fn_lu_activity to ecomp_sdk.fn_lu_activity;
-rename table ecomp_sdk_os.fn_audit_log to ecomp_sdk.fn_audit_log;
-rename table ecomp_sdk_os.fn_broadcast_message to ecomp_sdk.fn_broadcast_message;
-rename table ecomp_sdk_os.fn_chat_logs to ecomp_sdk.fn_chat_logs;
-rename table ecomp_sdk_os.fn_chat_room to ecomp_sdk.fn_chat_room;
-rename table ecomp_sdk_os.fn_chat_users to ecomp_sdk.fn_chat_users;
-rename table ecomp_sdk_os.fn_datasource to ecomp_sdk.fn_datasource;
-rename table ecomp_sdk_os.fn_function to ecomp_sdk.fn_function;
-rename table ecomp_sdk_os.fn_lu_alert_method to ecomp_sdk.fn_lu_alert_method;
-rename table ecomp_sdk_os.fn_lu_broadcast_site to ecomp_sdk.fn_lu_broadcast_site;
-rename table ecomp_sdk_os.fn_lu_menu_set to ecomp_sdk.fn_lu_menu_set;
-rename table ecomp_sdk_os.fn_lu_priority to ecomp_sdk.fn_lu_priority;
-rename table ecomp_sdk_os.fn_lu_role_type to ecomp_sdk.fn_lu_role_type;
-rename table ecomp_sdk_os.fn_lu_tab_set to ecomp_sdk.fn_lu_tab_set;
-rename table ecomp_sdk_os.fn_lu_message_location to ecomp_sdk.fn_lu_message_location;
-rename table ecomp_sdk_os.fn_menu to ecomp_sdk.fn_menu;
-rename table ecomp_sdk_os.fn_org to ecomp_sdk.fn_org;
-rename table ecomp_sdk_os.fn_restricted_url to ecomp_sdk.fn_restricted_url;
-rename table ecomp_sdk_os.fn_role_composite to ecomp_sdk.fn_role_composite;
-rename table ecomp_sdk_os.fn_role_function to ecomp_sdk.fn_role_function;
-rename table ecomp_sdk_os.fn_tab to ecomp_sdk.fn_tab;
-rename table ecomp_sdk_os.fn_tab_selected to ecomp_sdk.fn_tab_selected;
-rename table ecomp_sdk_os.fn_user_pseudo_role to ecomp_sdk.fn_user_pseudo_role;
-rename table ecomp_sdk_os.fn_user_role to ecomp_sdk.fn_user_role;
-rename table ecomp_sdk_os.schema_info to ecomp_sdk.schema_info;
-rename table ecomp_sdk_os.fn_app to ecomp_sdk.fn_app;
-rename table ecomp_sdk_os.fn_workflow to ecomp_sdk.fn_workflow;
-rename table ecomp_sdk_os.fn_schedule_workflows to ecomp_sdk.fn_schedule_workflows;
-rename table ecomp_sdk_os.demo_bar_chart to ecomp_sdk.demo_bar_chart;
-rename table ecomp_sdk_os.demo_bar_chart_inter to ecomp_sdk.demo_bar_chart_inter;
-rename table ecomp_sdk_os.demo_line_chart to ecomp_sdk.demo_line_chart;
-rename table ecomp_sdk_os.demo_pie_chart to ecomp_sdk.demo_pie_chart;
-rename table ecomp_sdk_os.demo_util_chart to ecomp_sdk.demo_util_chart;
-rename table ecomp_sdk_os.demo_scatter_chart to ecomp_sdk.demo_scatter_chart;
-rename table ecomp_sdk_os.demo_scatter_plot to ecomp_sdk.demo_scatter_plot;
-rename table ecomp_sdk_os.fn_qz_job_details to ecomp_sdk.fn_qz_job_details;
-rename table ecomp_sdk_os.fn_qz_triggers to ecomp_sdk.fn_qz_triggers;
-rename table ecomp_sdk_os.fn_qz_simple_triggers to ecomp_sdk.fn_qz_simple_triggers;
-rename table ecomp_sdk_os.fn_qz_cron_triggers to ecomp_sdk.fn_qz_cron_triggers;
-rename table ecomp_sdk_os.fn_qz_simprop_triggers to ecomp_sdk.fn_qz_simprop_triggers;
-rename table ecomp_sdk_os.fn_qz_blob_triggers to ecomp_sdk.fn_qz_blob_triggers;
-rename table ecomp_sdk_os.fn_qz_calendars to ecomp_sdk.fn_qz_calendars;
-rename table ecomp_sdk_os.fn_qz_paused_trigger_grps to ecomp_sdk.fn_qz_paused_trigger_grps;
-rename table ecomp_sdk_os.fn_qz_fired_triggers to ecomp_sdk.fn_qz_fired_triggers;
-rename table ecomp_sdk_os.fn_qz_scheduler_state to ecomp_sdk.fn_qz_scheduler_state;
-rename table ecomp_sdk_os.fn_qz_locks to ecomp_sdk.fn_qz_locks;
-rename table ecomp_sdk_os.rcloudinvocation to ecomp_sdk.rcloudinvocation;
-rename table ecomp_sdk_os.rcloudnotebook to ecomp_sdk.rcloudnotebook;
-
-USE ecomp_sdk;
-
---
--- NAME: V_URL_ACCESS; TYPE: VIEW
---
-CREATE VIEW v_url_access AS
- SELECT DISTINCT M.ACTION AS URL,
- M.FUNCTION_CD
- FROM FN_MENU M
- WHERE (M.ACTION IS NOT NULL)
-UNION
- SELECT DISTINCT T.ACTION AS URL,
- T.FUNCTION_CD
- FROM FN_TAB T
- WHERE (T.ACTION IS NOT NULL)
-UNION
- SELECT R.RESTRICTED_URL AS URL,
- R.FUNCTION_CD
- FROM FN_RESTRICTED_URL R;
-
-update fn_menu
-set image_src = 'icon-building-home'
-where menu_id = 2 and label = 'Home';
-
-update fn_menu
-set image_src = 'icon-documents-book'
-where menu_id = 5000 and label = 'Sample Pages';
-
-update fn_menu
-set image_src = 'icon-misc-piechart'
-where menu_id = 8 and label = 'Reports';
-
-update fn_menu
-set image_src = 'icon-people-oneperson'
-where menu_id = 9 and label = 'Profile';
-
-update fn_menu
-set image_src = 'icon-content-star'
-where menu_id = 10 and label = 'Admin';
-
-update fn_menu
-set action = 'samplePage#/collaborate_list'
-where menu_id = 121 and label = 'Collaboration';
-
-update fn_menu
-set action = 'samplePage#/notebook'
-where menu_id = 150038 and label = 'Notebook';
-
-update fn_menu
-set action = 'admin#/admin'
-where menu_id = 101 and label = 'Roles';
-
-update fn_menu
-set action ='report#/report_wizard'
-where menu_id = 87 and label = 'Create Reports';
-
-delete from fn_menu
-where menu_id = 13 and label = 'Application Logout';
-
-delete from fn_menu
-where menu_id = 92 and label = 'Import User';
-
-delete from fn_menu
-where menu_id = 103 and label = 'Broadcast Messages';
-
-alter table fn_user
- CHANGE COLUMN FIRST_NAME FIRST_NAME VARCHAR(50) NULL DEFAULT NULL ,
- CHANGE COLUMN MIDDLE_NAME MIDDLE_NAME VARCHAR(50) NULL DEFAULT NULL ,
- CHANGE COLUMN LAST_NAME LAST_NAME VARCHAR(50) NULL DEFAULT NULL;
-
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (89, 'Import', 8, 140, 'report#/report_import', 'menu_reports', 'Y', null, null, null, null, 'APP', 'N', null);
-INSERT INTO fn_menu (MENU_ID, LABEL, PARENT_ID, SORT_ORDER, ACTION, FUNCTION_CD, ACTIVE_YN, SERVLET, QUERY_STRING, EXTERNAL_URL, TARGET, MENU_SET_CD, SEPARATOR_YN, IMAGE_SRC) VALUES (150022, 'Menus', 10, 60, 'admin#/admin_menu_edit', 'menu_admin', 'Y', NULL, NULL, NULL, NULL, 'APP', 'N', NULL);
-
-drop schema ecomp_sdk_os;
-
-commit;