-- =====================================================
-- 添加排课计划参考示例数据
-- 版本: V29
-- 创建时间: 2026-03-18
-- 描述: 为课程添加排课计划参考数据，帮助学校老师了解课程包下的
--       导入课、集体课、五大领域课的排课安排建议
-- =====================================================

-- 排课计划参考数据说明：
-- 根据用户需求，课程体系下有多个课程包，每个课程包包含：
-- 1. 导入课 (INTRODUCTION) - 课程导入，激发兴趣
-- 2. 集体课 (COLLECTIVE) - 集体教学活动
-- 3. 五大领域课 - LANGUAGE(语言)、SOCIETY(社会)、SCIENCE(科学)、ART(艺术)、HEALTH(健康)

-- 为小猪佩奇绘本阅读课程添加排课计划参考
UPDATE `course` SET `schedule_ref_data` = '[
    {
        "lessonType": "INTRODUCTION",
        "title": "导入课",
        "description": "通过图片、视频等形式导入课程主题，激发幼儿学习兴趣",
        "suggestedOrder": 1,
        "durationMinutes": 15,
        "frequency": "每周1次，连续2周",
        "keyPoints": [
            "展示绘本封面，引导观察",
            "提出开放性问题激发兴趣",
            "介绍课程主题和学习目标"
        ],
        "tips": "建议配合实物教具或多媒体资源，增强视觉效果"
    },
    {
        "lessonType": "COLLECTIVE",
        "title": "集体课",
        "description": "全班集体参与的教学活动，培养集体意识和协作能力",
        "suggestedOrder": 2,
        "durationMinutes": 25,
        "frequency": "每周2次，连续4周",
        "keyPoints": [
            "绘本共读，教师引导讲解",
            "互动问答，鼓励幼儿表达",
            "角色扮演或情景模拟",
            "总结分享，巩固学习成果"
        ],
        "tips": "注重全体参与，关注个别差异，给予每个幼儿表达机会"
    },
    {
        "lessonType": "LANGUAGE",
        "title": "语言领域活动",
        "description": "语言表达能力训练，丰富词汇量",
        "suggestedOrder": 3,
        "durationMinutes": 20,
        "frequency": "每周2次",
        "keyPoints": [
            "词汇学习与巩固",
            "句型练习与对话",
            "故事复述与创编",
            "语言游戏活动"
        ],
        "tips": "创设语言环境，鼓励大胆表达，及时给予正面反馈"
    },
    {
        "lessonType": "SOCIETY",
        "title": "社会领域活动",
        "description": "培养社会交往能力和情感认知",
        "suggestedOrder": 4,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "情感认知与表达",
            "社交技能培养",
            "规则意识建立",
            "团队合作活动"
        ],
        "tips": "结合生活实际，引导幼儿体验和反思"
    },
    {
        "lessonType": "SCIENCE",
        "title": "科学领域活动",
        "description": "科学探究与认知能力培养",
        "suggestedOrder": 5,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "观察与发现",
            "探究与实验",
            "分类与比较",
            "记录与分享"
        ],
        "tips": "提供丰富材料，鼓励动手操作，培养科学思维"
    },
    {
        "lessonType": "ART",
        "title": "艺术领域活动",
        "description": "艺术表现与审美能力培养",
        "suggestedOrder": 6,
        "durationMinutes": 25,
        "frequency": "每周1次",
        "keyPoints": [
            "欣赏与感受",
            "创作与表现",
            "分享与评价",
            "作品展示活动"
        ],
        "tips": "尊重幼儿创意，提供多样化材料，鼓励自由表达"
    },
    {
        "lessonType": "HEALTH",
        "title": "健康领域活动",
        "description": "身体运动与健康生活习惯培养",
        "suggestedOrder": 7,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "身体协调训练",
            "生活习惯养成",
            "安全意识教育",
            "情绪管理学习"
        ],
        "tips": "结合游戏活动，注重趣味性和参与度"
    }
]' WHERE `name` = '小猪佩奇绘本阅读';

