schema.sql
changeset 213 0fe1f610698d
parent 210 c7c2fde4f98d
child 218 e0ec986c0af3
equal deleted inserted replaced
212:d57af0b0302e 213:0fe1f610698d
    50 
    50 
    51 CREATE TABLE {{TABLE_PREFIX}}page_text(
    51 CREATE TABLE {{TABLE_PREFIX}}page_text(
    52   page_id varchar(63),
    52   page_id varchar(63),
    53   namespace varchar(16) NOT NULL default 'Article',
    53   namespace varchar(16) NOT NULL default 'Article',
    54   page_text text,
    54   page_text text,
    55   char_tag varchar(63)
    55   char_tag varchar(63),
    56 ) CHARACTER SET `utf8`;
    56   FULLTEXT KEY {{TABLE_PREFIX}}page_search_idx (page_id, namespace, page_text)
       
    57 ) ENGINE = MYISAM CHARACTER SET `utf8`;
    57 
    58 
    58 CREATE TABLE {{TABLE_PREFIX}}pages(
    59 CREATE TABLE {{TABLE_PREFIX}}pages(
    59   page_order int(8),
    60   page_order int(8),
    60   name varchar(127),
    61   name varchar(127),
    61   urlname varchar(63),
    62   urlname varchar(63),