| Yu Wang | b0a5fe4 | 2025-06-09 20:50:14 +0800 | [diff] [blame] | 1 | # CREATE TABLE cheating_records ( |
| 2 | # id BIGINT AUTO_INCREMENT PRIMARY KEY, |
| 3 | # info_hash VARCHAR(40), |
| 4 | # user_id BIGINT, |
| 5 | # ip VARCHAR(45) NOT NULL, |
| 6 | # port INT NOT NULL, |
| 7 | # reason TEXT NOT NULL, |
| 8 | # detected_at DATETIME NOT NULL, |
| 9 | # INDEX idx_detected_at (detected_at) |
| 10 | # ); |
| 11 | |
| 12 | CREATE TABLE traffic_anomaly ( |
| 13 | id INT PRIMARY KEY AUTO_INCREMENT, |
| 14 | info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希', |
| 15 | ip VARCHAR(45) NOT NULL COMMENT 'Peer IP', |
| 16 | port INT NOT NULL COMMENT 'Peer 端口', |
| 17 | upload_delta BIGINT NOT NULL COMMENT '本次上传增量（字节）', |
| 18 | download_delta BIGINT NOT NULL COMMENT '本次下载增量（字节）', |
| 19 | occur_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '异常发生时间' |
| 20 | ); |
| 21 | CREATE TABLE client_anomaly ( |
| 22 | id INT PRIMARY KEY AUTO_INCREMENT, |
| 23 | info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希', |
| 24 | ip VARCHAR(45) NOT NULL COMMENT 'Peer IP', |
| 25 | port INT NOT NULL COMMENT 'Peer 端口', |
| 26 | peer_id VARCHAR(60) NOT NULL COMMENT '原始peer_id', |
| 27 | client_type VARCHAR(50) NOT NULL COMMENT '客户端类型（可疑/黑名单）', |
| 28 | occur_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '检测时间' |
| 29 | ); |
| 30 | -- 存储文件级流量异常记录 |
| 31 | CREATE TABLE IF NOT EXISTS file_traffic_anomaly ( |
| 32 | id INT PRIMARY KEY AUTO_INCREMENT, |
| 33 | info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希', |
| 34 | total_upload BIGINT NOT NULL COMMENT '总上传量（字节）', |
| 35 | total_download BIGINT NOT NULL COMMENT '总下载量（字节）', |
| 36 | create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间' |
| 37 | ); |