Last modified: 2014-06-01 17:16:22 UTC
rc_id will hit its max at 2147483647 rather than 4294967295 because it's an int rather than an unsigned int. Therefore, it should be changed to unsigned. Maybe this is also a good opportunity to change it to an unsigned bigint, since it's at 600 million already on enwiki and at the current rate of increase could reach its limit in our lifetime.
Some fields that should be unsigned, that aren't: *change_tag.ct_rc_id *change_tag.ct_log_id *change_tag.ct_rev_id *filearchive.fa_id *filearchive.fa_deleted_user *ipblocks.ipb_id *page_props.pp_page *page_restrictions.pr_page *recentchanges.rc_id *tag_summary.ts_rc_id *tag_summary.ts_log_id *tag_summary.ts_rev_id *user_newtalk.user_id *user_properties.up_user
See also bug 61111, proposing changing primary keys to bigint unsigned.
112825
Gerrit change #112825
Change 112825 had a related patch set uploaded by MZMcBride: Make the following fields int unsigned: https://gerrit.wikimedia.org/r/112825
