--- a/install/schemas/postgresql_stage2.sql Tue Mar 11 17:09:20 2008 -0400
+++ b/install/schemas/postgresql_stage2.sql Sat Mar 15 00:08:01 2008 -0400
@@ -85,7 +85,7 @@
default_style varchar(63) NOT NULL DEFAULT '',
enabled smallint NOT NULL DEFAULT '1',
group_list text DEFAULT NULL,
- group_policy varchar(5) NOT NULL DEFAULT 'allow_all',
+ group_policy varchar(9) NOT NULL DEFAULT 'allow_all',
CHECK (group_policy IN ('allow_all', 'whitelist', 'blacklist'))
);
@@ -193,6 +193,7 @@
CREATE TABLE {{TABLE_PREFIX}}search_index(
word varchar(64) NOT NULL,
+ word_lcase varchar(64) NOT NULL,
page_names text,
PRIMARY KEY ( word )
);