-- 更新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;
|
