From 708e8a0a2a38d72d274e65794411a3ef1e241069 Mon Sep 17 00:00:00 2001
From: "waqas.ikram" <waqas.ikram@est.tech>
Date: Thu, 18 Feb 2021 15:01:28 +0000
Subject: Removing so-etsi-nfvo module

Change-Id: I5ab5d409bad26abd83b2d8338c4c5ab5fa6be97c
Issue-ID: SO-3485
Signed-off-by: waqas.ikram <waqas.ikram@est.tech>
---
 .../db/migration/V1_1__create_nfvo_tables.sql      | 70 ----------------------
 1 file changed, 70 deletions(-)
 delete mode 100644 so-etsi-nfvo/so-etsi-nfvo-ns-lcm/so-etsi-nfvo-ns-lcm-database-service/src/main/resources/db/migration/V1_1__create_nfvo_tables.sql

(limited to 'so-etsi-nfvo/so-etsi-nfvo-ns-lcm/so-etsi-nfvo-ns-lcm-database-service/src/main/resources/db/migration')

diff --git a/so-etsi-nfvo/so-etsi-nfvo-ns-lcm/so-etsi-nfvo-ns-lcm-database-service/src/main/resources/db/migration/V1_1__create_nfvo_tables.sql b/so-etsi-nfvo/so-etsi-nfvo-ns-lcm/so-etsi-nfvo-ns-lcm-database-service/src/main/resources/db/migration/V1_1__create_nfvo_tables.sql
deleted file mode 100644
index 7f50c791f6..0000000000
--- a/so-etsi-nfvo/so-etsi-nfvo-ns-lcm/so-etsi-nfvo-ns-lcm-database-service/src/main/resources/db/migration/V1_1__create_nfvo_tables.sql
+++ /dev/null
@@ -1,70 +0,0 @@
-use nfvo;
-
-CREATE TABLE IF NOT EXISTS `JOB` (
-  `JOB_ID` varchar(255) PRIMARY KEY NOT NULL,
-  `JOB_TYPE` varchar(255) NOT NULL,
-  `JOB_ACTION` varchar(255) NOT NULL,
-  `RESOURCE_ID` varchar(255) NOT NULL,
-  `RESOURCE_NAME` varchar(255) DEFAULT NULL,
-  `STATUS` varchar(255) NOT NULL,
-  `START_TIME` DATETIME DEFAULT NULL,
-  `END_TIME` DATETIME DEFAULT NULL,
-  `PROGRESS` int(11) DEFAULT NULL,
-  `PROCESS_INSTANCE_ID` varchar(255) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-
-
-CREATE TABLE IF NOT EXISTS `JOB_STATUS` (
-  `ID` INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
-  `UPDATED_TIME` DATETIME NOT NULL,
-  `DESCRIPTION` longtext DEFAULT NULL,
-  `STATUS` varchar(255) NOT NULL,
-  `JOB_ID` varchar(255) NOT NULL,
-  FOREIGN KEY (JOB_ID)
-      REFERENCES JOB(JOB_ID)
-      ON UPDATE CASCADE ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE IF NOT EXISTS `NS_INST` (
-  `NS_INST_ID` varchar(255) PRIMARY KEY NOT NULL,
-  `NAME` varchar(255) NOT NULL,
-  `NS_PACKAGE_ID` varchar(255) DEFAULT NULL,
-  `NSD_ID` varchar(255) NOT NULL,
-  `NSD_INVARIANT_ID` varchar(255) NOT NULL,
-  `DESCRIPTION` longtext DEFAULT NULL,
-  `STATUS` varchar(255) NOT NULL,
-  `STATUS_UPDATED_TIME` DATETIME NOT NULL,
-  `GLOBAL_CUSTOMER_ID` varchar(255) DEFAULT NULL,
-  `SERVICE_TYPE` varchar(255) DEFAULT NULL
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE IF NOT EXISTS `NF_INST` (
-  `NF_INST_ID` varchar(255) PRIMARY KEY NOT NULL,
-  `NAME` varchar(255) DEFAULT NULL,
-  `VNFD_ID` varchar(255) DEFAULT NULL,
-  `PACKAGE_ID` varchar(255) DEFAULT NULL,
-  `NS_INST_ID` varchar(255) NOT NULL,
-  `STATUS` varchar(255) NOT NULL,
-  `CREATE_TIME` DATETIME DEFAULT NULL,
-  `LAST_UPDATE_TIME` DATETIME DEFAULT NULL,
-  FOREIGN KEY (NS_INST_ID)
-      REFERENCES NS_INST(NS_INST_ID)
-	  ON UPDATE CASCADE ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-
-CREATE TABLE IF NOT EXISTS `NS_LCM_OP_OCCS` (
-  `ID` varchar(255) PRIMARY KEY NOT NULL,
-  `OPERATION_STATE` varchar(255) NOT NULL,
-  `STATE_ENTERED_TIME` DATETIME DEFAULT NULL,
-  `START_TIME` DATETIME DEFAULT NULL,
-  `NS_INST_ID` varchar(255) NOT NULL,
-  `OPERATION` varchar(255) NOT NULL,
-  `IS_AUTO_INVOCATION` varchar(255) NOT NULL,
-  `OPERATION_PARAMS` longtext NOT NULL,
-  `IS_CANCEL_PENDING` varchar(255) NOT NULL,
-  `CANCEL_MODE` varchar(255) DEFAULT NULL,
-  FOREIGN KEY (NS_INST_ID)
-      REFERENCES NS_INST(NS_INST_ID)
-	  ON UPDATE CASCADE ON DELETE CASCADE
-) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- 
cgit 1.2.3-korg