diff options
| author |   tang peng <tang.peng5@zte.com.cn> | 2020-10-10 11:19:22 +0800 |
|---|---|---|
| committer | tang peng <tang.peng5@zte.com.cn> | 2020-10-10 11:19:22 +0800 |
| commit | 348ce6e112876f552a939e58d74376704537344e (patch) | |
| tree | e8bed6f7be5a87dd1eb770bb9f57965e7a8a117c /rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql | |
| parent | 7dbc431fa39b0c0094033780c78cb6f871221f85 (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/onap-holmes_rulemgt-createobj.sql')
| -rw-r--r-- | rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql | 4 |
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, |