LuckyCoinkydink/sql/db_update_0.6.6_0.6.7_mysql.sql
2006-08-02 10:07:34 +00:00

4 lines
261 B
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';