55 lines
3.4 KiB
SQL
55 lines
3.4 KiB
SQL
-- 活动日程表数据插入脚本
|
||
-- 赛事ID: 200
|
||
-- 表名: martial_activity_schedule
|
||
-- 实际字段: id, competition_id, schedule_date, schedule_time, event_name, venue, description, remark, sort_order, status, create_time, update_time
|
||
|
||
-- 清空现有测试数据（可选）
|
||
-- DELETE FROM martial_activity_schedule WHERE competition_id = 200;
|
||
|
||
-- 插入活动日程数据（三天的赛事安排）
|
||
|
||
-- 第一天：2025-12-25 (报到日)
|
||
INSERT INTO martial_activity_schedule
|
||
(id, competition_id, schedule_date, schedule_time, event_name, venue, sort_order, status, create_time, update_time)
|
||
VALUES
|
||
(2001, 200, '2025-12-25', '08:00:00', '运动员报到', '赛事组委会接待处', 1, 1, NOW(), NOW()),
|
||
(2002, 200, '2025-12-25', '09:00:00', '领取参赛证件及装备', '赛事组委会接待处', 2, 1, NOW(), NOW()),
|
||
(2003, 200, '2025-12-25', '10:00:00', '赛前技术会议', '会议室A', 3, 1, NOW(), NOW()),
|
||
(2004, 200, '2025-12-25', '14:00:00', '场地开放训练', '主赛场', 4, 1, NOW(), NOW()),
|
||
(2005, 200, '2025-12-25', '16:00:00', '裁判员培训会', '会议室B', 5, 1, NOW(), NOW()),
|
||
(2006, 200, '2025-12-25', '18:00:00', '开幕式彩排', '主赛场', 6, 1, NOW(), NOW());
|
||
|
||
-- 第二天：2025-12-26 (正式比赛第一天)
|
||
INSERT INTO martial_activity_schedule
|
||
(id, competition_id, schedule_date, schedule_time, event_name, venue, sort_order, status, create_time, update_time)
|
||
VALUES
|
||
(2007, 200, '2025-12-26', '07:30:00', '运动员检录', '检录处', 7, 1, NOW(), NOW()),
|
||
(2008, 200, '2025-12-26', '08:30:00', '开幕式', '主赛场', 8, 1, NOW(), NOW()),
|
||
(2009, 200, '2025-12-26', '09:00:00', '男子长拳预赛', '主赛场', 9, 1, NOW(), NOW()),
|
||
(2010, 200, '2025-12-26', '10:30:00', '女子长拳预赛', '主赛场', 10, 1, NOW(), NOW()),
|
||
(2011, 200, '2025-12-26', '12:00:00', '午休', '', 11, 1, NOW(), NOW()),
|
||
(2012, 200, '2025-12-26', '14:00:00', '男子太极拳预赛', '主赛场', 12, 1, NOW(), NOW()),
|
||
(2013, 200, '2025-12-26', '15:30:00', '女子太极拳预赛', '主赛场', 13, 1, NOW(), NOW()),
|
||
(2014, 200, '2025-12-26', '17:00:00', '当日赛事总结会', '会议室A', 14, 1, NOW(), NOW());
|
||
|
||
-- 第三天：2025-12-27 (正式比赛第二天 - 决赛日)
|
||
INSERT INTO martial_activity_schedule
|
||
(id, competition_id, schedule_date, schedule_time, event_name, venue, sort_order, status, create_time, update_time)
|
||
VALUES
|
||
(2015, 200, '2025-12-27', '07:30:00', '运动员检录', '检录处', 15, 1, NOW(), NOW()),
|
||
(2016, 200, '2025-12-27', '08:30:00', '男子长拳半决赛', '主赛场', 16, 1, NOW(), NOW()),
|
||
(2017, 200, '2025-12-27', '10:00:00', '女子长拳半决赛', '主赛场', 17, 1, NOW(), NOW()),
|
||
(2018, 200, '2025-12-27', '12:00:00', '午休', '', 18, 1, NOW(), NOW()),
|
||
(2019, 200, '2025-12-27', '14:00:00', '男子长拳决赛', '主赛场', 19, 1, NOW(), NOW()),
|
||
(2020, 200, '2025-12-27', '15:00:00', '女子长拳决赛', '主赛场', 20, 1, NOW(), NOW()),
|
||
(2021, 200, '2025-12-27', '16:00:00', '男子太极拳决赛', '主赛场', 21, 1, NOW(), NOW()),
|
||
(2022, 200, '2025-12-27', '17:00:00', '女子太极拳决赛', '主赛场', 22, 1, NOW(), NOW()),
|
||
(2023, 200, '2025-12-27', '18:00:00', '颁奖典礼', '主赛场', 23, 1, NOW(), NOW()),
|
||
(2024, 200, '2025-12-27', '19:00:00', '闭幕式', '主赛场', 24, 1, NOW(), NOW());
|
||
|
||
-- 查询验证
|
||
SELECT id, competition_id, schedule_date, schedule_time, event_name, venue
|
||
FROM martial_activity_schedule
|
||
WHERE competition_id = 200
|
||
ORDER BY schedule_date, schedule_time;
|