summaryrefslogtreecommitdiffstats
path: root/ecomp-sdk/epsdk-app-common
diff options
context:
space:
mode:
Diffstat (limited to 'ecomp-sdk/epsdk-app-common')
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_2_Common.sql (renamed from ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_0_Common.sql)6
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_2_Common.sql (renamed from ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_0_Common.sql)5
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql29
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql58
-rw-r--r--ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql (renamed from ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql)3
5 files changed, 65 insertions, 36 deletions
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_0_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_2_Common.sql
index 31d8be45..92ff2ad9 100644
--- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_0_Common.sql
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDDLMySql_3_2_Common.sql
@@ -1,5 +1,5 @@
-- ---------------------------------------------------------------------------------------------------------------
--- This script creates tables in the COMMON version 2.1.0 of the ONAP SDK application database.
+-- This script creates tables in the COMMON version 3.2.0 of the ONAP SDK application database.
-- Additional DDL scripts may be required!
--
-- Note to database admin: set the MySQL system variable called lower_case_table_names to 1
@@ -472,7 +472,7 @@ create table fn_function (
FUNCTION_NAME CHARACTER VARYING(50) NOT NULL,
TYPE VARCHAR(20) NOT NULL,
ACTION VARCHAR(20) NOT NULL,
- UNIQUE KEY function (FUNCTION_CD,TYPE,ACTION)
+ UNIQUE KEY functcdtypeaction (FUNCTION_CD,TYPE,ACTION)
);
--
@@ -1389,4 +1389,4 @@ alter table cr_hist_user_map
alter table cr_hist_user_map
add constraint sys_c0014617 foreign key (user_id) references fn_user(user_id);
-commit; \ No newline at end of file
+commit;
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_0_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_2_Common.sql
index 94d0de8c..40e5f2ea 100644
--- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_0_Common.sql
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkDMLMySql_3_2_Common.sql
@@ -1,5 +1,5 @@
-- ---------------------------------------------------------------------------------------------------------------
--- This script populates tables in the COMMON version 2.1.0 of the ONAP SDK application database.
+-- This script populates tables in the COMMON version 3.2.0 of the ONAP SDK application database.
-- Additional DML scripts may be required!
-- ---------------------------------------------------------------------------------------------------------------
@@ -185,6 +185,7 @@ INSERT INTO fn_restricted_url VALUES('report/wizard/save_formfield_groups_data',
INSERT INTO fn_restricted_url VALUES('report/wizard/save_col_tab_data/*','menu_reports');
INSERT INTO fn_restricted_url VALUES('raptor/dashboard/run/*','menu_reports');
+insert into fn_restricted_url values ('v2','menu_home');
-- fn_role
Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (16,'Standard User','Y',5);
@@ -2899,4 +2900,4 @@ INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-
INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-03-07','%Y-%m-%d'),61.86667);
INSERT INTO demo_util_chart (TRAFFIC_DATE,UTIL_PERC ) VALUES (str_to_date('2016-03-08','%Y-%m-%d'),62.00000);
-commit; \ No newline at end of file
+commit;
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql
deleted file mode 100644
index f0a228df..00000000
--- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_0_to_2_6_Common.sql
+++ /dev/null
@@ -1,29 +0,0 @@
-use ecomp_sdk;
-
-SET FOREIGN_KEY_CHECKS=0;
-
-UPDATE fn_menu
-SET ACTION='admin#/role_function_list'
-WHERE LABEL='Role Functions';
-
-
-UPDATE fn_menu
-SET ACTION='admin#/usage_list'
-WHERE LABEL='Usage';
-
-
-UPDATE fn_menu
-SET ACTION='admin#/admin'
-WHERE LABEL='Roles';
-
-UPDATE fn_menu
-SET ACTION='admin#/jcs_admin'
-WHERE LABEL='Cache Admin';
-
-UPDATE fn_menu
-SET ACTION='admin#/admin_menu_edit'
-WHERE LABEL='Menus';
-
-delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2';
-
-commit; \ No newline at end of file
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql
new file mode 100644
index 00000000..1db43db8
--- /dev/null
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Rollback_3_2_to_2_6_Common.sql
@@ -0,0 +1,58 @@
+use ecomp_sdk;
+
+SET FOREIGN_KEY_CHECKS=0;
+
+UPDATE fn_menu
+SET ACTION='welcome'
+WHERE LABEL='Home';
+
+UPDATE fn_menu
+SET ACTION='userProfile#/self_profile'
+WHERE LABEL='Self';
+
+UPDATE fn_menu
+SET ACTION='admin#/role_function_list'
+WHERE LABEL='Role Functions';
+
+
+UPDATE fn_menu
+SET ACTION='admin#/usage_list'
+WHERE LABEL='Usage';
+
+
+UPDATE fn_menu
+SET ACTION='admin#/admin'
+WHERE LABEL='Roles';
+
+UPDATE fn_menu
+SET ACTION='admin#/jcs_admin'
+WHERE LABEL='Cache Admin';
+
+UPDATE fn_menu
+SET ACTION='userProfile'
+WHERE LABEL='Search';
+
+UPDATE fn_menu
+SET ACTION='admin#/admin_menu_edit'
+WHERE LABEL='Menus';
+
+-- fn_menu - update menu icon
+UPDATE fn_menu
+SET `IMAGE_SRC`='icon-building-home'
+WHERE `LABEL`='Home';
+
+UPDATE fn_menu
+SET `IMAGE_SRC`='icon-misc-piechart'
+WHERE `LABEL`='Reports';
+
+UPDATE fn_menu
+SET `IMAGE_SRC`='icon-people-oneperson'
+WHERE `LABEL`='Profile';
+
+UPDATE fn_menu
+SET `IMAGE_SRC`='icon-content-star'
+WHERE `LABEL`='Admin';
+
+delete FROM fn_restricted_url WHERE RESTRICTED_URL='V2';
+
+commit; \ No newline at end of file
diff --git a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql
index 4139a7a5..16a408e4 100644
--- a/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_0_Common.sql
+++ b/ecomp-sdk/epsdk-app-common/db-scripts/EcompSdkMySql_Upgrade_2_6_to_3_2_Common.sql
@@ -3,7 +3,7 @@ use ecomp_sdk;
SET FOREIGN_KEY_CHECKS=0;
UPDATE fn_menu
-SET ACTION='welcome'
+SET ACTION='v2/welcome'
WHERE LABEL='Home';
UPDATE fn_menu
@@ -38,7 +38,6 @@ UPDATE fn_menu
SET ACTION='v2/admin/admin_menu_edit'
WHERE LABEL='Menus';
-
-- fn_menu - update menu icon
UPDATE fn_menu
SET `IMAGE_SRC`='icon ion-ios-home'