[wp-trac] [WordPress Trac] #3725: user_id in DB much larger than needed

[WordPress Trac]

#3725: user_id in DB much larger than needed
---------------------------+------------------------------------------------
 Reporter:  charleshooper  |       Owner:  charleshooper
     Type:  defect         |      Status:  new          
 Priority:  low            |   Milestone:  2.3          
Component:  Optimization   |     Version:  2.2          
 Severity:  minor          |    Keywords:  has-patch    
---------------------------+------------------------------------------------
 Since the maximum # of users WordPress can support has been accepted as
 much much smaller than 2,147,483,647 the database schema should be
 modified to change all columns that reference a user ID to type INT.

 Currently, all of these columns are type BIGINT, except for
 {{{link_owner}}} in {{{wp_links}}} for some reason. In addition, user IDs
 are type-casted to INTs in some places in the WordPress core, such as in
 {{{get_userdata}}}.

 The attached patch changes all of the columns referencing user IDs to INTs
 and bumps {{{wp_db_version}}}.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/3725>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software