X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;ds=sidebyside;f=engine-d-standalone%2Fsrc%2Fmain%2Fassembly%2Fdbscripts%2Fpostgresql%2Fonap-holmes_engine-createobj.sql;h=a3975b3c84f10d9c0c25cdcba0bbdd85db626ff4;hb=bffabda06aa6c5b8027ecdc98f812df2d2c45cba;hp=6831ce2dfac44a478fe3b8ab2bdeb4bcd117f34e;hpb=5fa7c2ef60c8c26fd5a77340a1c557f92b2bc3f8;p=holmes%2Fengine-management.git

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,