| 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-- |
| 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 |