Update of /cvsroot/php-blog/serendipity/sql
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv20950
Added Files:
Tag: branch-0-6
db_update_0.2_0.3_postgres.sql
Removed Files:
Tag: branch-0-6
db_update_0.2_0.3_pqsql.sql db_update_0.3_0.4_pgsql.sql
db_update_0.5.1_0.6_pgsql.sql db_update_0.5_0.5.1_pgsql.sql
Log Message:
Some database fixes: the dbtype is postgres not pgsql or pqsql
--- db_update_0.2_0.3_pqsql.sql DELETED ---
--- db_update_0.5_0.5.1_pgsql.sql DELETED ---
--- NEW FILE: db_update_0.2_0.3_postgres.sql ---
ALTER TABLE {PREFIX}entries ADD COLUMN trackbacks INT(4) DEFAULT 0 AFTER `comments`;
ALTER TABLE {PREFIX}entries ADD COLUMN isdraft BOOLEAN NOT NULL FALSE AFTER `categoryid`;
ALTER TABLE {PREFIX}comments ADD COLUMN subscribed BOOLEAN NOT NULL AFTER `type`;
INSERT INTO {PREFIX}config (name, value) VALUES ('allowSubscriptions', 'false');
INSERT INTO {PREFIX}config (name, value) VALUES ('template', 'default');
INSERT INTO {PREFIX}config (name, value) VALUES ('embed', 'false');
INSERT INTO {PREFIX}config (name, value) VALUES ('indexFile', 'index.php');
INSERT INTO {PREFIX}config (name, value) VALUES ('blockReferer', ';');
INSERT INTO {PREFIX}config (name, value) VALUES ('XHTML11', 'false');
--- db_update_0.3_0.4_pgsql.sql DELETED ---
--- db_update_0.5.1_0.6_pgsql.sql DELETED ---
|
