upgrade.sql
changeset 285 7846d45bd250
parent 272 e0ec986c0af3
child 291 a1d0846c4504
equal deleted inserted replaced
284:0f039028f7a5 285:7846d45bd250
    12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM COLLATE = utf8_bin;
    12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM COLLATE = utf8_bin;
    13 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
    13 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
    14 ALTER TABLE {{TABLE_PREFIX}}search_index COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
    14 ALTER TABLE {{TABLE_PREFIX}}search_index COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
    15 -- The search cache is no longer needed because of the new unified search engine
    15 -- The search cache is no longer needed because of the new unified search engine
    16 @DROP TABLE {{TABLE_PREFIX}}search_cache;
    16 @DROP TABLE {{TABLE_PREFIX}}search_cache;
       
    17 -- Yes, it appears we need pages with names this long after all
       
    18 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255);
       
    19 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255);
    17 ---END 1.0.2b1---
    20 ---END 1.0.2b1---
    18 ---BEGIN 1.0.1.1---
    21 ---BEGIN 1.0.1.1---
    19 ---END 1.0.1.1---
    22 ---END 1.0.1.1---
    20 ---BEGIN 1.0.1---
    23 ---BEGIN 1.0.1---
    21 ---END 1.0.1---
    24 ---END 1.0.1---