Page Comparison

INSERT INTO `directory_country_region` (`region_id`, `country_id`, `code`, `default_name`) VALUES
(NULL, 'NO', '01', 'Østfold'),
(NULL, 'NO', '02', 'Akershus'),
(NULL, 'NO', '03', 'Oslo'),
(NULL, 'NO', '04', 'Hedmark'),
(NULL, 'NO', '05', 'Oppland'),
(NULL, 'NO', '06', 'Buskerud'),
(NULL, 'NO', '07', 'Vestfold'),
(NULL, 'NO', '08', 'Telemark')
;


INSERT INTO directory_country_region_name( locale, region_id, name )
SELECT 'en_US' AS "language", region_id, default_name
FROM `directory_country_region`
WHERE country_id = 'NO';

INSERT INTO directory_country_region_name( locale, region_id, name )
SELECT 'en_US' AS "language", region_id, default_name
FROM `directory_country_region`
WHERE country_id = 'nb_NO';

INSERT INTO directory_country_region_name( locale, region_id, name )
SELECT 'en_US' AS "language", region_id, default_name
FROM `directory_country_region`
WHERE country_id = 'nn_NO';

UPDATE customer_address_entity
SET region_id = (SELECT region_id
FROM directory_country_region
WHERE directory_country_region.default_name = customer_address_entity.region
AND directory_country_region.country_id = customer_address_entity.country_id
)
WHERE (region_id = 0 or ISNULL(region_id))
AND country_id = 'NO';


UPDATE sales_order_address
SET region_id = (SELECT region_id
FROM directory_country_region
WHERE directory_country_region.default_name = sales_order_address.region
AND directory_country_region.country_id = sales_order_address.country_id
)
WHERE (region_id = 0 or ISNULL(region_id))
AND country_id = 'NO';

UPDATE quote_address
SET region_id = (SELECT region_id
FROM directory_country_region
WHERE directory_country_region.default_name = quote_address.region
AND directory_country_region.country_id = quote_address.country_id
)
WHERE (region_id = 0 or ISNULL(region_id))
AND country_id = 'NO';