-- Actualización de datos nutricionales de alimentos (valores por 100g)
-- Fuentes: USDA FoodData Central, tablas nutricionales estándar

-- Agua
UPDATE foods SET calories = 0, proteins = 0, carbs = 0, fats = 0, fiber = 0, category = 'Bebidas' WHERE id = 299;

-- Carbohidratos cocidos
UPDATE foods SET calories = 130, proteins = 2.7, carbs = 28, fats = 0.3, fiber = 0.4 WHERE name = 'Arroz cocido';
UPDATE foods SET calories = 76, proteins = 1.4, carbs = 17.7, fats = 0.1, fiber = 2.5 WHERE name = 'Batata (Cocida)';
UPDATE foods SET calories = 87, proteins = 1.9, carbs = 20.1, fats = 0.1, fiber = 1.8 WHERE name = 'Papa (Cocida)';
UPDATE foods SET calories = 116, proteins = 0.8, carbs = 27.5, fats = 0.2, fiber = 2.1 WHERE name = 'Yautía cocida';
UPDATE foods SET calories = 131, proteins = 5, carbs = 25, fats = 1.1, fiber = 1.8 WHERE name = 'Pasta cruda';
UPDATE foods SET calories = 122, proteins = 1.1, carbs = 31.9, fats = 0.2, fiber = 1.3 WHERE name = 'Plátano Verde (Cocido)';
UPDATE foods SET calories = 116, proteins = 1.1, carbs = 30.5, fats = 0.2, fiber = 2.3 WHERE name = 'Plátano Maduro (Cocido)';
UPDATE foods SET calories = 368, proteins = 14.1, carbs = 64.2, fats = 6.1, fiber = 7 WHERE name = 'Quinoa (cruda)';
UPDATE foods SET calories = 120, proteins = 4.4, carbs = 21.3, fats = 1.9, fiber = 2.8 WHERE name = 'Quinoa (cocida)';
UPDATE foods SET calories = 127, proteins = 4.5, carbs = 27.5, fats = 0.4, fiber = 3.6 WHERE name = 'Trigo cocido';
UPDATE foods SET calories = 89, proteins = 0.7, carbs = 22.8, fats = 0.3, fiber = 2.6 WHERE name = 'Guineito cocido';

-- Panes y tortillas
UPDATE foods SET calories = 218, proteins = 7.5, carbs = 45.2, fats = 1.9, fiber = 6.5 WHERE name = 'Pan integral de hamburguesa';
UPDATE foods SET calories = 257, proteins = 10, carbs = 50.9, fats = 1.5, fiber = 2.1 WHERE name = 'Bagel (regular)';
UPDATE foods SET calories = 265, proteins = 9, carbs = 49, fats = 3.5, fiber = 5 WHERE name = 'Pan integral de sándwich';
UPDATE foods SET calories = 275, proteins = 9.1, carbs = 55.7, fats = 1.2, fiber = 2.2 WHERE name = 'Pan pita';
UPDATE foods SET calories = 218, proteins = 5.7, carbs = 48, fats = 1.1, fiber = 2.7 WHERE name = 'Tortilla de Maíz (pequeña)';
UPDATE foods SET calories = 304, proteins = 8.2, carbs = 53.3, fats = 5.8, fiber = 3.2 WHERE name = 'Tortilla de Trigo (pequeña)';

-- Tubérculos y raíces
UPDATE foods SET calories = 112, proteins = 1.5, carbs = 26.3, fats = 0.2, fiber = 3.2 WHERE name = 'Mapuey';
UPDATE foods SET calories = 387, proteins = 1.2, carbs = 85.7, fats = 0.6, fiber = 12.5 WHERE name = 'Casabe';

-- Cereales
UPDATE foods SET calories = 379, proteins = 13.2, carbs = 67.7, fats = 6.5, fiber = 10.1 WHERE name = 'Hojuelas de avena';
UPDATE foods SET calories = 371, proteins = 7.1, carbs = 80.1, fats = 0.8, fiber = 1.6 WHERE name = 'Crema de arroz';
UPDATE foods SET calories = 387, proteins = 3.2, carbs = 86.1, fats = 1.2, fiber = 2.7 WHERE name = 'Maíz';
UPDATE foods SET calories = 376, proteins = 12.8, carbs = 77.4, fats = 0.6, fiber = 5 WHERE name = 'Couscous';
UPDATE foods SET calories = 387, proteins = 1.2, carbs = 81.5, fats = 3.5, fiber = 1.4 WHERE name = 'Galletas de arroz';

-- Legumbres cocidas
UPDATE foods SET calories = 127, proteins = 8.7, carbs = 22.8, fats = 0.5, fiber = 6.4 WHERE name = 'Habichuelas cocidas';
UPDATE foods SET calories = 116, proteins = 9, carbs = 20.1, fats = 0.4, fiber = 7.9 WHERE name = 'Lentejas';
UPDATE foods SET calories = 343, proteins = 21.7, carbs = 61.8, fats = 1.5, fiber = 15 WHERE name = 'Guandules crudos';
UPDATE foods SET calories = 164, proteins = 8.9, carbs = 27.4, fats = 2.6, fiber = 7.6 WHERE name = 'Garbanzos';

-- Suplementos
UPDATE foods SET calories = 0, proteins = 0, carbs = 0, fats = 0, fiber = 0 WHERE name = 'Creatina monohidrato';
UPDATE foods SET calories = 0, proteins = 0, carbs = 0, fats = 0, fiber = 0 WHERE name = 'Stevia';

-- Alimentos duplicados con datos en 0
UPDATE foods SET calories = 90, proteins = 25, carbs = 0, fats = 1, fiber = 0 WHERE name = 'Tuna enlatada en agua' AND calories = 0;
UPDATE foods SET calories = 160, proteins = 2, carbs = 8.5, fats = 14.7, fiber = 6.7 WHERE name = 'Aguacate' AND calories = 0;
UPDATE foods SET calories = 208, proteins = 24.6, carbs = 0, fats = 11.5, fiber = 0 WHERE name = 'Sardina en lata en agua' AND calories = 0;
