upgrade.sql
changeset 297 ee1fc84f12a8
parent 292 b3cfaf0a505c
child 301 7e094a04d84e
equal deleted inserted replaced
296:fb3df5ce6c9e 297:ee1fc84f12a8
    15 @DROP TABLE {{TABLE_PREFIX}}search_cache;
    15 @DROP TABLE {{TABLE_PREFIX}}search_cache;
    16 -- 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
    17 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);
    18 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255), MODIFY COLUMN namespace varchar(63), MODIFY COLUMN page_text longtext;
    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);
    19 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
       
    20 UPDATE {{TABLE_PREFIX}}config SET config_value='cbf:len=185;crc=55fb6f14;data=0[1],1[4],0[3],1[1],0[22],1[1],0[16],1[3],0[16],1[1],0[1],1[2],0[6],1[1],0[1],1[1],0[4],1[2],0[3],1[1],0[48],1[2],0[2],1[1],0[4],1[1],0[37]|end' WHERE config_name = 'allowed_mime_types' AND config_value='cbf:len=168;crc=c3dcad3f;data=0[1],1[4],0[3],1[1],0[2],1[1],0[11],1[1],0[7],1[1],0[9],1[1],0[6],1[3],0[10],1[1],0[2],1[2],0[1],1[1],0[1],1[2],0[6],1[3],0[1],1[1],0[2],1[4],0[1],1[2],0[3],1[1],0[4],1[2],0[26],1[5],0[6],1[2],0[2],1[1],0[4],1[1],0[10],1[2],0[1],1[1],0[6]|end';
    20 ---END 1.0.2b1---
    21 ---END 1.0.2b1---
    21 ---BEGIN 1.0.1.1---
    22 ---BEGIN 1.0.1.1---
    22 ---END 1.0.1.1---
    23 ---END 1.0.1.1---
    23 ---BEGIN 1.0.1---
    24 ---BEGIN 1.0.1---
    24 ---END 1.0.1---
    25 ---END 1.0.1---