[wp-trac] [WordPress Trac] #8751: ID data types are inconsistent
WordPress Trac
wp-trac at lists.automattic.com
Mon Dec 29 22:19:43 GMT 2008
#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
More information about the wp-trac
mailing list