upgrade.sql
changeset 178 4c19952406db
parent 177 492510dddc34
child 179 36b287f1d85c
equal deleted inserted replaced
176:1bc7e849a264 178:4c19952406db
     1 -- Enano CMS - upgrade SQL
     1 -- Enano CMS - upgrade SQL
     2 -- Variables are in the format {{VAR_NAME}}
     2 -- Variables are in the format {{VAR_NAME}}
     3 -- ALL NON-SQL LINES, even otherwise blank lines, must start with "--" or they will get sent to MySQL!
     3 -- ALL NON-SQL LINES, even otherwise blank lines, must start with "--" or they will get sent to MySQL!
     4 -- Common tasks (version numbers)
     4 -- Common tasks (version numbers)
     5 DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version';
     5 DELETE FROM {{TABLE_PREFIX}}config WHERE config_name='enano_version' OR config_name='enano_beta_version' OR config_name='enano_alpha_version' OR config_name='enano_rc_version';
     6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0.2' );
     6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.1.1' );
       
     7 ---BEGIN Stable1.0ToUnstable1.1---
       
     8 UPDATE {{TABLE_PREFIX}}groups SET group_id=9998 WHERE group_id=4;
       
     9 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9998 WHERE group_id=4;
       
    10 INSERT INTO {{TABLE_PREFIX}}groups(group_id,group_name,group_type,system_group) VALUES(4, 'Regular members', 3, 1);
       
    11 ---END Stable1.0ToUnstable1.1---
       
    12 ---BEGIN 1.0.2---
       
    13 ---END 1.0.2---
     7 ---BEGIN 1.0.2b1---
    14 ---BEGIN 1.0.2b1---
     8 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.
    15 -- 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;
    16 ALTER TABLE {{TABLE_PREFIX}}page_groups MODIFY COLUMN pg_target text DEFAULT NULL;
    10 ---END 1.0.2b1---
    17 ---END 1.0.2b1---
    11 ---BEGIN 1.0.1.1---
    18 ---BEGIN 1.0.1.1---