[wp-trac] [WordPress Trac] #8751: ID data types are inconsistent

[WordPress Trac]

#8751: ID data types are inconsistent
--------------------------+-------------------------------------------------
 Reporter:  ramenboy      |       Owner:  anonymous
     Type:  defect (bug)  |      Status:  new      
 Priority:  normal        |   Milestone:  2.8      
Component:  General       |     Version:           
 Severity:  normal        |    Keywords:           
--------------------------+-------------------------------------------------
 The data types for post and user IDs vary from table to table. Some
 columns are int(11), others are bigint(20); some are unsigned, and others
 are not. Assuming bigint(20) unsigned is the intended data type for post
 and user IDs, the following columns are inconsistent:

 wp_comments:
   * comment_post_ID is int(11), should be bigint(20) unsigned
   * comment_parent is bigint(20), should be bigint(20) unsigned
   * user_id is bigint(20), should be bigint(20) unsigned

 wp_links:
   * link_owner is int(11), should be bigint(20) unsigned

 wp_postmeta:
   * post_id is bigint(20), should be bigint(20) unsigned

 wp_posts:
   * post_author is bigint(20), should be bigint(20) unsigned
   * post_parent is bigint(20), should be bigint(20) unsigned
   * comment_count is bigint(20), should be bigint(20) unsigned

 wp_usermeta:
   * umeta_id is bigint(20), should be bigint(20) unsigned
   * user_id is bigint(20), should be bigint(20) unsigned

 comment_post_ID was supposedly fixed in #1621, but this fix seems to have
 been reverted at some point.

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