1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/configs/sql-init-scripts/sqlite/update_admins-r1409.sql	Sun Mar 30 07:00:22 2008 +0000
     1.3 @@ -0,0 +1,23 @@
     1.4 +
     1.5 +ALTER TABLE sm_admins ADD immunity INTEGER DEFAULT 0 NOT NULL;
     1.6 +
     1.7 +CREATE TABLE _sm_groups_temp (
     1.8 +  id INTEGER PRIMARY KEY AUTOINCREMENT,
     1.9 +  flags varchar(30) NOT NULL,
    1.10 +  name varchar(120) NOT NULL,
    1.11 +  immunity_level INTEGER DEFAULT 0 NOT NULL
    1.12 +);
    1.13 +INSERT INTO _sm_groups_temp (id, flags, name) SELECT id, flags, name FROM sm_groups;
    1.14 +UPDATE _sm_groups_temp SET immunity_level = 2 WHERE id IN (SELECT g.id FROM sm_groups g WHERE g.immunity = 'global');
    1.15 +UPDATE _sm_groups_temp SET immunity_level = 1 WHERE id IN (SELECT g.id FROM sm_groups g WHERE g.immunity = 'default');
    1.16 +DROP TABLE sm_groups;
    1.17 +ALTER TABLE _sm_groups_temp RENAME TO sm_groups;
    1.18 +
    1.19 +CREATE TABLE IF NOT EXISTS sm_config (
    1.20 +  cfg_key varchar(32) NOT NULL,
    1.21 +  cfg_value varchar(255) NOT NULL,
    1.22 +  PRIMARY KEY (cfg_key)
    1.23 +);
    1.24 +
    1.25 +REPLACE INTO sm_config (cfg_key, cfg_value) VALUES ('admin_version', '1.0.0.1409');
    1.26 +