1 files changed, 0 insertions, 50 deletions
diff --git a/kubernetes/holmes/components/holmes-engine-mgmt/resources/config/onap-holmes_engine-createobj.sql b/kubernetes/holmes/components/holmes-engine-mgmt/resources/config/onap-holmes_engine-createobj.sql
deleted file mode 100644
index e5eecb1a5a..0000000000
--- a/kubernetes/holmes/components/holmes-engine-mgmt/resources/config/onap-holmes_engine-createobj.sql
+++ /dev/null
@@ -1,50 +0,0 @@
---
--- Copyright 2017 ZTE Corporation.
---
--- 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.
---
-\c postgres
-
-/******************CREATE NEW DATABASE AND USER***************************/
-CREATE DATABASE ${DB_NAME};
-
-CREATE ROLE ${JDBC_USERNAME} with PASSWORD '${JDBC_PASSWORD}' LOGIN;
-
-\encoding UTF8;
-
-/******************CREATE NEW TABLE***************************/
-\c ${DB_NAME};
-
-CREATE TABLE IF NOT EXISTS ALARM_INFO (
-  EVENTID VARCHAR(150) NOT NULL,
-  EVENTNAME VARCHAR(150) NOT NULL,
-  ALARMISCLEARED SMALLINT NOT NULL,
-  ROOTFLAG SMALLINT NOT NULL,
-  STARTEPOCHMICROSEC BIGINT NOT NULL,
-  LASTEPOCHMICROSEC BIGINT NOT NULL,
-  SOURCEID VARCHAR(150)  NOT NULL,
-  SOURCENAME VARCHAR(150)  NOT NULL,
-  SEQUENCE SMALLINT NOT NULL,
-  PRIMARY KEY (EVENTID, SEQUENCE, SOURCENAME)
-);
-
-CREATE TABLE IF NOT EXISTS ENGINE_ENTITY (
-  ID VARCHAR(150) NOT NULL,
-  IP VARCHAR(128) NOT NULL,
-  PORT SMALLINT NOT NULL,
-  LASTMODIFIED BIGINT NOT NULL,
-  PRIMARY KEY (ID)
-);
-
-GRANT ALL PRIVILEGES ON ALARM_INFO TO ${JDBC_USERNAME};
-GRANT ALL PRIVILEGES ON ENGINE_ENTITY TO ${JDBC_USERNAME};