schema.sql
changeset 221 956263992d48
parent 218 e0ec986c0af3
child 228 7846d45bd250
equal deleted inserted replaced
220:2d4bb97fa75a 221:956263992d48
   182   namespace varchar(63),
   182   namespace varchar(63),
   183   PRIMARY KEY ( hit_id ) 
   183   PRIMARY KEY ( hit_id ) 
   184 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   184 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   185 
   185 
   186 CREATE TABLE {{TABLE_PREFIX}}search_index(
   186 CREATE TABLE {{TABLE_PREFIX}}search_index(
   187   word varbinary(64) NOT NULL,
   187   word varchar(64) NOT NULL,
   188   page_names text,
   188   page_names text,
   189   PRIMARY KEY ( word ) 
   189   PRIMARY KEY ( word ) 
   190 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   190 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   191 
   191 
   192 CREATE TABLE {{TABLE_PREFIX}}groups(
   192 CREATE TABLE {{TABLE_PREFIX}}groups(