upgrade.sql
changeset 303 4c2d4833a968
parent 293 fbe306070c40
child 318 eec2dfd2f0a3
equal deleted inserted replaced
302:c4d792a262b0 303:4c2d4833a968
     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.5' );
     6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0.5' );
     7 ---BEGIN 1.0.4---
     7 ---BEGIN 1.0.4---
     8 ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
     8 @ALTER TABLE {{TABLE_PREFIX}}tags CHANGE user user_id mediumint(8) NOT NULL DEFAULT 1;
     9 ---END 1.0.4---
     9 ---END 1.0.4---
    10 ---BEGIN 1.0.3---
    10 ---BEGIN 1.0.3---
    11 -- No DB changes in this release
    11 -- No DB changes in this release
    12 ---END 1.0.3---
    12 ---END 1.0.3---
    13 ---BEGIN 1.0.2---
    13 ---BEGIN 1.0.2---