[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
Component:  Database                             |  Review
 Severity:  major                                |     Version:  3.0
 Keywords:  2nd-opinion has-patch needs-testing  |  Resolution:
                                                 |     Focuses:  multisite
-------------------------------------------------+-------------------------

Comment (by johnjamesjacoby):

 [https://core.trac.wordpress.org/attachment/ticket/40418/40418.patch
 40418.patch]

 * Bumps the database version (will likely need a patch refresh by the time
 it's time)
 * Updates `$ms_global_tables` in `wp_get_db_schema()` with the `unsigned`
 data types
 * Adds `ALTERS` to `pre_schema_upgrade()` for existing installations

 Related to work from #38203.

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