configs/sql-init-scripts/mysql/update_admins_r1409.sql
author Asher Baker <asherkin@gmail.com>
Sat Jun 09 20:02:08 2012 -0400 (2012-06-09)
changeset 3554 ba0fa3d9fb25
parent 1403 ecb9c66fd4bb
permissions -rw-r--r--
Updated sdktools msvc10 proj file to use MMSOURCE19. (NPOTB).
     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