From e8d169e14a81785379315f003977765043fb4cd5 Mon Sep 17 00:00:00 2001 From: Fei Tang Date: Tue, 3 Apr 2018 14:11:13 +0800 Subject: [PATCH] Fixed the sql issue Issue-ID: HOLMES-106 Change-Id: I50ac94e8dfb61beaef17ebb0f164e6d37acc5d88 Signed-off-by: Fei Tang --- .../assembly/dbscripts/postgresql/onap-holmes_engine-createobj.sql | 3 +-- 1 file changed, 1 insertion(+), 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; -- 2.16.6