

INSERT INTO teacher_profiles (user_id, location, hourly_rate, intro_video_url, about, rating_avg, rating_count)
VALUES
  (2, 'Tokyo, Japan', 28.00, 'https://cdn.inglesdesde.casa/videos/teachers/sora-intro.mp4', 'I specialize in conversation practice and JLPT prep.', 4.8, 120),
  (3, 'Paris, France', 32.00, 'https://cdn.inglesdesde.casa/videos/teachers/marie-intro.mp4', 'I love helping students build confidence in French.', 4.9, 86);

INSERT INTO teacher_languages (teacher_id, language_code) VALUES
  (2, 'ja'), (2, 'en'),
  (3, 'fr'), (3, 'en');

INSERT INTO user_languages (user_id, language_code) VALUES
  (1, 'en'), (1, 'es'), (1, 'ja');

INSERT INTO teacher_availability (teacher_id, day_of_week, start_time, end_time, timezone) VALUES
  (2, 1, '09:00:00', '14:00:00', 'Asia/Tokyo'),
  (2, 3, '18:00:00', '22:00:00', 'Asia/Tokyo'),
  (3, 2, '08:00:00', '12:00:00', 'Europe/Paris'),
  (3, 4, '16:00:00', '20:00:00', 'Europe/Paris');

INSERT INTO teacher_time_off (teacher_id, start_date, end_date, reason) VALUES
  (2, '2026-02-20', '2026-02-21', 'Personal time off');

INSERT INTO textbooks (id, language_code, name) VALUES
  (1, 'en', 'English Foundations'),
  (2, 'es', 'Espanol Diario'),
  (3, 'zh-Hans', 'Mandarin Starter'),
  (4, 'fr', 'Francais Moderne'),
  (5, 'ja', 'Nihongo Now'),
  (6, 'de', 'Deutsch Heute');

INSERT INTO lessons (textbook_id, chapter, title) VALUES
  (1, 'Chapter 1', 'Greetings and Introductions'),
  (1, 'Chapter 2', 'Everyday Questions'),
  (2, 'Unidad 1', 'Saludos'),
  (3, 'Lesson 1', 'Pronunciation Basics'),
  (4, 'Unite 1', 'Bonjour!'),
  (5, 'Lesson 1', 'Hiragana Basics'),
  (6, 'Kapitel 1', 'Hallo');

INSERT INTO promotions (id, title, description, image_url, discount_type, discount_value, starts_at, ends_at, active)
VALUES
  (1, 'Welcome Pack', '20% off your first credit pack.', 'https://cdn.inglesdesde.casa/images/promos/welcome.png', 'percent', 20, '2026-01-01', '2026-12-31', 1);

INSERT INTO promo_codes (code, promotion_id, max_uses, used_count, expires_at) VALUES
  ('WELCOME20', 1, 1000, 5, '2026-12-31');

INSERT INTO hero_items (title, subtitle, image_url, link_url, promo_id) VALUES
  ('New Year Fluency Sprint', 'Join a 4-week challenge and earn bonuses.', 'https://cdn.inglesdesde.casa/images/hero/sprint.png', 'https://inglesdesde.casa/promo/sprint', 1),
  ('Limited 1:1 Spots', 'Book top teachers this week.', 'https://cdn.inglesdesde.casa/images/hero/spots.png', 'https://inglesdesde.casa/promo/spots', NULL);

INSERT INTO announcements (title, body) VALUES
  ('Platform Update', 'We added in-app classroom upgrades and better scheduling.'),
  ('Holiday Hours', 'Support is available 9am-5pm local time.');

INSERT INTO mini_lessons (title, language_code, duration_minutes, content) VALUES
  ('5-Minute Pronunciation Warmup', 'en', 5, 'Focus on vowel clarity and pacing.'),
  ('Saludos Rapidos', 'es', 5, 'Practice quick greetings with native cadence.'),
  ('Hiragana Drill', 'ja', 6, 'Review five base characters.');

INSERT INTO achievements (code, title, description, icon) VALUES
  ('first_class', 'First Class', 'Completed your first class.', 'spark'),
  ('streak_5', '5-Day Streak', 'Completed classes 5 days in a row.', 'flame');

INSERT INTO badges (code, title, description, icon) VALUES
  ('consistent', 'Consistent Learner', 'Finished 10 classes.', 'medal');

INSERT INTO user_achievements (user_id, achievement_id, earned_at) VALUES
  (1, 1, '2026-01-15 10:00:00'),
  (1, 2, '2026-01-20 10:00:00');

INSERT INTO user_badges (user_id, badge_id, earned_at) VALUES
  (1, 1, '2026-01-22 10:00:00');

INSERT INTO classes (id, student_id, teacher_id, start_time_utc, end_time_utc, status, length_minutes, subject, textbook_id, lesson_id, created_at)
VALUES
  (1, 1, 2, '2026-02-07 02:00:00', '2026-02-07 02:25:00', 'upcoming', 25, 'Conversation', 5, 6, '2026-02-01 10:00:00'),
  (2, 1, 3, '2026-01-25 18:00:00', '2026-01-25 18:50:00', 'completed', 50, 'Pronunciation', 4, 5, '2026-01-20 10:00:00');

INSERT INTO class_notes (class_id, notes, recording_url) VALUES
  (2, 'Great improvement on nasal vowels. Keep practicing daily.', 'https://cdn.inglesdesde.casa/recordings/class-2.mp4');

INSERT INTO class_materials (class_id, type, title, url, size, duration, progress) VALUES
  (1, 'pdf', 'Nihongo Now - Lesson 1', 'https://cdn.inglesdesde.casa/materials/nihongo-now-lesson-1.pdf', '1.2 MB', NULL, 0.2),
  (2, 'video', 'Pronunciation Drill', 'https://cdn.inglesdesde.casa/materials/french-pronunciation.mp4', NULL, '15:00', 0.85);

INSERT INTO reviews (class_id, student_id, teacher_id, rating, comment) VALUES
  (2, 1, 3, 5, 'Fantastic session with clear explanations.');

INSERT INTO message_threads (id, student_id, teacher_id, last_message_at) VALUES
  (1, 1, 2, '2026-02-01 12:00:00');

INSERT INTO messages (thread_id, sender_id, content, created_at) VALUES
  (1, 1, 'Hi Sora! Excited for our next class.', '2026-02-01 11:00:00'),
  (1, 2, 'Looking forward to it! Let me know your goals.', '2026-02-01 12:00:00');

INSERT INTO notifications (user_id, type, title, body, created_at) VALUES
  (1, 'class_booked', 'Class booked', 'Your class with Sora is confirmed.', '2026-02-01 11:05:00'),
  (1, 'achievement', 'Achievement unlocked', 'You earned the 5-Day Streak!', '2026-01-20 10:05:00');

INSERT INTO transactions (user_id, provider, method, amount, currency, status, brand, last4, provider_ref)
VALUES
  (1, 'mock', 'apple_pay', 54.00, 'USD', 'succeeded', 'Apple Pay', '1234', 'mock_txn_1'),
  (1, 'mock', 'card', 8.00, 'USD', 'succeeded', 'Visa', '4242', 'mock_txn_2');
