install/schemas/mysql_stage2.sql
changeset 499 6b7fdd898ba3
parent 468 194a19711346
child 519 94214ec0871c
equal deleted inserted replaced
498:a85af9c28355 499:6b7fdd898ba3
   190   PRIMARY KEY ( hit_id ) 
   190   PRIMARY KEY ( hit_id ) 
   191 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   191 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   192 
   192 
   193 CREATE TABLE {{TABLE_PREFIX}}search_index(
   193 CREATE TABLE {{TABLE_PREFIX}}search_index(
   194   word varchar(64) NOT NULL,
   194   word varchar(64) NOT NULL,
       
   195   word_lcase varchar(64) NOT NULL,
   195   page_names text,
   196   page_names text,
   196   PRIMARY KEY ( word ) 
   197   PRIMARY KEY ( word ) 
   197 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   198 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   198 
   199 
   199 CREATE TABLE {{TABLE_PREFIX}}groups(
   200 CREATE TABLE {{TABLE_PREFIX}}groups(