upgrade.sql
changeset 235 b3cfaf0a505c
parent 234 a1d0846c4504
child 240 ee1fc84f12a8
equal deleted inserted replaced
234:a1d0846c4504 235:b3cfaf0a505c
     8 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.
     8 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.
     9 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL;
     9 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL;
    10 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases.
    10 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases.
    11 -- We'll attempt to create it here, but don't die if it fails
    11 -- We'll attempt to create it here, but don't die if it fails
    12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8;
    12 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8;
    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 CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
    13 ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, 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
    14 -- The search cache is no longer needed because of the new unified search engine
    16 @DROP TABLE {{TABLE_PREFIX}}search_cache;
    15 @DROP TABLE {{TABLE_PREFIX}}search_cache;
    17 -- Yes, it appears we need pages with names this long after all
    16 -- 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);
    17 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);
    18 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255), MODIFY COLUMN namespace varchar(63), MODIFY COLUMN page_text longtext;
       
    19 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
    20 ---END 1.0.2b1---
    20 ---END 1.0.2b1---
    21 ---BEGIN 1.0.1.1---
    21 ---BEGIN 1.0.1.1---
    22 ---END 1.0.1.1---
    22 ---END 1.0.1.1---
    23 ---BEGIN 1.0.1---
    23 ---BEGIN 1.0.1---
    24 ---END 1.0.1---
    24 ---END 1.0.1---