INSERT INTO action.translations_core
(tx_core_loc_key, tx_core_language_code, tx_core_translation)
VALUES
('checkin_logs_page_title', 'en', 'Email Logs'),
('log_download_email_subject', 'en', 'Your Logs Export is Ready'),
('log_download_text_1', 'en', 'Your requested logs export is ready for download. Click the link below to download your file:'),
('settings_logs', 'en', 'Logs'),
('checkin_logs_no_logs', 'en', 'No email logs found.'),
('checkin_logs_download', 'en', 'Download Logs'),
('person_name', 'en', 'Name'),
('person_unique_identifier', 'en', 'Unique ID'),
('person_email_address', 'en', 'Email Address'),
('email_status', 'en', 'Status'),
('email_log_notes', 'en', 'Notes'),
('checkin_email_settings_reminder_due_date', 'en', 'On due date'),
('checkin_email_settings_reminder_1_before', 'en', '1 day before'),
('checkin_email_settings_reminder_2_before', 'en', '2 days before'),
('checkin_email_settings_reminder', 'en', 'Send email reminders:'),
('checkin_email_settings_time', 'en', 'Email sending time'),
('checkin_email_settings_message', 'en', 'Email Message'),
('email_subject', 'en', 'Subject'),
('settings_email_body', 'en', 'Message'),
('settings_email_link', 'en', 'Link')
;

-- For non-prod where there are already checkins enabled
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkinemail_reminders', '0', account_id FROM action.account_settings GROUP BY account_id;
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkinemail_time_send', '06:00:00', account_id FROM action.account_settings GROUP BY account_id;
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkinemail_subject_en', 'Reminder: Submit your check-in by %DEADLINE_DATE%', account_id FROM action.account_settings GROUP BY account_id;
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkinemail_body_en', 'Hello,</br></br>The deadline to submit your current check-in is %DEADLINE_DATE% at %DEADLINE_TIME%. Please use the link below to complete your check-in.', account_id FROM action.account_settings GROUP BY account_id;
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkinemail_link_text_en', 'Access Check-In Now', account_id FROM action.account_settings GROUP BY account_id;
-- INSERT INTO action.account_settings (setting_key, setting_value, account_id) SELECT 'checkin_allow_submissions_after_deadline', 2, account_id FROM action.account_settings GROUP BY account_id;
