From aeb0696f457ca85b62d15ab6586c5779cf5cd97b Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Fri, 31 Jul 2026 16:56:21 +0800
Subject: [PATCH] feat(firewall): 添加访问日志功能
---
sql/firewall.sql | 26 ++++++++++++++++++++++++++
1 files changed, 26 insertions(+), 0 deletions(-)
diff --git a/sql/firewall.sql b/sql/firewall.sql
index 36d889d..e2419e7 100644
--- a/sql/firewall.sql
+++ b/sql/firewall.sql
@@ -59,6 +59,32 @@
INDEX idx_ip (IP)
) COMMENT = '防火墙IP白名单表';
+-- ============================================================
+-- 访问日志表
+-- ============================================================
+DROP TABLE IF EXISTS firewall_access_log;
+CREATE TABLE firewall_access_log (
+ ID BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键',
+ REVISION INT DEFAULT 1 COMMENT '乐观锁',
+ CREATED_BY VARCHAR(32) DEFAULT 'system' COMMENT '创建人',
+ CREATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ UPDATED_BY VARCHAR(32) DEFAULT 'system' COMMENT '更新人',
+ UPDATED_TIME DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
+ SITE_ID BIGINT COMMENT '站点ID',
+ IP VARCHAR(64) NOT NULL COMMENT '访问者IP',
+ COUNTRY_CODE VARCHAR(10) COMMENT '国家编码（ISO 3166-1 alpha-2）',
+ COUNTRY_NAME VARCHAR(50) COMMENT '国家名称',
+ USER_AGENT VARCHAR(500) COMMENT '浏览器UA',
+ REQUEST_URI VARCHAR(500) COMMENT '请求路径',
+ IS_BLOCKED TINYINT DEFAULT 0 COMMENT '是否被拦截：1-是，0-否',
+ PRIMARY KEY (ID),
+ INDEX idx_site_id (SITE_ID),
+ INDEX idx_ip (IP),
+ INDEX idx_country (COUNTRY_CODE),
+ INDEX idx_created_time (CREATED_TIME),
+ INDEX idx_blocked (IS_BLOCKED)
+) COMMENT = '防火墙访问日志表';
+
-- ----------------------------
-- 默认数据
-- ----------------------------
--
Gitblit v1.9.1