CRM/Upgrade/Incremental/sql/3.1.beta6.mysql.tpl

   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;