Remove the tag from esr-server.

[aai/esr-server.git] / esr-core / distribution / standalone / src / main / assembly / dbscripts / mysql / openo-common-extsys-createobj.sql

diff --git a/esr-core/distribution/standalone/src/main/assembly/dbscripts/mysql/openo-common-extsys-createobj.sql b/esr-core/distribution/standalone/src/main/assembly/dbscripts/mysql/openo-common-extsys-createobj.sql
deleted file mode 100644 (file)
index 73f2ea0..0000000
--- a/esr-core/distribution/standalone/src/main/assembly/dbscripts/mysql/openo-common-extsys-createobj.sql
+++ /dev/null
@@ -1,91 +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 old database and user***************************/
-use mysql;
-drop database IF  EXISTS extsys;
-delete from user where User='extsys';
-FLUSH PRIVILEGES;
-
-/******************create new database and user***************************/
-create database extsys CHARACTER SET utf8;
-
-GRANT ALL PRIVILEGES ON extsys.* TO 'extsys'@'%' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'extsys'@'%' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
-
-GRANT ALL PRIVILEGES ON extsys.* TO 'extsys'@'localhost' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'extsys'@'localhost' IDENTIFIED BY 'extsys' WITH GRANT OPTION;
-FLUSH PRIVILEGES;
-
-use extsys;
-set Names 'utf8';
-/******************drop old table and create new***************************/
-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)
-);
-
-