REDCap

Configuration Check (REDCap 15.0.35)

This page will test your current REDCap configuration to determine if any errors exist that might prevent it from functioning properly.

Basic tests

TEST 1: Establish basic REDCap file structure
Search for necessary files and folders that should be located in the main REDCap folder (i.e. "/var/www/html/redcap").

SUCCESSFUL! - All necessary files and folders were found.

TEST 2: Connect to the table named "redcap_config"

SUCCESSFUL! - The table "redcap_config" in the MySQL database named dbredcap was accessed successfully.

TEST 3: Check REDCap database table structure

YOUR REDCAP DATABASE STRUCTURE IS INCORRECT!
Your current database table structure does not match REDCap's expected table structure, which means that database tables and/or parts of tables are missing. This can happen if an issue occurs during an upgrade and is not corrected afterward.

Click this button to fix the issue automatically.

– OR –

Copy the SQL in the box below and execute it on the MySQL database server where the REDCap database tables are stored, then reload this page to run this check again.

Please do NOT post about this on REDCap Community unless the Repair SQL fails to resolve this issue.

-- SQL TO REPAIR REDCAP TABLES
USE `dbredcap`;
SET SESSION SQL_SAFE_UPDATES = 0;
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE `redcap_actions` CHANGE `action_id` `action_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_actions` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_actions` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_actions` CHANGE `recipient_id` `recipient_id` int(10) DEFAULT NULL COMMENT 'FK user_information';
ALTER TABLE `redcap_alerts` CHANGE `alert_id` `alert_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_alerts` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `form_name_event` `form_name_event` int(10) DEFAULT NULL COMMENT 'Event ID';
ALTER TABLE `redcap_alerts` CHANGE `email_attachment1` `email_attachment1` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `email_attachment2` `email_attachment2` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `email_attachment3` `email_attachment3` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `email_attachment4` `email_attachment4` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `email_attachment5` `email_attachment5` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `cron_send_email_on_time_lag_days` `cron_send_email_on_time_lag_days` int(4) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `cron_send_email_on_time_lag_hours` `cron_send_email_on_time_lag_hours` int(3) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `cron_send_email_on_time_lag_minutes` `cron_send_email_on_time_lag_minutes` int(3) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `cron_repeat_for_max` `cron_repeat_for_max` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_alerts` CHANGE `alert_order` `alert_order` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts_recurrence` CHANGE `aq_id` `aq_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_alerts_recurrence` CHANGE `alert_id` `alert_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts_recurrence` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts_recurrence` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_alerts_recurrence` CHANGE `times_sent` `times_sent` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_alerts_sent` CHANGE `alert_sent_id` `alert_sent_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_alerts_sent` CHANGE `alert_id` `alert_id` int(10) NOT NULL;
ALTER TABLE `redcap_alerts_sent` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_alerts_sent` CHANGE `instance` `instance` smallint(4) DEFAULT '1';
ALTER TABLE `redcap_alerts_sent_log` CHANGE `alert_sent_log_id` `alert_sent_log_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_alerts_sent_log` CHANGE `alert_sent_id` `alert_sent_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_auth` CHANGE `legacy_hash` `legacy_hash` int(1) NOT NULL DEFAULT '0' COMMENT 'Using older legacy hash for password storage?';
ALTER TABLE `redcap_auth` CHANGE `temp_pwd` `temp_pwd` int(1) NOT NULL DEFAULT '0' COMMENT 'Flag to force user to re-enter password';
ALTER TABLE `redcap_auth` CHANGE `password_question` `password_question` int(10) DEFAULT NULL COMMENT 'PK of question';
ALTER TABLE `redcap_auth_questions` CHANGE `qid` `qid` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_cache` CHANGE `cache_id` `cache_id` bigint(19) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_cde_cache` CHANGE `cache_id` `cache_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_cde_field_mapping` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_crons` CHANGE `cron_id` `cron_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_crons` CHANGE `cron_frequency` `cron_frequency` int(10) DEFAULT NULL COMMENT 'seconds';
ALTER TABLE `redcap_crons` CHANGE `cron_max_run_time` `cron_max_run_time` int(10) DEFAULT NULL COMMENT 'max # seconds a cron should run';
ALTER TABLE `redcap_crons` CHANGE `cron_instances_max` `cron_instances_max` int(2) NOT NULL DEFAULT '1' COMMENT 'Number of instances that can run simultaneously';
ALTER TABLE `redcap_crons` CHANGE `cron_instances_current` `cron_instances_current` int(2) NOT NULL DEFAULT '0' COMMENT 'Current number of instances running';
ALTER TABLE `redcap_crons` CHANGE `cron_times_failed` `cron_times_failed` int(2) NOT NULL DEFAULT '0' COMMENT 'After X failures, set as Disabled';
ALTER TABLE `redcap_crons_datediff` CHANGE `dd_id` `dd_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_crons_datediff` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_crons_history` CHANGE `ch_id` `ch_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_crons_history` CHANGE `cron_id` `cron_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_custom_queries` CHANGE `qid` `qid` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_custom_queries_folders` CHANGE `folder_id` `folder_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_custom_queries_folders` CHANGE `position` `position` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_custom_queries_folders_items` CHANGE `folder_id` `folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_custom_queries_folders_items` CHANGE `qid` `qid` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data2` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data2` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data2` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data3` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data3` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data3` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data4` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data4` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data4` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data5` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data5` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data5` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data6` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_data6` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data6` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_data_access_groups` CHANGE `group_id` `group_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_access_groups` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_access_groups_users` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_access_groups_users` CHANGE `group_id` `group_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_dictionaries` CHANGE `dd_id` `dd_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_dictionaries` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_dictionaries` CHANGE `doc_id` `doc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_dictionaries` CHANGE `ui_id` `ui_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import` CHANGE `import_id` `import_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_import` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import` CHANGE `user_id` `user_id` int(10) DEFAULT NULL COMMENT 'User importing the data';
ALTER TABLE `redcap_data_import` CHANGE `dag_id` `dag_id` int(10) DEFAULT NULL COMMENT 'Current DAG of user importing data';
ALTER TABLE `redcap_data_import` CHANGE `total_processing_time` `total_processing_time` int(10) DEFAULT NULL COMMENT 'seconds';
ALTER TABLE `redcap_data_import` CHANGE `records_provided` `records_provided` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import` CHANGE `records_imported` `records_imported` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import` CHANGE `total_errors` `total_errors` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import_rows` CHANGE `row_id` `row_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_import_rows` CHANGE `import_id` `import_id` int(10) NOT NULL;
ALTER TABLE `redcap_data_import_rows` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_import_rows` CHANGE `total_time` `total_time` int(10) DEFAULT NULL COMMENT 'milliseconds';
ALTER TABLE `redcap_data_import_rows` CHANGE `error_count` `error_count` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `res_id` `res_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `status_id` `status_id` int(10) DEFAULT NULL COMMENT 'FK from data_quality_status';
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `user_id` `user_id` int(10) DEFAULT NULL COMMENT 'Current user';
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `response_requested` `response_requested` int(1) NOT NULL DEFAULT '0' COMMENT 'Is a response requested?';
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `upload_doc_id` `upload_doc_id` int(10) DEFAULT NULL COMMENT 'FK of uploaded document';
ALTER TABLE `redcap_data_quality_resolutions` CHANGE `field_comment_edited` `field_comment_edited` int(1) NOT NULL DEFAULT '0' COMMENT 'Denote if field comment was edited';
ALTER TABLE `redcap_data_quality_rules` CHANGE `rule_id` `rule_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_quality_rules` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_quality_rules` CHANGE `rule_order` `rule_order` int(3) DEFAULT '1';
ALTER TABLE `redcap_data_quality_rules` CHANGE `real_time_execute` `real_time_execute` int(1) NOT NULL DEFAULT '0' COMMENT 'Run in real-time on data entry forms?';
ALTER TABLE `redcap_data_quality_status` CHANGE `status_id` `status_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_data_quality_status` CHANGE `rule_id` `rule_id` int(10) DEFAULT NULL COMMENT 'FK from data_quality_rules table';
ALTER TABLE `redcap_data_quality_status` CHANGE `pd_rule_id` `pd_rule_id` int(2) DEFAULT NULL COMMENT 'Name of pre-defined rules';
ALTER TABLE `redcap_data_quality_status` CHANGE `non_rule` `non_rule` int(1) DEFAULT NULL COMMENT '1 for non-rule, else NULL';
ALTER TABLE `redcap_data_quality_status` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_data_quality_status` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_data_quality_status` CHANGE `status` `status` int(2) DEFAULT NULL COMMENT 'Current status of discrepancy';
ALTER TABLE `redcap_data_quality_status` CHANGE `exclude` `exclude` int(1) NOT NULL DEFAULT '0' COMMENT 'Hide from results';
ALTER TABLE `redcap_data_quality_status` CHANGE `assigned_user_id` `assigned_user_id` int(10) DEFAULT NULL COMMENT 'UI ID of user assigned to query';
ALTER TABLE `redcap_ddp_log_view` CHANGE `ml_id` `ml_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_ddp_log_view` CHANGE `user_id` `user_id` int(10) DEFAULT NULL COMMENT 'PK from user_information table';
ALTER TABLE `redcap_ddp_log_view` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_ddp_log_view_data` CHANGE `ml_id` `ml_id` int(10) DEFAULT NULL COMMENT 'PK from ddp_log_view table';
ALTER TABLE `redcap_ddp_log_view_data` CHANGE `md_id` `md_id` int(10) DEFAULT NULL COMMENT 'PK from ddp_records_data table';
ALTER TABLE `redcap_ddp_mapping` CHANGE `map_id` `map_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_ddp_mapping` CHANGE `is_record_identifier` `is_record_identifier` int(1) DEFAULT NULL COMMENT '1=Yes, Null=No';
ALTER TABLE `redcap_ddp_mapping` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_ddp_mapping` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_ddp_preview_fields` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_ddp_records` CHANGE `mr_id` `mr_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_ddp_records` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_ddp_records` CHANGE `item_count` `item_count` int(10) DEFAULT NULL COMMENT 'New item count (as of last viewing)';
ALTER TABLE `redcap_ddp_records` CHANGE `future_date_count` `future_date_count` int(10) NOT NULL DEFAULT '0' COMMENT 'Count of datetime reference fields with values in the future';
ALTER TABLE `redcap_ddp_records_data` CHANGE `md_id` `md_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_ddp_records_data` CHANGE `map_id` `map_id` int(10) NOT NULL COMMENT 'PK from ddp_mapping table';
ALTER TABLE `redcap_ddp_records_data` CHANGE `mr_id` `mr_id` int(10) DEFAULT NULL COMMENT 'PK from ddp_records table';
ALTER TABLE `redcap_ddp_records_data` CHANGE `adjudicated` `adjudicated` int(1) NOT NULL DEFAULT '0' COMMENT 'Has source value been adjudicated?';
ALTER TABLE `redcap_ddp_records_data` CHANGE `exclude` `exclude` int(1) NOT NULL DEFAULT '0' COMMENT 'Has source value been excluded?';
ALTER TABLE `redcap_descriptive_popups` CHANGE `popup_id` `popup_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_descriptive_popups` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_docs` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_docs` CHANGE `export_file` `export_file` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_docs` CHANGE `temp` `temp` int(1) NOT NULL DEFAULT '0' COMMENT 'Is file only a temp file?';
ALTER TABLE `redcap_docs_attachments` CHANGE `docs_id` `docs_id` int(10) NOT NULL;
ALTER TABLE `redcap_docs_folders` CHANGE `folder_id` `folder_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_docs_folders` CHANGE `parent_folder_id` `parent_folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_docs_folders` CHANGE `role_id` `role_id` int(10) DEFAULT NULL COMMENT 'User role association';
ALTER TABLE `redcap_docs_folders_files` CHANGE `docs_id` `docs_id` int(10) NOT NULL;
ALTER TABLE `redcap_docs_folders_files` CHANGE `folder_id` `folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_docs_share` CHANGE `docs_id` `docs_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_econsent` CHANGE `consent_id` `consent_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_econsent` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_econsent` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_econsent_forms` CHANGE `consent_form_id` `consent_form_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_econsent_forms` CHANGE `consent_id` `consent_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_econsent_forms` CHANGE `uploader` `uploader` int(10) DEFAULT NULL;
ALTER TABLE `redcap_econsent_forms` CHANGE `consent_form_pdf_doc_id` `consent_form_pdf_doc_id` int(10) DEFAULT NULL COMMENT 'Consent form PDF document';
ALTER TABLE `redcap_econsent_forms` CHANGE `consent_form_filter_dag_id` `consent_form_filter_dag_id` int(10) DEFAULT NULL COMMENT 'Consent form DAG filter';
ALTER TABLE `redcap_edocs_data_mapping` CHANGE `doc_id` `doc_id` int(10) NOT NULL;
ALTER TABLE `redcap_edocs_data_mapping` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_edocs_data_mapping` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_edocs_data_mapping` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_edocs_metadata` CHANGE `doc_id` `doc_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_edocs_metadata` CHANGE `doc_size` `doc_size` int(10) DEFAULT NULL;
ALTER TABLE `redcap_edocs_metadata` CHANGE `gzipped` `gzipped` int(1) NOT NULL DEFAULT '0' COMMENT 'Is file gzip compressed?';
ALTER TABLE `redcap_edocs_metadata` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_ehr_datamart_revisions` CHANGE `id` `id` int(11) unsigned NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Patient` `counts_Patient` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Observation` `counts_Observation` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Condition` `counts_Condition` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Medication` `counts_Medication` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_AllergyIntolerance` `counts_AllergyIntolerance` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Encounter` `counts_Encounter` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_Immunization` `counts_Immunization` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_import_counts` CHANGE `counts_AdverseEvent` `counts_AdverseEvent` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_resource_import_details` CHANGE `count` `count` mediumint(7) DEFAULT '0';
ALTER TABLE `redcap_ehr_settings` CHANGE `order` `order` int(10) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_error_log` CHANGE `error_id` `error_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_error_log` CHANGE `log_view_id` `log_view_id` bigint(19) DEFAULT NULL;
ALTER TABLE `redcap_esignatures` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_esignatures` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_esignatures` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_events_arms` CHANGE `arm_id` `arm_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_events_arms` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_events_arms` CHANGE `arm_num` `arm_num` int(2) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_events_calendar` CHANGE `cal_id` `cal_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_events_calendar` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_events_calendar` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_events_calendar` CHANGE `group_id` `group_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_events_calendar` CHANGE `event_status` `event_status` int(2) DEFAULT NULL COMMENT 'NULL=Ad Hoc, 0=Due Date, 1=Scheduled, 2=Confirmed, 3=Cancelled, 4=No Show';
ALTER TABLE `redcap_events_calendar` CHANGE `note_type` `note_type` int(2) DEFAULT NULL;
ALTER TABLE `redcap_events_calendar_feed` CHANGE `feed_id` `feed_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_events_calendar_feed` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_events_forms` CHANGE `event_id` `event_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_events_metadata` CHANGE `event_id` `event_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_events_metadata` CHANGE `arm_id` `arm_id` int(10) NOT NULL DEFAULT '0' COMMENT 'FK for events_arms';
ALTER TABLE `redcap_events_repeat` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_external_links` CHANGE `ext_id` `ext_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_external_links` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_external_links` CHANGE `link_order` `link_order` int(5) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_external_links` CHANGE `open_new_window` `open_new_window` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_external_links` CHANGE `append_record_info` `append_record_info` int(1) NOT NULL DEFAULT '0' COMMENT 'Append record and event to URL';
ALTER TABLE `redcap_external_links` CHANGE `append_pid` `append_pid` int(1) NOT NULL DEFAULT '0' COMMENT 'Append project_id to URL';
ALTER TABLE `redcap_external_links` CHANGE `link_to_project_id` `link_to_project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_external_links_dags` CHANGE `group_id` `group_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_external_links_exclude_projects` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_folders` CHANGE `folder_id` `folder_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_folders` CHANGE `ui_id` `ui_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_folders` CHANGE `position` `position` int(10) DEFAULT NULL;
ALTER TABLE `redcap_folders_projects` CHANGE `ui_id` `ui_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_folders_projects` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_folders_projects` CHANGE `folder_id` `folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_form_display_logic_conditions` CHANGE `control_id` `control_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_form_display_logic_conditions` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_form_display_logic_targets` CHANGE `control_id` `control_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_form_display_logic_targets` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_instrument_zip` CHANGE `iza_id` `iza_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_instrument_zip` CHANGE `upload_count` `upload_count` smallint(5) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_instrument_zip_authors` CHANGE `iza_id` `iza_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_instrument_zip_origins` CHANGE `upload_count` `upload_count` smallint(5) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_library_map` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_library_map` CHANGE `library_id` `library_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_locking_data` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_locking_data` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_locking_data` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_locking_labels` CHANGE `display` `display` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_locking_labels` CHANGE `display_esignature` `display_esignature` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_locking_records` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_locking_records` CHANGE `arm_id` `arm_id` int(10) NOT NULL;
ALTER TABLE `redcap_locking_records_pdf_archive` CHANGE `doc_id` `doc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_locking_records_pdf_archive` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_locking_records_pdf_archive` CHANGE `arm_id` `arm_id` int(10) NOT NULL;
ALTER TABLE `redcap_log_event` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event10` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event10` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event10` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event10` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event11` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event11` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event11` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event11` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event12` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event12` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event12` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event12` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event2` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event2` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event2` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event2` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event3` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event3` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event3` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event3` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event4` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event4` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event4` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event4` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event5` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event5` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event5` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event5` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event6` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event6` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event6` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event6` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event7` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event7` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event7` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event7` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event8` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event8` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event8` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event8` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event9` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_event9` CHANGE `ts` `ts` bigint(14) DEFAULT NULL;
ALTER TABLE `redcap_log_event9` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_event9` CHANGE `legacy` `legacy` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_log_view` CHANGE `log_view_id` `log_view_id` bigint(19) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_log_view` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_view` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_view_old` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_view_old` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_log_view_requests` CHANGE `lvr_id` `lvr_id` bigint(19) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_log_view_requests` CHANGE `log_view_id` `log_view_id` bigint(19) DEFAULT NULL COMMENT 'FK from redcap_log_view';
ALTER TABLE `redcap_log_view_requests` CHANGE `mysql_process_id` `mysql_process_id` int(10) DEFAULT NULL COMMENT 'Process ID for MySQL';
ALTER TABLE `redcap_log_view_requests` CHANGE `php_process_id` `php_process_id` int(10) DEFAULT NULL COMMENT 'Process ID for PHP';
ALTER TABLE `redcap_messages` CHANGE `message_id` `message_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_messages` CHANGE `thread_id` `thread_id` int(10) DEFAULT NULL COMMENT 'Thread that message belongs to (FK from redcap_messages_threads)';
ALTER TABLE `redcap_messages` CHANGE `author_user_id` `author_user_id` int(10) DEFAULT NULL COMMENT 'Author of message (FK from redcap_user_information)';
ALTER TABLE `redcap_messages` CHANGE `attachment_doc_id` `attachment_doc_id` int(10) DEFAULT NULL COMMENT 'doc_id if there is an attachment (FK from redcap_edocs_metadata)';
ALTER TABLE `redcap_messages_recipients` CHANGE `recipient_id` `recipient_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_messages_recipients` CHANGE `thread_id` `thread_id` int(10) DEFAULT NULL COMMENT 'Thread that recipient belongs to (FK from redcap_messages_threads)';
ALTER TABLE `redcap_messages_recipients` CHANGE `recipient_user_id` `recipient_user_id` int(10) DEFAULT NULL COMMENT 'Individual recipient in thread (FK from redcap_user_information)';
ALTER TABLE `redcap_messages_status` CHANGE `status_id` `status_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_messages_status` CHANGE `message_id` `message_id` int(10) DEFAULT NULL COMMENT 'FK from redcap_messages';
ALTER TABLE `redcap_messages_status` CHANGE `recipient_id` `recipient_id` int(10) DEFAULT NULL COMMENT 'Individual recipient in thread (FK from redcap_messages_recipients)';
ALTER TABLE `redcap_messages_status` CHANGE `recipient_user_id` `recipient_user_id` int(10) DEFAULT NULL COMMENT 'Individual recipient in thread (FK from redcap_user_information)';
ALTER TABLE `redcap_messages_threads` CHANGE `thread_id` `thread_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_metadata` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata` CHANGE `field_req` `field_req` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata` CHANGE `edoc_id` `edoc_id` int(10) DEFAULT NULL COMMENT 'image/file attachment';
ALTER TABLE `redcap_metadata` CHANGE `edoc_display_img` `edoc_display_img` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata` CHANGE `grid_rank` `grid_rank` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_archive` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_archive` CHANGE `field_req` `field_req` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_archive` CHANGE `edoc_id` `edoc_id` int(10) DEFAULT NULL COMMENT 'image/file attachment';
ALTER TABLE `redcap_metadata_archive` CHANGE `edoc_display_img` `edoc_display_img` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_archive` CHANGE `grid_rank` `grid_rank` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_archive` CHANGE `pr_id` `pr_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_metadata_prod_revisions` CHANGE `pr_id` `pr_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_metadata_prod_revisions` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_prod_revisions` CHANGE `ui_id_requester` `ui_id_requester` int(10) DEFAULT NULL;
ALTER TABLE `redcap_metadata_prod_revisions` CHANGE `ui_id_approver` `ui_id_approver` int(10) DEFAULT NULL;
ALTER TABLE `redcap_metadata_temp` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_temp` CHANGE `field_req` `field_req` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_temp` CHANGE `edoc_id` `edoc_id` int(10) DEFAULT NULL COMMENT 'image/file attachment';
ALTER TABLE `redcap_metadata_temp` CHANGE `edoc_display_img` `edoc_display_img` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_metadata_temp` CHANGE `grid_rank` `grid_rank` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_mobile_app_devices` CHANGE `device_id` `device_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mobile_app_devices` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mobile_app_files` CHANGE `af_id` `af_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mobile_app_files` CHANGE `doc_id` `doc_id` int(10) NOT NULL;
ALTER TABLE `redcap_mobile_app_files` CHANGE `user_id` `user_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mobile_app_files` CHANGE `device_id` `device_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mobile_app_log` CHANGE `mal_id` `mal_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mobile_app_log` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mobile_app_log` CHANGE `log_event_id` `log_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mobile_app_log` CHANGE `device_id` `device_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_config` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_config_temp` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_metadata` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_metadata_temp` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_snapshots` CHANGE `snapshot_id` `snapshot_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_multilanguage_snapshots` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_multilanguage_snapshots` CHANGE `edoc_id` `edoc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_snapshots` CHANGE `created_by` `created_by` int(10) DEFAULT NULL COMMENT 'References a uu_id in the redcap_user_information table';
ALTER TABLE `redcap_multilanguage_snapshots` CHANGE `deleted_by` `deleted_by` int(10) DEFAULT NULL COMMENT 'References a uu_id in the redcap_user_information table';
ALTER TABLE `redcap_multilanguage_ui` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_multilanguage_ui_temp` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_aboutpages` CHANGE `page_id` `page_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mycap_aboutpages` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_aboutpages` CHANGE `custom_logo` `custom_logo` int(10) DEFAULT NULL COMMENT 'doc id for custom image uploaded';
ALTER TABLE `redcap_mycap_aboutpages` CHANGE `page_order` `page_order` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_contacts` CHANGE `contact_id` `contact_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mycap_contacts` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_contacts` CHANGE `contact_order` `contact_order` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_links` CHANGE `link_id` `link_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mycap_links` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_links` CHANGE `append_project_code` `append_project_code` int(1) NOT NULL DEFAULT '0' COMMENT 'Append Project Code to URL';
ALTER TABLE `redcap_mycap_links` CHANGE `append_participant_code` `append_participant_code` int(1) NOT NULL DEFAULT '0' COMMENT 'Append Participant Code to URL';
ALTER TABLE `redcap_mycap_links` CHANGE `link_order` `link_order` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_messages` CHANGE `project_id` `project_id` int(10) DEFAULT NULL COMMENT 'FK to redcap_projects.project_id';
ALTER TABLE `redcap_mycap_participants` CHANGE `project_id` `project_id` int(10) DEFAULT NULL COMMENT 'FK to redcap_projects.project_id';
ALTER TABLE `redcap_mycap_participants` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_projectfiles` CHANGE `doc_id` `doc_id` int(10) NOT NULL COMMENT 'PFK to redcap_edocs_metadata.doc_id';
ALTER TABLE `redcap_mycap_projectfiles` CHANGE `category` `category` int(10) DEFAULT NULL COMMENT 'File categorization, if any. 1=PROMIS Form, 2=PROMIS Calibration, 3=Image, 4=Config Version';
ALTER TABLE `redcap_mycap_projects` CHANGE `project_id` `project_id` int(10) NOT NULL COMMENT 'FK to redcap_projects.project_id';
ALTER TABLE `redcap_mycap_projects` CHANGE `status` `status` int(1) NOT NULL DEFAULT '1' COMMENT '0=Deleted, 1=Active';
ALTER TABLE `redcap_mycap_syncissuefiles` CHANGE `doc_id` `doc_id` int(10) NOT NULL COMMENT 'PFK to redcap_edocs_metadata.doc_id';
ALTER TABLE `redcap_mycap_syncissues` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_syncissues` CHANGE `error_type` `error_type` int(1) NOT NULL DEFAULT '0' COMMENT '1 = REDCap Save, 2 = Could not find participant, 3 = Could not find project, 4 = Other';
ALTER TABLE `redcap_mycap_tasks` CHANGE `task_id` `task_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mycap_tasks` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_mycap_tasks` CHANGE `enabled_for_mycap` `enabled_for_mycap` int(1) NOT NULL DEFAULT '1' COMMENT '0 = no, 1 = yes';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `allow_retro_completion` `allow_retro_completion` int(1) NOT NULL DEFAULT '0' COMMENT 'Allow retroactive completion?';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `allow_save_complete_later` `allow_save_complete_later` int(1) NOT NULL DEFAULT '0' COMMENT 'Allow save and complete later?';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `include_instruction_step` `include_instruction_step` int(1) NOT NULL DEFAULT '0' COMMENT 'Include Instruction Step?';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `include_completion_step` `include_completion_step` int(1) NOT NULL DEFAULT '0' COMMENT 'Include Completion Step?';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `schedule_interval_week` `schedule_interval_week` int(2) DEFAULT NULL COMMENT 'Weeks from 1 to 24';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `schedule_interval_month` `schedule_interval_month` int(2) DEFAULT NULL COMMENT 'Months from 1 to 12';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `schedule_relative_offset` `schedule_relative_offset` int(10) DEFAULT NULL COMMENT 'Number of days to delay';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `schedule_end_count` `schedule_end_count` int(10) DEFAULT NULL COMMENT 'Ends after number of times';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `schedule_end_after_days` `schedule_end_after_days` int(10) DEFAULT NULL COMMENT 'Ends after number of days have elapsed';
ALTER TABLE `redcap_mycap_tasks_schedules` CHANGE `active` `active` int(1) NOT NULL DEFAULT '1' COMMENT 'Is it currently active?';
ALTER TABLE `redcap_mycap_themes` CHANGE `theme_id` `theme_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_mycap_themes` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_new_record_cache` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_new_record_cache` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `send_count` `send_count` int(10) DEFAULT '1' COMMENT 'Total';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `smtp` `smtp` int(10) DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `sendgrid` `sendgrid` int(10) DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `mandrill` `mandrill` int(10) DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `twilio_sms` `twilio_sms` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `mosio_sms` `mosio_sms` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_counts` CHANGE `mailgun` `mailgun` int(10) DEFAULT '0';
ALTER TABLE `redcap_outgoing_email_sms_identifiers` CHANGE `ident_id` `ident_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_outgoing_email_sms_identifiers` CHANGE `ssq_id` `ssq_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_outgoing_email_sms_log` CHANGE `email_id` `email_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_outgoing_email_sms_log` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_outgoing_email_sms_log` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_outgoing_email_sms_log` CHANGE `instance` `instance` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_pdf_image_cache` CHANGE `pdf_doc_id` `pdf_doc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pdf_image_cache` CHANGE `page` `page` int(5) DEFAULT NULL;
ALTER TABLE `redcap_pdf_image_cache` CHANGE `num_pages` `num_pages` int(5) DEFAULT NULL;
ALTER TABLE `redcap_pdf_image_cache` CHANGE `image_doc_id` `image_doc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pdf_snapshots` CHANGE `snapshot_id` `snapshot_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_pdf_snapshots` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pdf_snapshots` CHANGE `consent_id` `consent_id` int(10) DEFAULT NULL COMMENT 'Used for eConsent';
ALTER TABLE `redcap_pdf_snapshots` CHANGE `trigger_surveycomplete_survey_id` `trigger_surveycomplete_survey_id` int(10) DEFAULT NULL COMMENT 'Trigger based on survey completion';
ALTER TABLE `redcap_pdf_snapshots` CHANGE `trigger_surveycomplete_event_id` `trigger_surveycomplete_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pdf_snapshots` CHANGE `pdf_save_to_event_id` `pdf_save_to_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pdf_snapshots_triggered` CHANGE `snapshot_id` `snapshot_id` int(10) NOT NULL;
ALTER TABLE `redcap_project_checklist` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_project_dashboards` CHANGE `dash_id` `dash_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_project_dashboards` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_project_dashboards` CHANGE `dash_order` `dash_order` int(3) DEFAULT NULL;
ALTER TABLE `redcap_project_dashboards_access_dags` CHANGE `dash_id` `dash_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_project_dashboards_access_dags` CHANGE `group_id` `group_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_project_dashboards_access_roles` CHANGE `dash_id` `dash_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_project_dashboards_access_roles` CHANGE `role_id` `role_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_project_dashboards_access_users` CHANGE `dash_id` `dash_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_project_dashboards_folders` CHANGE `folder_id` `folder_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_project_dashboards_folders` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_project_dashboards_folders` CHANGE `position` `position` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_project_dashboards_folders_items` CHANGE `folder_id` `folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_project_dashboards_folders_items` CHANGE `dash_id` `dash_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `project_id` `project_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_projects` CHANGE `status` `status` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `created_by` `created_by` int(10) DEFAULT NULL COMMENT 'FK from User Info';
ALTER TABLE `redcap_projects` CHANGE `draft_mode` `draft_mode` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `surveys_enabled` `surveys_enabled` int(1) NOT NULL DEFAULT '0' COMMENT '0 = forms only, 1 = survey+forms, 2 = single survey only';
ALTER TABLE `redcap_projects` CHANGE `repeatforms` `repeatforms` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `scheduling` `scheduling` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `purpose` `purpose` int(2) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `show_which_records` `show_which_records` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `count_project` `count_project` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `online_offline` `online_offline` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `double_data_entry` `double_data_entry` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `date_shift_max` `date_shift_max` int(10) NOT NULL DEFAULT '364';
ALTER TABLE `redcap_projects` CHANGE `auto_inc_set` `auto_inc_set` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `disable_data_entry` `disable_data_entry` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `require_change_reason` `require_change_reason` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `dts_enabled` `dts_enabled` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `project_pi_pub_exclude` `project_pi_pub_exclude` int(1) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `history_widget_enabled` `history_widget_enabled` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `display_project_logo_institution` `display_project_logo_institution` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `imported_from_rs` `imported_from_rs` int(1) NOT NULL DEFAULT '0' COMMENT 'If imported from REDCap Survey';
ALTER TABLE `redcap_projects` CHANGE `display_today_now_button` `display_today_now_button` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `auto_variable_naming` `auto_variable_naming` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `randomization` `randomization` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `enable_participant_identifiers` `enable_participant_identifiers` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `template_id` `template_id` int(10) DEFAULT NULL COMMENT 'If created from a project template, the project_id of the template';
ALTER TABLE `redcap_projects` CHANGE `data_resolution_enabled` `data_resolution_enabled` int(1) NOT NULL DEFAULT '1' COMMENT '0=Disabled, 1=Field comment log, 2=Data Quality resolution workflow';
ALTER TABLE `redcap_projects` CHANGE `field_comment_edit_delete` `field_comment_edit_delete` int(1) NOT NULL DEFAULT '1' COMMENT 'Allow users to edit or delete Field Comments';
ALTER TABLE `redcap_projects` CHANGE `realtime_webservice_enabled` `realtime_webservice_enabled` int(1) NOT NULL DEFAULT '0' COMMENT 'Is real-time web service enabled for external data import?';
ALTER TABLE `redcap_projects` CHANGE `edoc_upload_max` `edoc_upload_max` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `file_attachment_upload_max` `file_attachment_upload_max` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `survey_auth_enabled` `survey_auth_enabled` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `survey_auth_event_id1` `survey_auth_event_id1` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `survey_auth_event_id2` `survey_auth_event_id2` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `survey_auth_event_id3` `survey_auth_event_id3` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `survey_auth_apply_all_surveys` `survey_auth_apply_all_surveys` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `survey_auth_fail_limit` `survey_auth_fail_limit` int(2) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `survey_auth_fail_window` `survey_auth_fail_window` int(3) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `twilio_enabled` `twilio_enabled` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects` CHANGE `twilio_from_number` `twilio_from_number` bigint(16) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `twilio_request_inspector_enabled` `twilio_request_inspector_enabled` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `twilio_append_response_instructions` `twilio_append_response_instructions` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_projects` CHANGE `delete_file_repository_export_files` `delete_file_repository_export_files` int(3) NOT NULL DEFAULT '0' COMMENT 'Will auto-delete files after X days';
ALTER TABLE `redcap_projects` CHANGE `project_dashboard_min_data_points` `project_dashboard_min_data_points` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `protected_email_mode_logo` `protected_email_mode_logo` int(10) DEFAULT NULL;
ALTER TABLE `redcap_projects` CHANGE `file_repository_total_size` `file_repository_total_size` int(10) DEFAULT NULL COMMENT 'MB';
ALTER TABLE `redcap_projects_external` CHANGE `project_pi_pub_exclude` `project_pi_pub_exclude` int(1) DEFAULT NULL;
ALTER TABLE `redcap_projects_templates` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_projects_templates` CHANGE `enabled` `enabled` int(1) NOT NULL DEFAULT '0' COMMENT 'If enabled, template is visible to users in list.';
ALTER TABLE `redcap_projects_user_hidden` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_projects_user_hidden` CHANGE `ui_id` `ui_id` int(10) NOT NULL;
ALTER TABLE `redcap_pub_articles` CHANGE `article_id` `article_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_pub_articles` CHANGE `pubsrc_id` `pubsrc_id` int(10) NOT NULL;
ALTER TABLE `redcap_pub_authors` CHANGE `author_id` `author_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_pub_authors` CHANGE `article_id` `article_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_pub_matches` CHANGE `matched` `matched` int(1) DEFAULT NULL;
ALTER TABLE `redcap_pub_mesh_terms` CHANGE `mesh_id` `mesh_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_pub_mesh_terms` CHANGE `article_id` `article_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `rid` `rid` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_randomization` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `stratified` `stratified` int(1) NOT NULL DEFAULT '1' COMMENT '1=Stratified, 0=Block';
ALTER TABLE `redcap_randomization` CHANGE `target_event` `target_event` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event1` `source_event1` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event2` `source_event2` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event3` `source_event3` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event4` `source_event4` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event5` `source_event5` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event6` `source_event6` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event7` `source_event7` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event8` `source_event8` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event9` `source_event9` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event10` `source_event10` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event11` `source_event11` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event12` `source_event12` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event13` `source_event13` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event14` `source_event14` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `source_event15` `source_event15` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `trigger_option` `trigger_option` int(1) DEFAULT NULL;
ALTER TABLE `redcap_randomization` CHANGE `trigger_event_id` `trigger_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_randomization_allocation` CHANGE `aid` `aid` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_randomization_allocation` CHANGE `rid` `rid` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_randomization_allocation` CHANGE `project_status` `project_status` int(1) NOT NULL DEFAULT '0' COMMENT 'Used in dev or prod status';
ALTER TABLE `redcap_randomization_allocation` CHANGE `group_id` `group_id` int(10) DEFAULT NULL COMMENT 'DAG';
ALTER TABLE `redcap_record_dashboards` CHANGE `arm` `arm` int(2) DEFAULT NULL;
ALTER TABLE `redcap_record_list` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_record_list` CHANGE `arm` `arm` int(2) NOT NULL;
ALTER TABLE `redcap_record_list` CHANGE `dag_id` `dag_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_record_list` CHANGE `sort` `sort` mediumint(7) DEFAULT NULL;
ALTER TABLE `redcap_reports` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_reports` CHANGE `report_order` `report_order` int(3) DEFAULT NULL;
ALTER TABLE `redcap_reports` CHANGE `output_dags` `output_dags` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports` CHANGE `output_survey_fields` `output_survey_fields` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports` CHANGE `output_missing_data_codes` `output_missing_data_codes` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports` CHANGE `remove_line_breaks_in_values` `remove_line_breaks_in_values` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_reports_access_dags` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_access_dags` CHANGE `group_id` `group_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_access_roles` CHANGE `report_id` `report_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_access_roles` CHANGE `role_id` `role_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_access_users` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_ai_prompts` CHANGE `project_id` `project_id` int(10) NOT NULL;
ALTER TABLE `redcap_reports_ai_prompts` CHANGE `report_id` `report_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_reports_edit_access_dags` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_edit_access_dags` CHANGE `group_id` `group_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_edit_access_roles` CHANGE `report_id` `report_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_edit_access_roles` CHANGE `role_id` `role_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_edit_access_users` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_fields` CHANGE `report_id` `report_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_reports_fields` CHANGE `field_order` `field_order` int(3) DEFAULT NULL;
ALTER TABLE `redcap_reports_fields` CHANGE `limiter_event_id` `limiter_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_reports_filter_dags` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_filter_dags` CHANGE `group_id` `group_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_filter_events` CHANGE `report_id` `report_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_filter_events` CHANGE `event_id` `event_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_reports_folders` CHANGE `folder_id` `folder_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_reports_folders` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_reports_folders` CHANGE `position` `position` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_reports_folders_items` CHANGE `folder_id` `folder_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_reports_folders_items` CHANGE `report_id` `report_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_sendit_docs` CHANGE `send_confirmation` `send_confirmation` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_sendit_docs` CHANGE `location` `location` int(1) NOT NULL DEFAULT '0' COMMENT '1 = Home page; 2 = File Repository; 3 = Form';
ALTER TABLE `redcap_sendit_recipients` CHANGE `sent_confirmation` `sent_confirmation` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `survey_id` `survey_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `question_by_section` `question_by_section` int(1) NOT NULL DEFAULT '0' COMMENT '0 = one-page survey';
ALTER TABLE `redcap_surveys` CHANGE `display_page_number` `display_page_number` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys` CHANGE `question_auto_numbering` `question_auto_numbering` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys` CHANGE `survey_enabled` `survey_enabled` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys` CHANGE `save_and_return` `save_and_return` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `logo` `logo` int(10) DEFAULT NULL COMMENT 'FK for redcap_edocs_metadata';
ALTER TABLE `redcap_surveys` CHANGE `hide_title` `hide_title` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `view_results` `view_results` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `min_responses_view_results` `min_responses_view_results` int(5) NOT NULL DEFAULT '10';
ALTER TABLE `redcap_surveys` CHANGE `check_diversity_view_results` `check_diversity_view_results` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `promis_skip_question` `promis_skip_question` int(1) NOT NULL DEFAULT '0' COMMENT 'Allow participants to skip questions on PROMIS CATs';
ALTER TABLE `redcap_surveys` CHANGE `survey_auth_enabled_single` `survey_auth_enabled_single` int(1) NOT NULL DEFAULT '0' COMMENT 'Enable Survey Login for this single survey?';
ALTER TABLE `redcap_surveys` CHANGE `edit_completed_response` `edit_completed_response` int(1) NOT NULL DEFAULT '0' COMMENT 'Allow respondents to return and edit a completed response?';
ALTER TABLE `redcap_surveys` CHANGE `confirmation_email_attachment` `confirmation_email_attachment` int(10) DEFAULT NULL COMMENT 'FK for redcap_edocs_metadata';
ALTER TABLE `redcap_surveys` CHANGE `text_to_speech` `text_to_speech` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `theme` `theme` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `text_size` `text_size` tinyint(2) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `font_family` `font_family` tinyint(2) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `enhanced_choices` `enhanced_choices` smallint(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys` CHANGE `response_limit` `response_limit` int(7) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `survey_time_limit_days` `survey_time_limit_days` smallint(3) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `survey_time_limit_hours` `survey_time_limit_hours` tinyint(2) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `survey_time_limit_minutes` `survey_time_limit_minutes` tinyint(2) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `pdf_save_to_event_id` `pdf_save_to_event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys` CHANGE `survey_width_percent` `survey_width_percent` int(3) DEFAULT NULL;
ALTER TABLE `redcap_surveys_emails` CHANGE `email_id` `email_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_emails` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_emails` CHANGE `email_sender` `email_sender` int(10) DEFAULT NULL COMMENT 'FK ui_id from redcap_user_information';
ALTER TABLE `redcap_surveys_emails_recipients` CHANGE `email_recip_id` `email_recip_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_emails_recipients` CHANGE `email_id` `email_id` int(10) DEFAULT NULL COMMENT 'FK redcap_surveys_emails';
ALTER TABLE `redcap_surveys_emails_recipients` CHANGE `participant_id` `participant_id` int(10) DEFAULT NULL COMMENT 'FK redcap_surveys_participants';
ALTER TABLE `redcap_surveys_emails_send_rate` CHANGE `esr_id` `esr_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_emails_send_rate` CHANGE `emails_per_batch` `emails_per_batch` int(10) DEFAULT NULL COMMENT 'Number of emails sent in this batch';
ALTER TABLE `redcap_surveys_emails_send_rate` CHANGE `emails_per_minute` `emails_per_minute` int(6) DEFAULT NULL COMMENT 'Number of emails sent per minute for this batch';
ALTER TABLE `redcap_surveys_erase_twilio_log` CHANGE `tl_id` `tl_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_erase_twilio_log` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_login` CHANGE `response_id` `response_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_participants` CHANGE `participant_id` `participant_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_participants` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_participants` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `doc_id` `doc_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `consent_id` `consent_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `consent_form_id` `consent_form_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `snapshot_id` `snapshot_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_pdf_archive` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys_phone_codes` CHANGE `pc_id` `pc_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_phone_codes` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_queue` CHANGE `sq_id` `sq_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_queue` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_queue` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_queue` CHANGE `active` `active` int(1) NOT NULL DEFAULT '1' COMMENT 'Is it currently active?';
ALTER TABLE `redcap_surveys_queue` CHANGE `auto_start` `auto_start` int(1) NOT NULL DEFAULT '0' COMMENT 'Automatically start if next after survey completion';
ALTER TABLE `redcap_surveys_queue` CHANGE `condition_surveycomplete_survey_id` `condition_surveycomplete_survey_id` int(10) DEFAULT NULL COMMENT 'survey_id of trigger';
ALTER TABLE `redcap_surveys_queue` CHANGE `condition_surveycomplete_event_id` `condition_surveycomplete_event_id` int(10) DEFAULT NULL COMMENT 'event_id of trigger';
ALTER TABLE `redcap_surveys_queue_hashes` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys_response` CHANGE `participant_id` `participant_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_response` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `ss_id` `ss_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_scheduler` CHANGE `survey_id` `survey_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_scheduler` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_scheduler` CHANGE `max_recurrence` `max_recurrence` int(5) DEFAULT NULL;
ALTER TABLE `redcap_surveys_scheduler` CHANGE `active` `active` int(1) NOT NULL DEFAULT '1' COMMENT 'Is it currently active?';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `condition_surveycomplete_survey_id` `condition_surveycomplete_survey_id` int(10) DEFAULT NULL COMMENT 'survey_id of trigger';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `condition_surveycomplete_event_id` `condition_surveycomplete_event_id` int(10) DEFAULT NULL COMMENT 'event_id of trigger';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `condition_send_time_lag_days` `condition_send_time_lag_days` int(4) DEFAULT NULL COMMENT 'Wait X days to send invites after condition is met';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `condition_send_time_lag_hours` `condition_send_time_lag_hours` int(2) DEFAULT NULL COMMENT 'Wait X hours to send invites after condition is met';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `condition_send_time_lag_minutes` `condition_send_time_lag_minutes` int(2) DEFAULT NULL COMMENT 'Wait X seconds to send invites after condition is met';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `reminder_timelag_days` `reminder_timelag_days` int(3) DEFAULT NULL COMMENT 'Wait X days to send reminders';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `reminder_timelag_hours` `reminder_timelag_hours` int(2) DEFAULT NULL COMMENT 'Wait X hours to send reminders';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `reminder_timelag_minutes` `reminder_timelag_minutes` int(2) DEFAULT NULL COMMENT 'Wait X seconds to send reminders';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `reminder_num` `reminder_num` int(3) NOT NULL DEFAULT '0' COMMENT 'Reminder recurrence';
ALTER TABLE `redcap_surveys_scheduler` CHANGE `reeval_before_send` `reeval_before_send` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_surveys_scheduler_queue` CHANGE `ssq_id` `ssq_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_scheduler_queue` CHANGE `ss_id` `ss_id` int(10) DEFAULT NULL COMMENT 'FK for surveys_scheduler table';
ALTER TABLE `redcap_surveys_scheduler_queue` CHANGE `email_recip_id` `email_recip_id` int(10) DEFAULT NULL COMMENT 'FK for redcap_surveys_emails_recipients table';
ALTER TABLE `redcap_surveys_scheduler_queue` CHANGE `reminder_num` `reminder_num` int(3) NOT NULL DEFAULT '0' COMMENT 'Email reminder instance (0 = original invitation)';
ALTER TABLE `redcap_surveys_scheduler_queue` CHANGE `instance` `instance` smallint(4) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_surveys_scheduler_recurrence` CHANGE `ssr_id` `ssr_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_scheduler_recurrence` CHANGE `ss_id` `ss_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_scheduler_recurrence` CHANGE `event_id` `event_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_scheduler_recurrence` CHANGE `times_sent` `times_sent` smallint(4) DEFAULT NULL;
ALTER TABLE `redcap_surveys_short_codes` CHANGE `participant_id` `participant_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_surveys_themes` CHANGE `theme_id` `theme_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_surveys_themes` CHANGE `ui_id` `ui_id` int(10) DEFAULT NULL COMMENT 'NULL = Theme is available to all users';
ALTER TABLE `redcap_todo_list` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_twilio_error_log` CHANGE `error_id` `error_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_twilio_error_log` CHANGE `ssq_id` `ssq_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_twilio_error_log` CHANGE `alert_sent_log_id` `alert_sent_log_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_two_factor_response` CHANGE `tf_id` `tf_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_two_factor_response` CHANGE `user_id` `user_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_user_information` CHANGE `ui_id` `ui_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_user_information` CHANGE `allow_create_db` `allow_create_db` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_information` CHANGE `display_on_email_users` `display_on_email_users` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_information` CHANGE `two_factor_auth_code_expiration` `two_factor_auth_code_expiration` int(3) NOT NULL DEFAULT '2';
ALTER TABLE `redcap_user_rights` CHANGE `project_id` `project_id` int(10) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `role_id` `role_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_user_rights` CHANGE `group_id` `group_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_user_rights` CHANGE `lock_record` `lock_record` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `lock_record_multiform` `lock_record_multiform` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `lock_record_customize` `lock_record_customize` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `data_import_tool` `data_import_tool` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `data_comparison_tool` `data_comparison_tool` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `data_logging` `data_logging` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `email_logging` `email_logging` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `file_repository` `file_repository` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `double_data` `double_data` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `user_rights` `user_rights` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `data_access_groups` `data_access_groups` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `graphical` `graphical` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `reports` `reports` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `design` `design` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `alerts` `alerts` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `calendar` `calendar` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `api_export` `api_export` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `api_import` `api_import` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `api_modules` `api_modules` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `mobile_app` `mobile_app` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `mobile_app_download_data` `mobile_app_download_data` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `record_create` `record_create` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `record_rename` `record_rename` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `record_delete` `record_delete` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `dts` `dts` int(1) NOT NULL DEFAULT '0' COMMENT 'DTS adjudication page';
ALTER TABLE `redcap_user_rights` CHANGE `participants` `participants` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_rights` CHANGE `data_quality_design` `data_quality_design` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `data_quality_execute` `data_quality_execute` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `data_quality_resolution` `data_quality_resolution` int(1) NOT NULL DEFAULT '0' COMMENT '0=No access, 1=View only, 2=Respond, 3=Open, close, respond, 4=Open only, 5=Open and respond';
ALTER TABLE `redcap_user_rights` CHANGE `random_setup` `random_setup` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `random_dashboard` `random_dashboard` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `random_perform` `random_perform` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_rights` CHANGE `realtime_webservice_mapping` `realtime_webservice_mapping` int(1) NOT NULL DEFAULT '0' COMMENT 'User can map fields for RTWS';
ALTER TABLE `redcap_user_rights` CHANGE `realtime_webservice_adjudicate` `realtime_webservice_adjudicate` int(1) NOT NULL DEFAULT '0' COMMENT 'User can adjudicate data for RTWS';
ALTER TABLE `redcap_user_rights` CHANGE `mycap_participants` `mycap_participants` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `role_id` `role_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_user_roles` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
ALTER TABLE `redcap_user_roles` CHANGE `lock_record` `lock_record` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `lock_record_multiform` `lock_record_multiform` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `lock_record_customize` `lock_record_customize` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `data_import_tool` `data_import_tool` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `data_comparison_tool` `data_comparison_tool` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `data_logging` `data_logging` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `email_logging` `email_logging` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `file_repository` `file_repository` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `double_data` `double_data` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `user_rights` `user_rights` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `data_access_groups` `data_access_groups` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `graphical` `graphical` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `reports` `reports` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `design` `design` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `alerts` `alerts` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `calendar` `calendar` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `api_export` `api_export` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `api_import` `api_import` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `api_modules` `api_modules` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `mobile_app` `mobile_app` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `mobile_app_download_data` `mobile_app_download_data` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `record_create` `record_create` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `record_rename` `record_rename` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `record_delete` `record_delete` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `dts` `dts` int(1) NOT NULL DEFAULT '0' COMMENT 'DTS adjudication page';
ALTER TABLE `redcap_user_roles` CHANGE `participants` `participants` int(1) NOT NULL DEFAULT '1';
ALTER TABLE `redcap_user_roles` CHANGE `data_quality_design` `data_quality_design` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `data_quality_execute` `data_quality_execute` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `data_quality_resolution` `data_quality_resolution` int(1) NOT NULL DEFAULT '0' COMMENT '0=No access, 1=View only, 2=Respond, 3=Open, close, respond';
ALTER TABLE `redcap_user_roles` CHANGE `random_setup` `random_setup` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `random_dashboard` `random_dashboard` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `random_perform` `random_perform` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_user_roles` CHANGE `realtime_webservice_mapping` `realtime_webservice_mapping` int(1) NOT NULL DEFAULT '0' COMMENT 'User can map fields for RTWS';
ALTER TABLE `redcap_user_roles` CHANGE `realtime_webservice_adjudicate` `realtime_webservice_adjudicate` int(1) NOT NULL DEFAULT '0' COMMENT 'User can adjudicate data for RTWS';
ALTER TABLE `redcap_user_roles` CHANGE `mycap_participants` `mycap_participants` int(1) NOT NULL DEFAULT '0';
ALTER TABLE `redcap_validation_types` CHANGE `visible` `visible` int(1) NOT NULL DEFAULT '1' COMMENT 'Show in Online Designer?';
ALTER TABLE `redcap_web_service_cache` CHANGE `cache_id` `cache_id` int(10) NOT NULL AUTO_INCREMENT;
ALTER TABLE `redcap_web_service_cache` CHANGE `project_id` `project_id` int(10) DEFAULT NULL;
SET FOREIGN_KEY_CHECKS = 1;

