summaryrefslogtreecommitdiffstats
path: root/ResmanagementService/deployment
diff options
context:
space:
mode:
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 (