configs/sql-init-scripts/mysql/update_admins_r1409.sql
branchrefac-jit
changeset 2284 026da5437111
parent 2192 7602d7fb60d9
child 2288 15c77b21589a
     1.1 --- a/configs/sql-init-scripts/mysql/update_admins_r1409.sql	Fri Jul 11 06:51:21 2008 +0000
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,15 +0,0 @@
     1.4 -
     1.5 -ALTER TABLE sm_admins ADD immunity INT UNSIGNED NOT NULL;
     1.6 -
     1.7 -ALTER TABLE sm_groups ADD immunity_level INT UNSIGNED NOT NULL;
     1.8 -UPDATE sm_groups SET immunity_level = 2 WHERE immunity = 'default';
     1.9 -UPDATE sm_groups SET immunity_level = 1 WHERE immunity = 'global';
    1.10 -ALTER TABLE sm_groups DROP immunity;
    1.11 -
    1.12 -CREATE TABLE sm_config (
    1.13 -  cfg_key varchar(32) NOT NULL,
    1.14 -  cfg_value varchar(255) NOT NULL,
    1.15 -  PRIMARY KEY (cfg_key)
    1.16 -);
    1.17 -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';
    1.18 -