From e0addf5b588a1244f9679becd90999dfcb4c3a94 Mon Sep 17 00:00:00 2001
From: "ITSERVICES\\rb7147" <rb7147@att.com>
Date: Tue, 25 Apr 2017 11:46:00 -0400
Subject: Policy 1707 commit to LF

Change-Id: Ibe6f01d92f9a434c040abb05d5386e89d675ae65
Signed-off-by: ITSERVICES\rb7147 <rb7147@att.com>
---
 .../install/mysql/data/170204_upgrade_script.sql   | 88 ++++++++++++++++++++++
 1 file changed, 88 insertions(+)
 create mode 100644 packages/base/src/files/install/mysql/data/170204_upgrade_script.sql

(limited to 'packages/base/src/files/install/mysql/data/170204_upgrade_script.sql')

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

