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