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/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