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

18 lines
705 B
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');