Posts Tagged ‘schema’

2.3 to 2.5 Database Changes

50
responses
by
on
March 23rd, 2008
in
WordPress

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.

[Continue Reading...]

Closed, Open Source Share Compatibility Problems

2
responses
by
on
December 13th, 2005
in
Blogging News, LinkyLoo

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.

[Continue Reading...]

MYdbPAL Free Download

No
responses
by
on
October 19th, 2005
in
LinkyLoo

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

[Continue Reading...]



Obviously Powered by WordPress. © 2003-2013

css.php