diff options
| author |   Guangrong Fu <fu.guangrong@zte.com.cn> | 2017-10-14 16:41:35 +0800 |
|---|---|---|
| committer | Guangrong Fu <fu.guangrong@zte.com.cn> | 2017-10-14 16:41:35 +0800 |
| commit | 8b2d0be73ab8dcbd573769ed89ad27ecd7c25f88 (patch) | |
| tree | f1a9730298b9a5b22c0d8743957e00c0119c622a /rulemgt-standalone/src/main/assembly/dbscripts/postgresql | |
| parent | 049c1722681a7c0d564d625f2740cbc47c15a4be (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.sql | 3 |
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); |