diff -r a85af9c28355 -r 6b7fdd898ba3 install/schemas/postgresql_stage2.sql --- 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 ) );