ID data types are inconsistent

[ramenboy]

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.

[Denis-de-Bernardy]

Fixed in a separate ticket