[php-blog-cvs] Re: serendipity db_update.sql,NONE,1.1

[Tom S. <ts...@dr...>]

tro...@us... wrote:

> Update of /cvsroot/php-blog/serendipity
> In directory sc8-pr-cvs1:/tmp/cvs-serv15753
> 
> Added Files:
> 	db_update.sql 
> Log Message:
> Schema changes since 0.2
> 
> 
> --- NEW FILE: db_update.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');

INSERT INTO serendipity_config (name, value) VALUES ('template', 'default');

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

INSERT INTO serendipity_config (name, value) VALUES ('indexFile', 
'index.php');

INSERT INTO serendipity_config (name, value) VALUES ('blockReferer', ';');

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


We should add new config-vars to the sql-upgrade aswell? to make sure 
they are set after an upgrade. Sometimes the vars are required for s9y 
to run? Right? (Will commit if we agree on this)

We should also make sure vars are not doublicated in the config table

PS. Right now we don't have a correct way of knowing which version is 
INSTALLED, since I removed the $serendipity['versionInstalled'] from 
serendipity_config_local.inc.php (it wasn't being set correctly)
This var NEEDS be set before we can release 0.3 (unless we want people 
to say "I *know* I have version 0.2 installed, upgrade me to 0.4)?

I will have a look at it *soon*

Goodnight
-- 
Tom Sommer, Denmark
www.dreamcoder.dk - www.tsn.dk - http://blog.dreamcoder.dk