---

4376-
4377---
4378--- Структура таблицы `xf_ip`
4379---
4380-
4381:CREATE TABLE `xf_ip` (
4382-  `ip_id` int UNSIGNED NOT NULL,
4383-  `user_id` int UNSIGNED NOT NULL,
4384-  `content_type` varbinary(25) NOT NULL,
4385-  `content_id` int UNSIGNED NOT NULL,
4386-  `action` varbinary(25) NOT NULL DEFAULT '',
4387-  `ip` varbinary(16) NOT NULL,
4388-  `log_date` int UNSIGNED NOT NULL
4389-) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
4390-
4391---
4392--- Дамп данных таблицы `xf_ip`
4393---
4394-
4395-INSERT INTO `xf_ip` (`ip_id`, `user_id`, `content_type`, `content_id`, `action`, `ip`, `log_date`) VALUES
4396-(1, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xb28de0e5, 1778798236),
4397-(2, 1, 0x75736572, 1, 0x6c6f67696e, 0xb9c19e4d, 1778798638),
4398-(3, 1, 0x75736572, 1, 0x6c6f67696e, 0xb9c19e50, 1778798832),
4399-(4, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xb9c19e57, 1778798901),
4400-(5, 1, 0x706f7374, 1, '', 0xb9c19e4e, 1778798985),
4401-(6, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb9c19e4c, 1778799101),
4402-(7, 1, 0x75736572, 1, 0x707265666572656e6365735f65646974, 0xb9c19e50, 1778799857),
4403-(8, 1, 0x75736572, 1, 0x6163636f756e745f64657461696c735f65646974, 0xb9c19e51, 1778799907),
4404-(9, 1, 0x75736572, 1, 0x6163636f756e745f64657461696c735f65646974, 0xb9c19e4a, 1778799946),
4405-(10, 1, 0x75736572, 1, 0x6163636f756e745f64657461696c735f65646974, 0xb9c19e53, 1778799980),
4406-(11, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb9c19e4b, 1778800360),
4407-(12, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xc2212d3b, 1778801685),
4408-(13, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xc2212d2e, 1778801759),
4409-(14, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0x5e4d13a3, 1778803335),
4410-(15, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade3b, 1778832272),
4411-(16, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade36, 1778832272),
4412-(17, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade34, 1778832272),
4413-(18, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade3a, 1778832272),
4414-(19, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade38, 1778832272),
4415-(20, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xb92ade36, 1778832286),
4416-(21, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade33, 1778832603),
4417-(22, 1, 0x75736572, 1, 0x636f6f6b69655f6c6f67696e, 0xb92ade3c, 1778832604),
4418-(23, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xb92ade3e, 1778832618),
4419-(24, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0x59cf4876, 1778834410),
4420-(25, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0x59cf4876, 1778835368),
4421-(26, 1, 0x75736572, 1, 0x6c6f67696e5f61646d696e, 0xb92ade33, 1778837357),
--
4753-
4754---
4755--- Структура таблицы `xf_ip_match`
4756---
4757-
4758:CREATE TABLE `xf_ip_match` (
4759-  `ip` varchar(43) COLLATE utf8mb4_general_ci NOT NULL,
4760-  `match_type` enum('banned','discouraged') COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'banned',
4761-  `first_byte` binary(1) NOT NULL,
4762-  `start_range` varbinary(16) NOT NULL,
4763-  `end_range` varbinary(16) NOT NULL,
4764-  `create_user_id` int UNSIGNED NOT NULL DEFAULT '0',
4765-  `create_date` int UNSIGNED NOT NULL DEFAULT '0',