9cmY1ikx

1
2CREATE TABLE sm_admins (
3  id int(10) unsigned NOT NULL auto_increment,
4  authtype enum('steam','name','ip') NOT NULL,
5  identity varchar(65) NOT NULL,
6  password varchar(65),
7  flags varchar(30) NOT NULL,
8  name varchar(65) NOT NULL,
9  immunity int(10) unsigned NOT NULL,
10  PRIMARY KEY (id)
11);
12
13CREATE TABLE sm_groups (
14  id int(10) unsigned NOT NULL auto_increment,
15  flags varchar(30) NOT NULL,
16  name varchar(120) NOT NULL,
17  immunity_level int(1) unsigned NOT NULL,
18  PRIMARY KEY (id)
19);
20
21CREATE TABLE sm_group_immunity (
22  group_id int(10) unsigned NOT NULL,
23  other_id int(10) unsigned NOT NULL,
24  PRIMARY KEY (group_id, other_id)
25);
26
27CREATE TABLE sm_group_overrides (
28  group_id int(10) unsigned NOT NULL,
29  type enum('command','group') NOT NULL,
30  name varchar(32) NOT NULL,
31  access enum('allow','deny') NOT NULL,
32  PRIMARY KEY (group_id, type, name)
33);
34
35CREATE TABLE sm_overrides (
36  type enum('command','group') NOT NULL,
37  name varchar(32) NOT NULL,
38  flags varchar(30) NOT NULL,
39  PRIMARY KEY (type,name)
40);
41
42CREATE TABLE sm_admins_groups (
43  admin_id int(10) unsigned NOT NULL,
44  group_id int(10) unsigned NOT NULL,
45  inherit_order int(10) NOT NULL,
46  PRIMARY KEY (admin_id, group_id)
47);
48
49CREATE TABLE IF NOT EXISTS sm_config (
50  cfg_key varchar(32) NOT NULL,
51  cfg_value varchar(255) NOT NULL,
52  PRIMARY KEY (cfg_key)
53);
54
55INSERT INTO sm_config (cfg_key, cfg_value) VALUES ('admin_version', '1.0.0.1409') ON DUPLICATE KEY UPDATE cfg_value = '1.0.0.1409';