I’ve seen a number of people tell others that WordPress 2.5 will have little to no database schema changes. It looks like that is no longer the case as MichaelH has pointed out.

Changes to database schema from Version 2.3 to 2.5.

*Table: comments

• Changed ‘comment_approved’ to varchar(20) NOT NULL default ‘1′
• Added KEY ‘comment_approved_date_gmt’ (comment_approved, comment_date_gmt)
• Added KEY ‘comment_date_gmt’ (comment_date_gmt)

*Table: links

• Changed ‘link_visible’ to varchar(20) NOT NULL default ‘Y’

*Table: options

• Changed ‘autoload’ to varchar(20) NOT NULL default ‘yes’

*Table: posts

• Changed ‘post_status’ to varchar(20) NOT NULL default ‘publish’
• Changed ‘comment_status’ to varchar(20) NOT NULL default ‘open’
• Changed ‘ping_status’ to varchar(20) NOT NULL default ‘open’

*Table: term_relationships

Added ‘term_order’ int(11) NOT NULL default 0

Thanks to MichaelH for putting these changes together. This information is especially useful to plugin and theme authors as it lets them know if their particular project will break.

Read it at the source

This entry was posted on Sunday, March 23rd, 2008 at 2:50 pm. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.