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

[WordPress Trac]

#40418: ID columns in multisite database tables should be unsigned
--------------------------------------------+------------------------------
 Reporter:  johnjamesjacoby                 |       Owner:  johnjamesjacoby
     Type:  defect (bug)                    |      Status:  closed
 Priority:  normal                          |   Milestone:  6.9
Component:  Upgrade/Install                 |     Version:  3.0
 Severity:  normal                          |  Resolution:  fixed
 Keywords:  has-patch needs-refresh commit  |     Focuses:  multisite
--------------------------------------------+------------------------------
Changes (by johnjamesjacoby):

 * status:  assigned => closed
 * resolution:   => fixed


Comment:

 In [changeset:"60497" 60497]:
 {{{
 #!CommitTicketReference repository="" revision="60497"
 Multisite: Enforce consistent types on ID columns in multisite database
 tables, to better allow for foreign keys to more reliably be defined
 between them.

 This change adjusts the install & upgrade routines so all of ID-based
 database columns in the multisite database tables are `unsigned`, bringing
 them up-to-speed with ID-based columns in single-site tables.

 Additionally, the `$wp_db_version` number is bumped, and the
 `pre_schema_upgrade()` upgrade function is modified to accommodate & use
 that new version.

 Follow-up to [10852].

 Props spacedmonkey, johnjamesjacoby.

 Fixes #40418.
 }}}

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