-- Corriger les types de véhicules manquants
-- À exécuter dans phpMyAdmin

UPDATE forage_vehicules 
SET type = CASE 
    WHEN id LIKE 'FG-2%' THEN 'Gros camion'
    WHEN id LIKE 'FG-1%' THEN 'Pick-up'
    ELSE type
END
WHERE type = '' OR type IS NULL;

-- Vérification
SELECT type, COUNT(*) as count 
FROM forage_vehicules 
GROUP BY type;
