database Weblog Tools Collection

3/23/2008 ↓

2.3 to 2.5 Database Changes 49comments

Jeff Chandler

Please subscribe to our RSS feed for new articles. We report on Wordpress news, themes, plugins, ideas, hacks, quick fixes and everything about blogging, especially about Wordpress. You can also receive updates from this blog via email if you want that method of notification.

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.

changes, database, LinkyLoo, schema, WordPress

12/13/2005 ↓

Closed, Open Source Share Compatibility Problems
Closed, Open Source Share Compatibility Problems: Interesting take on the compatibility problems brought onto Wordpress by the latest versions of Mysql running in “strict” mode as default. Especially poignant here because I see well greased programmers moving to the postgresql model because of a shift of ideologies of the mysql group. I should look into the added benefits that the strict model provides to the system. (2)

10/19/2005 ↓

MYdbPAL Free Download
MYdbPAL Free Download: I am not sure of this program and you are on your own to figure out how this works but from my initial reaction, though the user interface is hideous, it can be a useful database education tool and provide good insight into existing database schemas. Thanks SlickDeals (0)