CREATE TABLE `banned_ip` (
                             `id` int unsigned NOT NULL AUTO_INCREMENT,
                             `ip` varchar(48) COLLATE utf8mb4_unicode_ci NOT NULL,
                             `created_at` datetime DEFAULT NULL,
                             `updated_at` datetime DEFAULT NULL,
                             PRIMARY KEY (`id`),
                             UNIQUE KEY `UNQ_ip` (`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='IP黑名单';

ALTER TABLE `user`
    ADD INDEX `idx_ip`(`ip`);