From e0addf5b588a1244f9679becd90999dfcb4c3a94 Mon Sep 17 00:00:00 2001 From: "ITSERVICES\\rb7147" Date: Tue, 25 Apr 2017 11:46:00 -0400 Subject: Policy 1707 commit to LF Change-Id: Ibe6f01d92f9a434c040abb05d5386e89d675ae65 Signed-off-by: ITSERVICES\rb7147 --- .../install/mysql/data/161000_upgrade_script.sql | 80 +------------------- .../install/mysql/data/170204_downgrade_script.sql | 22 ++++++ .../install/mysql/data/170204_upgrade_script.sql | 88 ++++++++++++++++++++++ 3 files changed, 111 insertions(+), 79 deletions(-) create mode 100644 packages/base/src/files/install/mysql/data/170204_downgrade_script.sql create mode 100644 packages/base/src/files/install/mysql/data/170204_upgrade_script.sql (limited to 'packages/base/src/files/install/mysql/data') 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 -- cgit 1.2.3-korg