aboutsummaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql/data/160200_upgrade_script.sql
diff options
context:
space:
mode:
Diffstat (limited to 'packages/base/src/files/install/mysql/data/160200_upgrade_script.sql')
-rw-r--r--packages/base/src/files/install/mysql/data/160200_upgrade_script.sql127
1 files changed, 0 insertions, 127 deletions
diff --git a/packages/base/src/files/install/mysql/data/160200_upgrade_script.sql b/packages/base/src/files/install/mysql/data/160200_upgrade_script.sql
deleted file mode 100644
index 46629a94..00000000
--- a/packages/base/src/files/install/mysql/data/160200_upgrade_script.sql
+++ /dev/null
@@ -1,127 +0,0 @@
-/*-
- * ============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=========================================================
- */
-
-drop table if exists xacml.DCAEuuid;
-CREATE TABLE xacml.DCAEuuid (
- ID int NOT NULL,
- name VARCHAR(45) NOT NULL,
- description VARCHAR(64)
- );
-
-drop table if exists xacml.MicroServiceLocation;
-CREATE TABLE xacml.MicroServiceLocation (
- ID int NOT NULL,
- name VARCHAR(45) NOT NULL,
- description VARCHAR(64)
- );
-
-drop table if exists xacml.DCAEUsers;
-CREATE TABLE xacml.DCAEUsers (
- ID int NOT NULL,
- name VARCHAR(45) NOT NULL,
- description VARCHAR(64)
- );
-
-drop table if exists xacml.microserviceconfigname;
-CREATE TABLE xacml.microserviceconfigname (
- ID int NOT NULL,
- name VARCHAR(45) NOT NULL,
- description VARCHAR(64)
- );
-
-drop table if exists xacml.vmType;
-CREATE TABLE xacml.vmType (
- ID int NOT NULL,
- name VARCHAR(45) NOT NULL,
- description VARCHAR(64)
- );
-
-alter table xacml.term add created_by varchar(100);
-alter table xacml.term add created_date date;
-alter table xacml.term add modified_by varchar(100);
-alter table xacml.term add modified_date date;
-
-drop table if exists xacml.pepoptions;
-CREATE TABLE xacml.PEPOPTIONS (
-ID INT NOT NULL,
-PEP_NAME VARCHAR(45) NOT NULL,
-DESCRIPTION VARCHAR(1024),
-Actions VARCHAR(1024) NOT 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)
-);
-
-drop table if exists xacml.VarbindDictionary;
-CREATE TABLE xacml.VarbindDictionary (
-Id INT NOT NULL,
-created_by VARCHAR(255) NOT NULL,
-created_date TIMESTAMP,
-modified_by VARCHAR(255) NOT NULL,
-modified_date TIMESTAMP NOT NULL,
-varbind_Description VARCHAR(2048),
-varbind_Name VARCHAR(45) NOT NULL UNIQUE,
-varbind_oid VARCHAR(45) NOT NULL,
-PRIMARY KEY (Id)
-);
-
-drop table if exists xacml.GocEventAlarm;
-CREATE TABLE xacml.GocEventAlarm(
-Id INT NOT NULL,
-Event VARCHAR(45) NOT NULL,
-description VARCHAR(1024),
-Alarm VARCHAR(1024) NOT 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)
-);
-
-drop table if exists xacml.GocTraversal;
-CREATE TABLE xacml.GocTraversal(
-ID INT NOT NULL,
-TRAVERSAL 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)
-);
-
-drop table if exists xacml.BRMSParamTemplate;
-CREATE TABLE xacml.BRMSParamTemplate(
-ID INT NOT NULL,
-param_template_name VARCHAR(45) NOT NULL,
-DESCRIPTION VARCHAR(45),
-rule LONGTEXT NOT NULL,
-CREATED_DATE TIMESTAMP NOT NULL,
-CREATED_BY VARCHAR(45) NOT NULL,
-PRIMARY KEY(ID)
-);
-
-alter table xacml.roles add name varchar(45);
-
-
-
-