upgrade.sql
changeset 30 7e8fd44b36b0
parent 21 663fcf528726
child 33 143d3ee32f3c
equal deleted inserted replaced
29:e5484a9e0818 30:7e8fd44b36b0
     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' );
     7 ---BEGIN 1.0RC3---
     7 ---BEGIN 1.0RC3---
     8 -- Placeholder (all versions need to have at least one query performed)
     8 -- Placeholder (all versions need to have at least one query performed)
     9 UPDATE {{TABLE_PREFIX}}config SET config_value='' WHERE config_name='              ';
     9 ALTER {{TABLE_PREFIX}}users ADD COLUMN user_coppa tinyint(1) NOT NULL DEFAULT 0;
    10 ---END 1.0RC3---
    10 ---END 1.0RC3---
    11 ---BEGIN 1.0RC2---
    11 ---BEGIN 1.0RC2---
    12 -- Add the "Moderators" group
    12 -- Add the "Moderators" group
    13 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3;
    13 UPDATE {{TABLE_PREFIX}}groups SET group_id=9999 WHERE group_id=3;
    14 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3;
    14 UPDATE {{TABLE_PREFIX}}group_members SET group_id=9999 WHERE group_id=3;