TEST 4: Check if PHP cURL extension is installed

SUCCESSFUL! - The cURL extension is installed.

TEST 5: Checking communication with REDCap Consortium server (https://redcap.vumc.org/consortium/)
(used to report weekly site stats and connect to Shared Library)

Communicating with server... please wait

TEST 6: Check if REDCap Cron Job is running

ERROR: Cron job not running!
It appears that your REDCap cron job has either not been set up or is not running at the proper interval. Please see the Cron Jobs page in the Control Center for details on setting it up. This cron job is very important and must be running on a regular basis at the prescribed interval in order for certain background tasks to be performed correctly.

Go to Cron Jobs page

Secondary tests

NOT using SSL - CRITICAL: It is HIGHLY recommended that you use SSL (i.e. https) on your web server when hosting REDCap. Otherwise, data security could be compromised. If your server does not already have an SSL certificate, you will need to obtain one.

Using PHP 8.0.2 or higher

Using MariaDB 5.5.5 or higher

GD library (version 2 or higher) is installed

Imagick extension in PHP is not installed - RECOMMENDED: It is recommended that you install the Imagick extension in PHP on your web server. Some features in REDCap will not be available without it being installed. For example, any inline PDF attachments on Descriptive Text fields will *not* be able to be displayed inside a PDF export of a given form or survey unless the Imagick extension in PHP has been installed.

PHP Fileinfo extension is installed

REDCap is not able to send emails - CRITICAL:It appears that your SMTP configuration (email-sending functionality) is either not set up or not configured correctly on the web server. It is HIGHLY recommended that you configure your email/SMTP server correctly in your web server's PHP.INI configuration file or else emails will not be able to be sent out from REDCap. REDCap requires email-sending capabilities for many vital application functions. For more details on configuring email-sending capabilities on your web server, visit PHP's mail configuration page.

"max_allowed_packet" setting in MySQL should be increased - RECOMMENDED: It appears that your MySQL database server's "max_allowed_packet" setting is lower than recommended for optimal REDCap usage. It is suggested that you increase that setting to 128M (i.e., 128 MB) or higher, preferably to the maximum value of 1G (i.e., 1 GB). Setting it to the max value of 1G will not have any negative side effects. To change this setting, open your my.cnf (or my.ini) configuration file for MySQL and modify the line for max_allowed_packet to set it as the following: max_allowed_packet=1G. Then restart MySQL, and then reload this page.

'max_input_vars' could be larger - RECOMMENDED: It is highly recommended that you change your value for 'max_input_vars' in your PHP.INI configuration file to a value of 100000 or higher. If not increased, then REDCap might not be able to successfully save data when entered on a very long survey or data entry form. You can modify this setting in your server's PHP.INI configuration file. If 'max_input_vars' is not found in your PHP.INI file, you should add it as max_input_vars = 100000 . Once done, restart your web server for the changes to take effect.

'upload_max_filesize' and 'post_max_size' are too small: It is HIGHLY recommended that you change your value for both 'upload_max_filesize' and 'post_max_size' in PHP to a higher value, preferably greater than 10MB (e.g., 32M). You can modify this in your server's PHP.INI configuration file, then restart your web server. At such small values, your users will likely have issues uploading files if you do not increase these.

'innodb_buffer_pool_size' could be larger - RECOMMENDED: It is recommended that you change your value for 'innodb_buffer_pool_size' in MySQL to a higher value. It is generally recommended that it be set to 10% larger than the size of your database, which is currently 944MB in size. So ideally 'innodb_buffer_pool_size' should be set to at least 1024MB if possible (it is currently 128MB). Also, it is recommended that the size of 'innodb_buffer_pool_size' not exceed 80% of your total RAM (memory) that is allocated to MySQL on your database server. You can modify this in your MY.CNF configuration file (or MY.INI for Windows), then restart MySQL. If you do not increase this value, you may begin to see performance issues in MySQL.

Database configuration issue: There is a configuration issue with the MySQL setting named "optimizer_switch" that needs to be fixed. If not fixed, if may cause some things not to function correctly in REDCap or might cause the database server to crash unexpectedly. To fix this, add the line
optimizer_switch=rowid_filter=OFF
under the [mysqld] section in your MY.CNF (or MY.INI) configuration file for MySQL/MariaDB. If there is already a line in the file that begins with "optimizer_switch", then add this new line directly below it. After that new line has been added, save that configuration file, and then restart the MySQL/MariaDB service. Then reload this page to ensure the fix has successfully taken effect.

MARIADB DATABASE CONFIGURATION RECOMMENDATIONS:

Your database configuration settings do not appear to be optimal. For better database performance and stability, consider making the changes below to your database configuration settings in your my.cnf (Linux/Unix) or my.ini (Windows) configuration file. TIP: Remember to restart the MariaDB service after making any edits to the configuration, otherwise they won't take effect.

Recommendations for the REDCap database server:

The query_cache is not turned on. It should be turned on by setting it with new value(s) - recommended initial value: query_cache_size=16777216 and query_cache_type=1.
Too many temporary tables are being written to disk. Increase max_heap_table_size and tmp_table_size (note: keep their values the same as each other as you increase them both).

DISCLAIMER: It is extremely important for you to fully understand each change you make to the database server. If you don't understand the recommendations above, you should consult a knowledgeable DBA or system administrator that you trust. Always test your changes on staging environments, and always keep in mind that improvements in one area can negatively affect the database in other areas.

The REDCap web server's temp directory is writable
Location: /tmp

"temp" directory is writable
Location: /var/www/html/redcap/temp/

File upload directory is writable
Location: /var/www/html/redcap/edocs/

Directory that stores user-uploaded documents is exposed to the web:
It is HIGHLY recommended that you change your location where user-uploaded files are stored. Currently, they are being stored in REDCap's "edocs" directory, which is the default location and is completely accessible to the web. Although it is extremely unlikely that anyone could successfully retrieve a file from that location on the server via the web, it is still a potential security risk, especially if the documents contain sensitive information.

It is recommend that you go to the File Upload Settings page in the Control Center and set a new path for your user-uploaded documents (i.e. "Enable alternate internal storage of uploaded files rather than default 'edocs' folder"), and set it to a path on your web server that is NOT accessible from the web. Once you have changed that value, go to the 'edocs' directory and copy all existing files in that folder to the new location you just set.

"modules" directory is writable
Location: /var/www/html/redcap/modules/

Internal Service Check: Checking communication with the REDCap survey end-point