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

   1 USE catalogdb;
   2
   3 CREATE TABLE IF NOT EXISTS vnfc_customization (
   4 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
   5 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
   6 `MODEL_UUID` VARCHAR(200) NOT NULL,
   7 `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
   8 `MODEL_VERSION` VARCHAR(20) NOT NULL,
   9 `MODEL_NAME` VARCHAR(200) NOT NULL,
  10 `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
  11 `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
  12 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  13 PRIMARY KEY (`MODEL_CUSTOMIZATION_UUID`))
  14 ENGINE = InnoDB
  15 AUTO_INCREMENT = 20654
  16 DEFAULT CHARACTER SET = latin1;
  17
  18 CREATE TABLE IF NOT EXISTS cvnfc_customization (
  19   `ID` INT(11) NOT NULL AUTO_INCREMENT,
  20   `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  21   `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
  22   `MODEL_UUID` VARCHAR(200) NOT NULL,
  23   `MODEL_INVARIANT_UUID` VARCHAR(200) NOT NULL,
  24   `MODEL_VERSION` VARCHAR(20) NOT NULL,
  25   `MODEL_NAME` VARCHAR(200) NOT NULL,
  26   `TOSCA_NODE_TYPE` VARCHAR(200) NOT NULL,
  27   `DESCRIPTION` VARCHAR(1200) NULL DEFAULT NULL,
  28   `NFC_FUNCTION` VARCHAR(200) NULL,
  29   `NFC_NAMING_CODE` VARCHAR(200) NULL,
  30   `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31   `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  32   `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  33   `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  34   PRIMARY KEY (`ID`),
  35   INDEX `fk_cvnfc_customization__vf_module_customization1_idx` (
  36     `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC
  37   ),
  38   INDEX `fk_cvnfc_customization__vnfc_customization1_idx` (
  39     `VNFC_CUST_MODEL_CUSTOMIZATION_UUID` ASC
  40   ),
  41   INDEX `fk_cvnfc_customization__vnf_resource_customization1_idx` (
  42     `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC
  43   ),
  44   UNIQUE INDEX `UK_cvnfc_customization` (
  45     `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC,
  46     `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID` ASC,
  47     `MODEL_CUSTOMIZATION_UUID` ASC
  48   ),
  49   INDEX `fk_cvnfc_customization__vnf_vfmod_cvnfc_config_cust1_idx` (`MODEL_CUSTOMIZATION_UUID` ASC),
  50   CONSTRAINT `fk_cvnfc_customization__vf_module_customization1` FOREIGN KEY (
  51     `VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID`
  52   ) REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
  53     CONSTRAINT `fk_cvnfc_customization__vnfc_customization1` FOREIGN KEY (
  54       `VNFC_CUST_MODEL_CUSTOMIZATION_UUID`
  55     ) REFERENCES `vnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
  56     CONSTRAINT `fk_cvnfc_customization__vnf_resource_customization1` FOREIGN KEY (
  57       `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`
  58     ) REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
  59 ) ENGINE = InnoDB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = latin1;
  60
  61 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
  62   `ID` INT(11) NOT NULL AUTO_INCREMENT,
  63   `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  64   `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  65   `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  66   `CVNFC_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
  67   `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
  68   `CONFIGURATION_TYPE` VARCHAR(200) NULL,
  69   `CONFIGURATION_ROLE` VARCHAR(200) NULL,
  70   `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
  71   `POLICY_NAME` VARCHAR(200) NULL,
  72   `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  73   `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
  74   PRIMARY KEY (`ID`),
  75   INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
  76   UNIQUE INDEX `UK_vnf_vfmodule_cvnfc_configuration_customization` (
  77     `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC,
  78     `VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC,
  79     `CVNFC_MODEL_CUSTOMIZATION_UUID` ASC,
  80     `MODEL_CUSTOMIZATION_UUID` ASC
  81   ),
  82   INDEX `fk_vnf_vfmodule_cvnfc_config_cust__cvnfc_cust1_idx` (
  83     `CVNFC_MODEL_CUSTOMIZATION_UUID` ASC
  84   ),
  85   INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vf_module_cust_idx` (
  86     `VF_MODULE_MODEL_CUSTOMIZATION_UUID` ASC
  87   ),
  88   INDEX `fk_vnf_vfmodule_cvnfc_config_cust__vnf_res_cust_idx` (
  89     `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` ASC
  90   ),
  91   CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`) REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
  92   CONSTRAINT `fk_cvnfc_configuration_customization__cvnfc_customization1` FOREIGN KEY (
  93     `CVNFC_MODEL_CUSTOMIZATION_UUID`
  94   ) REFERENCES `cvnfc_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
  95   CONSTRAINT `fk_vnf_configuration_cvnfc_customization__vf_module_customiza1` FOREIGN KEY (
  96     `VF_MODULE_MODEL_CUSTOMIZATION_UUID`
  97   ) REFERENCES `vf_module_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE,
  98   CONSTRAINT `fk_vfmodule_cvnfc_configuration_customization__vnf_resource_c1` FOREIGN KEY (
  99     `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID`
 100   ) REFERENCES `vnf_resource_customization` (`MODEL_CUSTOMIZATION_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
 101 ) ENGINE = INNODB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = LATIN1;