Code Review
/
holmes
/
engine-management.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
Fix to prevent recreating ALARM_INFO table if exists
[holmes/engine-management.git]
/
engine-d-standalone
/
src
/
main
/
assembly
/
dbscripts
/
postgresql
/
onap-holmes_engine-createobj.sql
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
(file)
--- 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;
/******************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,
EVENTID VARCHAR(150) NOT NULL,
EVENTNAME VARCHAR(150) NOT NULL,
ALARMISCLEARED SMALLINT NOT NULL,