From 8b2d0be73ab8dcbd573769ed89ad27ecd7c25f88 Mon Sep 17 00:00:00 2001 From: Guangrong Fu Date: Sat, 14 Oct 2017 16:41:35 +0800 Subject: Add DMaaP Configuration APIs for Testing Change-Id: Iefc0f22da204f30fca8ef81effcd3497a347ebc0 Issue-ID: HOLMES-59 Signed-off-by: Guangrong Fu --- .../assembly/dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql | 3 +++ 1 file changed, 3 insertions(+) (limited to 'rulemgt-standalone/src/main/assembly/dbscripts/postgresql') 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); -- cgit 1.2.3-korg