--
-- Update the imported customer addresses with the new region ID's
--
update customer_address_entity cae
set region_id = (select dcr.region_id
                  from directory_country_region dcr
                  where dcr.country_id = 'AU'
                    and dcr.default_name = cae.region);
