From 0e16acf4d8579fd82349d6cd24e236275735a818 Mon Sep 17 00:00:00 2001 From: Pamela Dragosh Date: Tue, 14 Feb 2017 19:45:48 -0500 Subject: Initial OpenECOMP policy/drools-pdp commit Change-Id: I0072ccab6f40ed32da39667f9f8523b6d6dad2e2 Signed-off-by: Pamela Dragosh --- .../install/mysql/data/151001_upgrade_script.sql | 246 +++++++++++++++++++++ 1 file changed, 246 insertions(+) create mode 100644 packages/base/src/files/install/mysql/data/151001_upgrade_script.sql (limited to 'packages/base/src/files/install/mysql/data/151001_upgrade_script.sql') diff --git a/packages/base/src/files/install/mysql/data/151001_upgrade_script.sql b/packages/base/src/files/install/mysql/data/151001_upgrade_script.sql new file mode 100644 index 00000000..9708fd42 --- /dev/null +++ b/packages/base/src/files/install/mysql/data/151001_upgrade_script.sql @@ -0,0 +1,246 @@ +/*- + * ============LICENSE_START======================================================= + * Base Package + * ================================================================================ + * 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========================================================= + */ + +set foreign_key_checks=0; +DROP TABLE IF EXISTS XACML.SERVICEGROUP; +CREATE TABLE XACML.SERVICEGROUP +( +id integer NOT NULL, +name varchar(32), +type varchar(16), +transportprotocol varchar(255), +appprotocol varchar(255), +ports varchar(255), +description varchar(255), +primary key(id) +) +; + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.SERVICEGROUP TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.ENFORCINGTYPE; +CREATE TABLE XACML.ENFORCINGTYPE +( +ID INTEGER NOT NULL, +ENFORCINGTYPE VARCHAR(255) NOT NULL, +SCRIPT VARCHAR(5000) NOT NULL, +CONNECTIONQUERY VARCHAR(1000) NOT NULL, +VALUEQUERY VARCHAR(1000) NOT NULL, +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.ENFORCINGTYPE TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.ACTIONPOLICYDICT; +CREATE TABLE XACML.ACTIONPOLICYDICT +( +ID INTEGER NOT NULL, +TYPE VARCHAR(45) NOT NULL, +URL VARCHAR(45) NOT NULL, +METHOD VARCHAR(45) NOT NULL, +HEADERS VARCHAR(1024) NOT NULL, +BODY VARCHAR(4096) NOT NULL, +CREATED_DATE TIMESTAMP NOT NULL, +CREATED_BY VARCHAR(45) NOT NULL, +MODIFIED_DATE TIMESTAMP NOT NULL, +MODIFIED_BY VARCHAR(45) NOT NULL, +ATTRIBUTE_NAME VARCHAR(45) NOT NULL, +DESCRIPTION VARCHAR(1024), +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.ACTIONPOLICYDICT TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.TERM; +CREATE TABLE XACML.TERM +( +ID INTEGER NOT NULL, +TERMNAME VARCHAR(45) NOT NULL, +SRCIPLIST VARCHAR(100), +DESTIPLIST VARCHAR(100), +PROTOCOLLIST VARCHAR(100), +PORTLIST VARCHAR(100), +SRCPORTLIST VARCHAR(100), +DESTPORTLIST VARCHAR(100), +ACTION VARCHAR(100), +DESCRIPTION VARCHAR(100), +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.TERM TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.PROTOCOLLIST; +CREATE TABLE XACML.PROTOCOLLIST +( +ID INTEGER NOT NULL, +PROTOCOLNAME VARCHAR(45) NOT NULL, +DESCRIPTION VARCHAR(64), +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.PROTOCOLLIST TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.PORTLIST; +CREATE TABLE XACML.PORTLIST +( +ID INTEGER NOT NULL, +PORTNAME VARCHAR(45) NOT NULL, +DESCRIPTION VARCHAR(64), +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.PORTLIST TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.PREFIXLIST; +CREATE TABLE XACML.PREFIXLIST +( +ID INTEGER NOT NULL, +PL_NAME VARCHAR(45) NOT NULL, +PL_VALUE VARCHAR(64), +DESCRIPTION VARCHAR(255) NULL, +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.PREFIXLIST TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.ADDRESSGROUP; +CREATE TABLE XACML.ADDRESSGROUP +( + ID INTEGER NOT NULL, + NAME VARCHAR(32), + DESCRIPTION VARCHAR(64), + PREFIXLIST VARCHAR(255), + PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.ADDRESSGROUP TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.POLICYSCORE; +CREATE TABLE XACML.POLICYSCORE +( +POLICY_NAME VARCHAR(100) NOT NULL, +POLICY_SCORE VARCHAR(100), +PRIMARY KEY(POLICY_NAME) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.POLICYSCORE TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.VSCLACTION; +CREATE TABLE XACML.VSCLACTION +( +ID INTEGER NOT NULL, +VSCL_ACTION VARCHAR(45) NOT NULL, +DESCRIPTION VARCHAR(45) NULL, +CREATED_DATE TIMESTAMP NOT NULL, +CREATED_BY VARCHAR(45) NOT NULL, +MODIFIED_DATE TIMESTAMP NOT NULL, +MODIFIED_BY VARCHAR(45) NOT NULL, +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.VSCLACTION TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.VNFTYPE; +CREATE TABLE XACML.VNFTYPE +( +ID INTEGER NOT NULL, +VNF_TYPE VARCHAR(45) NOT NULL, +DESCRIPTION VARCHAR(45) NULL, +CREATED_DATE TIMESTAMP NOT NULL, +CREATED_BY VARCHAR(45) NOT NULL, +MODIFIED_DATE TIMESTAMP NOT NULL, +MODIFIED_BY VARCHAR(45) NOT NULL, +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.VNFTYPE TO POLICY_USER; + +SET FOREIGN_KEY_CHECKS=0; + +DROP TABLE IF EXISTS XACML.ATTRIBUTE; +CREATE TABLE XACML.ATTRIBUTE +( +ID INTEGER NOT NULL, +CREATED_BY VARCHAR(255) NOT NULL, +CREATED_DATE TIMESTAMP, +DESCRIPTION VARCHAR(2048), +IS_DESIGNATOR CHAR(1) NOT NULL, +MODIFIED_BY VARCHAR(255) NOT NULL, +MODIFIED_DATE TIMESTAMP NOT NULL, +SELECTOR_PATH VARCHAR(2048), +XACML_ID VARCHAR(500) NOT NULL, +CATEGORY INTEGER, +CONSTRAINT_TYPE INTEGER, +DATATYPE INTEGER, +PRIORITY VARCHAR(45), +ATTRIBUTE_VALUE VARCHAR(45), +PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.ATTRIBUTE TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.DECISIONSETTINGS; +CREATE TABLE XACML.DECISIONSETTINGS +( + ID INTEGER NOT NULL, + XACML_ID VARCHAR(45) NOT NULL, + DESCRIPTION VARCHAR(45), + DATATYPE VARCHAR(45) NOT NULL, + CREATED_BY VARCHAR(45) NOT NULL, + MODIFIED_DATE TIMESTAMP NOT NULL, + MODIFIED_BY VARCHAR(45) NOT NULL, + PRIORITY VARCHAR(45), + CREATED_DATE TIMESTAMP NOT NULL, + PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.DECISIONSETTINGS TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.POLICY_MANAGEMENT; +CREATE TABLE XACML.POLICY_MANAGEMENT +( + ID INTEGER NOT NULL, + CONFIG_NAME VARCHAR(45) NOT NULL, + CREATE_DATE_TIME TIMESTAMP, + CREATED_BY VARCHAR(45) NOT NULL, + ECOMP_NAME VARCHAR(45) NOT NULL, + POLICY_NAME VARCHAR(45) NOT NULL, + SCOPE VARCHAR(45) NOT NULL, + UPDATE_DATE_TIME TIMESTAMP NOT NULL, + UPDATED_BY VARCHAR(45) NOT NULL, + XML TEXT NOT NULL, + PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.POLICY_MANAGEMENT TO POLICY_USER; + +DROP TABLE IF EXISTS XACML.SCOPES; +CREATE TABLE XACML.SCOPES +( + ID INTEGER NOT NULL, + SCOPE VARCHAR(45) NOT NULL, + PARENT_SCOPE INTEGER, + PRIMARY KEY(ID) +); + +GRANT INSERT, UPDATE, DELETE, SELECT ON XACML.SCOPES TO POLICY_USER; + + +set foreign_key_checks=1; -- cgit 1.2.3-korg