dvander@1403: 
dvander@1403: CREATE TABLE sm_admins (
dvander@1403:   id INTEGER PRIMARY KEY AUTOINCREMENT,
dvander@1403:   authtype varchar(16) NOT NULL CHECK(authtype IN ('steam', 'ip', 'name')),
dvander@1403:   identity varchar(65) NOT NULL,
dvander@1403:   password varchar(65),
dvander@1403:   flags varchar(30) NOT NULL,
dvander@1403:   name varchar(65) NOT NULL,
dvander@1403:   immunity INTEGER NOT NULL
dvander@1403: );
dvander@1403: 
dvander@1403: CREATE TABLE sm_groups (
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 NOT NULL
dvander@1403: );
dvander@1403: 
dvander@1403: CREATE TABLE sm_group_immunity (
dvander@1403:   group_id INTEGER NOT NULL,
dvander@1403:   other_id INTEGER NOT NULL,
dvander@1403:   PRIMARY KEY (group_id, other_id)
dvander@1403: );
dvander@1403: 
dvander@1403: CREATE TABLE sm_group_overrides (
dvander@1403:   group_id INTEGER NOT NULL,
dvander@1403:   type varchar(16) NOT NULL CHECK (type IN ('command', 'group')),
dvander@1403:   name varchar(32) NOT NULL,
dvander@1403:   access varchar(16) NOT NULL CHECK (access IN ('allow', 'deny')),
dvander@1403:   PRIMARY KEY (group_id, type, name)
dvander@1403: );
dvander@1403: 
dvander@1403: CREATE TABLE sm_overrides (
dvander@1403:   type varchar(16) NOT NULL CHECK (type IN ('command', 'group')),
dvander@1403:   name varchar(32) NOT NULL,
dvander@1403:   flags varchar(30) NOT NULL,
dvander@1403:   PRIMARY KEY (type,name)
dvander@1403: );
dvander@1403: 
dvander@1403: CREATE TABLE sm_admins_groups (
dvander@1403:   admin_id INTEGER NOT NULL,
dvander@1403:   group_id INTEGER NOT NULL,
dvander@1403:   inherit_order int(10) NOT NULL,
dvander@1403:   PRIMARY KEY (admin_id, group_id)
dvander@1403: );
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: