1.1 --- a/configs/sql-init-scripts/sqlite/update_admins-r1409.sql	Fri Mar 28 06:21:34 2008 +0000
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,23 +0,0 @@
     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 -