-- =====================================================
-- 幼儿园阅读平台数据库扩展脚本
-- 版本：V13
-- 创建时间：2026-03-16
-- 描述：添加教师端相关表的缺失字段
-- 状态：已手动执行，字段已存在
-- =====================================================

-- 此迁移已执行，所有字段已存在于数据库中
-- 如果未来需要重新初始化数据库，请确保此脚本在 V1__init_schema.sql 之后正确执行

-- 已添加的字段列表：
-- 1. schedule_plan 表：course_id, teacher_id, scheduled_date, scheduled_time, week_day, repeat_type, repeat_end_date, source, note, reminder_sent, reminder_sent_at
-- 2. lesson_feedback 表：design_quality, participation, goal_achievement, step_feedbacks, pros, suggestions, activities_done
-- 3. task_template 表：task_type, related_course_id, default_duration, is_default, status, created_by
-- 4. student_record 表：focus, participation, interest, understanding, domain_achievements
-- 5. lesson 表：schedule_plan_id, planned_datetime, start_datetime, end_datetime, actual_duration, overall_rating, participation_rating, completion_note, progress_data, current_lesson_id, current_step_id, lesson_ids, completed_lesson_ids
-- 6. class_teacher 表：is_primary
-- 7. clazz 表：lesson_count
-- 8. teacher 表：lesson_count, feedback_count
-- 9. course 表：usage_count, teacher_count, avg_rating

SELECT 'V13 迁移已存在，跳过执行' AS status;
