EYa8R7wi

1CREATE TABLE IF NOT EXISTS `s1040_db`.`litebans_bans` (
2  `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
3  `uuid` VARCHAR(36) NULL DEFAULT NULL,
4  `ip` VARCHAR(45) NULL DEFAULT NULL,
5  `reason` VARCHAR(2048) NOT NULL,
6  `banned_by_uuid` VARCHAR(36) NULL DEFAULT NULL,
7  `banned_by_name` VARCHAR(128) NULL DEFAULT NULL,
8  `removed_by_uuid` VARCHAR(36) NULL DEFAULT NULL,
9  `removed_by_name` VARCHAR(128) NULL DEFAULT NULL,
10  `removed_by_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP() ON UPDATE CURRENT_TIMESTAMP(),
11  `time` BIGINT(20) NOT NULL,
12  `until` BIGINT(20) NOT NULL,
13  `server_scope` VARCHAR(32) NULL DEFAULT NULL,
14  `server_origin` VARCHAR(32) NULL DEFAULT NULL,
15  `silent` BIT(1) NOT NULL,
16  `ipban` BIT(1) NOT NULL,
17  `active` BIT(1) NOT NULL,
18  `ipban_wildcard` BIT(1) NULL DEFAULT NULL,
19  PRIMARY KEY (`id`),
20  UNIQUE INDEX `id` (`id` ASC) VISIBLE,
21  INDEX `idx_litebans_bans_uuid` (`uuid` ASC) VISIBLE,
22  INDEX `idx_litebans_bans_ip` (`ip` ASC) VISIBLE,
23  INDEX `idx_litebans_bans_banned_by_uuid` (`banned_by_uuid` ASC) VISIBLE,
24  INDEX `idx_litebans_bans_time` (`time` ASC) VISIBLE,
25  INDEX `idx_litebans_bans_until` (`until` ASC) VISIBLE,
26  INDEX `idx_litebans_bans_ipban` (`ipban` ASC) VISIBLE,
27  INDEX `idx_litebans_bans_active` (`active` ASC) VISIBLE,
28  INDEX `idx_litebans_bans_ipban_wildcard` (`ipban_wildcard` ASC) VISIBLE)
29ENGINE = InnoDB
30AUTO_INCREMENT = 2799
31DEFAULT CHARACTER SET = utf8
32COLLATE = utf8_unicode_ci