summaryrefslogtreecommitdiffstats
path: root/engine-d-standalone/src/main/assembly/dbscripts/postgresql
diff options
context:
space:
mode:
authorVenkata Molluru <venkatamuralimohanreddy.molluru@techmahindra.com>2021-11-09 08:03:02 +0000
committerVenkata Molluru <venkatamuralimohanreddy.molluru@techmahindra.com>2021-11-09 08:05:38 +0000
commitbffabda06aa6c5b8027ecdc98f812df2d2c45cba (patch)
treef5db71e72549a9340d0a78fa900cd097e110be13 /engine-d-standalone/src/main/assembly/dbscripts/postgresql
parent5fa7c2ef60c8c26fd5a77340a1c557f92b2bc3f8 (diff)
Fix to prevent recreating ALARM_INFO table if exists
Issue-ID: HOLMES-491 Change-Id: Iaf2dca7c2e2e8fe21b3a7176ebb81501d76ac414 Signed-off-by: Venkata Molluru <venkatamuralimohanreddy.molluru@techmahindra.com>
Diffstat (limited to 'engine-d-standalone/src/main/assembly/dbscripts/postgresql')
-rw-r--r--engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql4
1 files changed, 1 insertions, 3 deletions
diff --git a/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql b/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql
index 6831ce2..a3975b3 100644
--- a/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql
+++ b/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql
@@ -25,9 +25,7 @@ CREATE ROLE DBUSER with PASSWORD 'DBPWD' LOGIN;
/******************DELETE OLD TABLE AND CREATE NEW***************************/
\c DBNAME;
-DROP TABLE IF EXISTS ALARM_INFO;
-
-CREATE TABLE ALARM_INFO (
+CREATE TABLE IF NOT EXISTS ALARM_INFO (
EVENTID VARCHAR(150) NOT NULL,
EVENTNAME VARCHAR(150) NOT NULL,
ALARMISCLEARED SMALLINT NOT NULL,