adapters/mso-catalog-db-adapter/src/main/resources/db/migration/V5.5.1__Correct_Default_NeutronNetwork.sql

   1 USE catalogdb;
   2 DELETE FROM temp_network_heat_template_lookup WHERE HEAT_TEMPLATE_ARTIFACT_UUID = 'efee1d84-b8ec-11e7-abc4-cec278b6b50a';
   3 DELETE FROM heat_template WHERE ARTIFACT_UUID = 'efee1d84-b8ec-11e7-abc4-cec278b6b50a';
   4 INSERT INTO `heat_template` (`ARTIFACT_UUID`,`NAME`,`VERSION`,`BODY`,`TIMEOUT_MINUTES`,`DESCRIPTION`,`CREATION_TIMESTAMP`,`ARTIFACT_CHECKSUM`) VALUES
   5 ('efee1d84-b8ec-11e7-abc4-cec278b6b50a','Generic NeutronNet','1','
   6 heat_template_version: 2013-05-23
   7 description: A simple Neutron network
   8 parameters:
   9   network_name:
  10     type: string
  11     description: Name of the Neutron Network
  12     default: ONAP-NW1
  13   shared:
  14     type: boolean
  15     description: Shared amongst tenants
  16     default: False
  17 outputs:
  18   network_id:
  19     description: Openstack network identifier
  20     value: { get_resource: network }
  21 resources:
  22   network:
  23     type: OS::Neutron::Net
  24     properties:
  25       name: { get_param: network_name }
  26       shared: { get_param: shared }',10,'Generic Neutron Template','2017-10-26 14:44:00', 'MANUAL RECORD');
  27
  28
  29
  30 INSERT INTO `temp_network_heat_template_lookup` (`NETWORK_RESOURCE_MODEL_NAME`, `HEAT_TEMPLATE_ARTIFACT_UUID`,`AIC_VERSION_MIN` , `AIC_VERSION_MAX` )
  31 VALUES ('Generic NeutronNet','efee1d84-b8ec-11e7-abc4-cec278b6b50a','2.0','3.0');
  32