diff options
Diffstat (limited to 'esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql')
| -rw-r--r-- | esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql | 71 |
1 files changed, 0 insertions, 71 deletions
diff --git a/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql b/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql deleted file mode 100644 index 073c73f..0000000 --- a/esr-mgr/src/test/resources/sql/extsys-resource-createObj-mysql.sql +++ /dev/null @@ -1,71 +0,0 @@ --- --- Copyright 2016 ZTE Corporation. --- --- Licensed under the Apache License, Version 2.0 (the "License"); --- you may not use this file except in compliance with the License. --- You may obtain a copy of the License at --- --- http://www.apache.org/licenses/LICENSE-2.0 --- --- Unless required by applicable law or agreed to in writing, software --- distributed under the License is distributed on an "AS IS" BASIS, --- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. --- See the License for the specific language governing permissions and --- limitations under the License. --- - -DROP TABLE IF EXISTS extsys_base_table; -CREATE TABLE extsys_base_table ( - ID VARCHAR(200) NOT NULL, - NAME VARCHAR(200) NULL, - TYPE VARCHAR(200) NULL, - VENDOR VARCHAR(100) NULL, - VERSION VARCHAR(100) NULL, - DESCRIPTION VARCHAR(100) NULL, - CREATETIME VARCHAR(200) NULL, - CATAGORY VARCHAR(200) NULL, - CONSTRAINT extsys_base_table PRIMARY KEY(ID) -); -DROP TABLE IF EXISTS extsys_ems_table; -CREATE TABLE extsys_ems_table ( - EMSID VARCHAR(200) NOT NULL, - URL VARCHAR(100) NULL, - PRODUCTNAME VARCHAR(100) NULL, - USERNAME VARCHAR(100) NULL, - PASSWORD VARCHAR(100) NULL, - CONSTRAINT extsys_ems_table PRIMARY KEY(EMSID) -); - -DROP TABLE IF EXISTS extsys_sdnc_table; -CREATE TABLE extsys_sdnc_table ( - SDNCONTROLLERID VARCHAR(200) NOT NULL, - URL VARCHAR(100) NULL, - USERNAME VARCHAR(100) NULL, - PASSWORD VARCHAR(100) NULL, - PRODUCTNAME VARCHAR(100) NULL, - PROTOCOL VARCHAR(100) NULL, - CONSTRAINT extsys_sdnc_table PRIMARY KEY(SDNCONTROLLERID) -); - -DROP TABLE IF EXISTS extsys_vim_table; -CREATE TABLE extsys_vim_table ( - VIMID VARCHAR(200) NOT NULL, - URL VARCHAR(100) NULL, - USERNAME VARCHAR(100) NULL, - PASSWORD VARCHAR(100) NULL, - DOMAIN VARCHAR(100) NULL, - TENANT VARCHAR(100) NULL, - CONSTRAINT extsys_vim_table PRIMARY KEY(VIMID) -); - -DROP TABLE IF EXISTS extsys_vnfm_table; -CREATE TABLE extsys_vnfm_table ( - VNFMID VARCHAR(200) NOT NULL, - URL VARCHAR(200) NULL, - USERNAME VARCHAR(100) NULL, - PASSWORD VARCHAR(100) NULL, - VIMID VARCHAR(100) NULL, - CERTIFICATEURL VARCHAR(200) NULL, - CONSTRAINT extsys_vnfm_table PRIMARY KEY(VNFMID) -); - |