http://weblogtoolscollection.com/news/ Weblogtoolscollection News Topic: Database changes from 2.3 to 2.5 en Sat, 06 Sep 2008 23:32:18 +0000 http://weblogtoolscollection.com/news/topic/database-changes-from-23-to-25#post-2483 Fri, 21 Mar 2008 18:15:22 +0000 MichaelH 2483@http://weblogtoolscollection.com/news/ <p>Changes to database schema from Version 2.3 to 2.5.</p> <p>*Table: comments</p> <ul> <li>Changed 'comment_approved' to varchar(20) NOT NULL default '1'</li> <li>Added KEY 'comment_approved_date_gmt' (comment_approved, comment_date_gmt)</li> <li>Added KEY 'comment_date_gmt' (comment_date_gmt) </li> </ul> <p>*Table: links</p> <ul> <li>Changed 'link_visible' to varchar(20) NOT NULL default 'Y'</li> </ul> <p>*Table: options</p> <ul> <li>Changed 'autoload' to varchar(20) NOT NULL default 'yes'</li> </ul> <p>*Table: posts</p> <ul> <li>Changed 'post_status' to varchar(20) NOT NULL default 'publish'</li> <li>Changed 'comment_status' to varchar(20) NOT NULL default 'open'</li> <li>Changed 'ping_status' to varchar(20) NOT NULL default 'open'</li> </ul> <p>*Table: term_relationships <ul> Added 'term_order' int(11) NOT NULL default 0 </ul>