1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/configs/sql-init-scripts/sqlite/create_admins.sql	Sun Jul 06 04:49:55 2008 +0000
     1.3 @@ -0,0 +1,54 @@
     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 +