-- Dictionary phrase seed for XXXV Konferencja registration labels. -- Safe to run more than once: each INSERT checks for an existing Polish key. INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_yes', 'pl', 'Tak' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_yes' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_no', 'pl', 'Nie' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_no' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_missing', 'pl', 'brak' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_missing' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_invoice_data', 'pl', 'Dane do wystawienia faktury' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_invoice_data' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participant_data', 'pl', 'Dane uczestnika' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participant_data' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_institution_data', 'pl', 'Dane instytucji' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_institution_data' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_presentation_data', 'pl', 'Dane wystąpienia' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_presentation_data' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_submit_talk', 'pl', 'Zgłaszam referat' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_submit_talk' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_submit_poster', 'pl', 'Zgłaszam poster' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_submit_poster' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_topic', 'pl', 'Temat' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_topic' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_abstract', 'pl', 'Streszczenie' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_abstract' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_author', 'pl', 'Autor' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_author' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_amount_information', 'pl', 'Informacja o kwocie do zapłaty' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_amount_information' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_selected_options', 'pl', 'Wybrane opcje' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_selected_options' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_fee_discount_2026', 'pl', 'Opłata obniżona (płatność do 03.10.2026)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_fee_discount_2026' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_fee_normal_2026', 'pl', 'Opłata zwykła (płatność po 03.10.2026)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_fee_normal_2026' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_net_price', 'pl', 'Cena netto' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_net_price' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_net_price_no_vat', 'pl', 'Cena netto (bez VAT)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_net_price_no_vat' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_gross_price', 'pl', 'Cena brutto' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_gross_price' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_gross_price_vat', 'pl', 'Cena brutto (z VAT)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_gross_price_vat' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_total_to_pay', 'pl', 'Razem do zapłaty' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_total_to_pay' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_full_conference_label', 'pl', 'Cała konferencja' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_full_conference_label' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_full_cta', 'pl', 'Biorę udział w całej konferencji' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_full_cta' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_one_day_lodging_cta', 'pl', 'Biorę udział w jednym dniu konferencji (z noclegiem)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_one_day_lodging_cta' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_one_day_no_lodging_cta', 'pl', 'Biorę udział w jednym dniu konferencji (bez noclegu)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_one_day_no_lodging_cta' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_full', 'pl', 'cała konferencja' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_full' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_one_day_lodging', 'pl', 'jeden dzień konferencji (z noclegiem)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_one_day_lodging' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_one_day_no_lodging', 'pl', 'jeden dzień konferencji (bez noclegu)' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_one_day_no_lodging' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_select_day', 'pl', 'Proszę zaznaczyć dzień' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_select_day' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_selected_presence_days', 'pl', 'Wskazane dni obecności' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_selected_presence_days' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_full_conference_presence', 'pl', 'Obecność podczas całej konferencji.' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_full_conference_presence' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_single_room_surcharge', 'pl', 'Dopłata do pokoju 1-osobowego' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_single_room_surcharge' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_accompanying_driver_fee', 'pl', 'Opłata za pobyt osoby towarzyszącej lub kierowcy w pokoju dwuosobowym' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_accompanying_driver_fee' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_accompanying_driver', 'pl', 'Osoba towarzysząca/kierowca' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_accompanying_driver' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_preferences', 'pl', 'Udział i preferencje' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_preferences' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_preferences', 'pl', 'Preferencje żywieniowe' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_preferences' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_standard', 'pl', 'dieta standardowa' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_standard' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_special', 'pl', 'dieta specjalna' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_special' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_standard_short', 'pl', 'standardowa' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_standard_short' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_special_short', 'pl', 'specjalna' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_special_short' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet_which', 'pl', 'Jaka?' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet_which' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_conference_price', 'pl', 'Cena za konferencję' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_conference_price' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_consents_expressed', 'pl', 'Wyrażono zgody' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_consents_expressed' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_consent_data', 'pl', 'Zgoda na przetwarzanie danych' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_consent_data' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_consent_image', 'pl', 'Zgoda na przetwarzanie wizerunku' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_consent_image' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_selected_participation_option', 'pl', 'Wybrana opcja udziału' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_selected_participation_option' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_participation_type', 'pl', 'Typ udziału' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_participation_type' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_days', 'pl', 'Dni' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_days' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_diet', 'pl', 'Dieta' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_diet' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_payment_status', 'pl', 'Status opłaty' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_payment_status' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_paid', 'pl', 'opłacone' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_paid' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_unpaid', 'pl', 'nie opłacone' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_unpaid' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_edit', 'pl', 'edytuj' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_edit' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_delete', 'pl', 'usuń' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_delete' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_cancel', 'pl', 'Anuluj' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_cancel' AND lang = 'pl'); INSERT INTO mf_dictionary (keyword, lang, replacement) SELECT 'registration_save', 'pl', 'Zapisz' WHERE NOT EXISTS (SELECT 1 FROM mf_dictionary WHERE keyword = 'registration_save' AND lang = 'pl');