1.1 --- a/configs/sql-init-scripts/sqlite/create_admins.sql	Fri Mar 28 06:21:34 2008 +0000
     1.2 +++ /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.3 @@ -1,54 +0,0 @@
     1.4 -
     1.5 -CREATE TABLE sm_admins (
     1.6 -  id INTEGER PRIMARY KEY AUTOINCREMENT,
     1.7 -  authtype varchar(16) NOT NULL CHECK(authtype IN ('steam', 'ip', 'name')),
     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 INTEGER NOT NULL
    1.13 -);
    1.14 -
    1.15 -CREATE TABLE sm_groups (
    1.16 -  id INTEGER PRIMARY KEY AUTOINCREMENT,
    1.17 -  flags varchar(30) NOT NULL,
    1.18 -  name varchar(120) NOT NULL,
    1.19 -  immunity_level INTEGER NOT NULL
    1.20 -);
    1.21 -
    1.22 -CREATE TABLE sm_group_immunity (
    1.23 -  group_id INTEGER NOT NULL,
    1.24 -  other_id INTEGER NOT NULL,
    1.25 -  PRIMARY KEY (group_id, other_id)
    1.26 -);
    1.27 -
    1.28 -CREATE TABLE sm_group_overrides (
    1.29 -  group_id INTEGER NOT NULL,
    1.30 -  type varchar(16) NOT NULL CHECK (type IN ('command', 'group')),
    1.31 -  name varchar(32) NOT NULL,
    1.32 -  access varchar(16) NOT NULL CHECK (access IN ('allow', 'deny')),
    1.33 -  PRIMARY KEY (group_id, type, name)
    1.34 -);
    1.35 -
    1.36 -CREATE TABLE sm_overrides (
    1.37 -  type varchar(16) NOT NULL CHECK (type IN ('command', 'group')),
    1.38 -  name varchar(32) NOT NULL,
    1.39 -  flags varchar(30) NOT NULL,
    1.40 -  PRIMARY KEY (type,name)
    1.41 -);
    1.42 -
    1.43 -CREATE TABLE sm_admins_groups (
    1.44 -  admin_id INTEGER NOT NULL,
    1.45 -  group_id INTEGER NOT NULL,
    1.46 -  inherit_order int(10) NOT NULL,
    1.47 -  PRIMARY KEY (admin_id, group_id)
    1.48 -);
    1.49 -
    1.50 -CREATE TABLE IF NOT EXISTS sm_config (
    1.51 -  cfg_key varchar(32) NOT NULL,
    1.52 -  cfg_value varchar(255) NOT NULL,
    1.53 -  PRIMARY KEY (cfg_key)
    1.54 -);
    1.55 -
    1.56 -REPLACE INTO sm_config (cfg_key, cfg_value) VALUES ('admin_version', '1.0.0.1409');
    1.57 -