dvander@1403: 
dvander@1403: ALTER TABLE sm_admins ADD immunity INTEGER DEFAULT 0 NOT NULL;
dvander@1403: 
dvander@1403: CREATE TABLE _sm_groups_temp (
dvander@1403:   id INTEGER PRIMARY KEY AUTOINCREMENT,
dvander@1403:   flags varchar(30) NOT NULL,
dvander@1403:   name varchar(120) NOT NULL,
dvander@1403:   immunity_level INTEGER DEFAULT 0 NOT NULL
dvander@1403: );
dvander@1403: INSERT INTO _sm_groups_temp (id, flags, name) SELECT id, flags, name FROM sm_groups;
dvander@1403: UPDATE _sm_groups_temp SET immunity_level = 2 WHERE id IN (SELECT g.id FROM sm_groups g WHERE g.immunity = 'global');
dvander@1403: UPDATE _sm_groups_temp SET immunity_level = 1 WHERE id IN (SELECT g.id FROM sm_groups g WHERE g.immunity = 'default');
dvander@1403: DROP TABLE sm_groups;
dvander@1403: ALTER TABLE _sm_groups_temp RENAME TO sm_groups;
dvander@1403: 
dvander@1403: CREATE TABLE IF NOT EXISTS sm_config (
dvander@1403:   cfg_key varchar(32) NOT NULL,
dvander@1403:   cfg_value varchar(255) NOT NULL,
dvander@1403:   PRIMARY KEY (cfg_key)
dvander@1403: );
dvander@1403: 
dvander@1403: REPLACE INTO sm_config (cfg_key, cfg_value) VALUES ('admin_version', '1.0.0.1409');
dvander@1403: