upgrade.sql
changeset 156 edbff85d43e8
parent 153 9b86248e8fee
child 177 492510dddc34
child 196 54b3e14bf19d
child 223 8877bbfccc38
equal deleted inserted replaced
155:87bffacdfb92 156:edbff85d43e8
     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.0.2' );
     7 ---BEGIN 1.0.2b1---
     7 ---BEGIN 1.0.2b1---
       
     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;
     8 ---END 1.0.2b1---
    10 ---END 1.0.2b1---
     9 ---BEGIN 1.0.1.1---
    11 ---BEGIN 1.0.1.1---
    10 ---END 1.0.1.1---
    12 ---END 1.0.1.1---
    11 ---BEGIN 1.0.1---
    13 ---BEGIN 1.0.1---
    12 ---END 1.0.1---
    14 ---END 1.0.1---