diff options
| author |   Rob Daugherty <rd472p@att.com> | 2017-10-05 11:13:00 -0400 |
|---|---|---|
| committer | Rob Daugherty <rd472p@att.com> | 2017-10-05 11:23:44 -0400 |
| commit | 6e27afe506decbcf42ebf6579129dde9931ef179 (patch) | |
| tree | 25d591d963070bb0f7e833644b30b77a87457d00 /volumes/mariadb | |
| parent | c91c30eebf37f69f9bec65a83252638a3b855b90 (diff) | |
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 <rd472p@att.com>
Diffstat (limited to 'volumes/mariadb')
| -rw-r--r-- | volumes/mariadb/docker-entrypoint-initdb.d/db-sql-scripts/main-schemas/MySQL-Catalog-schema.sql | 9 |
1 files changed, 0 insertions, 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); |