aboutsummaryrefslogtreecommitdiffstats
path: root/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
diff options
context:
space:
mode:
authorwaqas.ikram <waqas.ikram@est.tech>2021-02-18 15:01:28 +0000
committerwaqas.ikram <waqas.ikram@est.tech>2021-02-18 15:07:11 +0000
commit708e8a0a2a38d72d274e65794411a3ef1e241069 (patch)
treea284a5052c45402b706c4f5acf2bd6ef512973d1 /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
parent4005922ca75a2e373d12ac264a889f76029fb38e (diff)
Removing so-etsi-nfvo module
Change-Id: I5ab5d409bad26abd83b2d8338c4c5ab5fa6be97c Issue-ID: SO-3485 Signed-off-by: waqas.ikram <waqas.ikram@est.tech>
Diffstat (limited to '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')
-rw-r--r--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.sql70
1 files changed, 0 insertions, 70 deletions
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;