install/schemas/postgresql_stage2.sql
changeset 353 2398420f48e7
parent 350 dd7cbc97f681
child 359 e0787bb6285b
--- a/install/schemas/postgresql_stage2.sql	Thu Jan 17 09:39:56 2008 -0500
+++ b/install/schemas/postgresql_stage2.sql	Thu Jan 17 23:31:35 2008 -0500
@@ -177,6 +177,12 @@
   PRIMARY KEY ( hit_id ) 
 );
 
+CREATE TABLE {{TABLE_PREFIX}}search_index(
+  word varchar(64) NOT NULL,
+  page_names text,
+  PRIMARY KEY ( word )
+);
+
 CREATE TABLE {{TABLE_PREFIX}}groups(
   group_id SERIAL,
   group_name varchar(64),