1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/configs/sql-init-scripts/mysql/create_admins.sql	Sun Mar 30 07:00:22 2008 +0000
     1.3 @@ -0,0 +1,56 @@
     1.4 +
     1.5 +CREATE TABLE sm_admins (
     1.6 +  id int(10) unsigned NOT NULL auto_increment,
     1.7 +  authtype enum('steam','name','ip') NOT NULL,
     1.8 +  identity varchar(65) NOT NULL,
     1.9 +  password varchar(65),
    1.10 +  flags varchar(30) NOT NULL,
    1.11 +  name varchar(65) NOT NULL,
    1.12 +  immunity int(10) unsigned NOT NULL,
    1.13 +  PRIMARY KEY (id)
    1.14 +);
    1.15 +
    1.16 +CREATE TABLE sm_groups (
    1.17 +  id int(10) unsigned NOT NULL auto_increment,
    1.18 +  flags varchar(30) NOT NULL,
    1.19 +  name varchar(120) NOT NULL,
    1.20 +  immunity_level int(1) unsigned NOT NULL,
    1.21 +  PRIMARY KEY (id)
    1.22 +);
    1.23 +
    1.24 +CREATE TABLE sm_group_immunity (
    1.25 +  group_id int(10) unsigned NOT NULL,
    1.26 +  other_id int(10) unsigned NOT NULL,
    1.27 +  PRIMARY KEY (group_id, other_id)
    1.28 +);
    1.29 +
    1.30 +CREATE TABLE sm_group_overrides (
    1.31 +  group_id int(10) unsigned NOT NULL,
    1.32 +  type enum('command','group') NOT NULL,
    1.33 +  name varchar(32) NOT NULL,
    1.34 +  access enum('allow','deny') NOT NULL,
    1.35 +  PRIMARY KEY (group_id, type, name)
    1.36 +);
    1.37 +
    1.38 +CREATE TABLE sm_overrides (
    1.39 +  type enum('command','group') NOT NULL,
    1.40 +  name varchar(32) NOT NULL,
    1.41 +  flags varchar(30) NOT NULL,
    1.42 +  PRIMARY KEY (type,name)
    1.43 +);
    1.44 +
    1.45 +CREATE TABLE sm_admins_groups (
    1.46 +  admin_id int(10) unsigned NOT NULL,
    1.47 +  group_id int(10) unsigned NOT NULL,
    1.48 +  inherit_order int(10) NOT NULL,
    1.49 +  PRIMARY KEY (admin_id, group_id)
    1.50 +);
    1.51 +
    1.52 +CREATE TABLE IF NOT EXISTS sm_config (
    1.53 +  cfg_key varchar(32) NOT NULL,
    1.54 +  cfg_value varchar(255) NOT NULL,
    1.55 +  PRIMARY KEY (cfg_key)
    1.56 +);
    1.57 +
    1.58 +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';
    1.59 +