install/schemas/postgresql_stage2.sql
changeset 350 dd7cbc97f681
parent 349 fdaf9070566c
child 353 2398420f48e7
equal deleted inserted replaced
349:fdaf9070566c 350:dd7cbc97f681
   173   username varchar(63) NOT NULL,
   173   username varchar(63) NOT NULL,
   174   time int NOT NULL DEFAULT 0,
   174   time int NOT NULL DEFAULT 0,
   175   page_id varchar(63),
   175   page_id varchar(63),
   176   namespace varchar(63),
   176   namespace varchar(63),
   177   PRIMARY KEY ( hit_id ) 
   177   PRIMARY KEY ( hit_id ) 
   178 );
       
   179 
       
   180 CREATE TABLE {{TABLE_PREFIX}}search_index(
       
   181   word varchar(64) NOT NULL,
       
   182   page_names text,
       
   183   PRIMARY KEY ( word ) 
       
   184 );
   178 );
   185 
   179 
   186 CREATE TABLE {{TABLE_PREFIX}}groups(
   180 CREATE TABLE {{TABLE_PREFIX}}groups(
   187   group_id SERIAL,
   181   group_id SERIAL,
   188   group_name varchar(64),
   182   group_name varchar(64),