configs/sql-init-scripts/mysql/update_admins_r1409.sql
author Scott Ehlert <ds@alliedmods.net>
Sun Sep 14 03:43:26 2008 -0500 (2008-09-14)
changeset 2290 f734bfbd3bf5
parent 1403 ecb9c66fd4bb
permissions -rw-r--r--
Fixed tags for sourcemod-central

sourcemod-1.0.0 - Orginally tagged by David Anderson <[email protected]> on Mon Mar 17 01:28:54 2008 UTC
     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