summaryrefslogtreecommitdiffstats
path: root/ResmanagementService/deployment
diff options
context:
space:
mode:
authorluxin <luxin7@huawei.com>2017-09-01 14:47:07 +0800
committerluxin <luxin7@huawei.com>2017-09-01 14:47:07 +0800
commit47d3c331a04ce44b756973217f85a4a04ea45be0 (patch)
treefef9655fc837cfcdb8525abe34757109f895de45 /ResmanagementService/deployment
parent8f15590f99d86626665545cc8be77115ca6bb9ba (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')
-rw-r--r--ResmanagementService/deployment/src/main/release/db/mysql/db-schema.sql14
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 (