Answers.Body: <p>In theory you could update this by yourself via SQL.  There are two arguments against this thought:</p>
  
  <ul>
  <li>The ID won't match anyone else's Civi, which could lead to problems with third-party extensions.</li>
  <li>This is a change that the rest of the community can benefit from.</li>
  </ul>
  
  <p>I would file a ticket at issues.civicrm.org.  If you have the chops to create a Github pull request, great!  If not, no worries.  Please be sure to include a reference to sources showing the missing "State", such as <a href="https://en.wikipedia.org/wiki/Local_government_in_Fiji" rel="nofollow">https://en.wikipedia.org/wiki/Local_government_in_Fiji</a>.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-01-17T22:00:51.717Z
Answers.Text: For assistance getting this fix into CiviCRM, there's a chat channel at https://chat.civicrm.org/civicrm/channels/dev-newcomers - you should find someone happy to help you through the process. Hi from Dunedin!
Answers.UserDisplayName: Chris Burgess
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-11T04:42:56.840Z
Answers.Text: Thank you for taking the time to answer my question.  Good advice that i'll follow.. However issues.mayfirst.org doesn't resolve anywhere
Answers.UserDisplayName: AaronS NZ
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-11T05:13:03.190Z
Answers.Text: I think he meant issues.civicrm.org.
Answers.UserDisplayName: Andie Hunt
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2015-08-11T02:23:32.043Z
Answers.LastActivityDate: 2015-08-11T12:55:29.990Z
Answers.LastEditDate: 2015-08-11T12:55:29.990Z
Answers.UserDisplayName: Jon G - Megaphone Tech
Body: <p>Fiji is separated into 5 divisions, however civicrm only includes 4 in the dropdown "State" list.  Here are what the "State" options should be.. </p>
  
  <ul>
  <li>Northern</li>
  <li>Western</li>
  <li>Central (MISSING)</li>
  <li>Eastern</li>
  <li>Rotuma</li>
  </ul>
  
  <p>I am assuming that it would be ok to do
  MySQL> insert into civicrm_state_province(name, abbreviation, country_id) values('Central', 'C', 1074);</p>
  
  <p>Is it OK to do this, and if I do this, what will happen if and when Civicrm updates/upgrades ? </p>
  
  <p>Thanks for your help... </p>
  
Tags: <contacts>
Title: State list for Fiji incomplete
ThreadText: # State list for Fiji incomplete
  
  (Asked by: username_0 on 2015-08-11)
  
  Fiji is separated into 5 divisions, however civicrm only includes 4 in the dropdown "State" list. Here are what the "State" options should be..
  
  * Northern
  * Western
  * Central (MISSING)
  * Eastern
  * Rotuma
  
  I am assuming that it would be ok to do
  MySQL> insert into civicrm\_state\_province(name, abbreviation, country\_id) values('Central', 'C', 1074);
  
  Is it OK to do this, and if I do this, what will happen if and when Civicrm updates/upgrades ?
  
  Thanks for your help...
  
  **Tags:** contacts
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2015-08-11. Score: 1
  
  In theory you could update this by yourself via SQL. There are two arguments against this thought:
  
  * The ID won't match anyone else's Civi, which could lead to problems with third-party extensions.
  * This is a change that the rest of the community can benefit from.
  
  I would file a ticket at issues.civicrm.org. If you have the chops to create a Github pull request, great! If not, no worries. Please be sure to include a reference to sources showing the missing "State", such as <https://en.wikipedia.org/wiki/Local_government_in_Fiji>.
  
  > **Comments:**
  > **username_0**: Thank you for taking the time to answer my question.  Good advice that i'll follow.. However issues.mayfirst.org doesn't resolve anywhere  
  > **username_3**: I think he meant issues.civicrm.org.  
  > **username_2**: For assistance getting this fix into CiviCRM, there's a chat channel at https://chat.civicrm.org/civicrm/channels/dev-newcomers - you should find someone happy to help you through the process. Hi from Dunedin!  
  
  ---
  
  