X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=esr-core%2Fdistribution%2Fstandalone%2Fsrc%2Fmain%2Fassembly%2Fdbscripts%2Fmysql%2Fopeno-common-extsys-createobj.sql;fp=esr-core%2Fdistribution%2Fstandalone%2Fsrc%2Fmain%2Fassembly%2Fdbscripts%2Fmysql%2Fopeno-common-extsys-createobj.sql;h=0000000000000000000000000000000000000000;hb=6b8d734e71fc1677c68d85c9d78c8fa014e2b7d5;hp=73f2ea0f55bd62a3b23eb37c59fa6b83d1eacb5f;hpb=aba957d99b0d0d21c77d80efe98a3450b6635c1a;p=aai%2Fesr-server.git

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
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)
-);
-
-