Answers.Body: <p>There are a number of other threads around this issue and you may find the specific advice you need if you read through them eg</p>
  
  <p><a href="https://civicrm.stackexchange.com/questions/18487/how-to-find-and-or-fix-missing-indices">How to find and/or fix missing indices?</a></p>
  
  <p>or this one</p>
  
  <p><a href="https://civicrm.stackexchange.com/questions/19408/missing-indices-status-after-upgrading-to-civicrm-4-7-21-on-wordpress-4-8">Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-08-14T01:19:26.403Z
Answers.LastActivityDate: 2017-08-14T01:19:26.403Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I want to see which indices were supposed to be created in the last upgrade I ran because I get a status report message saying that some indices are missing, but when I click "Update Indices" I get an error saying "DB Error: already exists". So I'm pretty sure some of the indices are missing, but not all of them. So I want to manually create only the missing ones.</p>
  
Tags: <upgrade><database>
Title: Where can I see the database upgrade script?
ThreadText: # Where can I see the database upgrade script?
  
  (Asked by: username_0 on 2017-08-13)
  
  I want to see which indices were supposed to be created in the last upgrade I ran because I get a status report message saying that some indices are missing, but when I click "Update Indices" I get an error saying "DB Error: already exists". So I'm pretty sure some of the indices are missing, but not all of them. So I want to manually create only the missing ones.
  
  **Tags:** upgrade, database
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2017-08-14. Score: 1
  
  There are a number of other threads around this issue and you may find the specific advice you need if you read through them eg
  
  [How to find and/or fix missing indices?](https://civicrm.stackexchange.com/questions/18487/how-to-find-and-or-fix-missing-indices)
  
  or this one
  
  [Missing indices status after upgrading to CiviCRM 4.7.21 on WordPress 4.8](https://civicrm.stackexchange.com/questions/19408/missing-indices-status-after-upgrading-to-civicrm-4-7-21-on-wordpress-4-8)
  
  
  ---
  
  