summaryrefslogtreecommitdiffstats
path: root/rulemgt-standalone/src/main/assembly/dbscripts/postgresql
diff options
context:
space:
mode:
authorGuangrong Fu <fu.guangrong@zte.com.cn>2017-10-14 16:41:35 +0800
committerGuangrong Fu <fu.guangrong@zte.com.cn>2017-10-14 16:41:35 +0800
commit8b2d0be73ab8dcbd573769ed89ad27ecd7c25f88 (patch)
treef1a9730298b9a5b22c0d8743957e00c0119c622a /rulemgt-standalone/src/main/assembly/dbscripts/postgresql
parent049c1722681a7c0d564d625f2740cbc47c15a4be (diff)
Add DMaaP Configuration APIs for Testing
Change-Id: Iefc0f22da204f30fca8ef81effcd3497a347ebc0 Issue-ID: HOLMES-59 Signed-off-by: Guangrong Fu <fu.guangrong@zte.com.cn>
Diffstat (limited to 'rulemgt-standalone/src/main/assembly/dbscripts/postgresql')
-rw-r--r--rulemgt-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql3
1 files changed, 3 insertions, 0 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 fb1c86d..cbd3c59 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
@@ -33,6 +33,7 @@ CREATE ROLE holmes with PASSWORD 'holmespwd' LOGIN;
CREATE TABLE APLUS_RULE (
RID VARCHAR(30) NOT NULL,
NAME VARCHAR(150) NOT NULL,
+ CTRLLOOP VARCHAR(150) NOT NULL,
DESCRIPTION VARCHAR(4000) NULL,
ENABLE SMALLINT NOT NULL,
TEMPLATEID BIGINT NOT NULL,
@@ -50,6 +51,8 @@ CREATE TABLE APLUS_RULE (
UNIQUE (NAME)
);
+CREATE INDEX IDX_APLUS_RULE_NAME ON APLUS_RULE (NAME);
+CREATE INDEX IDX_APLUS_RULE_CTRLLOOP ON APLUS_RULE (CTRLLOOP);
CREATE INDEX IDX_APLUS_RULE_ENABLE ON APLUS_RULE (ENABLE);
CREATE INDEX IDX_APLUS_RULE_TEMPLATEID ON APLUS_RULE (TEMPLATEID);
CREATE INDEX IDX_APLUS_RULE_ENGINEID ON APLUS_RULE (ENGINEID);