adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V2.7__VNFCInstanceGroup1806.sql

   1 use catalogdb;
   2
   3 CREATE TABLE IF NOT EXISTS `catalogdb`.`collection_resource_instance_group_customization` (
   4   `COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID` VARCHAR(200) NOT NULL,
   5   `INSTANCE_GROUP_MODEL_UUID` VARCHAR(200) NOT NULL,
   6   `FUNCTION` VARCHAR(200) NULL,
   7   `DESCRIPTION` VARCHAR(1200) NULL,
   8   `SUBINTERFACE_NETWORK_QUANTITY` INT(11) NULL,
   9   `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  10   PRIMARY KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`, `INSTANCE_GROUP_MODEL_UUID`),
  11   INDEX `fk_collection_resource_instance_group_customization__instan_idx` (`INSTANCE_GROUP_MODEL_UUID` ASC),
  12   CONSTRAINT `fk_collection_resource_instance_group_customization__collecti1`
  13     FOREIGN KEY (`COLLECTION_RESOURCE_CUSTOMIZATION_MODEL_UUID`)
  14     REFERENCES `catalogdb`.`collection_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
  15     ON DELETE CASCADE
  16     ON UPDATE CASCADE,
  17   CONSTRAINT `fk_collection_resource_instance_group_customization__instance1`
  18     FOREIGN KEY (`INSTANCE_GROUP_MODEL_UUID`)
  19     REFERENCES `catalogdb`.`instance_group` (`MODEL_UUID`)
  20     ON DELETE CASCADE
  21     ON UPDATE CASCADE)
  22 ENGINE = InnoDB
  23 DEFAULT CHARACTER SET = latin1;
  24
  25 CREATE TABLE IF NOT EXISTS `catalogdb`.`vnfc_instance_group_customization` (
  26   `VNF_RESOURCE_CUSTOMIZATION_MODEL_UUID` VARCHAR(200) NOT NULL,
  27   `INSTANCE_GROUP_MODEL_UUID` VARCHAR(200) NOT NULL,
  28   `FUNCTION` VARCHAR(200) NULL,
  29   `DESCRIPTION` VARCHAR(1200) NULL,
  30   `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31   PRIMARY KEY (`VNF_RESOURCE_CUSTOMIZATION_MODEL_UUID`, `INSTANCE_GROUP_MODEL_UUID`),
  32   INDEX `fk_vnfc_instance_group_customization__instance_group1_idx` (`INSTANCE_GROUP_MODEL_UUID` ASC),
  33   CONSTRAINT `fk_vnfc_instance_group_customization__vnf_resource_customizat1`
  34     FOREIGN KEY (`VNF_RESOURCE_CUSTOMIZATION_MODEL_UUID`)
  35     REFERENCES `catalogdb`.`vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`)
  36     ON DELETE CASCADE
  37     ON UPDATE CASCADE,
  38   CONSTRAINT `fk_vnfc_instance_group_customization__instance_group1`
  39     FOREIGN KEY (`INSTANCE_GROUP_MODEL_UUID`)
  40     REFERENCES `catalogdb`.`instance_group` (`MODEL_UUID`)
  41     ON DELETE CASCADE
  42     ON UPDATE CASCADE)
  43 ENGINE = InnoDB
  44 DEFAULT CHARACTER SET = latin1;
  45
  46 Alter TABLE `instance_group`
  47 DROP COLUMN  `function`,
  48 DROP COLUMN  `description`,
  49 CHANGE `primary_type` `object_type` varchar(200) NOT NULL,
  50 MODIFY  `tosca_node_type` varchar(200) NULL;
  51
  52 Alter TABLE `collection_resource_customization`
  53 DROP COLUMN  `subinterface_network_quantity`,
  54 CHANGE `primary_type` `object_type` varchar(200) NOT NULL,
  55 MODIFY  role varchar(200) NULL,
  56 MODIFY function varchar(200)  NULL,
  57 MODIFY collection_resource_type varchar(200) NULL;