kT1bzTF5

1CREATE TABLE IF NOT EXISTS `2k_anticheat_bans` (
2  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
3  `steamid` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
4  `license` varchar(100) COLLATE utf8mb4_bin NOT NULL,
5  `reason` varchar(255) COLLATE utf8mb4_bin NOT NULL,
6  `state` enum('active','inactive') COLLATE utf8mb4_bin NOT NULL DEFAULT 'active',
7  `banned_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
8  PRIMARY KEY (`id`),
9  UNIQUE KEY `steamid_license` (`steamid`,`license`)
10) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
11
12CREATE TABLE IF NOT EXISTS `2k_anticheat_logs` (
13  `id` int(11) NOT NULL AUTO_INCREMENT,
14  `steamid` varchar(100) NOT NULL,
15  `player_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
16  `action` varchar(255) NOT NULL,
17  `event_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
18  PRIMARY KEY (`id`)
19) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;