1.1 --- a/configs/sql-init-scripts/mysql/create_admins.sql	Fri Jul 11 06:51:21 2008 +0000
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,56 +0,0 @@
     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 -