upgrade.sql
changeset 285 e72bf2c24875
parent 256 f8356d9c3481
child 293 fbe306070c40
equal deleted inserted replaced
284:d823e49e2e4e 285:e72bf2c24875
     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.3' );
     6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0.4' );
       
     7 ---BEGIN 1.0.3---
       
     8 -- No DB changes in this release
       
     9 ---END 1.0.3---
     7 ---BEGIN 1.0.2---
    10 ---BEGIN 1.0.2---
     8 -- No DB changes in this release
    11 -- No DB changes in this release
     9 ---END 1.0.2---
    12 ---END 1.0.2---
    10 ---BEGIN 1.0.2b1---
    13 ---BEGIN 1.0.2b1---
    11 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.
    14 -- This is really optional, but could reduce confusion if regex page groups get truncated for no apparent reason.