upgrade.sql
changeset 149 42c6c83b8a00
parent 142 ca9118d9c0f2
child 152 9b4279c25d33
child 153 9b86248e8fee
equal deleted inserted replaced
144:380e55865f86 149:42c6c83b8a00
     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.0.2' );
       
     7 ---BEGIN 1.0.2b1---
       
     8 ---END 1.0.2b1---
     7 ---BEGIN 1.0.1.1---
     9 ---BEGIN 1.0.1.1---
     8 -- No changes in this release
       
     9 ---END 1.0.1.1---
    10 ---END 1.0.1.1---
    10 ---BEGIN 1.0.1---
    11 ---BEGIN 1.0.1---
    11 -- No changes in this release
       
    12 ---END 1.0.1---
    12 ---END 1.0.1---
    13 ---BEGIN 1.0---
    13 ---BEGIN 1.0---
    14 -- Fix for obnoxious $_GET issue
    14 -- Fix for obnoxious $_GET issue
    15 UPDATE {{TABLE_PREFIX}}sidebar SET block_type=1,block_content='<div class="slideblock2" style="padding: 0px;"><form action="$CONTENTPATH$$NS_SPECIAL$Search" method="get" style="padding: 0; margin: 0;"><p><input type="hidden" name="title" value="$NS_SPECIAL$Search" />$INPUT_AUTH$<input name="q" alt="Search box" type="text" size="10" style="width: 70%" /> <input type="submit" value="Go" style="width: 20%" /></p></form></div>' WHERE block_name='Search' AND item_id=4;
    15 UPDATE {{TABLE_PREFIX}}sidebar SET block_type=1,block_content='<div class="slideblock2" style="padding: 0px;"><form action="$CONTENTPATH$$NS_SPECIAL$Search" method="get" style="padding: 0; margin: 0;"><p><input type="hidden" name="title" value="$NS_SPECIAL$Search" />$INPUT_AUTH$<input name="q" alt="Search box" type="text" size="10" style="width: 70%" /> <input type="submit" value="Go" style="width: 20%" /></p></form></div>' WHERE block_name='Search' AND item_id=4;
    16 -- Added on advice from Neal
    16 -- Added on advice from Neal