INSERT INTO action.translations_core
(tx_core_loc_key, tx_core_language_code, tx_core_translation)
VALUES
('blocked_priorities', 'en', '%blocked% %priorities%'),
('personal_overview_page_title', 'en', 'Welcome!'),
('personal_work_overview', 'en', 'Work Overview'),
('personal_overview_actions', 'en', 'Things to Do'),
('checkin_stat_change_text', 'en', 'from last period'),
('checkin_stat_change_no_data', 'en', 'no data last period'),
('overview_goals_in_progress', 'en', '%goals% in Progress'),
('overview_added_accomplishments', 'en', 'You added %n% new %accomplishments% during this period. See details.'),
('overview_added_accomplishment', 'en', 'You added %n% new %accomplishment% during this period. See details.'),
('overview_added_priorities', 'en', 'You ended this period with %n% new %priorities%. See details.'),
('overview_added_priority', 'en', 'You ended this period with %n% new %priority%. See details.'),
('personal_overview_recent_highlights', 'en', 'Recent Highlights'),
('checkin_period_no_content', 'en', 'No submissions for this period.'),
('work_overview_tooltip', 'en', 'Stats from %date% to today.'),
('submit_checkin_action_item', 'en', 'Submit %checkin%: Due %date%'),
('overview_no_todo_actions', 'en', 'Nothing to do today'),
('comment_is_self', 'en', '(You)'),
('comment_is_edited', 'en', 'Edited'),
('comments_description', 'en', 'Comments are attached to this check-in period and can be seen by you and your manager.'),
('comment_creation_warning', 'en', 'Comments can be seen by you and your manager.'),
('comment_placeholder', 'en', 'Write a comment...'),
('checkin_general_settings_options_after_deadline_1', 'en', 'Allow submitting missed check-ins for the past'),
('checkin_general_settings_options_after_deadline_2', 'en', 'periods.'),
('overview_unsubmitted_warning', 'en', 'Unsubmitted responses cannot be seen by your manager.'),
('overview_finish_late_checkin', 'en', 'Finish this Check-In'),
('overview_unsubmitted_text', 'en', 'Response not submitted'),
('checkin_accomplishments_late_submission_warning', 'en', '%accomplishments% cannot be edited for past periods.'),
('checkin_priorities_late_submission_warning', 'en', '%priorities% cannot be edited for past periods.')
;

create table action.checkin_comments
(
    comment_id          int                    null,
    cycle_id            int                    null,
    person_id           int                    null,
    commenter_person_id int                    null,
    comment_text        text                   null,
    created_datetime    datetime default now() not null,
    is_edited           tinyint  default 0     null,
    constraint checkin_comments_pk
        primary key (comment_id)
);
alter table checkin_comments
    modify comment_id int auto_increment;

alter table checkin_comments
    auto_increment = 1;
