Policy 1707 commit to LF

Change-Id: Ibe6f01d92f9a434c040abb05d5386e89d675ae65
Signed-off-by: ITSERVICES\rb7147 <rb7147@att.com>

3 files changed, 111 insertions, 79 deletions

diff --git a/packages/base/src/files/install/mysql/data/161000_upgrade_script.sql b/packages/base/src/files/install/mysql/data/161000_upgrade_script.sql
index ba887f214..3c3272e0e 100755
--- a/packages/base/src/files/install/mysql/data/161000_upgrade_script.sql
+++ b/packages/base/src/files/install/mysql/data/161000_upgrade_script.sql
@@ -1675,87 +1675,9 @@ create table `globalrolesettings` (
 primary key (`role`)
 );
 
---
--- Table structure for table `goceventalarm`
---
-
-drop table if exists `goceventalarm`;
-create table `goceventalarm` (
-`id` int(11) not null auto_increment,
-`event` varchar(1024) not null,
-`description` varchar(1024) default null,
-`alarm` varchar(1024) not null,
-`created_date` timestamp not null default current_timestamp,
-`created_by` varchar(45) not null,
-`modified_date` timestamp not null default '0000-00-00 00:00:00',
-`modified_by` varchar(45) not null,
-primary key (`id`)
-);
-
---
--- Table structure for table `gocrcalarm`
---
-
-drop table if exists `gocrcalarm`;
-create table `gocrcalarm` (
-`id` int(11) not null auto_increment,
-`alarmname` varchar(1024) not null,
-`description` varchar(1024) default null,
-`created_date` timestamp not null default current_timestamp,
-`created_by` varchar(45) not null,
-`modified_date` timestamp not null default '0000-00-00 00:00:00',
-`modified_by` varchar(45) not null,
-primary key (`id`)
-);
-
---
--- Table structure for table `gocserverscope`
---
-
-drop table if exists `gocserverscope`;
-create table `gocserverscope` (
-`id` int(11) not null auto_increment,
-`serverscopename` varchar(1024) not null,
-`description` varchar(1024) default null,
-`serverscopeentry` varchar(1024) not null,
-`created_date` timestamp not null default current_timestamp on update current_timestamp,
-`created_by` varchar(45) not null,
-`modified_date` timestamp not null default '0000-00-00 00:00:00',
-`modified_by` varchar(45) not null,
-primary key (`id`)
-);
 
---
--- Table structure for table `goctraversal`
---
-
-drop table if exists `goctraversal`;
-create table `goctraversal` (
-`id` int(11) not null auto_increment,
-`traversal` varchar(1024) not null,
-`description` varchar(1024) default null,
-`created_date` timestamp not null default current_timestamp,
-`created_by` varchar(45) not null,
-`modified_date` timestamp not null default '0000-00-00 00:00:00',
-`modified_by` varchar(45) not null,
-primary key (`id`)
-);
 
---
--- Table structure for table `gocvnftype`
---
 
-drop table if exists `gocvnftype`;
-create table `gocvnftype` (
-`id` int(11) not null auto_increment,
-`vnfname` varchar(1024) not null,
-`description` varchar(1024) default null,
-`created_date` timestamp not null default current_timestamp,
-`created_by` varchar(45) not null,
-`modified_date` timestamp not null default '0000-00-00 00:00:00',
-`modified_by` varchar(45) not null,
-primary key (`id`)
-);
 
 --
 -- Table structure for table `groupentity`
@@ -6446,4 +6368,4 @@ INSERT INTO `policyversion` VALUES (3,'com/Config_MS_vFirewall',1,1,'2017-03-03
 insert into sequence (seq_name, seq_count) values ('SEQ_GEN', 3050); 
 
 set foreign_key_checks=1; 
-commit; 
+commit; 
\ No newline at end of file
diff --git a/packages/base/src/files/install/mysql/data/170204_downgrade_script.sql b/packages/base/src/files/install/mysql/data/170204_downgrade_script.sql
new file mode 100644
index 000000000..d33fde5c6
--- /dev/null
+++ b/packages/base/src/files/install/mysql/data/170204_downgrade_script.sql
@@ -0,0 +1,22 @@
+/*-
+* ============LICENSE_START=======================================================
+* ECOMP Policy Engine
+* ================================================================================
+* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+* ================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+*      http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+use ecomp_sdk;
+drop table if exists brmsgroup_info;
+drop table if exists brmsgroup_policy;
diff --git a/packages/base/src/files/install/mysql/data/170204_upgrade_script.sql b/packages/base/src/files/install/mysql/data/170204_upgrade_script.sql
new file mode 100644
index 000000000..87b24710d
--- /dev/null
+++ b/packages/base/src/files/install/mysql/data/170204_upgrade_script.sql
@@ -0,0 +1,88 @@
+/*-
+* ============LICENSE_START=======================================================
+* ECOMP Policy Engine
+* ================================================================================
+* Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
+* ================================================================================
+* Licensed under the Apache License, Version 2.0 (the "License");
+* you may not use this file except in compliance with the License.
+* You may obtain a copy of the License at
+*
+*      http://www.apache.org/licenses/LICENSE-2.0
+*
+* Unless required by applicable law or agreed to in writing, software
+* distributed under the License is distributed on an "AS IS" BASIS,
+* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+* See the License for the specific language governing permissions and
+* limitations under the License.
+* ============LICENSE_END=========================================================
+*/
+use ecomp_sdk;
+set foreign_key_checks=0;
+drop table if exists brmsgroup_info;
+CREATE TABLE brmsgroup_info
+(
+controllerName VARCHAR(255) NOT NULL,
+groupId VARCHAR(255) NOT NULL,
+artifactId VARCHAR(255) NOT NULL,
+version VARCHAR(45),
+PRIMARY KEY (controllerName)
+);
+drop table if exists brmsgroup_policy;
+CREATE TABLE brmsgroup_policy
+(
+policyName VARCHAR(255) NOT NULL,
+controllerName VARCHAR(255) NOT NULL references brmsgroup_info(controllerName),
+PRIMARY KEY(policyname)
+);
+
+
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5002,'Policy Super Admin','Y',10);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5003,'Policy Super Editor','Y',10);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5004,'Policy Super Guest','Y',10);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5005,'Policy Admin','Y',10);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5006,'Policy Editor','Y',10);
+Insert into fn_role (ROLE_ID,ROLE_NAME,ACTIVE_YN,PRIORITY) values (5007,'Policy Guest','Y',10);
+
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_admin');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_roles');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_pdp');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_dictionary');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5002,'policy_push');
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5003,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5003,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5003,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5003,'policy_pdp');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5003,'policy_push');
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5004,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5004,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5004,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5004,'policy_pdp');
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'policy_pdp');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'policy_dictionary');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5005,'policy_push');
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5006,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5006,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5006,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5006,'policy_pdp');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5006,'policy_push');
+
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5007,'menu_policy');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5007,'policy_dashboard');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5007,'policy_editor');
+Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (5007,'policy_pdp');
+
+set foreign_key_checks=0;
+
+commit;
\ No newline at end of file