diff options
| author |   Venkata Molluru <venkatamuralimohanreddy.molluru@techmahindra.com> | 2021-11-09 08:03:02 +0000 |
|---|---|---|
| committer | Venkata Molluru <venkatamuralimohanreddy.molluru@techmahindra.com> | 2021-11-09 08:05:38 +0000 |
| commit | bffabda06aa6c5b8027ecdc98f812df2d2c45cba (patch) | |
| tree | f5db71e72549a9340d0a78fa900cd097e110be13 /engine-d-standalone/src/main/assembly/dbscripts/postgresql | |
| parent | 5fa7c2ef60c8c26fd5a77340a1c557f92b2bc3f8 (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.sql | 4 |
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, |