File: db_update_0.2_0.3_postgres.sql

package info (click to toggle)
serendipity 1.0.4-1%2Betch1
  • links: PTS
  • area: main
  • in suites: etch
  • size: 14,692 kB
  • ctags: 10,206
  • sloc: php: 83,899; sql: 1,024; sh: 597; makefile: 56
file content (17 lines) | stat: -rw-r--r-- 705 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
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');