install/schemas/postgresql_stage2.sql
changeset 499 6b7fdd898ba3
parent 468 194a19711346
child 519 94214ec0871c
--- 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 )
 );