
-- Add driver_car and activity_bundle service types to daily_tours
-- These are valid service types that providers can offer

INSERT INTO daily_tours (
  slug,
  title,
  description,
  region_slug,
  duration_hours,
  route_places,
  related_place_types,
  difficulty,
  is_active
) VALUES
(
  'driver_car',
  'Şoförlü Araç Hizmeti',
  'Konforlu ve esnek ulaşım için profesyonel şoförlü araç hizmeti. Kendi programınızı yapın, biz sizi götürelim.',
  'cappadocia',
  8,
  ARRAY[]::TEXT[],
  ARRAY['transportation', 'flexible', 'comfort']::TEXT[],
  'easy',
  true
),
(
  'activity_bundle',
  'Aktivite Paketi',
  'Birden fazla aktiviteyi içeren ekonomik paket turlar. ATV, at safari, balon ve daha fazlası.',
  'cappadocia',
  6,
  ARRAY[]::TEXT[],
  ARRAY['adventure', 'activity', 'atv', 'horse_riding', 'hot_air_balloon']::TEXT[],
  'medium',
  true
)
ON CONFLICT (slug) DO UPDATE SET
  title = EXCLUDED.title,
  description = EXCLUDED.description,
  is_active = EXCLUDED.is_active;

-- Add comment explaining these service types
COMMENT ON COLUMN daily_tours.slug IS 'Service slug - can be tour (red_tour, green_tour, etc.) or service type (private_guide, driver_car, activity_bundle)';
