-- Renames the reference-data label column to a stable slug key on Diet,
-- Category (allergens), and Ingredient — see `utils/slugify.ts` and
-- `scripts/generate-catalog-i18n.ts`. The display label these columns used
-- to hold moves to `apps/web`'s `locales/fr/translation.json` (`catalog.*`
-- namespace) instead.

ALTER TABLE "diet" RENAME COLUMN "name" TO "key";
ALTER INDEX "diet_name_key" RENAME TO "diet_key_key";

ALTER TABLE "category" RENAME COLUMN "name" TO "key";
ALTER INDEX "category_name_key" RENAME TO "category_key_key";

ALTER TABLE "ingredients" RENAME COLUMN "name" TO "key";
ALTER INDEX "ingredients_name_key" RENAME TO "ingredients_key_key";

-- Auto-generated by scripts/generate-catalog-i18n.ts — do not hand-edit.
-- Backfills the "key" column (just renamed from "name" by this migration's
-- preceding statement, so it still holds the old French label) to its slug
-- value, for every row already seeded in a database this migration runs
-- against. A fresh database has none of these rows yet (the seed script
-- inserts by "key" from the start), so this is a no-op there.

UPDATE "diet" SET "key" = 'omnivore' WHERE "key" = 'Omnivore';
UPDATE "diet" SET "key" = 'vegetarien' WHERE "key" = 'Végétarien';
UPDATE "diet" SET "key" = 'vegan' WHERE "key" = 'Végan';
UPDATE "diet" SET "key" = 'pescetarien' WHERE "key" = 'Pescétarien';
UPDATE "diet" SET "key" = 'sans_gluten' WHERE "key" = 'Sans gluten';

UPDATE "category" SET "key" = 'gluten' WHERE "key" = 'Gluten';
UPDATE "category" SET "key" = 'crustaces' WHERE "key" = 'Crustacés';
UPDATE "category" SET "key" = 'oeufs' WHERE "key" = 'Œufs';
UPDATE "category" SET "key" = 'poissons' WHERE "key" = 'Poissons';
UPDATE "category" SET "key" = 'arachides' WHERE "key" = 'Arachides';
UPDATE "category" SET "key" = 'soja' WHERE "key" = 'Soja';
UPDATE "category" SET "key" = 'lait' WHERE "key" = 'Lait';
UPDATE "category" SET "key" = 'fruits_a_coque' WHERE "key" = 'Fruits à coque';
UPDATE "category" SET "key" = 'celeri' WHERE "key" = 'Céleri';
UPDATE "category" SET "key" = 'moutarde' WHERE "key" = 'Moutarde';
UPDATE "category" SET "key" = 'graines_de_sesame' WHERE "key" = 'Graines de sésame';
UPDATE "category" SET "key" = 'sulfites' WHERE "key" = 'Sulfites';
UPDATE "category" SET "key" = 'lupin' WHERE "key" = 'Lupin';
UPDATE "category" SET "key" = 'mollusques' WHERE "key" = 'Mollusques';

