From 348ce6e112876f552a939e58d74376704537344e Mon Sep 17 00:00:00 2001
From: tang peng <tang.peng5@zte.com.cn>
Date: Sat, 10 Oct 2020 11:19:22 +0800
Subject: Fixed MSB Invocation Issues

Issue-ID: HOLMES-365
Signed-off-by: tang peng <tang.peng5@zte.com.cn>
Change-Id: Ibae0924268e25f0af5f13ded1e2e1be51e8106d8
---
 .../assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql   | 4 +---
 1 file changed, 1 insertion(+), 3 deletions(-)

(limited to 'rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql')

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,
-- 
cgit 1.2.3-korg

