From 93eb6b470773bc49ea6e1a9d4cbd914eb95d525b Mon Sep 17 00:00:00 2001
From: lrj <owen.stl@gmail.com>
Date: 星期二, 30 九月 2025 17:38:04 +0800
Subject: [PATCH] feat: 完善比赛晋级功能并清理测试文件

---
 backend/db.sql |    2 ++
 1 files changed, 2 insertions(+), 0 deletions(-)

diff --git a/backend/db.sql b/backend/db.sql
index 63ae387..e5f882b 100644
--- a/backend/db.sql
+++ b/backend/db.sql
@@ -13,6 +13,7 @@
   `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
   `rating_scheme_id` bigint NOT NULL,
   `player_max` int DEFAULT NULL COMMENT '浜烘暟涓婇檺',
+  `sort_order` int DEFAULT NULL COMMENT '闃舵鎺掑簭锛屼粠1寮�濮嬭繛缁�',
   `state` int NOT NULL DEFAULT '1' COMMENT '0:鏈彂甯冿紝 1锛氬彂甯冿細2锛氬叧闂�',
   `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `create_user_id` bigint DEFAULT NULL,
@@ -22,6 +23,7 @@
   PRIMARY KEY (`id`) USING BTREE,
   KEY `fk_t_activity_rating_scheme` (`rating_scheme_id`) USING BTREE,
   KEY `idx_t_activity_deadline` (`signup_deadline`) USING BTREE,
+  KEY `idx_t_activity_sort` (`pid`, `sort_order`) USING BTREE,
   CONSTRAINT `fk_t_activity_rating_scheme` FOREIGN KEY (`rating_scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
 ) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 

--
Gitblit v1.8.0