upgrade.sql
changeset 18 edfc24408769
parent 0 902822492a68
child 21 663fcf528726
equal deleted inserted replaced
17:61ad9ffbd69c 18:edfc24408769
     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' );
     6 INSERT INTO {{TABLE_PREFIX}}config (config_name, config_value) VALUES( 'enano_version', '1.0' ),( 'enano_rc_version', '3' );
     7 ---BEGIN 1.0RC2---
     7 ---BEGIN 1.0RC2---
     8 -- Add the "Moderators" group
     8 -- Add the "Moderators" group
     9 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3;
     9 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3;
    10 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3;
    10 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3;
    11 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN system_group tinyint(1) NOT NULL DEFAULT 0;
    11 ALTER TABLE {{TABLE_PREFIX}}groups ADD COLUMN system_group tinyint(1) NOT NULL DEFAULT 0;