diff options
author | 2017-09-01 14:47:07 +0800 | |
---|---|---|
committer | 2017-09-01 14:47:07 +0800 | |
commit | 47d3c331a04ce44b756973217f85a4a04ea45be0 (patch) | |
tree | fef9655fc837cfcdb8525abe34757109f895de45 /ResmanagementService/deployment/src/main/release/db/mysql | |
parent | 8f15590f99d86626665545cc8be77115ca6bb9ba (diff) |
Add NS mysql table
Add NS mysql table and mybatis mapper file
Change-Id: Ieea386e4898f2a20a5644dfcc8bea545bd98505c
Issue-Id:VFC-216
Signed-off-by: luxin <luxin7@huawei.com>
Diffstat (limited to 'ResmanagementService/deployment/src/main/release/db/mysql')
-rw-r--r-- | ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql | 14 |
1 files changed, 13 insertions, 1 deletions
diff --git a/ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql b/ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql index af5e0a3..e53f856 100644 --- a/ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql +++ b/ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql @@ -1,5 +1,5 @@ #******************************************************************************* -# Copyright 2016 Huawei Technologies Co., Ltd. +# Copyright 2016-2017 Huawei Technologies Co., Ltd. # # Licensed under the Apache License, Version 2.0 (the "License"); # you may not use this file except in compliance with the License. @@ -174,6 +174,18 @@ CREATE TABLE vnfinfo ( VNFM_ID VARCHAR(256) NULL, CONSTRAINT vnfinfo PRIMARY KEY (VNF_INSTANCE_ID) ); + +DROP TABLE IF EXISTS ns; +CREATE TABLE ns ( + ID VARCHAR(256) NOT NULL, + NAME VARCHAR(256) NULL, + NSD_ID VARCHAR(256) NULL, + DESCRIPTION VARCHAR(1024) NULL, + STATUS VARCHAR(256) NULL, + CTEATE_TIME VARCHAR(256) NULL, + LAST_UPDATE VARCHAR(256) NULL, + CONSTRAINT ns PRIMARY KEY (ID) +); DROP TABLE IF EXISTS vnfstatus; CREATE TABLE vnfstatus ( |