configs/sql-init-scripts/mysql/update_admins_r1409.sql
author Matt Woodrow <pred@alliedmods.net>
Sun Oct 19 16:18:22 2008 +1300 (2008-10-19)
changeset 2366 ef798e137fe7
parent 1403 ecb9c66fd4bb
permissions -rw-r--r--
Updated rockthevote to use new OnClientConnected forward (bug 3311)
     1 
     2 ALTER TABLE sm_admins ADD immunity INT UNSIGNED NOT NULL;
     3 
     4 ALTER TABLE sm_groups ADD immunity_level INT UNSIGNED NOT NULL;
     5 UPDATE sm_groups SET immunity_level = 2 WHERE immunity = 'default';
     6 UPDATE sm_groups SET immunity_level = 1 WHERE immunity = 'global';
     7 ALTER TABLE sm_groups DROP immunity;
     8 
     9 CREATE TABLE sm_config (
    10   cfg_key varchar(32) NOT NULL,
    11   cfg_value varchar(255) NOT NULL,
    12   PRIMARY KEY (cfg_key)
    13 );
    14 INSERT INTO sm_config (cfg_key, cfg_value) VALUES ('admin_version', '1.0.0.1409') ON DUPLICATE KEY UPDATE cfg_value = '1.0.0.1409';
    15