[wp-trac] [WordPress Trac] #40418: ID columns in multisite database tables are all unsigned

[WordPress Trac]

#40418: ID columns in multisite database tables are all unsigned
-----------------------------+-----------------------------
 Reporter:  johnjamesjacoby  |      Owner:
     Type:  defect (bug)     |     Status:  new
 Priority:  normal           |  Milestone:  Awaiting Review
Component:  General          |    Version:
 Severity:  normal           |   Keywords:
  Focuses:                   |
-----------------------------+-----------------------------
 See #8751 for ye'olde single-site effort to normalize the respective
 object ID columns.

 All multisite ID columns are `bigint(20)`, but none of them are `unsigned`
 which has 2 unintended consequences:

 * Negative numbers can be stored as values instead of being set to `0`
 * Maximum int of `9223372036854775807` instead of intended
 `18446744073709551615`

 Changes are necessary to every multisite database table, as they all touch
 site or network IDs.

 Patch imminent

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