configs/sql-init-scripts/mysql/update_admins_r1409.sql
author Nicholas Hastings <skamonkey@gmail.com>
Tue Dec 18 17:58:45 2012 -0500 (2012-12-18)
changeset 3712 ea253cc4fbf6
parent 1403 ecb9c66fd4bb
permissions -rw-r--r--
Added support for new SPROP_VARINT sendprops.
     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