REDCap

Notifications

Server info: `REDCap 15.0.35 · PHP 8.3.6 (Linux/Unix OS) · MariaDB 10.11.13`

If there are any important notifications to show to REDCap administrators, they will appear here on this page.
New REDCap versions are available for upgrade View Check again
Upgrades are available for the versions listed below in which it will display the REDCap version number, a brief description, and release date. This process will download the upgrade zip file from the REDCap Community website and then (if possible) automatically execute the Upgrade SQL script to fully complete the upgrade. Click the button to upgrade to a specific version.
LTS versions(View changelog)
Bug fixes, including major security fixes (02/26/2026)
Bug fixes (02/18/2026)
Bug fixes, including critical security fixes (02/12/2026)
Bug fixes, include a critical security fix (02/05/2026)
Major bug fix (01/30/2026)
New LTS branch based off of REDCap 16.0.9 (Standard). (01/29/2026)
Bug fixes, including major security fixes (02/26/2026)
Bug fixes, including critical security fixes (02/12/2026)
Critical security fix (02/05/2026)
Bug fixes, including a major security fix (01/29/2026)
Bug fixes (01/22/2026)
Bug fixes (01/15/2026)
Bug fixes (01/08/2026)
Bug fixes (01/01/2026)
Bug fixes (12/18/2025)
Bug fixes (12/11/2025)
Bug fixes (12/06/2025)
Bug fixes (12/04/2025)
Bug fixes (11/26/2025)
Bug fixes (11/20/2025)
Standard Release versions(View changelog)
Bug fixes, including major security fixes, + minor improvements (02/26/2026)
Major bug fix (02/19/2026)
Bug fixes + minor improvements (02/18/2026)
New special function + minor improvements; Bug fixes, including critical security fixes (02/12/2026)
New feature; Bug fixes, including a critical security fix (02/05/2026)
Bug fixes, including a major security fix, + minor improvements (01/29/2026)
Bug fixes + minor improvements (01/22/2026)
Bug fixes + minor improvements (01/15/2026)
Bug fixes + minor improvements (01/08/2026)
Bug fixes + minor improvements (01/01/2026)
Bug fixes + minor improvements (12/18/2025)
Bug fixes (12/12/2025)
Bug fixes (12/11/2025)
Bug fixes (12/06/2025)
New feature: Access Control Groups; Bug fixes + minor improvements (12/04/2025)
Bug fixes (11/26/2025)
Bug fixes + minor improvements (11/20/2025)
Major bug fix (11/14/2025)
Bug fixes, including medium security fixes, + improvements (11/14/2025)
Bug fixes, including a medium security fix, + minor improvements (11/06/2025)
Using valid REDCap Community credentials, REDCap v will be downloaded automatically, and the upgrade process will begin immediately thereafter. If for some reason the upgrade process is not able to be completed automatically, it will notify you about how to finish the upgrade manually.
You must provide a valid username/password that you (or someone on your REDCap team) uses to login to the REDCap Community website. (If credentials were used previously, they will be pre-filled below.)
REDCap Community username:
REDCap Community password:
NOTICE: The Easy Upgrade feature cannot be used if the REDCap web server is using load balancing (multiple application servers). This is because the source code would only get downloaded to a single server (rather than to all of them) during the upgrade process.
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;
NOTICE: Authentication is not enabled!
Please note that authentication has not yet been enabled for this installation of REDCap. This means that no login screen will appear when accessing REDCap, and all users will be given the default username 'site_admin'. You can set the authentication method on the Security & Authentication page. However, first you may want to read an overview on the REDCap Community website of all the steps required when changing your authentication method for REDCap (see link below).

How to change your authentication method
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
Reporting Your Stats

Help support REDCap by reporting your REDCap stats to the consortium, preferably on a weekly basis. You can set your stats to be sent automatically once per week by setting it on the Control Center's General Configuration page. Your participation helps promote the longevity of REDCap and the consortium.
Your stats were last reported on 02/23/2026
Your current method for sending REDCap stats is Automatic (What stats are sent?)
Use alternative reporting method (if above does not work)
Other useful info:
Date of last REDCap upgrade: 07/28/2025
REDCap server's current time: 02/28/2026 10:09am (UTC timezone)
Your browser's current time:
Path to web server's PHP.INI configuration file:/etc/php/8.3/apache2/php.ini
Notice: The web server and the cron job are using different PHP.INI configuration files. The cron job uses the file located at: . This may lead to undesired side effects if the configurations differ (e.g., different time zone settings). It is often recommended that the cron job use the same configuration file as the web server.
Path to web server's PHP error log file:
Notifications Server info: REDCap 15.0.35 · PHP 8.3.6 (Linux/Unix OS) · MariaDB 10.11.13

Reporting Your Stats

Notifications

Conversations

Notifications

Server info: `REDCap 15.0.35 · PHP 8.3.6 (Linux/Unix OS) · MariaDB 10.11.13`
