INSERT INTO action.translations_core
(tx_core_loc_key, tx_core_language_code, tx_core_translation)
VALUES
('form_title_lbl', 'en', '%checkin% Period: %date_range%'),
('form_subtitle_lbl', 'en', 'Your %manager%: %manager_name%'),
('form_return_to_home_lbl', 'en', 'Return to Home'),
('form_progress_bar_aria_lbl', 'en', 'Progress Bar'),
('form_progress_bar_page_lbl', 'en', 'Page %current_page% of %total_pages%'),
('form_page_msg_title_invalid', 'en', 'Invalid Link'),
('form_page_msg_body_invalid', 'en', 'The link you attempted to access is not available.'),
('form_page_msg_title_expired', 'en', 'Expired Link'),
('form_page_msg_body_expired', 'en', 'This %checkin% period has ended.'),
('form_page_msg_title_submitted', 'en', 'Form Complete'),
('form_page_msg_body_submitted', 'en', 'Your %checkin% has been submitted.'),
('form_page_msg_back_to_home_btn', 'en', 'Back to My Dashboard'),
('priority_active_status', 'en', 'Active'),
('priority_blocked_status', 'en', 'Blocked'),
('priority_completed_status', 'en', 'Completed'),
('priority_backlog_status', 'en', 'Backlog'),
('form_priority_status_lbl', 'en', 'Status'),
('form_priority_characters_remaining', 'en', 'Characters remaining: %n%'),
('form_priority_add_active_priority', 'en', 'Add Active %priority%'),
('form_priority_add_from_backlog', 'en', 'Add from Backlog'),
('form_priority_add_new', 'en', 'Create New'),
('form_priority_max_priorities_reached_tooltip', 'en', 'Maximum has been reached'),
('form_page_next_btn', 'en', 'Next'),
('form_page_back_btn', 'en', 'Back'),
('form_page_submit_btn', 'en', 'Submit'),
('form_page_aria_lbl_edit_priority', 'en', 'Edit %priority%'),
('form_page_aria_lbl_priority_text', 'en', '%priority% title'),
('form_page_aria_lbl_search_backlog', 'en', 'search %priority% backlog'),
('form_page_aria_lbl_autocomplete_count', 'en', '%n% options available'),
('form_page_add_accomplishment', 'en', 'Add %accomplishment%'),
('form_page_aria_lbl_edit_accomplishment', 'en', 'Edit %accomplishment%'),
('form_page_aria_lbl_delete_accomplishment', 'en', 'Delete %accomplishment%'),
('form_page_aria_lbl_accomplishment_text', 'en', '%accomplishment% title'),
('form_accomplishment_characters_remaining', 'en', 'Characters remaining: %n%'),
('form_page_continue_btn', 'en', 'Continue'),
('form_page_submit_anyway_btn', 'en', 'Submit Anyway'),
('form_page_unanswered_modal_title', 'en', 'You have unanswered items'),
('form_page_unanswered_modal_descrip', 'en', 'You did not answer the following items, please answer them below and press "%form_page_continue_btn%", or press "%form_page_submit_anyway_btn%" to continue without answering these items.'),
('form_page_unanswered_modal_descrip_required', 'en', 'You have unanswered required items, please answer them below and press "%form_page_continue_btn%"'),
('form_page_unanswered_modal_required_items_lbl', 'en', 'Indicates an item that is required'),
('priority_log_priority_text_changed', 'en', 'title change | %new_value%'),
('priority_log_priority_status_changed', 'en', 'status change | %new_status%'),
('priority_log_priority_deleted', 'en', 'deleted'),
('priority_log_priority_created', 'en', 'created | %new_status%'),
('priority_log_no_history', 'en', 'No history available'),
('checkin_general_settings_deadline_lbl','en', 'Next deadline is: %deadline%'),
('checkin_general_settings_deadline_prediction_lbl', 'en', 'Next deadline will be: %deadline%'),
('checkin_general_settings_calculating_deadline_lbl', 'en', 'Calculating next deadline...'),
('priority_log_method_manual', 'en', 'Dashboard'),
('form_page_immediate_effect_descrip', 'en', 'Changes to this list take effect immediately.'),
;

UPDATE action.translations_core SET tx_core_translation = 'Sunday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_0';
UPDATE action.translations_core SET tx_core_translation = 'Monday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_1';
UPDATE action.translations_core SET tx_core_translation = 'Tuesday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_2';
UPDATE action.translations_core SET tx_core_translation = 'Wednesday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_3';
UPDATE action.translations_core SET tx_core_translation = 'Thursday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_4';
UPDATE action.translations_core SET tx_core_translation = 'Friday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_5';
UPDATE action.translations_core SET tx_core_translation = 'Saturday' WHERE tx_core_loc_key = 'checkin_general_settings_frequency_day_6';