ALTER TABLE `action`.`translations_core` 
ADD UNIQUE INDEX `tx_core_unique_key` (`tx_core_loc_key` ASC, `tx_core_language_code` ASC) VISIBLE;
;

INSERT IGNORE INTO action.translations_core (tx_core_loc_key, tx_core_language_code, tx_core_translation) VALUES
("nav_side_bar_logout", "en", "Logout"),
("nav_side_bar_help", "en", "Help"),
("nav_page_dashboard", "en", "Dashboard"),
("nav_page_reports", "en", "Reports"),
("nav_page_team", "en", "Team"),
("nav_page_goals", "en", "Goals"),
("nav_page_org", "en", "Org"),
("dashboard_no_goals", "en", "There are no available goals"),
("dashboard_goal_due", "en", "Due:"),
("dashboard_reports", "en", "Reports"),
("dashboard_no_reports", "en", "No reports available"),
("dashboard_open_report", "en", "Open"),
("dashboard_goal_overview", "en", "Goal Status Overview"),
("goal_status_not_started", "en", "Not Started"),
("goal_status_in_progress", "en", "In Progress"),
("goal_status_overdue", "en", "Overdue"),
("goal_status_complete", "en", "Complete"),
("dashboard_assigned_items", "en", "To-Do"),
("dashboard_panel_goal_details", "en", "Goal Details"),
("goals_goals", "en", "Goals"),
("goals_goal_details", "en", "Goal Details"),
("goals_create", "en", "Create new goal"),
("goals_update_assigned_item", "en", "Update assigned item"),
("goals_assigned_item_name", "en", "Name"),
("due_date", "en", "Due Date"),
("goals_assigned_item_status", "en", "Item status"),
("goals_goal_name", "en", "Name"),
("field_required", "en", "Field Required"),
("goals_complete_perc", "en", "Percentage Complete"),
("goals_must_be_perc", "en", "Value must be from 0-100"),
("goals_goal_tasks", "en", "Tasks"),
("goals_goal_delete_task", "en", "Delete task?"),
("goals_goal_no_tasks", "en", "There are no tasks"),
("goals_goal_task_name", "en", "Task name"),
("goals_goal_add_task", "en", "Add task"),
("goals_goal_description", "en", "Description"),
("goals_board_no_items", "en", "There are no items"),
("reports_create_goal", "en", "Create Goal"),
("reports_report", "en", "Report"),
("reports_report_type", "en", "Type"),
("reports_start_date", "en", "Start Date"),
("reports_open_report", "en", "Open"),
("reports_no_reports", "en", "No reports found"),
("switcher_switch_to", "en", "Switch To"),
("switcher_control", "en", "Control"),
("switcher_control_desc", "en", "CSM Dashboard"),
("switcher_configure", "en", "Configure"),
("switcher_configure_desc", "en", "Adjust settings and configure Spectiv"),
("switcher_hierarchy", "en", "Hierarchy"),
("switcher_hierarchy_desc", "en", "Manage your organization's hierarchies"),
("switcher_directory", "en", "Directory"),
("switcher_directory_desc", "en", "Manage your employee directory"),
("switcher_coaching", "en", "Coaching"),
("switcher_coaching_desc", "en", "View and manage your coaching sessions"),
("team_person_name", "en", "Name"),
("team_person_email", "en", "Email"),
("team_view_goal_progress", "en", "View Goal Progress"),
("toolbar_root_accounts", "en", "Root Accounts"),
("toolbar_bookmarked_accounts", "en", "Bookmarked Accounts"),
("toolbar_all_accounts", "en", "All Accounts"),
("cancel", "en", "Cancel"),
("save", "en", "Save"),
("delete", "en", "Delete"),
("no_status", "en", "Could not find status"),
("error_msg", "en", "An error has occurred."),
("support_submitted", "en", "Your request has been submitted. You will receive a response within one business day."),
("to_do_completed", "en", "To-do item completed!"),
("item_updated", "en", "Item updated successfully!"),
("goal_updated", "en", "Goal updated successfully"),
("goal_created", "en", "Goal created successfully"),
("task_updated", "en", "Task updated successfully"),
("task_created", "en", "Task successfully created"),
("task_deleted", "en", "Task successfully deleted"),
("cannot_load_reports", "en", "Cannot load reports"),
("support_contact_support", "en", "Contact Support"),
("support_problem_overview", "en", "Problem Overview"),
("support_problem_desc", "en", "Description"),
("support_attachments", "en", "Attachments (Limit: 6)"),
("support_attachments_desc", "en", "Please include relevant screenshots and/or files."),
("support_select_file", "en", "Select File"),
("submit", "en", "Submit"),
("nav_bar_goals", "en", "Goals"),
("nav_bar_assigned_items", "en", "Assigned Items"),
("assigned_item_not_found", "en", "Assigned Item Not Found"),
("assigned_to", "en", "Assigned To:"),
("filter_statistics_label", "en", "Filter Statistics"),
("filter_button", "en", "Filter"),
("clear_all_button", "en", "Clear All"),
('org_goals_competencies', 'en', 'Goal Category Overview'),
('org_goals_competency', 'en', 'Competency'),
('org_goals_total_goals', 'en', 'Total'),
('type_multirater', 'en', 'Multi Rater'),
('goals_goal_history', 'en', 'History'),
('org_filters_hierarchy', 'en', 'Hierarchy'),
('reports_download_report', 'en', 'Download Report'),
('reports_downloading_report', 'en', 'Downloading Report'),
('goal_history_task_updated', 'en', 'Task Updated: '),
('goal_history_task_created', 'en', 'Task Created: '),
('goal_history_task_completed', 'en', 'Task Completed: '),
('goals_goal_history_progress', 'en', 'Goal progress updated: '),
('goals_goal_history_status_update', 'en', 'Goal status updated: '),
('goals_goal_history_created', 'en', 'Goal created'),
('goals_goal_history_completed', 'en', 'Goal completed'),
('goal_history_task_deleted', 'en', 'Task deleted'),
('assignment_history_updated', 'en', 'Assignment updated'),
('assignment_history_completed', 'en', 'Assignment completed')
;


INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('reports_instructions_alert', 'en', 'As you review your report you can click on a competency or individual item to create a goal connected to it');

UPDATE `action`.`translations_core` SET `tx_core_translation` = 'Goal Category Overview' WHERE (`tx_core_loc_key` = 'org_goals_competencies');
INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('org_goals_competencies_detail', 'en', 'Goal Category Detail');
INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('type_org', 'en', 'Org');

INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('portrait_orientation_warning_header', 'en', 'Please turn your phone');
INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('portrait_orientation_warning_text', 'en', 'This page is designed for PC or landscape view.');

INSERT INTO `action`.`translations_core` (`tx_core_loc_key`, `tx_core_language_code`, `tx_core_translation`) VALUES ('org_goals_unlinked_goals', 'en', 'Unlinked goals');
