docker,端口,作弊数据库

Change-Id: Ief5141e6e4960f244184b2d307323e541b94cee1
diff --git a/cheat_db.sql b/cheat_db.sql
new file mode 100644
index 0000000..0741e54
--- /dev/null
+++ b/cheat_db.sql
@@ -0,0 +1,37 @@
+# CREATE TABLE cheating_records (
+#                                   id BIGINT AUTO_INCREMENT PRIMARY KEY,
+#                                   info_hash VARCHAR(40),
+#                                   user_id BIGINT,
+#                                   ip VARCHAR(45) NOT NULL,
+#                                   port INT NOT NULL,
+#                                   reason TEXT NOT NULL,
+#                                   detected_at DATETIME NOT NULL,
+#                                   INDEX idx_detected_at (detected_at)
+# );
+
+CREATE TABLE traffic_anomaly (
+                                 id INT PRIMARY KEY AUTO_INCREMENT,
+                                 info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希',
+                                 ip VARCHAR(45) NOT NULL COMMENT 'Peer IP',
+                                 port INT NOT NULL COMMENT 'Peer 端口',
+                                 upload_delta BIGINT NOT NULL COMMENT '本次上传增量(字节)',
+                                 download_delta BIGINT NOT NULL COMMENT '本次下载增量(字节)',
+                                 occur_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '异常发生时间'
+);
+CREATE TABLE client_anomaly (
+                                id INT PRIMARY KEY AUTO_INCREMENT,
+                                info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希',
+                                ip VARCHAR(45) NOT NULL COMMENT 'Peer IP',
+                                port INT NOT NULL COMMENT 'Peer 端口',
+                                peer_id VARCHAR(60) NOT NULL COMMENT '原始peer_id',
+                                client_type VARCHAR(50) NOT NULL COMMENT '客户端类型(可疑/黑名单)',
+                                occur_time DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '检测时间'
+);
+-- 存储文件级流量异常记录
+CREATE TABLE IF NOT EXISTS file_traffic_anomaly (
+                                                    id INT PRIMARY KEY AUTO_INCREMENT,
+                                                    info_hash VARCHAR(40) NOT NULL COMMENT '种子哈希',
+                                                    total_upload BIGINT NOT NULL COMMENT '总上传量(字节)',
+                                                    total_download BIGINT NOT NULL COMMENT '总下载量(字节)',
+                                                    create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '记录时间'
+);
\ No newline at end of file