CREATE TABLE sm_admins (

   id int(10) unsigned NOT NULL auto_increment,

   authtype enum('steam','name','ip') NOT NULL,

   identity varchar(65) NOT NULL,

   password varchar(65),

   flags varchar(30) NOT NULL,

   name varchar(65) NOT NULL,

   immunity int(10) unsigned NOT NULL,

   PRIMARY KEY (id)

 );

 CREATE TABLE sm_groups (

   id int(10) unsigned NOT NULL auto_increment,

   flags varchar(30) NOT NULL,

   name varchar(120) NOT NULL,

   immunity_level int(1) unsigned NOT NULL,

   PRIMARY KEY (id)

 );

 CREATE TABLE sm_group_immunity (

   group_id int(10) unsigned NOT NULL,

   other_id int(10) unsigned NOT NULL,

   PRIMARY KEY (group_id, other_id)

 );

 CREATE TABLE sm_group_overrides (

   group_id int(10) unsigned NOT NULL,

   type enum('command','group') NOT NULL,

   name varchar(32) NOT NULL,

   access enum('allow','deny') NOT NULL,

   PRIMARY KEY (group_id, type, name)

 );

 CREATE TABLE sm_overrides (

   type enum('command','group') NOT NULL,

   name varchar(32) NOT NULL,

   flags varchar(30) NOT NULL,

   PRIMARY KEY (type,name)

 );

 CREATE TABLE sm_admins_groups (

   admin_id int(10) unsigned NOT NULL,

   group_id int(10) unsigned NOT NULL,

   inherit_order int(10) NOT NULL,

   PRIMARY KEY (admin_id, group_id)

 );

 CREATE TABLE IF NOT EXISTS sm_config (

   cfg_key varchar(32) NOT NULL,

   cfg_value varchar(255) NOT NULL,

   PRIMARY KEY (cfg_key)

 );

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