diff options
author | 2020-11-03 09:30:25 -0500 | |
---|---|---|
committer | 2020-11-03 09:30:25 -0500 | |
commit | b2ec6199c755d31701a75361cb8b73722027c646 (patch) | |
tree | 1b325f44adefac07a9e2e34f14aa1f093baefb61 /ms/generic-resource-api/src/main/resources/schema-mysql.sql | |
parent | 370f5fe6f8c90bb35a9529f19d862e63a2cf8b9d (diff) |
Fix data configuration
Update preloaded test data in GRA microservice to use data created
from TOSCA model load. Also, install missing properties file
used by GRA directed graphs.
Change-Id: I494a80e36f79e3f981b1fe95d16ae9d7314a8c43
Issue-ID: SDNC-1405
Signed-off-by: Dan Timoney <dtimoney@att.com>
Diffstat (limited to 'ms/generic-resource-api/src/main/resources/schema-mysql.sql')
-rw-r--r-- | ms/generic-resource-api/src/main/resources/schema-mysql.sql | 16 |
1 files changed, 10 insertions, 6 deletions
diff --git a/ms/generic-resource-api/src/main/resources/schema-mysql.sql b/ms/generic-resource-api/src/main/resources/schema-mysql.sql index ee3b997..90e4ca7 100644 --- a/ms/generic-resource-api/src/main/resources/schema-mysql.sql +++ b/ms/generic-resource-api/src/main/resources/schema-mysql.sql @@ -427,7 +427,7 @@ CREATE TABLE IF NOT EXISTS `COUNTRY_ASN_MAPPING` ( -- Table structure for table `CUSTOMER2CONNECTION_MAPPING` -- -CREATE TABLE `CUSTOMER2CONNECTION_MAPPING` ( +CREATE TABLE IF NOT EXISTS `CUSTOMER2CONNECTION_MAPPING` ( `customer2connection_id` int(11) NOT NULL AUTO_INCREMENT, `service_instance_id` varchar(80) NOT NULL, `instance_type` varchar(20) NOT NULL, @@ -1243,7 +1243,6 @@ CREATE TABLE IF NOT EXISTS `SERVICE_MODEL` ( PRIMARY KEY (`service_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; - -- -- Table structure for table `NETWORK_MODEL` -- @@ -1279,8 +1278,7 @@ CREATE TABLE IF NOT EXISTS `NETWORK_MODEL` ( `eipam_v6_address_plan` varchar(255) DEFAULT NULL, `version` varchar(255) DEFAULT NULL, PRIMARY KEY (`customization_uuid`), - KEY `FK_NETWORK_MODEL` (`service_uuid`), - CONSTRAINT `FK_NETWORK_MODEL` FOREIGN KEY (`service_uuid`) REFERENCES `SERVICE_MODEL` (`service_uuid`) ON DELETE NO ACTION ON UPDATE NO ACTION + KEY `FK_NETWORK_MODEL` (`service_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- @@ -2053,6 +2051,7 @@ CREATE TABLE IF NOT EXISTS `VFC_MODEL` ( -- Table structure for table `VFC_TO_NETWORK_ROLE_MAPPING` -- + CREATE TABLE IF NOT EXISTS `VFC_TO_NETWORK_ROLE_MAPPING` ( `seq` int(11) NOT NULL AUTO_INCREMENT, `vfc_customization_uuid` varchar(255) NOT NULL, @@ -2076,7 +2075,7 @@ CREATE TABLE IF NOT EXISTS `VFC_TO_NETWORK_ROLE_MAPPING` ( `subinterface_indicator` char(1) DEFAULT NULL, PRIMARY KEY (`seq`), KEY `IX1_VFC_TO_NETWORK_ROLE_MAPPING` (`vfc_customization_uuid`) -) ENGINE=InnoDB AUTO_INCREMENT=1791 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=2063 DEFAULT CHARSET=latin1; -- -- Table structure for table `VF_MODEL` @@ -2098,6 +2097,9 @@ CREATE TABLE IF NOT EXISTS `VF_MODEL` ( `nf_role` varchar(255) DEFAULT NULL, `vendor` varchar(255) DEFAULT NULL, `vendor_version` varchar(255) DEFAULT NULL, + `sdnc_model_name` varchar(255) DEFAULT NULL, + `sdnc_model_version` varchar(255) DEFAULT NULL, + `sdnc_artifact_name` varchar(255) DEFAULT NULL, PRIMARY KEY (`customization_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -2114,6 +2116,8 @@ CREATE TABLE IF NOT EXISTS `VF_MODULE_MODEL` ( `vf_module_type` varchar(255) DEFAULT NULL, `availability_zone_count` int(11) DEFAULT NULL, `ecomp_generated_vm_assignments` char(1) DEFAULT NULL, + `vf_customization_uuid` varchar(255) DEFAULT NULL, + `vf_module_label` varchar(255) DEFAULT NULL, PRIMARY KEY (`customization_uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; @@ -2129,7 +2133,7 @@ CREATE TABLE IF NOT EXISTS `VF_MODULE_TO_VFC_MAPPING` ( `vm_count` int(11) NOT NULL, PRIMARY KEY (`seq`), KEY `IX1_VF_MODULE_TO_VFC_MAPPING` (`vf_module_customization_uuid`) -) ENGINE=InnoDB AUTO_INCREMENT=1591 DEFAULT CHARSET=latin1; +) ENGINE=InnoDB AUTO_INCREMENT=1711 DEFAULT CHARSET=latin1; -- -- Table structure for table `VF_TO_NETWORK_ROLE_MAPPING` |