install/schemas/postgresql_stage2.sql
changeset 353 2398420f48e7
parent 350 dd7cbc97f681
child 359 e0787bb6285b
equal deleted inserted replaced
350:dd7cbc97f681 353:2398420f48e7
   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 )
   178 );
   184 );
   179 
   185 
   180 CREATE TABLE {{TABLE_PREFIX}}groups(
   186 CREATE TABLE {{TABLE_PREFIX}}groups(
   181   group_id SERIAL,
   187   group_id SERIAL,
   182   group_name varchar(64),
   188   group_name varchar(64),