summaryrefslogtreecommitdiffstats
path: root/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql
diff options
context:
space:
mode:
Diffstat (limited to 'engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql')
-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,