[php-blog-cvs] serendipity db_update-0.2-0.3.sql,NONE,1.1

[<tro...@us...>]

Update of /cvsroot/php-blog/serendipity
In directory sc8-pr-cvs1:/tmp/cvs-serv23488

Added Files:
	db_update-0.2-0.3.sql 
Log Message:
Schema changes from 0.2 to 0.3 release


--- NEW FILE: db_update-0.2-0.3.sql ---
ALTER TABLE serendipity_entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER 'comments';

ALTER TABLE serendipity_entries ADD COLUMN isdraft ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER 'categoryid';

ALTER TABLE serendipity_comments ADD COLUMN subscribed ENUM('true', 'false') NOT NULL DEFAULT 'false' AFTER 'type';

INSERT INTO serendipity_config (name, value) VALUES ('allowSubscriptions', 'false');