[wp-trac] [WordPress Trac] #39507: Increase the length of comment_type field in wp_comments table

[WordPress Trac]

#39507: Increase the length of comment_type field in wp_comments table
-------------------------+-----------------------------
 Reporter:  slaFFik      |      Owner:
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  Comments     |    Version:  1.5
 Severity:  normal       |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 Currently it's VARCHAR(20), which is very low for no reason (as far as I
 can see).

 Please increase its value to something like VARCHAR(100) (same as
 email/IP) or similar.

 It's quite useful to store in this field the combined type of the comment,
 where this type is generated based on prerequisites and should be obtained
 regularly with the comment object (not as a separate query to
 `commentmeta` table).

 The earliest WordPress version which has this value is 1.5, found here:
 https://codex.wordpress.org/index.php?title=Database_Description&oldid=10394

--
Ticket URL: <https://core.trac.wordpress.org/ticket/39507>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform