id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
8751,ID data types are inconsistent,ramenboy,anonymous,"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.",defect (bug),closed,normal,2.8,General,,normal,fixed,,