From 6e27afe506decbcf42ebf6579129dde9931ef179 Mon Sep 17 00:00:00 2001 From: Rob Daugherty Date: Thu, 5 Oct 2017 11:13:00 -0400 Subject: [PATCH] Remove foreign key which is not supported by code The foreign key we fixed in the VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM table is blocking distribution of the model. The insert that's failing is: insert into VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM ( VNF_RESOURCE_CUST_MODEL_CUSTOMIZATION_UUID, VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID) values (?, ?); The error is: "foreign key constraint fails" Issue: SO-180 Change-Id: I19cda2d4dae86e3257723f0fea6921049e391aca Signed-off-by: Rob Daugherty --- .../db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 9 --------- 1 file changed, 9 deletions(-) diff --git a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql index 7503fa6..836b3f9 100644 --- a/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql +++ b/volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql @@ -27,10 +27,6 @@ drop foreign key FK_iff1ayhb1hrp5jhea3vvikuni; - alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM - drop - foreign key FK_4p0consmgggrkf4qj1onx8g5j; - drop table if exists ALLOTTED_RESOURCE; drop table if exists ALLOTTED_RESOURCE_CUSTOMIZATION; @@ -464,8 +460,3 @@ add constraint FK_iff1ayhb1hrp5jhea3vvikuni foreign key (VNF_RESOURCE_MODEL_UUID) references VNF_RESOURCE (MODEL_UUID); - - alter table VNF_RES_CUSTOM_TO_VF_MODULE_CUSTOM - add constraint FK_4p0consmgggrkf4qj1onx8g5j - foreign key (VF_MODULE_CUST_MODEL_CUSTOMIZATION_UUID) - references VNF_RESOURCE_CUSTOMIZATION (MODEL_CUSTOMIZATION_UUID); -- 2.16.6