-- 更新Activity表中的时间数据，为每个比赛设置不同的时间
-- 这个脚本将为不同的比赛设置不同的报名截止时间和比赛时间

-- 更新比赛ID 16 (2011)
UPDATE t_activity SET 
    signup_deadline = '2025-01-15 18:00:00',
    match_time = '2025-01-20 09:00:00'
WHERE id = 16;

-- 更新比赛ID 19 (2012)
UPDATE t_activity SET 
    signup_deadline = '2025-01-20 18:00:00',
    match_time = '2025-01-25 09:00:00'
WHERE id = 19;

-- 更新比赛ID 22 (2013)
UPDATE t_activity SET 
    signup_deadline = '2025-01-25 18:00:00',
    match_time = '2025-01-30 09:00:00'
WHERE id = 22;

-- 更新比赛ID 25 (2020)
UPDATE t_activity SET 
    signup_deadline = '2025-02-01 18:00:00',
    match_time = '2025-02-05 09:00:00'
WHERE id = 25;

-- 更新比赛ID 28 (2021)
UPDATE t_activity SET 
    signup_deadline = '2025-02-05 18:00:00',
    match_time = '2025-02-10 09:00:00'
WHERE id = 28;

-- 更新比赛ID 31 (2030)
UPDATE t_activity SET 
    signup_deadline = '2025-02-10 18:00:00',
    match_time = '2025-02-15 09:00:00'
WHERE id = 31;

-- 更新比赛ID 34 (2031)
UPDATE t_activity SET 
    signup_deadline = '2025-02-15 18:00:00',
    match_time = '2025-02-20 09:00:00'
WHERE id = 34;

-- 更新比赛ID 37 (3001)
UPDATE t_activity SET 
    signup_deadline = '2025-02-20 18:00:00',
    match_time = '2025-02-25 09:00:00'
WHERE id = 37;

-- 更新比赛ID 40 (3002)
UPDATE t_activity SET 
    signup_deadline = '2025-02-25 18:00:00',
    match_time = '2025-03-01 09:00:00'
WHERE id = 40;

-- 更新比赛ID 43 (3003)
UPDATE t_activity SET 
    signup_deadline = '2025-03-01 18:00:00',
    match_time = '2025-03-05 09:00:00'
WHERE id = 43;

-- 验证更新结果
SELECT id, name, signup_deadline, match_time FROM t_activity WHERE id IN (16, 19, 22, 25, 28, 31, 34, 37, 40, 43) ORDER BY id;