upgrade.sql
changeset 49 ef92ded52f79
parent 33 143d3ee32f3c
child 50 5e9bb8b7bbdf
equal deleted inserted replaced
47:d6361ccbd2bd 49:ef92ded52f79
     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 ALTER {{TABLE_PREFIX}}users ADD COLUMN user_coppa tinyint(1) NOT NULL DEFAULT 0;
     9 ALTER TABLE {{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;