[civicrm-core.git] / CRM / Upgrade / Incremental / sql / 3.1.beta6.mysql.tpl

-- CRM-5670
-- Tyne and Wear
UPDATE civicrm_state_province SET abbreviation = 'TWR' WHERE id =  9986;
-- Greater Manchester
UPDATE civicrm_state_province SET abbreviation = 'GTM' WHERE id =  9988;
-- Co Tyrone
UPDATE civicrm_state_province SET abbreviation = 'TYR' WHERE id =  9989;
-- West Yorkshire
UPDATE civicrm_state_province SET abbreviation = 'WYK' WHERE id =  9990;
-- South Yorkshire
UPDATE civicrm_state_province SET abbreviation = 'SYK' WHERE id =  9991;
-- Merseyside
UPDATE civicrm_state_province SET abbreviation = 'MSY' WHERE id =  9992;
-- Berkshire
UPDATE civicrm_state_province SET abbreviation = 'BRK' WHERE id =  9993;
-- West Midlands
UPDATE civicrm_state_province SET abbreviation = 'WMD' WHERE id =  9994;
-- West Glamorgan
UPDATE civicrm_state_province SET abbreviation = 'WGM' WHERE id =  9998;
-- Greater London
UPDATE civicrm_state_province SET abbreviation = 'LON' WHERE id =  9999;
-- Clwyd
UPDATE civicrm_state_province SET abbreviation = 'CWD' WHERE id = 10013;
-- Dyfed
UPDATE civicrm_state_province SET abbreviation = 'DFD' WHERE id = 10014;
-- South Glamorgan
UPDATE civicrm_state_province SET abbreviation = 'SGM' WHERE id = 10015;
Commit	Line	Data
6a488035 TO	1	-- CRM-5670
	2	-- Tyne and Wear
	3	UPDATE civicrm_state_province SET abbreviation = 'TWR' WHERE id = 9986;
	4	-- Greater Manchester
	5	UPDATE civicrm_state_province SET abbreviation = 'GTM' WHERE id = 9988;
	6	-- Co Tyrone
	7	UPDATE civicrm_state_province SET abbreviation = 'TYR' WHERE id = 9989;
	8	-- West Yorkshire
	9	UPDATE civicrm_state_province SET abbreviation = 'WYK' WHERE id = 9990;
	10	-- South Yorkshire
	11	UPDATE civicrm_state_province SET abbreviation = 'SYK' WHERE id = 9991;
	12	-- Merseyside
	13	UPDATE civicrm_state_province SET abbreviation = 'MSY' WHERE id = 9992;
	14	-- Berkshire
	15	UPDATE civicrm_state_province SET abbreviation = 'BRK' WHERE id = 9993;
	16	-- West Midlands
	17	UPDATE civicrm_state_province SET abbreviation = 'WMD' WHERE id = 9994;
	18	-- West Glamorgan
	19	UPDATE civicrm_state_province SET abbreviation = 'WGM' WHERE id = 9998;
	20	-- Greater London
	21	UPDATE civicrm_state_province SET abbreviation = 'LON' WHERE id = 9999;
	22	-- Clwyd
	23	UPDATE civicrm_state_province SET abbreviation = 'CWD' WHERE id = 10013;
	24	-- Dyfed
	25	UPDATE civicrm_state_province SET abbreviation = 'DFD' WHERE id = 10014;
	26	-- South Glamorgan
	27	UPDATE civicrm_state_province SET abbreviation = 'SGM' WHERE id = 10015;