aboutsummaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql
diff options
context:
space:
mode:
authorITSERVICES\rb7147 <rb7147@att.com>2017-04-25 11:46:00 -0400
committerITSERVICES\rb7147 <rb7147@att.com>2017-05-03 09:58:17 -0400
commite0addf5b588a1244f9679becd90999dfcb4c3a94 (patch)
tree1212772d6366730266ff0e093c874b07aa716c29 /packages/base/src/files/install/mysql
parent39fb0f30472777e4b60d6a7ac8aa4eb9773961ff (diff)
Policy 1707 commit to LF
Change-Id: Ibe6f01d92f9a434c040abb05d5386e89d675ae65 Signed-off-by: ITSERVICES\rb7147 <rb7147@att.com>
Diffstat (limited to 'packages/base/src/files/install/mysql')
-rwxr-xr-xpackages/base/src/files/install/mysql/data/161000_upgrade_script.sql80
-rw-r--r--packages/base/src/files/install/mysql/data/170204_downgrade_script.sql22
-rw-r--r--packages/base/src/files/install/mysql/data/170204_upgrade_script.sql88
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