adapters/mso-requests-db-adapter/src/main/resources/db/migration/V6.1.1__Add_Instance_NFVO_Mapping_Table.sql


1
2
3
4
5
6
7
8
9
10
11
12

use requestdb;

CREATE TABLE `instance_nfvo_mapping` (
  `INSTANCE_ID` varchar(256) NOT NULL,
  `NFVO_NAME` varchar(256) DEFAULT NULL,
  `ENDPOINT` varchar(256) DEFAULT NULL,
  `USERNAME` varchar(256) DEFAULT NULL,
  `PASSWORD` varchar(256) DEFAULT NULL,
  `API_ROOT` varchar(256) DEFAULT NULL,
  `JOB_ID` varchar(256) DEFAULT NULL,
  PRIMARY KEY (`INSTANCE_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;