-- 为好饿的毛毛虫课程添加排课计划参考
UPDATE `course` SET `schedule_ref_data` = '[
    {
        "lessonType": "INTRODUCTION",
        "title": "导入课",
        "description": "通过毛毛虫玩偶导入课程，激发幼儿对生命成长的好奇",
        "suggestedOrder": 1,
        "durationMinutes": 15,
        "frequency": "每周1次，连续2周",
        "keyPoints": [
            "出示毛毛虫玩偶，激发兴趣",
            "提问关于毛毛虫的问题",
            "介绍成长的概念"
        ],
        "tips": "准备真实的毛毛虫或蝴蝶标本，增强直观感受"
    },
    {
        "lessonType": "COLLECTIVE",
        "title": "集体课",
        "description": "绘本共读，了解毛毛虫的成长过程",
        "suggestedOrder": 2,
        "durationMinutes": 25,
        "frequency": "每周2次，连续4周",
        "keyPoints": [
            "完整讲述绘本故事",
            "讨论每天吃的东西",
            "数数练习（1-5）",
            "认识星期概念"
        ],
        "tips": "使用日历教具，帮助幼儿理解时间概念"
    },
    {
        "lessonType": "LANGUAGE",
        "title": "语言领域活动",
        "description": "词汇扩展与句型练习",
        "suggestedOrder": 3,
        "durationMinutes": 20,
        "frequency": "每周2次",
        "keyPoints": [
            "食物词汇学习",
            "星期词汇学习",
            "简单句型练习",
            "故事复述"
        ],
        "tips": "使用闪卡和实物，增加词汇学习的趣味性"
    },
    {
        "lessonType": "SOCIETY",
        "title": "社会领域活动",
        "description": "生命教育与情感认知",
        "suggestedOrder": 4,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "认识生命成长过程",
            "分享自己的成长经历",
            "关爱生命教育",
            "分享与合作"
        ],
        "tips": "邀请家长分享幼儿成长照片，增强情感连接"
    },
    {
        "lessonType": "SCIENCE",
        "title": "科学领域活动",
        "description": "昆虫观察与自然科学探索",
        "suggestedOrder": 5,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "观察昆虫特征",
            "了解变态发育",
            "种植观察活动",
            "自然探索"
        ],
        "tips": "准备放大镜、观察盒等科学工具"
    },
    {
        "lessonType": "ART",
        "title": "艺术领域活动",
        "description": "创意手工与美术表达",
        "suggestedOrder": 6,
        "durationMinutes": 25,
        "frequency": "每周1次",
        "keyPoints": [
            "毛毛虫手工制作",
            "蝴蝶绘画创作",
            "拼贴画活动",
            "作品展示"
        ],
        "tips": "提供多样化材料，鼓励自由创作"
    },
    {
        "lessonType": "HEALTH",
        "title": "健康领域活动",
        "description": "健康饮食习惯培养",
        "suggestedOrder": 7,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "认识健康食物",
            "了解均衡饮食",
            "良好饮食习惯",
            "身体运动游戏"
        ],
        "tips": "结合健康餐盘游戏，学习食物分类"
    }
]' WHERE `name` = '好饿的毛毛虫';

-- 为三只小猪课程添加排课计划参考
UPDATE `course` SET `schedule_ref_data` = '[
    {
        "lessonType": "INTRODUCTION",
        "title": "导入课",
        "description": "通过小猪玩偶和房子图片导入课程主题",
        "suggestedOrder": 1,
        "durationMinutes": 15,
        "frequency": "每周1次，连续2周",
        "keyPoints": [
            "出示三只小猪图片",
            "提问关于房子的问题",
            "引入建房主题"
        ],
        "tips": "准备不同材质的建筑材料样品"
    },
    {
        "lessonType": "COLLECTIVE",
        "title": "集体课",
        "description": "绘本共读，理解故事情节和寓意",
        "suggestedOrder": 2,
        "durationMinutes": 25,
        "frequency": "每周2次，连续4周",
        "keyPoints": [
            "完整讲述故事",
            "讨论三只房子区别",
            "理解勤劳与智慧",
            "角色扮演活动"
        ],
        "tips": "准备动物头饰，增强角色扮演趣味性"
    },
    {
        "lessonType": "LANGUAGE",
        "title": "语言领域活动",
        "description": "词汇扩展与语言表达",
        "suggestedOrder": 3,
        "durationMinutes": 20,
        "frequency": "每周2次",
        "keyPoints": [
            "建筑材料词汇",
            "形容词学习（结实、轻便等）",
            "对话练习",
            "故事创编"
        ],
        "tips": "使用实物材料，增强词汇学习的直观性"
    },
    {
        "lessonType": "SOCIETY",
        "title": "社会领域活动",
        "description": "劳动教育与团队协作",
        "suggestedOrder": 4,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "认识劳动价值",
            "培养勤劳品质",
            "团队协作游戏",
            "分享劳动成果"
        ],
        "tips": "组织简单的劳动活动，体验劳动乐趣"
    },
    {
        "lessonType": "SCIENCE",
        "title": "科学领域活动",
        "description": "建筑材料与结构探索",
        "suggestedOrder": 5,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "认识不同建筑材料",
            "探索材料特性",
            "简单搭建活动",
            "结构稳定性实验"
        ],
        "tips": "准备积木、纸板等材料，开展搭建游戏"
    },
    {
        "lessonType": "ART",
        "title": "艺术领域活动",
        "description": "美术创作与手工活动",
        "suggestedOrder": 6,
        "durationMinutes": 25,
        "frequency": "每周1次",
        "keyPoints": [
            "房子绘画创作",
            "小猪手工制作",
            "拼贴画活动",
            "作品展示分享"
        ],
        "tips": "鼓励幼儿设计自己的理想房子"
    },
    {
        "lessonType": "HEALTH",
        "title": "健康领域活动",
        "description": "身体运动与安全意识",
        "suggestedOrder": 7,
        "durationMinutes": 20,
        "frequency": "每周1次",
        "keyPoints": [
            "跑跳运动游戏",
            "安全意识教育",
            "躲避游戏",
            "身体协调训练"
        ],
        "tips": "设计安全的追逐游戏，锻炼反应能力"
    }
]' WHERE `name` = '三只小猪';

-- 注意：lesson_type 字段位于 course_lesson 表，不在 course 表中
-- 课程类型（INTRODUCTION, COLLECTIVE, LANGUAGE, SOCIETY, SCIENCE, ART, HEALTH）
-- 在 course_esson 表中定义，此处不需要更新
