INSERT INTO action.translations_terminology (language_code, translation_code, translation)
VALUES 
('en', 'contributions', 'contributions'),
('en', 'contribution', 'contribution');

INSERT INTO action.translations_core
(tx_core_loc_key, tx_core_language_code, tx_core_translation)
VALUES
('form_builder_action_settings', 'en', 'Settings'),
('form_builder_action_preview', 'en', 'Preview'),
('form_builder_action_publish', 'en', 'Publish'),
('form_builder_library_header_lbl', 'en', 'Item Library'),
('form_builder_library_header_descrip', 'en', 'Drag and drop items into the form builder.'),
('form_builder_content_header_lbl', 'en', 'This Form'),
('form_builder_content_header_descrip', 'en', 'Changes will save automatically but are not implemented in the form until published.'),
('form_builder_library_instructional_text_block', 'en', 'Instructional Text Block'),
('form_builder_content_page_header_lbl', 'en', 'Page %n%'),
('form_builder_content_page_item_count_singular', 'en', '%n% Item'),
('form_builder_content_page_item_count_plural', 'en', '%n% Items'),
('form_builder_page_delete_modal_title', 'en', 'Confirmation'),
('form_builder_page_delete_modal_message', 'en', 'Are you sure you want to delete this page from the form?'),
('form_builder_item_delete_modal_title', 'en', 'Confirmation'),
('form_builder_item_delete_modal_message', 'en', 'Are you sure you want to delete this item from the form?'),
('continue', 'en', 'Continue'),
('form_builder_content_item_scale_lbl', 'en', 'Scale:'),
('form_builder_library_work_item_lbl', 'en', 'Work-Based Items'),
('form_builder_library_open_text_lbl', 'en', 'Open Text'),
('form_builder_library_single_select_lbl', 'en', 'Single Select'),
('form_builder_library_create_new_item', 'en', 'Create new item'),
('form_builder_library_no_items', 'en', 'No items found'),
('form_builder_library_instruction_lbl', 'en', 'Instruction'),
('form_builder_content_dictionary_phrase_tooltip', 'en', 'Dictionary phrase can be managed in item settings'),
('form_builder_item_setup_tooltip', 'en', 'Finish setting up this item before publishing the form'),
('form_builder_form_missing_items_toaster', 'en', 'To publish, this form must include at least 1 item.'),
('form_builder_page_missing_items_toaster', 'en', 'To publish, each page must include at least 1 item.'),
('form_builder_publish_modal_title', 'en', 'Publish Form'),
('form_builder_publish_modal_message', 'en', 'Changes to this form will immediately take effect after publishing. Would you like to continue?'),
('form_builder_publish_modal_cancel', 'en', 'Revert Changes'),
('form_builder_publish_modal_confirm', 'en', 'Publish'),
('form_builder_publish_modal_success_toaster', 'en', 'Form published successfully.'),
('form_builder_preview_invalid_toaster', 'en', 'All pages must have at least 1 item to preview the form.'),
('form_builder_page_settings_panel_title', 'en', 'Page Settings'),
('form_builder_item_settings_panel_title', 'en', 'Item Settings'),
('form_builder_page_settings_panel_page_name_lbl', 'en', 'Page Name'),
('form_builder_settings_panel_required_lbl', 'en', 'Required'),
('form_builder_page_settings_panel_required_toggle', 'en', 'Require responses to all items on this page'),
('form_builder_item_settings_panel_required_toggle', 'en', 'Require a response to this item'),
('form_builder_settings_panel_template_checkbox_lbl', 'en', 'Set as a template'),
('form_builder_settings_panel_template_checkbox_tooltip', 'en', 'Templates use the published version of the form and are available to this account and its subaccounts'),
('form_builder_add_form_from_template', 'en', 'Use a Template'),
('form_builder_add_form_new', 'en', 'New Form'),
('form_builder_template_modal_title', 'en', 'Create Form from a Template'),
('form_builder_template_modal_description', 'en', 'Select a template to use for this new form.'),
('form_builder_template_modal_selector_lbl', 'en', 'Template'),
('form_builder_template_modal_form_name_lbl', 'en', 'Form Name'),
('form_builder_template_modal_create_btn', 'en', 'Create'),
('form_builder_item_settings_panel_required_toggle_disabled', 'en', 'Option is enabled at the page level'),
('form_builder_item_settings_panel_text_field_lbl', 'en', 'Text'),
('form_builder_item_settings_panel_response_scale_lbl', 'en', 'Response Scale'),
('form_builder_item_settings_panel_response_scale_disclaimer', 'en', 'Please note: changing this scale after the form has been used could result in fragmented time-series data.'),
('form_builder_item_settings_panel_manager_rating_lbl', 'en', '%manager% Rating'),
('form_builder_item_settings_panel_manager_rating_checkbox', 'en', 'Ask for %manager% rating'),
('form_builder_item_settings_panel_manager_rating_descrip', 'en', 'Enter item text to display to %manager%'),
('form_builder_item_settings_panel_max_accomplishments_lbl', 'en', 'Maximum %accomplishments% allowed'),
('form_builder_new_item_modal_title', 'en', 'Create New Item'),
('form_builder_new_item_modal_description', 'en', 'Items created will be added to this form and the account item library.'),
('form_builder_new_item_modal_item_type_lbl', 'en', 'Item Type'),
('form_builder_new_item_modal_scale_lbl', 'en', 'Scale'),
('form_builder_new_item_modal_item_text_lbl', 'en', 'Item Text'),
('form_builder_new_item_modal_library_link', 'en', 'Click here for advanced item management'),
('form_builder_new_item_modal_tooltip_no_scale', 'en', 'Select a scale to see response options'),
('form_builder_new_item_modal_tooltip_scale', 'en', '%scale_name% Options: %scale_options%'),
('form_builder_item_settings_panel_item_id_lbl', 'en', 'Item ID'),
('form_builder_item_settings_panel_dictionary_phrases_lbl', 'en', 'Dictionary Phrases')
;

alter table action.forms
    add unpublished_changes TINYINT default FALSE null;

ALTER TABLE captureorg.library_items ADD COLUMN checkin_use TINYINT DEFAULT 0;