diff -r 000000000000 -r b7aa2b626807 configs/sql-init-scripts/mysql/create_admins.sql --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/configs/sql-init-scripts/mysql/create_admins.sql Sun Mar 30 07:00:22 2008 +0000 @@ -0,0 +1,56 @@ + +CREATE TABLE sm_admins ( + id int(10) unsigned NOT NULL auto_increment, + authtype enum('steam','name','ip') NOT NULL, + identity varchar(65) NOT NULL, + password varchar(65), + flags varchar(30) NOT NULL, + name varchar(65) NOT NULL, + immunity int(10) unsigned NOT NULL, + PRIMARY KEY (id) +); + +CREATE TABLE sm_groups ( + id int(10) unsigned NOT NULL auto_increment, + flags varchar(30) NOT NULL, + name varchar(120) NOT NULL, + immunity_level int(1) unsigned NOT NULL, + PRIMARY KEY (id) +); + +CREATE TABLE sm_group_immunity ( + group_id int(10) unsigned NOT NULL, + other_id int(10) unsigned NOT NULL, + PRIMARY KEY (group_id, other_id) +); + +CREATE TABLE sm_group_overrides ( + group_id int(10) unsigned NOT NULL, + type enum('command','group') NOT NULL, + name varchar(32) NOT NULL, + access enum('allow','deny') NOT NULL, + PRIMARY KEY (group_id, type, name) +); + +CREATE TABLE sm_overrides ( + type enum('command','group') NOT NULL, + name varchar(32) NOT NULL, + flags varchar(30) NOT NULL, + PRIMARY KEY (type,name) +); + +CREATE TABLE sm_admins_groups ( + admin_id int(10) unsigned NOT NULL, + group_id int(10) unsigned NOT NULL, + inherit_order int(10) NOT NULL, + PRIMARY KEY (admin_id, group_id) +); + +CREATE TABLE IF NOT EXISTS sm_config ( + cfg_key varchar(32) NOT NULL, + cfg_value varchar(255) NOT NULL, + PRIMARY KEY (cfg_key) +); + +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'; +