php-blog-cvs

[Tom S. <tom...@us...>]

Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv15264/sql

Added Files:
	db_update_0.6.6_0.6.7_mysql.sql 
	db_update_0.6.6_0.6.7_postgres.sql 
Log Message:
Allow moderation of comments through:
    * E-mail
    * Comment manager in Author Suite

Bumps version to 0.6.7-CVS, requires database changes


--- NEW FILE: db_update_0.6.6_0.6.7_postgres.sql ---
ALTER TABLE `{PREFIX}entries` ADD `moderate_comments` ENUM('true','false') DEFAULT 'false' NOT NULL AFTER `allow_comments`;
ALTER TABLE `{PREFIX}comments` ADD `status` VARCHAR( 50 ) NOT NULL AFTER `subscribed` ;
UPDATE {PREFIX}comments SET status = 'approved';

--- NEW FILE: db_update_0.6.6_0.6.7_mysql.sql ---
ALTER TABLE `{PREFIX}entries` ADD `moderate_comments` ENUM('true','false') DEFAULT 'false' NOT NULL AFTER `allow_comments`;
ALTER TABLE `{PREFIX}comments` ADD `status` VARCHAR( 50 ) NOT NULL AFTER `subscribed` ;
UPDATE {PREFIX}comments SET status = 'approved';