INSERT INTO treks (name, destination, duration_days, max_group_size, price_npr, price_usd, description, difficulty)
VALUES
  ('Annapurna Base Camp', 'Annapurna Region', 12, 10, 85000, 650, 'Trek through lush rhododendron forests and terraced hillsides to the base camp of Annapurna I (8,091m). The trek follows the Modi Khola valley with views of Machhapuchhre (Fishtail), Hiunchuli, and the Annapurna massif. Teahouse accommodation throughout.', 'moderate'),
  ('Langtang Valley', 'Langtang National Park', 7, 8, 55000, 420, 'A shorter trek through the Langtang Valley, known as the valley of glaciers. Passes through Tamang villages, bamboo forests, and alpine meadows. Fewer trekkers than the Annapurna circuit. Good views of Langtang Lirung (7,227m).', 'easy-moderate'),
  ('Everest Base Camp', 'Khumbu Region', 14, 12, 120000, 920, 'The classic trek to the base of the world''s highest mountain. Fly to Lukla, trek through Namche Bazaar, Tengboche monastery, and Gorak Shep to EBC at 5,364m. Acclimatisation days built in. Views of Everest, Lhotse, Nuptse, and Ama Dablam.', 'challenging'),
  ('Poon Hill', 'Annapurna Region', 4, 15, 35000, 270, 'A short sunrise trek with panoramic views of the Annapurna and Dhaulagiri ranges. Starts from Nayapul, passes through Ghorepani, and climbs to Poon Hill (3,210m) for sunrise. Suitable for beginners. Teahouse accommodation.', 'easy');

INSERT INTO bookings (trek_id, customer_name, customer_email, group_size, booking_date, status, created_at)
VALUES
  (1, 'Markus Weber', 'markus@alpineclub-munich.de', 4, '2025-10-15', 'confirmed', '2025-06-20 10:30:00'),
  (3, 'Yuki Tanaka', 'yuki.tanaka@outlook.jp', 2, '2025-11-01', 'confirmed', '2025-07-05 14:15:00'),
  (1, 'Sarah Chen', 'sarah.chen@gmail.com', 3, '2025-10-20', 'pending', '2025-08-12 09:45:00'),
  (4, 'Priya Sharma', 'priya.s@hotmail.com', 6, '2025-12-28', 'confirmed', '2025-09-01 16:00:00'),
  (2, 'Tom Eriksson', 'tom.eriksson@mail.se', 2, '2025-10-08', 'pending', '2025-09-15 11:20:00'),
  (3, 'Lisa Mueller', 'lisa.m@web.de', 1, '2025-11-10', 'confirmed', '2025-09-22 08:30:00');