summaryrefslogtreecommitdiffstats
path: root/rulemgt-standalone/src/main/assembly/dbscripts/postgresql
diff options
context:
space:
mode:
authortang peng <tang.peng5@zte.com.cn>2020-10-10 11:19:22 +0800
committertang peng <tang.peng5@zte.com.cn>2020-10-10 11:19:22 +0800
commit348ce6e112876f552a939e58d74376704537344e (patch)
treee8bed6f7be5a87dd1eb770bb9f57965e7a8a117c /rulemgt-standalone/src/main/assembly/dbscripts/postgresql
parent7dbc431fa39b0c0094033780c78cb6f871221f85 (diff)
Fixed MSB Invocation Issues
Issue-ID: HOLMES-365 Signed-off-by: tang peng <tang.peng5@zte.com.cn> Change-Id: Ibae0924268e25f0af5f13ded1e2e1be51e8106d8
Diffstat (limited to 'rulemgt-standalone/src/main/assembly/dbscripts/postgresql')
-rw-r--r--rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql4
1 files changed, 1 insertions, 3 deletions
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,