Database about sourcebans

[ErikMinekus]

There's no list with the default games and settings yet, but this command:

php bin/console doctrine:schema:create --dump-sql

generates this structure:

CREATE TABLE settings (name VARCHAR(32) NOT NULL, value LONGTEXT NOT NULL, PRIMARY KEY(name)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE actions (id INT AUTO_INCREMENT NOT NULL, admin_id SMALLINT DEFAULT NULL, server_id SMALLINT DEFAULT NULL, name VARCHAR(64) DEFAULT NULL, steam VARCHAR(32) DEFAULT NULL, ip VARCHAR(15) DEFAULT NULL, message VARCHAR(255) NOT NULL, admin_ip VARCHAR(32) NOT NULL, create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX admin_id (admin_id), INDEX server_id (server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE admins (id SMALLINT AUTO_INCREMENT NOT NULL, group_id INT DEFAULT NULL, name VARCHAR(64) NOT NULL, auth VARCHAR(255) NOT NULL, identity VARCHAR(64) NOT NULL, password VARCHAR(64) DEFAULT NULL, email VARCHAR(128) DEFAULT NULL, language VARCHAR(2) DEFAULT NULL, theme VARCHAR(32) DEFAULT NULL, timezone VARCHAR(32) DEFAULT NULL, server_password VARCHAR(64) DEFAULT NULL, validation_key VARCHAR(64) DEFAULT NULL, login_time INT(10) UNSIGNED DEFAULT NULL COMMENT '(DC2Type:timestamp)', create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX group_id (group_id), UNIQUE INDEX name (name), UNIQUE INDEX auth (auth, identity), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE admins_server_groups (admin_id SMALLINT NOT NULL, group_id SMALLINT NOT NULL, INDEX IDX_3879E1C6642B8210 (admin_id), INDEX IDX_3879E1C6FE54D947 (group_id), PRIMARY KEY(admin_id, group_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE appeals (id INT AUTO_INCREMENT NOT NULL, ban_id INT DEFAULT NULL, reason VARCHAR(255) NOT NULL, user_email VARCHAR(128) NOT NULL, user_ip VARCHAR(15) NOT NULL, archived TINYINT(1) NOT NULL, create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX ban_id (ban_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE bans (id INT AUTO_INCREMENT NOT NULL, admin_id SMALLINT DEFAULT NULL, server_id SMALLINT DEFAULT NULL, unban_admin_id SMALLINT DEFAULT NULL, type INT NOT NULL, steam VARCHAR(32) DEFAULT NULL, ip VARCHAR(45) DEFAULT NULL, name VARCHAR(64) DEFAULT NULL, reason VARCHAR(255) NOT NULL, length INT NOT NULL, admin_ip VARCHAR(15) NOT NULL, unban_reason VARCHAR(255) DEFAULT NULL, unban_time INT(10) UNSIGNED DEFAULT NULL COMMENT '(DC2Type:timestamp)', create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX server_id (server_id), INDEX admin_id (admin_id), INDEX unban_admin_id (unban_admin_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE blocks (name VARCHAR(64) NOT NULL, create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', ban_id INT NOT NULL, server_id SMALLINT NOT NULL, INDEX ban_id (ban_id), INDEX server_id (server_id), PRIMARY KEY(name, create_time, ban_id, server_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE comments (id INT AUTO_INCREMENT NOT NULL, admin_id SMALLINT DEFAULT NULL, update_admin_id SMALLINT DEFAULT NULL, object_type VARCHAR(1) NOT NULL, object_id INT NOT NULL, message LONGTEXT NOT NULL, update_time INT(10) UNSIGNED DEFAULT NULL COMMENT '(DC2Type:timestamp)', create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX admin_id (admin_id), INDEX object (object_type, object_id), INDEX update_admin_id (update_admin_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE demos (id INT AUTO_INCREMENT NOT NULL, object_type VARCHAR(1) NOT NULL, object_id INT NOT NULL, file VARCHAR(255) NOT NULL, INDEX object (object_type, object_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE games (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, folder VARCHAR(32) NOT NULL, icon VARCHAR(32) NOT NULL, UNIQUE INDEX folder (folder), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE groups (id INT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, roles TEXT DEFAULT NULL COMMENT '(DC2Type:simple_array)', UNIQUE INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE logs (id INT AUTO_INCREMENT NOT NULL, admin_id SMALLINT DEFAULT NULL, type VARCHAR(255) NOT NULL, title VARCHAR(64) NOT NULL, message VARCHAR(255) NOT NULL, function LONGTEXT NOT NULL, query VARCHAR(255) DEFAULT NULL, admin_ip VARCHAR(15) NOT NULL, create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX admin_id (admin_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE overrides (type VARCHAR(255) NOT NULL, name VARCHAR(32) NOT NULL, flags VARCHAR(30) NOT NULL, PRIMARY KEY(type, name)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE plugins (class VARCHAR(255) NOT NULL, status INT NOT NULL, PRIMARY KEY(class)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE reports (id INT AUTO_INCREMENT NOT NULL, server_id SMALLINT DEFAULT NULL, name VARCHAR(64) NOT NULL, steam VARCHAR(32) DEFAULT NULL, ip VARCHAR(15) DEFAULT NULL, reason VARCHAR(255) NOT NULL, user_name VARCHAR(64) NOT NULL, user_email VARCHAR(128) DEFAULT NULL, user_ip VARCHAR(15) NOT NULL, archived TINYINT(1) NOT NULL, create_time INT(10) UNSIGNED NOT NULL COMMENT '(DC2Type:timestamp)', INDEX server_id (server_id), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE servers (id SMALLINT AUTO_INCREMENT NOT NULL, game_id INT DEFAULT NULL, host VARCHAR(255) NOT NULL, port SMALLINT NOT NULL, rcon VARCHAR(32) DEFAULT NULL, enabled TINYINT(1) NOT NULL, INDEX game_id (game_id), UNIQUE INDEX host (host, port), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE servers_server_groups (server_id SMALLINT NOT NULL, group_id SMALLINT NOT NULL, INDEX IDX_E26136D71844E6B7 (server_id), INDEX IDX_E26136D7FE54D947 (group_id), PRIMARY KEY(server_id, group_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE server_groups (id SMALLINT AUTO_INCREMENT NOT NULL, name VARCHAR(32) NOT NULL, flags VARCHAR(32) NOT NULL, immunity SMALLINT NOT NULL, UNIQUE INDEX name (name), PRIMARY KEY(id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE server_groups_immunity (group_id SMALLINT NOT NULL, other_id SMALLINT NOT NULL, INDEX IDX_D662110FFE54D947 (group_id), INDEX IDX_D662110F998D9879 (other_id), PRIMARY KEY(group_id, other_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
CREATE TABLE server_group_overrides (type VARCHAR(255) NOT NULL, name VARCHAR(32) NOT NULL, group_id SMALLINT NOT NULL, access VARCHAR(255) NOT NULL, INDEX group_id (group_id), PRIMARY KEY(type, name, group_id)) DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
ALTER TABLE actions ADD CONSTRAINT FK_548F1EF642B8210 FOREIGN KEY (admin_id) REFERENCES admins (id);
ALTER TABLE actions ADD CONSTRAINT FK_548F1EF1844E6B7 FOREIGN KEY (server_id) REFERENCES servers (id);
ALTER TABLE admins ADD CONSTRAINT FK_A2E0150FFE54D947 FOREIGN KEY (group_id) REFERENCES groups (id);
ALTER TABLE admins_server_groups ADD CONSTRAINT FK_3879E1C6642B8210 FOREIGN KEY (admin_id) REFERENCES admins (id);
ALTER TABLE admins_server_groups ADD CONSTRAINT FK_3879E1C6FE54D947 FOREIGN KEY (group_id) REFERENCES server_groups (id);
ALTER TABLE appeals ADD CONSTRAINT FK_7F4D72A1255CD1D FOREIGN KEY (ban_id) REFERENCES bans (id);
ALTER TABLE bans ADD CONSTRAINT FK_CB0C272C642B8210 FOREIGN KEY (admin_id) REFERENCES admins (id);
ALTER TABLE bans ADD CONSTRAINT FK_CB0C272C1844E6B7 FOREIGN KEY (server_id) REFERENCES servers (id);
ALTER TABLE bans ADD CONSTRAINT FK_CB0C272C7D9D2E73 FOREIGN KEY (unban_admin_id) REFERENCES admins (id);
ALTER TABLE blocks ADD CONSTRAINT FK_CEED95781255CD1D FOREIGN KEY (ban_id) REFERENCES bans (id);
ALTER TABLE blocks ADD CONSTRAINT FK_CEED95781844E6B7 FOREIGN KEY (server_id) REFERENCES servers (id);
ALTER TABLE comments ADD CONSTRAINT FK_5F9E962A642B8210 FOREIGN KEY (admin_id) REFERENCES admins (id);
ALTER TABLE comments ADD CONSTRAINT FK_5F9E962AA00D79B1 FOREIGN KEY (update_admin_id) REFERENCES admins (id);
ALTER TABLE logs ADD CONSTRAINT FK_F08FC65C642B8210 FOREIGN KEY (admin_id) REFERENCES admins (id);
ALTER TABLE reports ADD CONSTRAINT FK_F11FA7451844E6B7 FOREIGN KEY (server_id) REFERENCES servers (id);
ALTER TABLE servers ADD CONSTRAINT FK_4F8AF5F7E48FD905 FOREIGN KEY (game_id) REFERENCES games (id);
ALTER TABLE servers_server_groups ADD CONSTRAINT FK_E26136D71844E6B7 FOREIGN KEY (server_id) REFERENCES servers (id);
ALTER TABLE servers_server_groups ADD CONSTRAINT FK_E26136D7FE54D947 FOREIGN KEY (group_id) REFERENCES server_groups (id);
ALTER TABLE server_groups_immunity ADD CONSTRAINT FK_D662110FFE54D947 FOREIGN KEY (group_id) REFERENCES server_groups (id);
ALTER TABLE server_groups_immunity ADD CONSTRAINT FK_D662110F998D9879 FOREIGN KEY (other_id) REFERENCES server_groups (id);
ALTER TABLE server_group_overrides ADD CONSTRAINT FK_5DE552D9FE54D947 FOREIGN KEY (group_id) REFERENCES server_groups (id);