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
dvander@1403
     1
dvander@1403
     2
ALTER TABLE sm_admins ADD immunity INT UNSIGNED NOT NULL;
dvander@1403
     3
dvander@1403
     4
ALTER TABLE sm_groups ADD immunity_level INT UNSIGNED NOT NULL;
dvander@1403
     5
UPDATE sm_groups SET immunity_level = 2 WHERE immunity = 'default';
dvander@1403
     6
UPDATE sm_groups SET immunity_level = 1 WHERE immunity = 'global';
dvander@1403
     7
ALTER TABLE sm_groups DROP immunity;
dvander@1403
     8
dvander@1403
     9
CREATE TABLE sm_config (
dvander@1403
    10
  cfg_key varchar(32) NOT NULL,
dvander@1403
    11
  cfg_value varchar(255) NOT NULL,
dvander@1403
    12
  PRIMARY KEY (cfg_key)
dvander@1403
    13
);
dvander@1403
    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';
dvander@1403
    15