Security/ Package Name changes

[portal.git] / ecomp-portal-DB-common / PortalDDLMySql_2_1_Common.sql

diff --git a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
similarity index 98%
rename from ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql
rename to ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
index 1ff699f..fd3828a 100644 (file)
--- a/ecomp-portal-DB-common/EcompPortalDDLMySql_1710_Common.sql
+++ b/ecomp-portal-DB-common/PortalDDLMySql_2_1_Common.sql
@@ -1,6 +1,5 @@
 -- ---------------------------------------------------------------------------------------------------------------
--- This is the 1710 Open Source Version of Ecomp Portal database called portal
--- based on 1707 Open Source Version and  Ecomp Portal database called portal 
+-- This is the 2.1.0 version of Portal database called portal
 
 -- note to : database admin,  set the mysql system variable called lower_case_table_names
 --             it can be set 3 different ways: 
@@ -9,11 +8,6 @@
 --                     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. 
---                          MySql/MariaDB Version compatibility information
--- bash-4.2$ mysql --version  – cluster version
--- mysql  Ver 15.1 Distrib 10.1.17-MariaDB, for Linux (x86_64) using readline 5.1
-
--- All versions newer or older than these DO NOT necessarily mean they are compatible.
 -- -----------------------------------------------------------------------------------------------------------------
 set foreign_key_checks=1; 
 
@@ -501,9 +495,10 @@ create table fn_menu (
     separator_yn character(1) default 'n',
     image_src character varying(100),
     constraint fk_fn_menu_ref_196_fn_menu foreign key (parent_id) references fn_menu(menu_id),
-    constraint fk_fn_menu_menu_set_cd foreign key (menu_set_cd) references fn_lu_menu_set(menu_set_cd),
-    constraint fk_fn_menu_ref_223_fn_funct foreign key (function_cd) references fn_function(function_cd)
+    constraint fk_fn_menu_menu_set_cd foreign key (menu_set_cd) references fn_lu_menu_set(menu_set_cd)
 );
+
+create index idx_fn_menu_label on fn_menu(label);
 --
 -- name: fn_org; type: table
 --
@@ -1300,6 +1295,7 @@ CREATE TABLE `ep_app_role_function` (
 `app_id` INT(11) NOT NULL,
 `role_id` INT(11) NOT NULL,
 `function_cd` VARCHAR(250) NOT NULL,
+`role_app_id` VARCHAR(20) NULL DEFAULT NULL,
 PRIMARY KEY (`id`),
 UNIQUE INDEX `UNIQUE KEY` (`app_id`, `role_id`, `function_cd`),
 CONSTRAINT `fk_ep_app_role_function_app_id` FOREIGN KEY (`app_id`) REFERENCES `fn_app` (`app_id`),
@@ -1562,10 +1558,6 @@ create index fn_audit_log_activity_cd using btree on fn_audit_log (activity_cd);
 --
 create index fn_audit_log_user_id using btree on fn_audit_log (user_id);
 --
--- name: fn_menu_function_cd; type: index
---
-create index fn_menu_function_cd using btree on fn_menu (function_cd);
---
 -- name: fn_org_access_cd; type: index
 --
 create index fn_org_access_cd using btree on fn_org (access_cd);