apps/backend/src/infrastructure/database/migrations/0007_allergen_translations_de_en.sqlSQL
insert into allergen_translations(allergen_code, locale, display_name, short_name) values
('GLUTEN','de-DE','Glutenhaltiges Getreide','Gluten'),
('GLUTEN','en-GB','Cereals containing gluten','Gluten'),
('CRUSTACEANS','de-DE','Krebstiere','Krebstiere'),
('CRUSTACEANS','en-GB','Crustaceans','Crustaceans'),
('EGGS','de-DE','Eier','Eier'),
('EGGS','en-GB','Eggs','Eggs'),
('FISH','de-DE','Fisch','Fisch'),
('FISH','en-GB','Fish','Fish'),
('PEANUTS','de-DE','Erdnüsse','Erdnüsse'),
('PEANUTS','en-GB','Peanuts','Peanuts'),
('SOY','de-DE','Soja','Soja'),
('SOY','en-GB','Soybeans','Soy'),
('MILK','de-DE','Milch','Milch'),
('MILK','en-GB','Milk','Milk'),
('NUTS','de-DE','Schalenfrüchte','Nüsse'),
('NUTS','en-GB','Tree nuts','Nuts'),
('CELERY','de-DE','Sellerie','Sellerie'),
('CELERY','en-GB','Celery','Celery'),
('MUSTARD','de-DE','Senf','Senf'),
('MUSTARD','en-GB','Mustard','Mustard'),
('SESAME','de-DE','Sesamsamen','Sesam'),
('SESAME','en-GB','Sesame seeds','Sesame'),
('SULPHITES','de-DE','Schwefeldioxid und Sulfite','Sulfite'),
('SULPHITES','en-GB','Sulphur dioxide and sulphites','Sulphites'),
('LUPIN','de-DE','Lupinen','Lupinen'),
('LUPIN','en-GB','Lupin','Lupin'),
('MOLLUSCS','de-DE','Weichtiere','Weichtiere'),
('MOLLUSCS','en-GB','Molluscs','Molluscs')
on conflict do nothing;