diff options
| author |   Ruoyu <ruoyu.ying@intel.com> | 2018-11-28 04:46:56 +0000 |
|---|---|---|
| committer | Ruoyu <ruoyu.ying@intel.com> | 2018-11-28 04:48:30 +0000 |
| commit | d023b242fad961d3fb4b420f7cbe47c59ac4fe6f (patch) | |
| tree | dae597663344f1a36f664c586b83d3de41ce8627 | |
| parent | 2bece9f64d34da20bb3ffb1b924d443c605d2674 (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; |