BYxcc9QY

1CREATE TABLE IF NOT EXISTS `player_analytics` (
2`id` int(11) NOT NULL,
3  `server_ip` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
4  `name` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
5  `auth` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
6  `connect_time` int(11) NOT NULL,
7  `connect_date` date NOT NULL,
8  `connect_method` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
9  `numplayers` tinyint(4) NOT NULL,
10  `map` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
11  `duration` int(11) DEFAULT NULL,
12  `flags` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
13  `ip` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
14  `city` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
15  `region` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
16  `country` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
17  `country_code` varchar(2) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
18  `country_code3` varchar(3) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
19  `premium` tinyint(1) DEFAULT NULL,
20  `html_motd_disabled` tinyint(1) DEFAULT NULL,
21  `os` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL
22) ENGINE=InnoDB AUTO_INCREMENT=2025486 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;