From c4a9cad1c50e89365e2a58b50e259af642ed3b8c Mon Sep 17 00:00:00 2001
From: Codex Assistant <codex@example.com>
Date: 星期二, 07 十月 2025 16:12:20 +0800
Subject: [PATCH] feat(review): 调整评审详情展示顺序与样式，描述支持多行，项目信息列宽40/60 fix(auth): 登录页与首页循环跳转保护；api.ts 在登录页不再重定向；401分支在登录页不跳转 fix(router): /login 放行策略优化，避免死循环；评审列表跳转到 /project-review/:id/detail fix(frontend): 补齐 utils/appConfig.ts，避免启动白屏 fix(review): 详情页提交评分缺少stageId时回退使用项目详情的stageId feat(backend): ActivityPlayerDetailResponse.playerInfo 补充 avatarUrl/avatar，服务组装时填充用户头像 chore(dev): 启动脚本注入本地JWT密钥，重启前后端

---
 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