feat: 完善比赛晋级功能并清理测试文件

lrj

昨天 93eb6b470773bc49ea6e1a9d4cbd914eb95d525b

 backend/src/test/java/com/rongyichuang/DatabaseSchemaTest.java

@@ -58,4 +58,20 @@
            System.out.println(table);
        }
    }

    @Test
    public void testForeignKeyConstraints() {
        try {
            String sql = "SELECT CONSTRAINT_NAME, TABLE_NAME, COLUMN_NAME, REFERENCED_TABLE_NAME, REFERENCED_COLUMN_NAME " +
                        "FROM information_schema.KEY_COLUMN_USAGE " +
                        "WHERE TABLE_SCHEMA = 'ryc' AND REFERENCED_TABLE_NAME IS NOT NULL";
            List<Map<String, Object>> result = jdbcTemplate.queryForList(sql);
            System.out.println("=== 外键约束 ===");
            for (Map<String, Object> row : result) {
                System.out.println(row);
            }
        } catch (Exception e) {
            System.out.println("查询外键约束失败: " + e.getMessage());
        }
    }
}