diff options
Diffstat (limited to 'ResmanagementService/deployment/src')
| -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 ( |