Jacek Pyziak
6ef8b0029d
Phase 2 complete: - Seed registration dictionary phrases - Update public and admin registration templates to use translations - Document PAUL plan, apply, summary, and changelog
227 lines
13 KiB
SQL
227 lines
13 KiB
SQL
-- 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');
|