install/schemas/upgrade/1.0.2b1-1.0.2-mysql.sql
changeset 1259 49db7495f6b8
parent 1258 d972b1276d95
child 1260 cd72bcd83401
equal deleted inserted replaced
1258:d972b1276d95 1259:49db7495f6b8
     1 -- Enano CMS
       
     2 -- Upgrade schema - Enano 1.0.2 beta 1 - 1.0.2 release
       
     3 
       
     4 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.
       
     5 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL;
       
     6 
       
     7 -- I have no idea how or why, but the f'ing index didn't get created for who-knows-how-many releases.
       
     8 -- We'll attempt to create it here, but don't die if it fails
       
     9 @ALTER TABLE {{TABLE_PREFIX}}page_text ENGINE = MYISAM, COLLATE = utf8_bin, CHARSET = utf8;
       
    10 ALTER TABLE {{TABLE_PREFIX}}search_index CHARSET = utf8, COLLATE = utf8_bin, MODIFY COLUMN word varchar(64) NOT NULL;
       
    11 
       
    12 -- The search cache is no longer needed because of the new unified search engine (it's too f'ing fast to need a cache :-D)
       
    13 @DROP TABLE {{TABLE_PREFIX}}search_cache;
       
    14 
       
    15 -- Yes, it appears we need pages with names this long after all
       
    16 ALTER TABLE {{TABLE_PREFIX}}pages MODIFY COLUMN urlname varchar(255), MODIFY COLUMN name varchar(255);
       
    17 
       
    18 -- Make page_text a little more efficient to deal with
       
    19 ALTER TABLE {{TABLE_PREFIX}}page_text MODIFY COLUMN page_id varchar(255), MODIFY COLUMN namespace varchar(63), MODIFY COLUMN page_text longtext;
       
    20 
       
    21 -- Now recreate the fulltext index
       
    22 @CREATE FULLTEXT INDEX {{TABLE_PREFIX}}page_search_idx ON {{TABLE_PREFIX}}page_text(page_id, namespace, page_text);
       
    23 
       
    24 -- Addition of new file types
       
    25 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';
       
    26 
       
    27 -- Reinforcement of "stable release" mentality
       
    28 @UPDATE {{TABLE_PREFIX}}users SET theme='oxygen', style='bleu' WHERE user_id = 2;
       
    29