diff options
| author |   tang peng <tang.peng5@zte.com.cn> | 2021-11-08 10:16:37 +0000 |
|---|---|---|
| committer |   Gerrit Code Review <gerrit@onap.org> | 2021-11-08 10:16:37 +0000 |
| commit | e62c96c88b0b52e93685a6c267f40127755f4bf2 (patch) | |
| tree | 4b033c9540511b4098fe26f965d017768939f1c2 /engine-d-standalone/src/main/assembly/dbscripts/postgresql | |
| parent | 79fef5f18c70df400890207dc8a3200e414caabb (diff) | |
| parent | 97afdabeb7d1f2095f3fa170f0f78fb366c91644 (diff) | |
Merge "Add support to 7.1 VES data-stream in-parallel to 5.4"
Diffstat (limited to 'engine-d-standalone/src/main/assembly/dbscripts/postgresql')
| -rw-r--r-- | engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql b/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql index 82eed4a..6831ce2 100644 --- a/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql +++ b/engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql @@ -36,7 +36,8 @@ CREATE TABLE ALARM_INFO ( LASTEPOCHMICROSEC BIGINT NOT NULL, SOURCEID VARCHAR(150) NOT NULL, SOURCENAME VARCHAR(150) NOT NULL, - PRIMARY KEY (EVENTID) + SEQUENCE SMALLINT NOT NULL, + PRIMARY KEY (EVENTID, SEQUENCE, SOURCENAME) ); CREATE TABLE IF NOT EXISTS ENGINE_ENTITY ( |