adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V8.4__AddBBNameSelectionReference.sql

   1 use catalogdb;
   2
   3 CREATE TABLE IF NOT EXISTS `bbname_selection_reference` (
   4   `ID` INT(11) NOT NULL AUTO_INCREMENT,
   5   `CONTROLLER_ACTOR` varchar(200) NOT NULL ,
   6   `SCOPE` varchar(200) NOT NULL,
   7   `ACTION` varchar(200) NOT NULL,
   8   `BB_NAME` varchar(200) NOT NULL,
   9   PRIMARY KEY (`ID`)
  10 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  11
  12 INSERT INTO bbname_selection_reference (CONTROLLER_ACTOR,SCOPE,ACTION,BB_NAME)
  13 VALUES
  14 ('APPC', 'vfModule', 'healthCheck','GenericVnfHealthCheckBB'),
  15 ('APPC', 'vfModule', 'configScaleOut','ConfigurationScaleOutBB'),
  16 ('APPC', 'vnf', 'healthCheck','GenericVnfHealthCheckBB');