X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=rulemgt-standalone%2Fsrc%2Fmain%2Fassembly%2Fdbscripts%2Fpostgresql%2Fonap-holmes_rulemgt-createobj.sql;h=7fae4e619651fc05e7a7dd3371064c5aad1a5484;hb=348ce6e112876f552a939e58d74376704537344e;hp=090734ca07d10962c2f001ace71820acb73cf993;hpb=626c238c770c843d56c08a20cb14d2556a753ec9;p=holmes%2Frule-management.git

diff --git a/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql b/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
index 090734c..7fae4e6 100644
--- a/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql
+++ b/rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-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 APLUS_RULE;
-
-CREATE TABLE APLUS_RULE (
+CREATE TABLE IF NOT EXISTS APLUS_RULE (
   RID VARCHAR(30) NOT NULL,
   NAME VARCHAR(150) NOT NULL,
   CTRLLOOP VARCHAR(150) NOT NULL,