3 DROP TABLE vnf_vfmodule_cvnfc_configuration_customization;
5 CREATE TABLE IF NOT EXISTS vnf_vfmodule_cvnfc_configuration_customization (
6 `ID` INT(11) NOT NULL AUTO_INCREMENT,
7 `MODEL_CUSTOMIZATION_UUID` VARCHAR(200) NOT NULL,
8 `MODEL_INSTANCE_NAME` VARCHAR(200) NOT NULL,
9 `CONFIGURATION_TYPE` VARCHAR(200) NULL,
10 `CONFIGURATION_ROLE` VARCHAR(200) NULL,
11 `CONFIGURATION_FUNCTION` VARCHAR(200) NULL,
12 `POLICY_NAME` VARCHAR(200) NULL,
13 `CREATION_TIMESTAMP` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
14 `CONFIGURATION_MODEL_UUID` VARCHAR(200) NOT NULL,
15 `VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) DEFAULT NULL,
16 `VF_MODULE_MODEL_CUSTOMIZATION_UUID` VARCHAR(200) DEFAULT NULL,
17 `CVNFC_CUSTOMIZATION_ID` INT(11) DEFAULT NULL,
19 INDEX `fk_vnf_vfmodule_cvnfc_config_cust__configuration_idx` (`CONFIGURATION_MODEL_UUID` ASC),
21 CONSTRAINT `fk_vnf_vfmod_cvnfc_config_cust__configuration_resource` FOREIGN KEY (`CONFIGURATION_MODEL_UUID`)
22 REFERENCES `configuration` (`MODEL_UUID`) ON DELETE CASCADE ON UPDATE CASCADE
23 ) ENGINE = INNODB AUTO_INCREMENT = 20654 DEFAULT CHARACTER SET = LATIN1;