diff options
| -rw-r--r-- | engine-d-standalone/src/main/assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql | 3 |
1 files changed, 1 insertions, 2 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 2b9f584..276957c 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,8 +36,7 @@ CREATE TABLE ALARM_INFO ( LASTEPOCHMICROSEC BIGINT NOT NULL, SOURCEID VARCHAR(150) NOT NULL, SOURCENAME VARCHAR(150) NOT NULL, - PRIMARY KEY (SOURCEID), - UNIQUE (SOURCENAME) + PRIMARY KEY (EVENTID) ); GRANT ALL PRIVILEGES ON ALARM_INFO TO DBUSER; |