UPDATE "ingredients" SET "key" = 'tomate' WHERE "key" = 'Tomate';
UPDATE "ingredients" SET "key" = 'oignon' WHERE "key" = 'Oignon';
UPDATE "ingredients" SET "key" = 'echalote' WHERE "key" = 'Échalote';
UPDATE "ingredients" SET "key" = 'ail' WHERE "key" = 'Ail';
UPDATE "ingredients" SET "key" = 'carotte' WHERE "key" = 'Carotte';
UPDATE "ingredients" SET "key" = 'courgette' WHERE "key" = 'Courgette';
UPDATE "ingredients" SET "key" = 'concombre' WHERE "key" = 'Concombre';
UPDATE "ingredients" SET "key" = 'cornichons' WHERE "key" = 'Cornichons';
UPDATE "ingredients" SET "key" = 'poivron' WHERE "key" = 'Poivron';
UPDATE "ingredients" SET "key" = 'champignon' WHERE "key" = 'Champignon';
UPDATE "ingredients" SET "key" = 'cepes' WHERE "key" = 'Cèpes';
UPDATE "ingredients" SET "key" = 'aubergine' WHERE "key" = 'Aubergine';
UPDATE "ingredients" SET "key" = 'brocoli' WHERE "key" = 'Brocoli';
UPDATE "ingredients" SET "key" = 'chou_fleur' WHERE "key" = 'Chou-fleur';
UPDATE "ingredients" SET "key" = 'chou_blanc' WHERE "key" = 'Chou blanc';
UPDATE "ingredients" SET "key" = 'chou_rouge' WHERE "key" = 'Chou rouge';
UPDATE "ingredients" SET "key" = 'chou_de_bruxelles' WHERE "key" = 'Chou de Bruxelles';
UPDATE "ingredients" SET "key" = 'epinard' WHERE "key" = 'Épinard';
UPDATE "ingredients" SET "key" = 'blette' WHERE "key" = 'Blette';
UPDATE "ingredients" SET "key" = 'salade' WHERE "key" = 'Salade';
UPDATE "ingredients" SET "key" = 'roquette' WHERE "key" = 'Roquette';
UPDATE "ingredients" SET "key" = 'cresson' WHERE "key" = 'Cresson';
UPDATE "ingredients" SET "key" = 'poireau' WHERE "key" = 'Poireau';
UPDATE "ingredients" SET "key" = 'celeri' WHERE "key" = 'Céleri';
UPDATE "ingredients" SET "key" = 'radis' WHERE "key" = 'Radis';
UPDATE "ingredients" SET "key" = 'betterave' WHERE "key" = 'Betterave';
UPDATE "ingredients" SET "key" = 'navet' WHERE "key" = 'Navet';
UPDATE "ingredients" SET "key" = 'panais' WHERE "key" = 'Panais';
UPDATE "ingredients" SET "key" = 'haricot_vert' WHERE "key" = 'Haricot vert';
UPDATE "ingredients" SET "key" = 'petit_pois' WHERE "key" = 'Petit pois';
UPDATE "ingredients" SET "key" = 'mais' WHERE "key" = 'Maïs';
UPDATE "ingredients" SET "key" = 'artichaut' WHERE "key" = 'Artichaut';
UPDATE "ingredients" SET "key" = 'fenouil' WHERE "key" = 'Fenouil';
UPDATE "ingredients" SET "key" = 'endive' WHERE "key" = 'Endive';
UPDATE "ingredients" SET "key" = 'potiron' WHERE "key" = 'Potiron';
UPDATE "ingredients" SET "key" = 'butternut' WHERE "key" = 'Butternut';
UPDATE "ingredients" SET "key" = 'asperge' WHERE "key" = 'Asperge';
UPDATE "ingredients" SET "key" = 'avocat' WHERE "key" = 'Avocat';
UPDATE "ingredients" SET "key" = 'pomme_de_terre' WHERE "key" = 'Pomme de terre';
UPDATE "ingredients" SET "key" = 'patate_douce' WHERE "key" = 'Patate douce';
UPDATE "ingredients" SET "key" = 'tomates_cerises' WHERE "key" = 'Tomates cerises';
UPDATE "ingredients" SET "key" = 'pak_choi' WHERE "key" = 'Pak-choï';
UPDATE "ingredients" SET "key" = 'germes_de_soja' WHERE "key" = 'Germes de soja';
UPDATE "ingredients" SET "key" = 'shiitake' WHERE "key" = 'Shiitake';
UPDATE "ingredients" SET "key" = 'daikon' WHERE "key" = 'Daikon';
UPDATE "ingredients" SET "key" = 'piment_vert_frais' WHERE "key" = 'Piment vert frais';
UPDATE "ingredients" SET "key" = 'citron' WHERE "key" = 'Citron';
UPDATE "ingredients" SET "key" = 'citron_vert' WHERE "key" = 'Citron vert';
UPDATE "ingredients" SET "key" = 'pomme' WHERE "key" = 'Pomme';
UPDATE "ingredients" SET "key" = 'poire' WHERE "key" = 'Poire';
UPDATE "ingredients" SET "key" = 'banane' WHERE "key" = 'Banane';
UPDATE "ingredients" SET "key" = 'orange' WHERE "key" = 'Orange';
UPDATE "ingredients" SET "key" = 'clementine' WHERE "key" = 'Clémentine';
UPDATE "ingredients" SET "key" = 'pamplemousse' WHERE "key" = 'Pamplemousse';
UPDATE "ingredients" SET "key" = 'fraise' WHERE "key" = 'Fraise';
UPDATE "ingredients" SET "key" = 'framboise' WHERE "key" = 'Framboise';
UPDATE "ingredients" SET "key" = 'myrtille' WHERE "key" = 'Myrtille';
UPDATE "ingredients" SET "key" = 'mure' WHERE "key" = 'Mûre';
UPDATE "ingredients" SET "key" = 'cerise' WHERE "key" = 'Cerise';
UPDATE "ingredients" SET "key" = 'abricot' WHERE "key" = 'Abricot';
UPDATE "ingredients" SET "key" = 'peche' WHERE "key" = 'Pêche';
UPDATE "ingredients" SET "key" = 'prune' WHERE "key" = 'Prune';
UPDATE "ingredients" SET "key" = 'raisin' WHERE "key" = 'Raisin';
UPDATE "ingredients" SET "key" = 'melon' WHERE "key" = 'Melon';
UPDATE "ingredients" SET "key" = 'pasteque' WHERE "key" = 'Pastèque';
UPDATE "ingredients" SET "key" = 'ananas' WHERE "key" = 'Ananas';
UPDATE "ingredients" SET "key" = 'mangue' WHERE "key" = 'Mangue';
UPDATE "ingredients" SET "key" = 'kiwi' WHERE "key" = 'Kiwi';
UPDATE "ingredients" SET "key" = 'figue' WHERE "key" = 'Figue';
UPDATE "ingredients" SET "key" = 'datte' WHERE "key" = 'Datte';
UPDATE "ingredients" SET "key" = 'litchi' WHERE "key" = 'Litchi';
UPDATE "ingredients" SET "key" = 'grenade' WHERE "key" = 'Grenade';
UPDATE "ingredients" SET "key" = 'rhubarbe' WHERE "key" = 'Rhubarbe';
UPDATE "ingredients" SET "key" = 'coing' WHERE "key" = 'Coing';
UPDATE "ingredients" SET "key" = 'basilic' WHERE "key" = 'Basilic';
UPDATE "ingredients" SET "key" = 'persil' WHERE "key" = 'Persil';
UPDATE "ingredients" SET "key" = 'thym' WHERE "key" = 'Thym';
UPDATE "ingredients" SET "key" = 'romarin' WHERE "key" = 'Romarin';
UPDATE "ingredients" SET "key" = 'laurier' WHERE "key" = 'Laurier';
UPDATE "ingredients" SET "key" = 'ciboulette' WHERE "key" = 'Ciboulette';
UPDATE "ingredients" SET "key" = 'coriandre_fraiche' WHERE "key" = 'Coriandre fraîche';
UPDATE "ingredients" SET "key" = 'menthe' WHERE "key" = 'Menthe';
UPDATE "ingredients" SET "key" = 'origan' WHERE "key" = 'Origan';
UPDATE "ingredients" SET "key" = 'aneth' WHERE "key" = 'Aneth';
UPDATE "ingredients" SET "key" = 'estragon' WHERE "key" = 'Estragon';
UPDATE "ingredients" SET "key" = 'sarriette' WHERE "key" = 'Sarriette';
UPDATE "ingredients" SET "key" = 'marjolaine' WHERE "key" = 'Marjolaine';
UPDATE "ingredients" SET "key" = 'sauge' WHERE "key" = 'Sauge';
UPDATE "ingredients" SET "key" = 'cerfeuil' WHERE "key" = 'Cerfeuil';
UPDATE "ingredients" SET "key" = 'gingembre' WHERE "key" = 'Gingembre';
UPDATE "ingredients" SET "key" = 'citronnelle' WHERE "key" = 'Citronnelle';
UPDATE "ingredients" SET "key" = 'combava' WHERE "key" = 'Combava';
UPDATE "ingredients" SET "key" = 'lapin' WHERE "key" = 'Lapin';
UPDATE "ingredients" SET "key" = 'boeuf_hache' WHERE "key" = 'Bœuf haché';
UPDATE "ingredients" SET "key" = 'steak_de_boeuf' WHERE "key" = 'Steak de bœuf';
UPDATE "ingredients" SET "key" = 'roti_de_boeuf' WHERE "key" = 'Rôti de bœuf';
UPDATE "ingredients" SET "key" = 'escalope_de_veau' WHERE "key" = 'Escalope de veau';
UPDATE "ingredients" SET "key" = 'filet_mignon_de_porc' WHERE "key" = 'Filet mignon de porc';
UPDATE "ingredients" SET "key" = 'cote_de_porc' WHERE "key" = 'Côte de porc';
UPDATE "ingredients" SET "key" = 'agneau' WHERE "key" = 'Agneau';
UPDATE "ingredients" SET "key" = 'gigot_d_agneau' WHERE "key" = 'Gigot d''agneau';
UPDATE "ingredients" SET "key" = 'lardons' WHERE "key" = 'Lardons';
UPDATE "ingredients" SET "key" = 'bacon' WHERE "key" = 'Bacon';
UPDATE "ingredients" SET "key" = 'jambon_blanc' WHERE "key" = 'Jambon blanc';
UPDATE "ingredients" SET "key" = 'jambon_cru' WHERE "key" = 'Jambon cru';
UPDATE "ingredients" SET "key" = 'saucisse' WHERE "key" = 'Saucisse';
UPDATE "ingredients" SET "key" = 'chorizo' WHERE "key" = 'Chorizo';
UPDATE "ingredients" SET "key" = 'merguez' WHERE "key" = 'Merguez';
UPDATE "ingredients" SET "key" = 'prosciutto' WHERE "key" = 'Prosciutto';
UPDATE "ingredients" SET "key" = 'pancetta' WHERE "key" = 'Pancetta';
UPDATE "ingredients" SET "key" = 'mortadelle' WHERE "key" = 'Mortadelle';
UPDATE "ingredients" SET "key" = 'salami' WHERE "key" = 'Salami';
UPDATE "ingredients" SET "key" = 'poulet' WHERE "key" = 'Poulet';
UPDATE "ingredients" SET "key" = 'dinde' WHERE "key" = 'Dinde';
UPDATE "ingredients" SET "key" = 'canard' WHERE "key" = 'Canard';
UPDATE "ingredients" SET "key" = 'magret_de_canard' WHERE "key" = 'Magret de canard';
UPDATE "ingredients" SET "key" = 'saumon' WHERE "key" = 'Saumon';
UPDATE "ingredients" SET "key" = 'thon' WHERE "key" = 'Thon';
UPDATE "ingredients" SET "key" = 'cabillaud' WHERE "key" = 'Cabillaud';
UPDATE "ingredients" SET "key" = 'truite' WHERE "key" = 'Truite';
UPDATE "ingredients" SET "key" = 'sardine' WHERE "key" = 'Sardine';
UPDATE "ingredients" SET "key" = 'anchois' WHERE "key" = 'Anchois';
UPDATE "ingredients" SET "key" = 'merlan' WHERE "key" = 'Merlan';
UPDATE "ingredients" SET "key" = 'surimi' WHERE "key" = 'Surimi';
UPDATE "ingredients" SET "key" = 'bar_loup_de_mer' WHERE "key" = 'Bar (loup de mer)';
UPDATE "ingredients" SET "key" = 'dorade' WHERE "key" = 'Dorade';
UPDATE "ingredients" SET "key" = 'sole' WHERE "key" = 'Sole';
UPDATE "ingredients" SET "key" = 'turbot' WHERE "key" = 'Turbot';
UPDATE "ingredients" SET "key" = 'merlu' WHERE "key" = 'Merlu';
UPDATE "ingredients" SET "key" = 'colin' WHERE "key" = 'Colin';
UPDATE "ingredients" SET "key" = 'lieu_noir' WHERE "key" = 'Lieu noir';
UPDATE "ingredients" SET "key" = 'eglefin' WHERE "key" = 'Églefin';
UPDATE "ingredients" SET "key" = 'maquereau' WHERE "key" = 'Maquereau';
UPDATE "ingredients" SET "key" = 'hareng' WHERE "key" = 'Hareng';
UPDATE "ingredients" SET "key" = 'rouget' WHERE "key" = 'Rouget';
UPDATE "ingredients" SET "key" = 'raie' WHERE "key" = 'Raie';
UPDATE "ingredients" SET "key" = 'lotte' WHERE "key" = 'Lotte';
UPDATE "ingredients" SET "key" = 'fletan' WHERE "key" = 'Flétan';
UPDATE "ingredients" SET "key" = 'espadon' WHERE "key" = 'Espadon';
UPDATE "ingredients" SET "key" = 'carpe' WHERE "key" = 'Carpe';
UPDATE "ingredients" SET "key" = 'brochet' WHERE "key" = 'Brochet';
UPDATE "ingredients" SET "key" = 'perche' WHERE "key" = 'Perche';
UPDATE "ingredients" SET "key" = 'tilapia' WHERE "key" = 'Tilapia';
UPDATE "ingredients" SET "key" = 'panga' WHERE "key" = 'Panga';
UPDATE "ingredients" SET "key" = 'saumon_fume' WHERE "key" = 'Saumon fumé';
UPDATE "ingredients" SET "key" = 'poisson_seche' WHERE "key" = 'Poisson séché';
UPDATE "ingredients" SET "key" = 'crevettes' WHERE "key" = 'Crevettes';
UPDATE "ingredients" SET "key" = 'langoustines' WHERE "key" = 'Langoustines';
UPDATE "ingredients" SET "key" = 'homard' WHERE "key" = 'Homard';
UPDATE "ingredients" SET "key" = 'crabe' WHERE "key" = 'Crabe';
UPDATE "ingredients" SET "key" = 'langouste' WHERE "key" = 'Langouste';
UPDATE "ingredients" SET "key" = 'moules' WHERE "key" = 'Moules';
UPDATE "ingredients" SET "key" = 'huitres' WHERE "key" = 'Huîtres';
UPDATE "ingredients" SET "key" = 'saint_jacques' WHERE "key" = 'Saint-Jacques';
UPDATE "ingredients" SET "key" = 'calamar' WHERE "key" = 'Calamar';
UPDATE "ingredients" SET "key" = 'poulpe' WHERE "key" = 'Poulpe';
UPDATE "ingredients" SET "key" = 'palourdes' WHERE "key" = 'Palourdes';
UPDATE "ingredients" SET "key" = 'bulots' WHERE "key" = 'Bulots';
UPDATE "ingredients" SET "key" = 'semoule' WHERE "key" = 'Semoule';
UPDATE "ingredients" SET "key" = 'couscous' WHERE "key" = 'Couscous';
UPDATE "ingredients" SET "key" = 'boulgour' WHERE "key" = 'Boulgour';
UPDATE "ingredients" SET "key" = 'polenta' WHERE "key" = 'Polenta';
UPDATE "ingredients" SET "key" = 'quinoa' WHERE "key" = 'Quinoa';
UPDATE "ingredients" SET "key" = 'pates' WHERE "key" = 'Pâtes';
UPDATE "ingredients" SET "key" = 'pates_completes' WHERE "key" = 'Pâtes complètes';
UPDATE "ingredients" SET "key" = 'riz' WHERE "key" = 'Riz';
UPDATE "ingredients" SET "key" = 'riz_basmati' WHERE "key" = 'Riz basmati';
UPDATE "ingredients" SET "key" = 'riz_complet' WHERE "key" = 'Riz complet';
UPDATE "ingredients" SET "key" = 'flocons_d_avoine' WHERE "key" = 'Flocons d''avoine';
UPDATE "ingredients" SET "key" = 'spaghetti' WHERE "key" = 'Spaghetti';
UPDATE "ingredients" SET "key" = 'penne' WHERE "key" = 'Penne';
UPDATE "ingredients" SET "key" = 'tagliatelles' WHERE "key" = 'Tagliatelles';
UPDATE "ingredients" SET "key" = 'lasagnes_feuilles' WHERE "key" = 'Lasagnes (feuilles)';
UPDATE "ingredients" SET "key" = 'gnocchi' WHERE "key" = 'Gnocchi';
UPDATE "ingredients" SET "key" = 'riz_arborio' WHERE "key" = 'Riz arborio';
UPDATE "ingredients" SET "key" = 'nouilles_de_riz' WHERE "key" = 'Nouilles de riz';
UPDATE "ingredients" SET "key" = 'nouilles_udon' WHERE "key" = 'Nouilles udon';
UPDATE "ingredients" SET "key" = 'nouilles_soba' WHERE "key" = 'Nouilles soba';
UPDATE "ingredients" SET "key" = 'nouilles_chinoises' WHERE "key" = 'Nouilles chinoises';
UPDATE "ingredients" SET "key" = 'vermicelles_de_riz' WHERE "key" = 'Vermicelles de riz';
UPDATE "ingredients" SET "key" = 'vermicelles_de_soja' WHERE "key" = 'Vermicelles de soja';
UPDATE "ingredients" SET "key" = 'riz_gluant' WHERE "key" = 'Riz gluant';
UPDATE "ingredients" SET "key" = 'riz_a_sushi' WHERE "key" = 'Riz à sushi';
UPDATE "ingredients" SET "key" = 'riz_jasmin' WHERE "key" = 'Riz jasmin';
UPDATE "ingredients" SET "key" = 'lentilles_vertes' WHERE "key" = 'Lentilles vertes';
UPDATE "ingredients" SET "key" = 'lentilles_corail' WHERE "key" = 'Lentilles corail';
UPDATE "ingredients" SET "key" = 'pois_chiches' WHERE "key" = 'Pois chiches';
UPDATE "ingredients" SET "key" = 'haricots_blancs' WHERE "key" = 'Haricots blancs';
UPDATE "ingredients" SET "key" = 'haricots_rouges' WHERE "key" = 'Haricots rouges';
UPDATE "ingredients" SET "key" = 'haricots_noirs' WHERE "key" = 'Haricots noirs';
UPDATE "ingredients" SET "key" = 'pois_casses' WHERE "key" = 'Pois cassés';
UPDATE "ingredients" SET "key" = 'feves' WHERE "key" = 'Fèves';
UPDATE "ingredients" SET "key" = 'edamame' WHERE "key" = 'Edamame';
UPDATE "ingredients" SET "key" = 'haricots_pinto' WHERE "key" = 'Haricots pinto';
UPDATE "ingredients" SET "key" = 'cacahuetes' WHERE "key" = 'Cacahuètes';
UPDATE "ingredients" SET "key" = 'amandes' WHERE "key" = 'Amandes';
UPDATE "ingredients" SET "key" = 'noix' WHERE "key" = 'Noix';
UPDATE "ingredients" SET "key" = 'noisettes' WHERE "key" = 'Noisettes';
UPDATE "ingredients" SET "key" = 'noix_de_cajou' WHERE "key" = 'Noix de cajou';
UPDATE "ingredients" SET "key" = 'pistaches' WHERE "key" = 'Pistaches';
UPDATE "ingredients" SET "key" = 'noix_de_pecan' WHERE "key" = 'Noix de pécan';
UPDATE "ingredients" SET "key" = 'poudre_d_amande' WHERE "key" = 'Poudre d''amande';
UPDATE "ingredients" SET "key" = 'pignons_de_pin' WHERE "key" = 'Pignons de pin';
UPDATE "ingredients" SET "key" = 'graines_de_tournesol' WHERE "key" = 'Graines de tournesol';
UPDATE "ingredients" SET "key" = 'graines_de_courge' WHERE "key" = 'Graines de courge';
UPDATE "ingredients" SET "key" = 'noix_de_coco_rapee' WHERE "key" = 'Noix de coco râpée';
UPDATE "ingredients" SET "key" = 'raisins_secs' WHERE "key" = 'Raisins secs';
UPDATE "ingredients" SET "key" = 'pruneaux' WHERE "key" = 'Pruneaux';
UPDATE "ingredients" SET "key" = 'abricots_secs' WHERE "key" = 'Abricots secs';
UPDATE "ingredients" SET "key" = 'graines_de_sesame' WHERE "key" = 'Graines de sésame';
UPDATE "ingredients" SET "key" = 'champignons_noirs' WHERE "key" = 'Champignons noirs';
UPDATE "ingredients" SET "key" = 'algue_nori' WHERE "key" = 'Algue nori';
UPDATE "ingredients" SET "key" = 'algue_wakame' WHERE "key" = 'Algue wakamé';
UPDATE "ingredients" SET "key" = 'algue_kombu' WHERE "key" = 'Algue kombu';
UPDATE "ingredients" SET "key" = 'pousses_de_bambou' WHERE "key" = 'Pousses de bambou';
UPDATE "ingredients" SET "key" = 'chataignes_d_eau' WHERE "key" = 'Châtaignes d''eau';
UPDATE "ingredients" SET "key" = 'pain' WHERE "key" = 'Pain';
UPDATE "ingredients" SET "key" = 'pain_de_mie' WHERE "key" = 'Pain de mie';
UPDATE "ingredients" SET "key" = 'pain_complet' WHERE "key" = 'Pain complet';
UPDATE "ingredients" SET "key" = 'baguette' WHERE "key" = 'Baguette';
UPDATE "ingredients" SET "key" = 'pain_de_seigle' WHERE "key" = 'Pain de seigle';
UPDATE "ingredients" SET "key" = 'chapelure' WHERE "key" = 'Chapelure';
UPDATE "ingredients" SET "key" = 'pain_a_burger' WHERE "key" = 'Pain à burger';
UPDATE "ingredients" SET "key" = 'pain_brioche' WHERE "key" = 'Pain brioché';
UPDATE "ingredients" SET "key" = 'pain_a_hot_dog' WHERE "key" = 'Pain à hot-dog';
UPDATE "ingredients" SET "key" = 'pain_pita' WHERE "key" = 'Pain pita';
UPDATE "ingredients" SET "key" = 'pain_bagel' WHERE "key" = 'Pain bagel';
UPDATE "ingredients" SET "key" = 'naan' WHERE "key" = 'Naan';
UPDATE "ingredients" SET "key" = 'pain_wrap' WHERE "key" = 'Pain wrap';
UPDATE "ingredients" SET "key" = 'pain_viennois' WHERE "key" = 'Pain viennois';
UPDATE "ingredients" SET "key" = 'pain_de_campagne' WHERE "key" = 'Pain de campagne';
UPDATE "ingredients" SET "key" = 'pain_aux_cereales' WHERE "key" = 'Pain aux céréales';
UPDATE "ingredients" SET "key" = 'petit_pain' WHERE "key" = 'Petit pain';
UPDATE "ingredients" SET "key" = 'pain_suedois' WHERE "key" = 'Pain suédois';
UPDATE "ingredients" SET "key" = 'pain_sans_gluten' WHERE "key" = 'Pain sans gluten';
UPDATE "ingredients" SET "key" = 'biscotte' WHERE "key" = 'Biscotte';
UPDATE "ingredients" SET "key" = 'croutons' WHERE "key" = 'Croûtons';
UPDATE "ingredients" SET "key" = 'focaccia' WHERE "key" = 'Focaccia';
UPDATE "ingredients" SET "key" = 'ciabatta' WHERE "key" = 'Ciabatta';
UPDATE "ingredients" SET "key" = 'tortilla_de_mais' WHERE "key" = 'Tortilla de maïs';
UPDATE "ingredients" SET "key" = 'tortilla_de_ble' WHERE "key" = 'Tortilla de blé';
UPDATE "ingredients" SET "key" = 'pate_feuilletee' WHERE "key" = 'Pâte feuilletée';
UPDATE "ingredients" SET "key" = 'pate_brisee' WHERE "key" = 'Pâte brisée';
UPDATE "ingredients" SET "key" = 'pate_a_pizza' WHERE "key" = 'Pâte à pizza';
UPDATE "ingredients" SET "key" = 'pate_a_tarte_sablee' WHERE "key" = 'Pâte à tarte sablée';
UPDATE "ingredients" SET "key" = 'lait' WHERE "key" = 'Lait';
UPDATE "ingredients" SET "key" = 'beurre' WHERE "key" = 'Beurre';
UPDATE "ingredients" SET "key" = 'creme_fraiche' WHERE "key" = 'Crème fraîche';
UPDATE "ingredients" SET "key" = 'creme_liquide' WHERE "key" = 'Crème liquide';
UPDATE "ingredients" SET "key" = 'fromage' WHERE "key" = 'Fromage';
UPDATE "ingredients" SET "key" = 'emmental' WHERE "key" = 'Emmental';
UPDATE "ingredients" SET "key" = 'gruyere' WHERE "key" = 'Gruyère';
UPDATE "ingredients" SET "key" = 'parmesan' WHERE "key" = 'Parmesan';
UPDATE "ingredients" SET "key" = 'mozzarella' WHERE "key" = 'Mozzarella';
UPDATE "ingredients" SET "key" = 'chevre_fromage' WHERE "key" = 'Chèvre (fromage)';
UPDATE "ingredients" SET "key" = 'feta' WHERE "key" = 'Feta';
UPDATE "ingredients" SET "key" = 'comte' WHERE "key" = 'Comté';
UPDATE "ingredients" SET "key" = 'fromage_blanc' WHERE "key" = 'Fromage blanc';
UPDATE "ingredients" SET "key" = 'mascarpone' WHERE "key" = 'Mascarpone';
UPDATE "ingredients" SET "key" = 'yaourt' WHERE "key" = 'Yaourt';
UPDATE "ingredients" SET "key" = 'burrata' WHERE "key" = 'Burrata';
UPDATE "ingredients" SET "key" = 'ricotta' WHERE "key" = 'Ricotta';
UPDATE "ingredients" SET "key" = 'pecorino' WHERE "key" = 'Pecorino';
UPDATE "ingredients" SET "key" = 'gorgonzola' WHERE "key" = 'Gorgonzola';
UPDATE "ingredients" SET "key" = 'cheddar' WHERE "key" = 'Cheddar';
UPDATE "ingredients" SET "key" = 'oeuf' WHERE "key" = 'Œuf';
UPDATE "ingredients" SET "key" = 'lait_de_coco' WHERE "key" = 'Lait de coco';
UPDATE "ingredients" SET "key" = 'creme_de_coco' WHERE "key" = 'Crème de coco';
UPDATE "ingredients" SET "key" = 'lait_d_amande' WHERE "key" = 'Lait d''amande';
UPDATE "ingredients" SET "key" = 'lait_d_avoine' WHERE "key" = 'Lait d''avoine';
UPDATE "ingredients" SET "key" = 'tofu' WHERE "key" = 'Tofu';
UPDATE "ingredients" SET "key" = 'tofu_soyeux' WHERE "key" = 'Tofu soyeux';
UPDATE "ingredients" SET "key" = 'herbes_de_provence' WHERE "key" = 'Herbes de Provence';
UPDATE "ingredients" SET "key" = 'poivre_noir' WHERE "key" = 'Poivre noir';
UPDATE "ingredients" SET "key" = 'paprika' WHERE "key" = 'Paprika';
UPDATE "ingredients" SET "key" = 'piment_d_espelette' WHERE "key" = 'Piment d''Espelette';
UPDATE "ingredients" SET "key" = 'piment_de_cayenne' WHERE "key" = 'Piment de Cayenne';
UPDATE "ingredients" SET "key" = 'cumin' WHERE "key" = 'Cumin';
UPDATE "ingredients" SET "key" = 'curry_poudre' WHERE "key" = 'Curry (poudre)';
UPDATE "ingredients" SET "key" = 'curcuma' WHERE "key" = 'Curcuma';
UPDATE "ingredients" SET "key" = 'cannelle' WHERE "key" = 'Cannelle';
UPDATE "ingredients" SET "key" = 'muscade' WHERE "key" = 'Muscade';
UPDATE "ingredients" SET "key" = 'safran' WHERE "key" = 'Safran';
UPDATE "ingredients" SET "key" = 'clou_de_girofle' WHERE "key" = 'Clou de girofle';
UPDATE "ingredients" SET "key" = 'vanille_gousse' WHERE "key" = 'Vanille (gousse)';
UPDATE "ingredients" SET "key" = 'poivre_blanc' WHERE "key" = 'Poivre blanc';
UPDATE "ingredients" SET "key" = 'poivre_rose' WHERE "key" = 'Poivre rose';
UPDATE "ingredients" SET "key" = 'poivre_du_sichuan' WHERE "key" = 'Poivre du Sichuan';
UPDATE "ingredients" SET "key" = 'paprika_fume' WHERE "key" = 'Paprika fumé';
UPDATE "ingredients" SET "key" = 'piment_oiseau' WHERE "key" = 'Piment oiseau';
UPDATE "ingredients" SET "key" = 'baies_de_genievre' WHERE "key" = 'Baies de genièvre';
UPDATE "ingredients" SET "key" = 'anis_etoile_badiane' WHERE "key" = 'Anis étoilé (badiane)';
UPDATE "ingredients" SET "key" = 'anis_vert' WHERE "key" = 'Anis vert';
UPDATE "ingredients" SET "key" = 'graines_de_fenouil' WHERE "key" = 'Graines de fenouil';
UPDATE "ingredients" SET "key" = 'sumac' WHERE "key" = 'Sumac';
UPDATE "ingredients" SET "key" = 'nigelle' WHERE "key" = 'Nigelle';
UPDATE "ingredients" SET "key" = 'quatre_epices' WHERE "key" = 'Quatre épices';
UPDATE "ingredients" SET "key" = 'colombo_poudre' WHERE "key" = 'Colombo (poudre)';
UPDATE "ingredients" SET "key" = 'baharat' WHERE "key" = 'Baharat';
UPDATE "ingredients" SET "key" = 'raifort' WHERE "key" = 'Raifort';
UPDATE "ingredients" SET "key" = 'sel_aux_herbes' WHERE "key" = 'Sel aux herbes';
UPDATE "ingredients" SET "key" = 'sel_de_celeri' WHERE "key" = 'Sel de céleri';
UPDATE "ingredients" SET "key" = 'fleur_de_sel' WHERE "key" = 'Fleur de sel';
UPDATE "ingredients" SET "key" = 'sel' WHERE "key" = 'Sel';
UPDATE "ingredients" SET "key" = 'cinq_epices' WHERE "key" = 'Cinq épices';
UPDATE "ingredients" SET "key" = 'garam_masala' WHERE "key" = 'Garam masala';
UPDATE "ingredients" SET "key" = 'graines_de_coriandre' WHERE "key" = 'Graines de coriandre';
UPDATE "ingredients" SET "key" = 'cardamome' WHERE "key" = 'Cardamome';
UPDATE "ingredients" SET "key" = 'fenugrec' WHERE "key" = 'Fenugrec';
UPDATE "ingredients" SET "key" = 'piment_jalapeno' WHERE "key" = 'Piment jalapeño';
UPDATE "ingredients" SET "key" = 'piment_chipotle' WHERE "key" = 'Piment chipotle';
UPDATE "ingredients" SET "key" = 'piment_poblano' WHERE "key" = 'Piment poblano';
UPDATE "ingredients" SET "key" = 'piment_habanero' WHERE "key" = 'Piment habanero';
UPDATE "ingredients" SET "key" = 'ras_el_hanout' WHERE "key" = 'Ras el hanout';
UPDATE "ingredients" SET "key" = 'za_atar' WHERE "key" = 'Za''atar';
UPDATE "ingredients" SET "key" = 'sauce_soja' WHERE "key" = 'Sauce soja';
UPDATE "ingredients" SET "key" = 'moutarde' WHERE "key" = 'Moutarde';
UPDATE "ingredients" SET "key" = 'mayonnaise' WHERE "key" = 'Mayonnaise';
UPDATE "ingredients" SET "key" = 'ketchup' WHERE "key" = 'Ketchup';
UPDATE "ingredients" SET "key" = 'tabasco' WHERE "key" = 'Tabasco';
UPDATE "ingredients" SET "key" = 'sauce_worcestershire' WHERE "key" = 'Sauce Worcestershire';
UPDATE "ingredients" SET "key" = 'sauce_nuoc_mam' WHERE "key" = 'Sauce nuoc-mâm';
UPDATE "ingredients" SET "key" = 'wasabi' WHERE "key" = 'Wasabi';
UPDATE "ingredients" SET "key" = 'harissa' WHERE "key" = 'Harissa';
UPDATE "ingredients" SET "key" = 'pate_de_curry' WHERE "key" = 'Pâte de curry';
UPDATE "ingredients" SET "key" = 'beurre_de_cacahuete' WHERE "key" = 'Beurre de cacahuète';
UPDATE "ingredients" SET "key" = 'moutarde_de_dijon' WHERE "key" = 'Moutarde de Dijon';
UPDATE "ingredients" SET "key" = 'moutarde_a_l_ancienne' WHERE "key" = 'Moutarde à l''ancienne';
UPDATE "ingredients" SET "key" = 'sauce_barbecue' WHERE "key" = 'Sauce barbecue';
UPDATE "ingredients" SET "key" = 'sauce_tartare' WHERE "key" = 'Sauce tartare';
UPDATE "ingredients" SET "key" = 'sauce_cocktail' WHERE "key" = 'Sauce cocktail';
UPDATE "ingredients" SET "key" = 'sauce_bearnaise' WHERE "key" = 'Sauce béarnaise';
UPDATE "ingredients" SET "key" = 'sauce_hollandaise' WHERE "key" = 'Sauce hollandaise';
UPDATE "ingredients" SET "key" = 'sauce_bechamel' WHERE "key" = 'Sauce béchamel';
UPDATE "ingredients" SET "key" = 'sauce_teriyaki' WHERE "key" = 'Sauce teriyaki';
UPDATE "ingredients" SET "key" = 'sauce_ponzu' WHERE "key" = 'Sauce ponzu';
UPDATE "ingredients" SET "key" = 'chimichurri' WHERE "key" = 'Chimichurri';
UPDATE "ingredients" SET "key" = 'pesto_rouge_tomates_sechees' WHERE "key" = 'Pesto rouge (tomates séchées)';
UPDATE "ingredients" SET "key" = 'pesto' WHERE "key" = 'Pesto';
UPDATE "ingredients" SET "key" = 'sauce_huitre' WHERE "key" = 'Sauce huître';
UPDATE "ingredients" SET "key" = 'sauce_hoisin' WHERE "key" = 'Sauce hoisin';
UPDATE "ingredients" SET "key" = 'sauce_sriracha' WHERE "key" = 'Sauce sriracha';
UPDATE "ingredients" SET "key" = 'sauce_sweet_chili' WHERE "key" = 'Sauce sweet chili';
UPDATE "ingredients" SET "key" = 'miso' WHERE "key" = 'Miso';
UPDATE "ingredients" SET "key" = 'pate_de_crevettes' WHERE "key" = 'Pâte de crevettes';
UPDATE "ingredients" SET "key" = 'pate_de_curry_rouge_thai' WHERE "key" = 'Pâte de curry rouge (thaï)';
UPDATE "ingredients" SET "key" = 'pate_de_curry_vert_thai' WHERE "key" = 'Pâte de curry vert (thaï)';
UPDATE "ingredients" SET "key" = 'tahini' WHERE "key" = 'Tahini';
UPDATE "ingredients" SET "key" = 'huile_d_olive' WHERE "key" = 'Huile d''olive';
UPDATE "ingredients" SET "key" = 'huile_de_tournesol' WHERE "key" = 'Huile de tournesol';
UPDATE "ingredients" SET "key" = 'huile_de_colza' WHERE "key" = 'Huile de colza';
UPDATE "ingredients" SET "key" = 'huile_de_coco' WHERE "key" = 'Huile de coco';
UPDATE "ingredients" SET "key" = 'huile_de_sesame' WHERE "key" = 'Huile de sésame';
UPDATE "ingredients" SET "key" = 'vinaigre_de_cidre' WHERE "key" = 'Vinaigre de cidre';
UPDATE "ingredients" SET "key" = 'vinaigre_blanc' WHERE "key" = 'Vinaigre blanc';
UPDATE "ingredients" SET "key" = 'vinaigre_balsamique' WHERE "key" = 'Vinaigre balsamique';
UPDATE "ingredients" SET "key" = 'capres' WHERE "key" = 'Câpres';
UPDATE "ingredients" SET "key" = 'olives' WHERE "key" = 'Olives';
UPDATE "ingredients" SET "key" = 'vin_blanc_cuisine' WHERE "key" = 'Vin blanc (cuisine)';
UPDATE "ingredients" SET "key" = 'vin_rouge_cuisine' WHERE "key" = 'Vin rouge (cuisine)';
UPDATE "ingredients" SET "key" = 'vinaigre_de_vin_rouge' WHERE "key" = 'Vinaigre de vin rouge';
UPDATE "ingredients" SET "key" = 'vinaigre_de_vin_blanc' WHERE "key" = 'Vinaigre de vin blanc';
UPDATE "ingredients" SET "key" = 'vinaigre_de_xeres' WHERE "key" = 'Vinaigre de xérès';
UPDATE "ingredients" SET "key" = 'huile_de_noix' WHERE "key" = 'Huile de noix';
UPDATE "ingredients" SET "key" = 'huile_de_noisette' WHERE "key" = 'Huile de noisette';
UPDATE "ingredients" SET "key" = 'huile_d_arachide' WHERE "key" = 'Huile d''arachide';
UPDATE "ingredients" SET "key" = 'huile_pimentee' WHERE "key" = 'Huile pimentée';
UPDATE "ingredients" SET "key" = 'vinaigre_de_riz' WHERE "key" = 'Vinaigre de riz';
UPDATE "ingredients" SET "key" = 'mirin' WHERE "key" = 'Mirin';
UPDATE "ingredients" SET "key" = 'sake_cuisine' WHERE "key" = 'Saké (cuisine)';
UPDATE "ingredients" SET "key" = 'jus_de_citron' WHERE "key" = 'Jus de citron';
UPDATE "ingredients" SET "key" = 'jus_de_citron_vert' WHERE "key" = 'Jus de citron vert';
UPDATE "ingredients" SET "key" = 'jus_d_orange' WHERE "key" = 'Jus d''orange';
UPDATE "ingredients" SET "key" = 'jus_de_pomme' WHERE "key" = 'Jus de pomme';
UPDATE "ingredients" SET "key" = 'jus_de_raisin' WHERE "key" = 'Jus de raisin';
UPDATE "ingredients" SET "key" = 'jus_de_tomate' WHERE "key" = 'Jus de tomate';
UPDATE "ingredients" SET "key" = 'jus_de_cranberry' WHERE "key" = 'Jus de cranberry';
UPDATE "ingredients" SET "key" = 'cafe' WHERE "key" = 'Café';
UPDATE "ingredients" SET "key" = 'the' WHERE "key" = 'Thé';
UPDATE "ingredients" SET "key" = 'biere_cuisine' WHERE "key" = 'Bière (cuisine)';
UPDATE "ingredients" SET "key" = 'cidre_cuisine' WHERE "key" = 'Cidre (cuisine)';
UPDATE "ingredients" SET "key" = 'champagne_vin_petillant_cuisine' WHERE "key" = 'Champagne / vin pétillant (cuisine)';
UPDATE "ingredients" SET "key" = 'porto_cuisine' WHERE "key" = 'Porto (cuisine)';
UPDATE "ingredients" SET "key" = 'vin_jaune_cuisine' WHERE "key" = 'Vin jaune (cuisine)';
UPDATE "ingredients" SET "key" = 'cognac' WHERE "key" = 'Cognac';
UPDATE "ingredients" SET "key" = 'rhum' WHERE "key" = 'Rhum';
UPDATE "ingredients" SET "key" = 'whisky' WHERE "key" = 'Whisky';
UPDATE "ingredients" SET "key" = 'vodka' WHERE "key" = 'Vodka';
UPDATE "ingredients" SET "key" = 'farine_de_ble' WHERE "key" = 'Farine de blé';
UPDATE "ingredients" SET "key" = 'farine_complete' WHERE "key" = 'Farine complète';
UPDATE "ingredients" SET "key" = 'farine_de_mais' WHERE "key" = 'Farine de maïs';
UPDATE "ingredients" SET "key" = 'farine_de_sarrasin' WHERE "key" = 'Farine de sarrasin';
UPDATE "ingredients" SET "key" = 'farine_de_riz' WHERE "key" = 'Farine de riz';
UPDATE "ingredients" SET "key" = 'bouillon_cube_legumes' WHERE "key" = 'Bouillon cube légumes';
UPDATE "ingredients" SET "key" = 'bouillon_cube_volaille' WHERE "key" = 'Bouillon cube volaille';
UPDATE "ingredients" SET "key" = 'concentre_de_tomate' WHERE "key" = 'Concentré de tomate';
UPDATE "ingredients" SET "key" = 'coulis_de_tomate' WHERE "key" = 'Coulis de tomate';
UPDATE "ingredients" SET "key" = 'tomates_pelees_conserve' WHERE "key" = 'Tomates pelées (conserve)';
UPDATE "ingredients" SET "key" = 'tomates_sechees' WHERE "key" = 'Tomates séchées';
UPDATE "ingredients" SET "key" = 'fond_de_veau' WHERE "key" = 'Fond de veau';
UPDATE "ingredients" SET "key" = 'fond_de_volaille' WHERE "key" = 'Fond de volaille';
UPDATE "ingredients" SET "key" = 'bouillon_cube_boeuf' WHERE "key" = 'Bouillon cube bœuf';
UPDATE "ingredients" SET "key" = 'bouillon_cube_poisson' WHERE "key" = 'Bouillon cube poisson';
UPDATE "ingredients" SET "key" = 'bouillon_de_legumes' WHERE "key" = 'Bouillon de légumes';
UPDATE "ingredients" SET "key" = 'bouillon_de_volaille' WHERE "key" = 'Bouillon de volaille';
UPDATE "ingredients" SET "key" = 'bouillon_de_boeuf' WHERE "key" = 'Bouillon de bœuf';
UPDATE "ingredients" SET "key" = 'court_bouillon' WHERE "key" = 'Court-bouillon';
UPDATE "ingredients" SET "key" = 'dashi_bouillon_japonais' WHERE "key" = 'Dashi (bouillon japonais)';
UPDATE "ingredients" SET "key" = 'bisque_de_crustaces' WHERE "key" = 'Bisque de crustacés';
UPDATE "ingredients" SET "key" = 'farine_de_tapioca' WHERE "key" = 'Farine de tapioca';
UPDATE "ingredients" SET "key" = 'masa_harina' WHERE "key" = 'Masa harina';
UPDATE "ingredients" SET "key" = 'eau' WHERE "key" = 'Eau';
UPDATE "ingredients" SET "key" = 'eau_gazeuse' WHERE "key" = 'Eau gazeuse';
UPDATE "ingredients" SET "key" = 'eau_de_fleur_d_oranger' WHERE "key" = 'Eau de fleur d''oranger';
UPDATE "ingredients" SET "key" = 'eau_de_rose' WHERE "key" = 'Eau de rose';
UPDATE "ingredients" SET "key" = 'fumet_de_poisson' WHERE "key" = 'Fumet de poisson';
UPDATE "ingredients" SET "key" = 'levure_boulangere' WHERE "key" = 'Levure boulangère';
UPDATE "ingredients" SET "key" = 'levure_chimique' WHERE "key" = 'Levure chimique';
UPDATE "ingredients" SET "key" = 'maizena' WHERE "key" = 'Maïzena';
UPDATE "ingredients" SET "key" = 'farine_de_lupin' WHERE "key" = 'Farine de lupin';
UPDATE "ingredients" SET "key" = 'gelatine' WHERE "key" = 'Gélatine';
UPDATE "ingredients" SET "key" = 'bicarbonate_de_soude' WHERE "key" = 'Bicarbonate de soude';
UPDATE "ingredients" SET "key" = 'fecule_de_pomme_de_terre' WHERE "key" = 'Fécule de pomme de terre';
UPDATE "ingredients" SET "key" = 'sucre' WHERE "key" = 'Sucre';
UPDATE "ingredients" SET "key" = 'miel' WHERE "key" = 'Miel';
UPDATE "ingredients" SET "key" = 'sirop_d_erable' WHERE "key" = 'Sirop d''érable';
UPDATE "ingredients" SET "key" = 'sucre_roux' WHERE "key" = 'Sucre roux';
UPDATE "ingredients" SET "key" = 'sucre_glace' WHERE "key" = 'Sucre glace';
UPDATE "ingredients" SET "key" = 'cassonade' WHERE "key" = 'Cassonade';
UPDATE "ingredients" SET "key" = 'chocolat_noir' WHERE "key" = 'Chocolat noir';
UPDATE "ingredients" SET "key" = 'chocolat_au_lait' WHERE "key" = 'Chocolat au lait';
UPDATE "ingredients" SET "key" = 'chocolat_blanc' WHERE "key" = 'Chocolat blanc';
UPDATE "ingredients" SET "key" = 'pepites_de_chocolat' WHERE "key" = 'Pépites de chocolat';
UPDATE "ingredients" SET "key" = 'cacao_en_poudre' WHERE "key" = 'Cacao en poudre';
UPDATE "ingredients" SET "key" = 'extrait_de_vanille' WHERE "key" = 'Extrait de vanille';
UPDATE "ingredients" SET "key" = 'sucre_de_palme' WHERE "key" = 'Sucre de palme';
UPDATE "ingredients" SET "key" = 'sirop_de_sucre_de_canne' WHERE "key" = 'Sirop de sucre de canne';
