diff options
author | Ruoyu <ruoyu.ying@intel.com> | 2018-11-28 04:46:56 +0000 |
---|---|---|
committer | Ruoyu Ying <ruoyu.ying@intel.com> | 2018-11-28 04:57:09 +0000 |
commit | 1c31435b418e46569ec17afd8de0d0cb9c9cbfee (patch) | |
tree | dae597663344f1a36f664c586b83d3de41ce8627 | |
parent | 169bdcaaec8b5e184e663f52ec5c95a61127678f (diff) |
Change primary key for OOF table
Change the primary key to serviceResourceId
Change-Id: I7161135536be44ab71a890065b002cbe08048d5a
Issue-ID: VFC-941
Signed-off-by: Ruoyu <ruoyu.ying@intel.com>
-rw-r--r-- | resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql index c244776..798e1c2 100644 --- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -287,12 +287,11 @@ CREATE TABLE NFVO_OOF_DATA ( `TRANSACTIONID` varchar(255) NOT NULL, `REQUESTSTATUS` varchar(50) NOT NULL, `RESOURCEMODULENAME` varchar(100) NOT NULL, - `SERVICERESOURCEID` varchar(255) NOT NULL, + `SERVICERESOURCEID` varchar(255) NOT NULL PRIMARY KEY, `VIMID` varchar(255) NULL, `CLOUDOWNER` varchar(100) NULL, `CLOUDREGIONID` varchar(255) NULL, `VDUINFO` longtext NULL, - CONSTRAINT ID PRIMARY KEY(REQUESTID,TRANSACTIONID) ); DROP TABLE IF EXISTS NFVO_PNFINST; |