adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V4.4__CreateTableControllerSelectionRefence.sql

   1 use catalogdb;
   2
   3 CREATE TABLE IF NOT EXISTS `controller_selection_reference` (
   4   `VNF_TYPE` VARCHAR(50) NOT NULL,
   5   `CONTROLLER_NAME` VARCHAR(100) NOT NULL,
   6   `ACTION_CATEGORY` VARCHAR(15) NOT NULL,
   7   PRIMARY KEY (`VNF_TYPE`, `CONTROLLER_NAME`, `ACTION_CATEGORY`)
   8   ) ENGINE = InnoDB DEFAULT CHARSET=latin1;