install/schemas/mysql_stage2.sql
changeset 350 dd7cbc97f681
parent 349 fdaf9070566c
child 353 2398420f48e7
equal deleted inserted replaced
349:fdaf9070566c 350:dd7cbc97f681
   177   username varchar(63) NOT NULL,
   177   username varchar(63) NOT NULL,
   178   time int(12) NOT NULL DEFAULT 0,
   178   time int(12) NOT NULL DEFAULT 0,
   179   page_id varchar(63),
   179   page_id varchar(63),
   180   namespace varchar(63),
   180   namespace varchar(63),
   181   PRIMARY KEY ( hit_id ) 
   181   PRIMARY KEY ( hit_id ) 
   182 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
       
   183 
       
   184 CREATE TABLE {{TABLE_PREFIX}}search_index(
       
   185   word varchar(64) NOT NULL,
       
   186   page_names text,
       
   187   PRIMARY KEY ( word ) 
       
   188 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   182 ) CHARACTER SET `utf8` COLLATE `utf8_bin`;
   189 
   183 
   190 CREATE TABLE {{TABLE_PREFIX}}groups(
   184 CREATE TABLE {{TABLE_PREFIX}}groups(
   191   group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
   185   group_id mediumint(5) UNSIGNED NOT NULL auto_increment,
   192   group_name varchar(64),
   186   group_name varchar(64),