diff options
| author |   Ruoyu Ying <ruoyu.ying@intel.com> | 2018-09-07 18:35:27 +0800 |
|---|---|---|
| committer | Ruoyu Ying <ruoyu.ying@intel.com> | 2018-09-07 18:37:29 +0800 |
| commit | 09094bb9434096914b1c5f16df6a426983a67d1f (patch) | |
| tree | eca6675a04f611abe64153031a0d5c9e62ee1e2b | |
| parent | 22656dd896543fe65bb718161bdb23323fda18a6 (diff) | |
Refine DB table for OOF directives
Refine DB table to store only one record for one vnf
Change-Id: I54deca8d0ede933b688a821362ce696fa34b6cc4
Issue-ID: VFC-1085
Signed-off-by: Ruoyu Ying <ruoyu.ying@intel.com>
| -rw-r--r-- | resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql index f6af383..e3c2cb6 100644 --- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -282,7 +282,6 @@ CREATE TABLE NFVO_WF_PLAN ( DROP TABLE IF EXISTS NFVO_OOF_DATA; CREATE TABLE NFVO_OOF_DATA ( - `ID` varchar(255) NOT NULL PRIMARY KEY, `REQUESTID` varchar(255) NOT NULL, `TRANSACTIONID` varchar(255) NOT NULL, `REQUESTSTATUS` varchar(50) NOT NULL, @@ -291,7 +290,6 @@ CREATE TABLE NFVO_OOF_DATA ( `VIMID` varchar(255) NULL, `CLOUDOWNER` varchar(100) NULL, `CLOUDREGIONID` varchar(255) NULL, - `VDUNAME` varchar(100) NULL, - `FLAVORNAME` varchar(100) NULL, - `DIRECTIVE` longtext NULL + `VDUINFO` longtext NULL, + CONSTRAINT ID PRIMARY KEY(REQUESTID,TRANSACTIONID) ); |