LuckyCoinkydink/sql/db_update_0.3_0.4_postgres.sql
2006-08-02 10:07:34 +00:00

5 lines
255 B
SQL

ALTER TABLE {PREFIX}entries ADD COLUMN allow_comments BOOLEAN;
UPDATE {PREFIX}entries SET allow_comments=TRUE;
ALTER TABLE {PREFIX}entries ALTER COLUMN allow_comments SET NOT NULL;
ALTER TABLE {PREFIX}entries ALTER COLUMN allow_comments SET DEFAULT TRUE;