do $$
declare
  csr_name_central character varying := 'WELKTXEF-ROUTER-000004';
  cluster_name_central character varying := 'welktxef-c000004-001';
  ilo_hostname_central character varying := 'welktxef-000004-rh-p30e910-001';
  oam_vip_hostname_central character varying := 'welktxef-000004-nh-pe1e910-001';
  ilo_gateway_address_central character varying := '2607:f160:10:9051:ce:23::';
  ilo_subnet_central character varying := '2607:f160:10:9051::';
  oam_subnet_central character varying := '2607:f160:10:9051::';
  oam_gateway_address_central character varying := ilo_gateway_address_central;
  oam_floating_address_central character varying := '2607:f160:10:9051:ce:290:0:1000';
  mgmt_start_address_central character varying := '2607:f160:10:9050:ce:290::';
  mgmt_end_address_central character varying := '2607:f160:10:9050:ce:290:0:f';
  mgmt_subnet_central character varying := '2607:f160:10:9050::';
  mgmt_gateway_address_central character varying := '2607:f160:10:9050:ce:23::';

  oam_hostname_central character varying := 'welktxef-000004-nh-pe2e910-001';
  ilo_host_address_central character varying := '2607:f160:10:9221:ce:fe0:0:800b';
  oam_host_address_central character varying := '2607:f160:10:9051:ce:290:0:1001';
begin
  update caas_cellsiterouter
  set ilo_subnet = ilo_subnet_central
  where csr_hostname = csr_name_central;

  update caas_cellsiterouter
  set ilo_default_gateway = ilo_gateway_address_central
  where csr_hostname = csr_name_central;

  update caas_cellsiterouter
  set oam_subnet = oam_subnet_central
  where csr_hostname = csr_name_central;

  update caas_cellsiterouter
  set oam_default_gateway = oam_gateway_address_central
  where csr_hostname = csr_name_central;

  update caas_cellsiterouter
  set mgmt_subnet = mgmt_subnet_central
  where csr_hostname = csr_name_central;

  update caas_cellsiterouter
  set mgmt_default_gateway = mgmt_gateway_address_central
  where csr_hostname = csr_name_central;

  update caas_cluster
  set oam_vip_hostname = oam_vip_hostname_central
  where cluster_name = cluster_name_central;

  update caas_cluster
  set oam_vip_address = oam_floating_address_central
  where cluster_name = cluster_name_central;

  update caas_cluster
  set mgmt_address_range_start = mgmt_start_address_central
  where cluster_name = cluster_name_central;

  update caas_cluster
  set mgmt_address_range_end = mgmt_end_address_central
  where cluster_name = cluster_name_central;

  update caas_server
  set oam_hostname = oam_hostname_central
  where ilo_hostname = ilo_hostname_central;

  update caas_server
  set oam_host_address = oam_host_address_central
  where ilo_hostname = ilo_hostname_central;

  update caas_server
  set ilo_host_address = ilo_host_address_central
  where ilo_hostname = ilo_hostname_central;
end $$;