[wp-trac] [WordPress Trac] #42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table

[WordPress Trac]

#42422: 'unique' index not removed from the 'slug' column of the 'wp_terms' table
--------------------------+------------------------------
 Reporter:  joellisenby   |       Owner:
     Type:  defect (bug)  |      Status:  new
 Priority:  normal        |   Milestone:  Awaiting Review
Component:  Taxonomy      |     Version:  4.8.3
 Severity:  normal        |  Resolution:
 Keywords:                |     Focuses:
--------------------------+------------------------------

Comment (by mike_vl):

 Hi, 12 days ago I logged the same issue as this one I believe.

 '''Unique constraint on slug in wp_terms table''' I have removed the
 constraint manually but am now unsure if there are other as yet
 undiscovered updates which have been skipped.

 Here are my results for the questions posed above:
 '''Is it single-site or Multisite?'''
 Single site

 '''What's the db_version string in wp_options?'''
 38590

 '''Have other, more recent database schema changes successfully taken
 place? For example: what's the size of your wp_posts.post_password column?
 [38590]? Or, do you have a wp_termmeta table?'''

 size wp_posts.post_password column varchar(20)
 wp_termmeta exists, I have not had to create it as the author of this
 ticket

 How large is the wp_terms table?
 1618 rows

 Is there an easy way to compare table structure to 'ideal' table structure
 to help identify

--
Ticket URL: <https://core.trac.wordpress.org/ticket/42422#comment:6>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform