Answers.Body: <p>I think you're right - good catch. See <a href="https://github.com/civicrm/civicrm-core/pull/19802" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/19802</a></p>
  <p>FYI in my database there isn't a restriction for uniqueness for the abbreviation field - the unique constraint is defined here: <a href="https://github.com/civicrm/civicrm-core/blob/da28128b812d4ae53c52abd8073656c61bbc4cc7/xml/schema/Core/StateProvince.xml#L70-L74" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/blob/da28128b812d4ae53c52abd8073656c61bbc4cc7/xml/schema/Core/StateProvince.xml#L70-L74</a> and it's <code>name</code> and <code>country_id</code>.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2021-03-14T19:30:04.017Z
Answers.LastActivityDate: 2021-03-14T19:39:20.490Z
Answers.LastEditDate: 2021-03-14T19:39:20.490Z
Answers.UserDisplayName: Demerit
Body: <p>It seems that a bug must first be reported here before is can be reported as bug.
  I use version 5.35.0 Joomla, but the error is created in version 5.31.alpha1.</p>
  <p>In the table the combination 'abbrevation' and 'country_id' must be unique. But the abbrevation for Carmarthenshire must be 'CMN' (wikipedia.org ISO_3166-2:GB) en not 'CRF', that is 'Cardiff'.
  (See: civicrm_state_province.tpl, 5.31.alpha1.mysql.tpl)
  I found this little copy-error when i tried to import the database with phpmyadmin.</p>
  
Tags: <upgrade>
Title: Error in table state_province for Wales
ThreadText: # Error in table state_province for Wales
  
  (Asked by: username_0 on 2021-03-14)
  
  It seems that a bug must first be reported here before is can be reported as bug.
  I use version 5.35.0 Joomla, but the error is created in version 5.31.alpha1.
  
  In the table the combination 'abbrevation' and 'country\_id' must be unique. But the abbrevation for Carmarthenshire must be 'CMN' (wikipedia.org ISO\_3166-2:GB) en not 'CRF', that is 'Cardiff'.
  (See: civicrm\_state\_province.tpl, 5.31.alpha1.mysql.tpl)
  I found this little copy-error when i tried to import the database with phpmyadmin.
  
  **Tags:** upgrade
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2021-03-14. Score: 1
  
  I think you're right - good catch. See <https://github.com/civicrm/civicrm-core/pull/19802>
  
  FYI in my database there isn't a restriction for uniqueness for the abbreviation field - the unique constraint is defined here: <https://github.com/civicrm/civicrm-core/blob/da28128b812d4ae53c52abd8073656c61bbc4cc7/xml/schema/Core/StateProvince.xml#L70-L74> and it's `name` and `country_id`.
  
  
  ---
  
  