Azure Database: Redcap Database Collation Scripts

Redcap Dev

`` sql
-- TABLE STRUCTURE: SQL to fix the table charset and collation of the REDCap database tables
USE redcap_appd87m1;
SET SESSION SQL_SAFE_UPDATES = 0;
SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE redcap_actions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE action_trigger action_trigger enum('MANUAL','ENDOFSURVEY','SURVEYQUESTION') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE action_response action_response enum('NONE','EMAIL_PRIMARY','EMAIL_SECONDARY','EMAIL_TERTIARY','STOPSURVEY','PROMPT') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_text custom_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_alerts_recurrence
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE instrument instrument varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE send_option send_option enum('now','date','time_lag','next_occurrence') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'now',
CHANGE status status enum('IDLE','QUEUED','SENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDLE';
ALTER TABLE redcap_alerts_sent_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE alert_type alert_type enum('EMAIL','SMS','VOICE_CALL','SENDGRID_TEMPLATE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE email_from email_from varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_to email_to text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE phone_number_to phone_number_to text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_cc email_cc text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_bcc email_bcc text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE subject subject text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE message message mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE attachment_names attachment_names text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_alerts_sent
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE instrument instrument varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_alerts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE alert_title alert_title varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE alert_type alert_type enum('EMAIL','SMS','VOICE_CALL','SENDGRID_TEMPLATE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE alert_stop_type alert_stop_type enum('RECORD','RECORD_EVENT','RECORD_EVENT_INSTRUMENT','RECORD_INSTRUMENT','RECORD_EVENT_INSTRUMENT_INSTANCE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'RECORD_EVENT_INSTRUMENT_INSTANCE',
CHANGE form_name form_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Instrument Name',
CHANGE alert_condition alert_condition text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Conditional logic',
CHANGE email_from email_from varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email From',
CHANGE email_from_display email_from_display varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email sender display name',
CHANGE email_to email_to text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email To',
CHANGE phone_number_to phone_number_to text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_cc email_cc text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email CC',
CHANGE email_bcc email_bcc text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email BCC',
CHANGE email_subject email_subject varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Subject',
CHANGE alert_message alert_message text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Message',
CHANGE email_failed email_failed varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_attachment_variable email_attachment_variable text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'REDCap file variables',
CHANGE cron_send_email_on cron_send_email_on enum('now','date','time_lag','next_occurrence') COLLATE utf8mb4_unicode_ci DEFAULT 'now' COMMENT 'When to send alert',
CHANGE cron_send_email_on_field cron_send_email_on_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE cron_send_email_on_field_after cron_send_email_on_field_after enum('before','after') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'after',
CHANGE cron_send_email_on_next_day_type cron_send_email_on_next_day_type enum('DAY','WEEKDAY','WEEKENDDAY','SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DAY',
CHANGE cron_repeat_for_units cron_repeat_for_units enum('DAYS','HOURS','MINUTES') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DAYS',
CHANGE sendgrid_template_id sendgrid_template_id text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sendgrid_template_data sendgrid_template_data text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sendgrid_mail_send_configuration sendgrid_mail_send_configuration text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_auth_copy
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_auth_history
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE password password varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
DROP INDEX username_password,
ADD KEY username_password (username(191),password(191));
ALTER TABLE redcap_auth_questions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE question question text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_auth
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE password password varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Hash of user''s password',
CHANGE password_salt password_salt varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique random salt for password',
CHANGE password_answer password_answer text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Hashed answer to password recovery question',
CHANGE password_reset_key password_reset_key varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE cache_key cache_key varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE invalidation_strategies invalidation_strategies text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_cde_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE tinyId tinyId varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE publicId publicId varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE steward steward varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE question question text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE choices choices text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_cde_field_mapping
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE tinyId tinyId varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE publicId publicId varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE questionId questionId varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE steward steward varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE web_service web_service varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE org_selected org_selected varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_crons_datediff
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE asi_status asi_status enum('QUEUED','PROCESSING') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Status for ASIs',
CHANGE alert_status alert_status enum('QUEUED','PROCESSING') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Status for Alerts';
ALTER TABLE redcap_crons_history
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE cron_run_status cron_run_status enum('PROCESSING','COMPLETED','FAILED') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE cron_info cron_info text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Any pertinent info that might be logged';
ALTER TABLE redcap_crons
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE cron_name cron_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name for each job',
CHANGE cron_description cron_description text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE cron_enabled cron_enabled enum('ENABLED','DISABLED') COLLATE utf8mb4_unicode_ci DEFAULT 'ENABLED',
CHANGE cron_external_url cron_external_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL to call for custom jobs not defined by REDCap';
ALTER TABLE redcap_custom_queries_folders_items
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_custom_queries_folders
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_custom_queries
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE query query text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_dashboard_ip_location_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE latitude latitude varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE longitude longitude varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE city city varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE region region varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE country country varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data2
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data3
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data4
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data5
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data6
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_access_groups_users
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_access_groups
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE group_name group_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_dictionaries
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_data_import_rows
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record_provided record_provided varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE row_status row_status enum('QUEUED','PROCESSING','COMPLETED','FAILED','CANCELED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'QUEUED',
CHANGE row_data row_data longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE errors errors text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_import
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE filename filename varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE status status enum('INITIALIZING','QUEUED','PROCESSING','COMPLETED','FAILED','CANCELED','PAUSED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'INITIALIZING',
CHANGE csv_header csv_header mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE delimiter delimiter enum(',',';','TAB') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',',
CHANGE date_format date_format enum('YMD','MDY','DMY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'YMD',
CHANGE overwrite_behavior overwrite_behavior enum('normal','overwrite') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'normal',
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_quality_resolutions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE response response enum('DATA_MISSING','TYPOGRAPHICAL_ERROR','CONFIRMED_CORRECT','WRONG_SOURCE','OTHER') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Response category if user responded to query',
CHANGE comment comment text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Text for comment',
CHANGE current_query_status current_query_status enum('OPEN','CLOSED','VERIFIED','DEVERIFIED') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current query status of thread';
ALTER TABLE redcap_data_quality_rules
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE rule_name rule_name text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE rule_logic rule_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_data_quality_status
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Only used if field-level is required',
CHANGE repeat_instrument repeat_instrument varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE query_status query_status enum('OPEN','CLOSED','VERIFIED','DEVERIFIED') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Status of data query';
ALTER TABLE redcap_data
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ddp_log_view_data
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE source_field source_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Field name from source system';
ALTER TABLE redcap_ddp_log_view
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE source_id source_id varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID value from source system (e.g. MRN)',
DROP INDEX source_id,
ADD KEY source_id (source_id(191));
ALTER TABLE redcap_ddp_mapping
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE external_source_field_name external_source_field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name of field mapped from external data source',
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE temporal_field temporal_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'REDCap date field',
CHANGE preselect preselect enum('MIN','MAX','FIRST','LAST','NEAR') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Preselect a source value for temporal fields only';
ALTER TABLE redcap_ddp_preview_fields
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field1 field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field2 field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field3 field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field4 field4 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field5 field5 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ddp_records_data
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE source_value source_value text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Encrypted data value from source system',
CHANGE source_value2 source_value2 text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ddp_records
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fetch_status fetch_status enum('QUEUED','FETCHING') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Current status of data fetch for this record';
ALTER TABLE redcap_docs_attachments
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_docs_folders_files
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_docs_folders
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_docs_share
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_docs_to_edocs
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_docs
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE docs_name docs_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE docs_type docs_type text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE docs_comment docs_comment text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE docs_rights docs_rights text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX docs_name,
ADD KEY docs_name (docs_name(191));
ALTER TABLE redcap_econsent_forms
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE version version varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE consent_form_richtext consent_form_richtext mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Consent form text (alternate to PDF)',
CHANGE consent_form_filter_lang_id consent_form_filter_lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Consent form MLM filter';
ALTER TABLE redcap_econsent
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE version version varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE type_label type_label varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_econsent_label custom_econsent_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE notes notes text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE firstname_field firstname_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE lastname_field lastname_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE dob_field dob_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE signature_field1 signature_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE signature_field2 signature_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE signature_field3 signature_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE signature_field4 signature_field4 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE signature_field5 signature_field5 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE consent_form_location_field consent_form_location_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Display consent form below this field';
ALTER TABLE redcap_edocs_metadata
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE stored_name stored_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'stored name',
CHANGE mime_type mime_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE doc_name doc_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE file_extension file_extension varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_access_tokens
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE patient patient varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE mrn mrn varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'If different from patient id',
CHANGE access_token access_token text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE refresh_token refresh_token text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_datamart_counts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_ehr_datamart_revisions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE mrns mrns mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fields fields mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE date_range_categories date_range_categories text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_fhir_logs
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE fhir_id fhir_id varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE resource_type resource_type varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE environment environment varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'CRON or direct user request',
CHANGE mrn mrn varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_ehr_import_counts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE type type enum('CDP','CDM','CDP-I') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CDP',
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_settings
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ehr_name ehr_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE client_id client_id varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE client_secret client_secret varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fhir_base_url fhir_base_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fhir_token_url fhir_token_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fhir_authorize_url fhir_authorize_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fhir_identity_provider fhir_identity_provider varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE patient_identifier_string patient_identifier_string varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE fhir_custom_auth_params fhir_custom_auth_params varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_user_map
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ehr_username ehr_username varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_ehr_user_projects
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_error_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE error error text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_esignatures
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE username username varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX username,
ADD KEY username (username(191));
ALTER TABLE redcap_events_arms
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE arm_name arm_name varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Arm 1';
ALTER TABLE redcap_events_calendar_feed
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_events_calendar
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event_time event_time varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'HH:MM',
CHANGE notes notes text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE extra_notes extra_notes text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_events_forms
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_events_metadata
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE descrip descrip varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Event 1' COMMENT 'Event Name',
CHANGE external_id external_id varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_event_label custom_event_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX external_id,
ADD KEY external_id (external_id(191));
ALTER TABLE redcap_events_repeat
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_repeat_form_label custom_repeat_form_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_external_links_dags
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_external_links_exclude_projects
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_external_links_users
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_external_links
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE link_url link_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE link_label link_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE link_type link_type enum('LINK','POST_AUTHKEY','REDCAP_PROJECT') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'LINK',
CHANGE user_access user_access enum('ALL','DAG','SELECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL';
ALTER TABLE redcap_external_module_settings
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE key key varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE type type varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'string',
CHANGE value value mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
DROP INDEX key,
ADD KEY key (key(191));
ALTER TABLE redcap_external_modules_downloads
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE module_name module_name varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_external_modules_log_parameters
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE value value mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
DROP FOREIGN KEY redcap_external_modules_log_parameters_ibfk_1,
DROP PRIMARY KEY,
ADD PRIMARY KEY (log_id,name(191)),
DROP INDEX name,
ADD KEY name (name(191));
ALTER TABLE redcap_external_modules_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE message message mediumtext COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_external_modules
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE directory_prefix directory_prefix varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_folders_projects
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_folders
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE foreground foreground varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE background background varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_form_display_logic_conditions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE control_condition control_condition text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_form_display_logic_targets
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_history_size
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_history_version
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE redcap_version redcap_version varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_instrument_zip_authors
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE author_name author_name varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_instrument_zip_origins
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE server_name server_name varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_instrument_zip
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE instrument_id instrument_id varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_ip_banned
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_ip_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE ip_hash ip_hash varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_library_map
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE acknowledgement acknowledgement text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE promis_key promis_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'PROMIS instrument key',
CHANGE scoring_type scoring_type enum('EACH_ITEM','END_ONLY') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'If has scoring, what type?',
CHANGE promis_battery_key promis_battery_key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'PROMIS battery key';
ALTER TABLE redcap_locking_data
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_locking_labels
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE label label text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_locking_records_pdf_archive
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_locking_records
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_log_event10
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event11
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event12
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event2
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX page_project,
ADD KEY page_project (page(191),project_id),
DROP INDEX pk_project,
ADD KEY pk_project (pk(191),project_id),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event3
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX page_project,
ADD KEY page_project (page(191),project_id),
DROP INDEX pk_project,
ADD KEY pk_project (pk(191),project_id),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event4
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX page_project,
ADD KEY page_project (page(191),project_id),
DROP INDEX pk_project,
ADD KEY pk_project (pk(191),project_id),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event5
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX page_project,
ADD KEY page_project (page(191),project_id),
DROP INDEX pk_project,
ADD KEY pk_project (pk(191),project_id),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event6
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event7
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event8
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event9
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX project_page,
ADD KEY project_page (project_id,page(191)),
DROP INDEX project_pk,
ADD KEY project_pk (project_id,pk(191)),
DROP INDEX project_user,
ADD KEY project_user (project_id,user(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_event
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('UPDATE','INSERT','DELETE','SELECT','ERROR','LOGIN','LOGOUT','OTHER','DATA_EXPORT','DOC_UPLOAD','DOC_DELETE','MANAGE','LOCK_RECORD','ESIGNATURE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE object_type object_type varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sql_log sql_log mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pk pk varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_values data_values text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE change_reason change_reason text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX pk,
ADD KEY pk (pk(191)),
DROP INDEX user,
ADD KEY user (user(191)),
DROP INDEX user_project,
ADD KEY user_project (project_id,user(191));
ALTER TABLE redcap_log_view_old
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('LOGIN_SUCCESS','LOGIN_FAIL','LOGOUT','PAGE_VIEW') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE browser_name browser_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE browser_version browser_version varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE full_url full_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record record varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE miscellaneous miscellaneous text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE session_id session_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX browser_name,
ADD KEY browser_name (browser_name(191)),
DROP INDEX browser_version,
ADD KEY browser_version (browser_version(191)),
DROP INDEX page,
ADD KEY page (page(191)),
DROP INDEX project_event_record,
ADD KEY project_event_record (project_id,event_id,record(191)),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_log_view_requests
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_log_view
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE user user varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE event event enum('LOGIN_SUCCESS','LOGIN_FAIL','LOGOUT','PAGE_VIEW') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE browser_name browser_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE browser_version browser_version varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE full_url full_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page page varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record record varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE miscellaneous miscellaneous text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE session_id session_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX browser_name,
ADD KEY browser_name (browser_name(191)),
DROP INDEX browser_version,
ADD KEY browser_version (browser_version(191)),
DROP INDEX page_ts_project_id,
ADD KEY page_ts_project_id (page(191),ts,project_id),
DROP INDEX project_event_record,
ADD KEY project_event_record (project_id,event_id,record(191)),
DROP INDEX project_record,
ADD KEY project_record (project_id,record(191)),
DROP INDEX ts_user_event,
ADD KEY ts_user_event (ts,user(191),event),
DROP INDEX user_project,
ADD KEY user_project (user(191),project_id);
ALTER TABLE redcap_messages_recipients
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_messages_status
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_messages_threads
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE type type enum('CHANNEL','NOTIFICATION','CONVERSATION') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Type of entity',
CHANGE channel_name channel_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Only for channels';
ALTER TABLE redcap_messages
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE message_body message_body text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'The message itself',
CHANGE stored_url stored_url varchar(256) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_metadata_archive
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE field_phi field_phi varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_menu_description form_menu_description varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_units field_units varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_preceding_header element_preceding_header mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_type element_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_label element_label mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_enum element_enum mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_note element_note mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_type element_validation_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_min element_validation_min varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_max element_validation_max varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_checktype element_validation_checktype varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE branching_logic branching_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_alignment custom_alignment enum('LH','LV','RH','RV') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'RV = NULL = default',
CHANGE stop_actions stop_actions text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE question_num question_num varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE grid_name grid_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name of grid group',
CHANGE misc misc mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Miscellaneous field attributes',
CHANGE video_url video_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_metadata_prod_revisions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_metadata_temp
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE field_phi field_phi varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_menu_description form_menu_description varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_units field_units varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_preceding_header element_preceding_header mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_type element_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_label element_label mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_enum element_enum mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_note element_note mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_type element_validation_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_min element_validation_min varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_max element_validation_max varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_checktype element_validation_checktype varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE branching_logic branching_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_alignment custom_alignment enum('LH','LV','RH','RV') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'RV = NULL = default',
CHANGE stop_actions stop_actions text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE question_num question_num varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE grid_name grid_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name of grid group',
CHANGE misc misc mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Miscellaneous field attributes',
CHANGE video_url video_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_metadata
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE field_phi field_phi varchar(5) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE form_menu_description form_menu_description varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE field_units field_units varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_preceding_header element_preceding_header mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_type element_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_label element_label mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_enum element_enum mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_note element_note mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_type element_validation_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_min element_validation_min varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_max element_validation_max varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE element_validation_checktype element_validation_checktype varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE branching_logic branching_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_alignment custom_alignment enum('LH','LV','RH','RV') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'RV = NULL = default',
CHANGE stop_actions stop_actions text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE question_num question_num varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE grid_name grid_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unique name of grid group',
CHANGE misc misc mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Miscellaneous field attributes',
CHANGE video_url video_url varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_mobile_app_devices
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE uuid uuid varchar(128) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE nickname nickname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_mobile_app_files
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE type type enum('ESCAPE_HATCH','LOGGING') COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_mobile_app_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE event event enum('INIT_PROJECT','INIT_DOWNLOAD_DATA','INIT_DOWNLOAD_DATA_PARTIAL','REINIT_PROJECT','REINIT_DOWNLOAD_DATA','REINIT_DOWNLOAD_DATA_PARTIAL','SYNC_DATA') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE details details text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_multilanguage_config_temp
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE name name varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE value value mediumtext COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_multilanguage_config
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE name name varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE value value mediumtext COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_multilanguage_metadata_temp
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE type type varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE name name varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE index index varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE hash hash char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_multilanguage_metadata
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE type type varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE name name varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE index index varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE hash hash char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_multilanguage_snapshots
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_multilanguage_ui_temp
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE item item varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE hash hash char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE translation translation text COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_multilanguage_ui
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE item item varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE hash hash char(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE translation translation text COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_mycap_aboutpages
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE identifier identifier varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page_title page_title varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE page_content page_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Page content',
CHANGE sub_type sub_type varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE image_type image_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Image Type',
CHANGE system_image_name system_image_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'System Image Name';
ALTER TABLE redcap_mycap_contacts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE identifier identifier varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE contact_header contact_header varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE contact_title contact_title varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE phone_number phone_number varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Field name that stores contact phone number',
CHANGE email email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE website website text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE additional_info additional_info text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_mycap_links
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE identifier identifier varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE link_name link_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE link_url link_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE link_icon link_icon varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_mycap_messages
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE uuid uuid char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'UUID',
CHANGE type type varchar(45) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Announcement, standard',
CHANGE from from varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Either a participant code or a redcap user',
CHANGE to to varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Either a participant code or a redcap user',
CHANGE title title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Optional title',
CHANGE body body text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Body content',
CHANGE processed_by processed_by varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'message processed by this REDCap user. FK to redcap_user_information.username';
ALTER TABLE redcap_mycap_participants
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE code code varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Participant identifier. Alias for record_id. We never store record_id on the mobile app for security reasons.',
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE timezone timezone varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Participant timezone',
CHANGE push_notification_ids push_notification_ids text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Stores push notification identifiers';
ALTER TABLE redcap_mycap_projectfiles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE project_code project_code varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PFK to redcap_mycap_projects.code',
CHANGE name name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'File name';
ALTER TABLE redcap_mycap_projects
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE code code varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Project identifier. Alias for project_id. We never store project_id on the mobile app for security reasons.',
CHANGE hmac_key hmac_key varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Hash-based Message Access Code key.',
CHANGE name name varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Name of the project within the app',
CHANGE participant_custom_field participant_custom_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'participant identifier field_name',
CHANGE participant_custom_label participant_custom_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE participant_allow_condition participant_allow_condition text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE config config mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON representation of the config',
CHANGE baseline_date_field baseline_date_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'baseline date field_name',
CHANGE baseline_date_config baseline_date_config mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'JSON representation of the baseline date settings config',
CHANGE event_display_format event_display_format enum('ID','LABEL','NONE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NONE';
ALTER TABLE redcap_mycap_syncissuefiles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE uuid uuid char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'PFK to redcap_mycap_syncissues.uuid';
ALTER TABLE redcap_mycap_syncissues
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE uuid uuid char(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'UUID generated by app. Maps to a field with annotation @MC-TASK-UUID',
CHANGE participant_code participant_code varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'FK to a record with field annotation @MC-PARTICIPANT-CODE. FK is not enforced as someone may inadvertently delete a participant, but we still want to get results',
CHANGE project_code project_code varchar(36) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'FK to redcap_mycap_projects.code. Not enforced because someone may accidentally delete a project.',
CHANGE payload payload mediumtext COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Request payload in JSON format',
CHANGE instrument instrument varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'FK to redcap_metadata.form_name. Relationship not enforced as we may receive results for tasks that were deleted in REDCap.',
CHANGE error_message error_message varchar(4000) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Error message that REDCap returned when attempting to save the result, or that MyCap identified',
CHANGE resolved_by resolved_by varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'issue resolved by this user. FK to redcap_user_information.username',
CHANGE resolved_comment resolved_comment varchar(2000) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Optional comment describing why issue was toggled as resolved';
ALTER TABLE redcap_mycap_tasks_schedules
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE instruction_step_title instruction_step_title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Instruction Step - Title',
CHANGE instruction_step_content instruction_step_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Instruction Step - Content',
CHANGE completion_step_title completion_step_title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Completion Step - Title',
CHANGE completion_step_content completion_step_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Completion Step - Content',
CHANGE schedule_relative_to schedule_relative_to varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .JoinDate, .ZeroDate',
CHANGE schedule_type schedule_type varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .OneTime, .Infinite, .Repeating, .Fixed',
CHANGE schedule_frequency schedule_frequency varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .Daily, .Weekly, .Monthly',
CHANGE schedule_days_of_the_week schedule_days_of_the_week varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'List of days of the week',
CHANGE schedule_days_of_the_month schedule_days_of_the_month varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'List of days of the month',
CHANGE schedule_days_fixed schedule_days_fixed varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'List of days for type FIXED',
CHANGE schedule_ends schedule_ends varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .Never or list of .AfterCountOccurrences, .AfterNDays, .OnDate',
CHANGE extended_config_json extended_config_json text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Extended Config JSON string for active task';
ALTER TABLE redcap_mycap_tasks
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'REDCap Instrument Name',
CHANGE task_title task_title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'MyCap Task Title',
CHANGE question_format question_format varchar(35) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .Questionnaire, .Form',
CHANGE card_display card_display varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Possible values are .Percent, .Form',
CHANGE x_date_field x_date_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Date Field for Chart Display = Chart',
CHANGE x_time_field x_time_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Time Field for Chart Display = Chart',
CHANGE y_numeric_field y_numeric_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Numeric Field for Chart Display = Chart';
ALTER TABLE redcap_mycap_themes
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE primary_color primary_color varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE light_primary_color light_primary_color varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE accent_color accent_color varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE dark_primary_color dark_primary_color varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE light_bg_color light_bg_color varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_type theme_type varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE system_type system_type varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_new_record_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_outgoing_email_counts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_outgoing_email_sms_identifiers
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_outgoing_email_sms_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE type type enum('EMAIL','SMS','VOICE_CALL','SENDGRID_TEMPLATE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE category category varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sender sender varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email or phone number',
CHANGE recipients recipients text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Emails or phone numbers',
CHANGE email_cc email_cc text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_bcc email_bcc text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_subject email_subject text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE message message mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE message_html message_html mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE attachment_names attachment_names text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE attachment_doc_ids attachment_doc_ids text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE instrument instrument varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_page_hits
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE page_name page_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_pdf_image_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_pdf_snapshots_triggered
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_pdf_snapshots
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_filename_prefix custom_filename_prefix text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE trigger_logic trigger_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Trigger based on logic',
CHANGE selected_forms_events selected_forms_events text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Instruments/events to include in snapshot',
CHANGE pdf_save_to_field pdf_save_to_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_project_checklist
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_project_dashboards_access_dags
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_project_dashboards_access_roles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_project_dashboards_access_users
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_project_dashboards_folders_items
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_project_dashboards_folders
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_project_dashboards
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE body body mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_access user_access enum('ALL','SELECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL',
CHANGE short_url short_url varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE cache_content cache_content longtext COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_projects_external
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE project_id project_id varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Brief user-defined project identifier unique within custom_type',
CHANGE custom_type custom_type varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Brief user-defined name for the resource/category/bucket under which the project falls',
CHANGE app_title app_title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_firstname project_pi_firstname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_mi project_pi_mi varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_lastname project_pi_lastname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_email project_pi_email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_alias project_pi_alias varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pub_matching_institution project_pub_matching_institution text COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_projects_templates
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_projects_user_hidden
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_projects
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE project_name project_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE app_title app_title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE completed_by completed_by varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE log_event_table log_event_table varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'redcap_log_event' COMMENT 'Project redcap_log_event table',
CHANGE data_table data_table varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'redcap_data' COMMENT 'Project redcap_data table',
CHANGE purpose_other purpose_other text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE __SALT__ __SALT__ varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Alphanumeric hash unique to each project',
CHANGE investigators investigators text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_note project_note mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE auth_meth auth_meth varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_language project_language varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'English',
CHANGE project_encoding project_encoding enum('japanese_sjis','chinese_utf8','chinese_utf8_traditional') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Encoding to be used for various exported files',
CHANGE is_child_of is_child_of varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE institution institution text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE site_org_type site_org_type text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE grant_cite grant_cite text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_contact_name project_contact_name text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_contact_email project_contact_email text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE headerlogo headerlogo text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_data_entry_note custom_data_entry_note text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_index_page_note custom_index_page_note text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE order_id_by order_id_by varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_reports custom_reports mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Legacy report builder',
CHANGE report_builder report_builder mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE google_translate_default google_translate_default varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_firstname project_pi_firstname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_mi project_pi_mi varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_lastname project_pi_lastname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_email project_pi_email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_alias project_pi_alias varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pi_username project_pi_username varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_pub_matching_institution project_pub_matching_institution text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_irb_number project_irb_number varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_grant_number project_grant_number varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE secondary_pk secondary_pk varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'field_name of seconary identifier',
CHANGE custom_record_label custom_record_label text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_email_participant_field survey_email_participant_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Field name that stores participant email',
CHANGE survey_phone_participant_field survey_phone_participant_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Field name that stores participant phone number',
CHANGE data_entry_trigger_url data_entry_trigger_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL for sending Post request when a record is created or modified',
CHANGE realtime_webservice_type realtime_webservice_type enum('CUSTOM','FHIR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CUSTOM',
CHANGE realtime_webservice_offset_plusminus realtime_webservice_offset_plusminus enum('+','-','+-') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '+-' COMMENT 'Default value of plus-minus range for days offset',
CHANGE survey_queue_custom_text survey_queue_custom_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_auth_field1 survey_auth_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_auth_field2 survey_auth_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_auth_field3 survey_auth_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_auth_min_fields survey_auth_min_fields enum('1','2','3') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_auth_custom_message survey_auth_custom_message text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE twilio_modules_enabled twilio_modules_enabled enum('SURVEYS','ALERTS','SURVEYS_ALERTS') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SURVEYS',
CHANGE twilio_account_sid twilio_account_sid varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE twilio_auth_token twilio_auth_token varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE twilio_voice_language twilio_voice_language varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
CHANGE twilio_default_delivery_preference twilio_default_delivery_preference enum('EMAIL','VOICE_INITIATE','SMS_INITIATE','SMS_INVITE_MAKE_CALL','SMS_INVITE_RECEIVE_CALL','SMS_INVITE_WEB') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE twilio_multiple_sms_behavior twilio_multiple_sms_behavior enum('OVERWRITE','CHOICE','FIRST') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CHOICE',
CHANGE twilio_delivery_preference_field_map twilio_delivery_preference_field_map varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE mosio_api_key mosio_api_key varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_public_survey_links custom_public_survey_links text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_custom_header_text pdf_custom_header_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_project_footer_text custom_project_footer_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE custom_project_footer_text_link custom_project_footer_text_link varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE missing_data_codes missing_data_codes text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE record_locking_pdf_vault_custom_text record_locking_pdf_vault_custom_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE protected_email_mode_custom_text protected_email_mode_custom_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE protected_email_mode_trigger protected_email_mode_trigger enum('ALL','PIPING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL',
CHANGE sendgrid_project_api_key sendgrid_project_api_key text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_db_character_set project_db_character_set varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE project_db_collation project_db_collation varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_pub_articles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE pub_id pub_id varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'The publication source''s ID for the article (e.g., a PMID in the case of PubMed)',
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE volume volume varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE issue issue varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pages pages varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE journal journal text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE journal_abbrev journal_abbrev varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_pub_authors
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE author author varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_pub_matches
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE external_project_id external_project_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FK 1/2 referencing redcap_projects_external (not explicitly defined as FK to allow redcap_projects_external to be blown away)',
CHANGE external_custom_type external_custom_type varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'FK 2/2 referencing redcap_projects_external (not explicitly defined as FK to allow redcap_projects_external to be blown away)',
CHANGE search_term search_term varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE unique_hash unique_hash varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_pub_mesh_terms
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE mesh_term mesh_term varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX mesh_term,
ADD KEY mesh_term (mesh_term(191));
ALTER TABLE redcap_pub_sources
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE pubsrc_name pubsrc_name varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_queue
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE key key varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE status status enum('waiting','processing','completed','warning','error','canceled') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE message message varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX key_index,
ADD KEY key_index (key(191));
ALTER TABLE redcap_randomization_allocation
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE is_used_by is_used_by varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Used by a record?',
CHANGE target_field target_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field1 source_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field2 source_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field3 source_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field4 source_field4 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field5 source_field5 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field6 source_field6 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field7 source_field7 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field8 source_field8 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field9 source_field9 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field10 source_field10 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field11 source_field11 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field12 source_field12 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field13 source_field13 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field14 source_field14 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value',
CHANGE source_field15 source_field15 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Data value';
ALTER TABLE redcap_randomization
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE group_by group_by enum('DAG','FIELD') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Randomize by group?',
CHANGE target_field target_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field1 source_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field2 source_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field3 source_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field4 source_field4 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field5 source_field5 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field6 source_field6 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field7 source_field7 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field8 source_field8 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field9 source_field9 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field10 source_field10 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field11 source_field11 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field12 source_field12 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field13 source_field13 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field14 source_field14 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE source_field15 source_field15 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_record_counts
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record_list_status record_list_status enum('NOT_STARTED','PROCESSING','COMPLETE','FIX_SORT') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NOT_STARTED';
ALTER TABLE redcap_record_dashboards
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE title title varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE description description text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE filter_logic filter_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orientation orientation enum('V','H') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'H',
CHANGE group_by group_by enum('form','event') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'event',
CHANGE selected_forms_events selected_forms_events text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sort_field_name sort_field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sort_order sort_order enum('ASC','DESC') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ASC';
ALTER TABLE redcap_record_list
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE redcap_reports_access_dags
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_access_roles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_access_users
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_reports_edit_access_dags
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_edit_access_roles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_edit_access_users
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_reports_fields
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE limiter_group_operator limiter_group_operator enum('AND','OR') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE limiter_operator limiter_operator enum('E','NE','GT','GTE','LT','LTE','CHECKED','UNCHECKED','CONTAINS','NOT_CONTAIN','STARTS_WITH','ENDS_WITH') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE limiter_value limiter_value varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_reports_filter_dags
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_filter_events
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_folders_items
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_reports_folders
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE name name varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_reports
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE unique_report_name unique_report_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_access user_access enum('ALL','SELECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL',
CHANGE user_edit_access user_edit_access enum('ALL','SELECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ALL',
CHANGE description description text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_field1 orderby_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_sort1 orderby_sort1 enum('ASC','DESC') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_field2 orderby_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_sort2 orderby_sort2 enum('ASC','DESC') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_field3 orderby_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE orderby_sort3 orderby_sort3 enum('ASC','DESC') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE advanced_logic advanced_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE filter_type filter_type enum('RECORD','EVENT') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EVENT',
CHANGE dynamic_filter1 dynamic_filter1 varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE dynamic_filter2 dynamic_filter2 varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE dynamic_filter3 dynamic_filter3 varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE short_url short_url varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE report_display_header report_display_header enum('LABEL','VARIABLE','BOTH') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BOTH',
CHANGE report_display_data report_display_data enum('LABEL','RAW','BOTH') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BOTH';
ALTER TABLE redcap_sendit_docs
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE doc_name doc_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE doc_orig_name doc_orig_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE doc_type doc_type varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE username username varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX user_id,
ADD KEY user_id (username(191));
ALTER TABLE redcap_sendit_recipients
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE email_address email_address varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE guid guid varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pwd pwd varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX email_address,
ADD KEY email_address (email_address(191));
ALTER TABLE redcap_sessions
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE session_id session_id varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE session_data session_data mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_emails_recipients
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE static_email static_email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static email address of recipient (used when participant has no email)',
CHANGE static_phone static_phone varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static phone number of recipient (used when participant has no phone number)',
CHANGE delivery_type delivery_type enum('EMAIL','VOICE_INITIATE','SMS_INITIATE','SMS_INVITE_MAKE_CALL','SMS_INVITE_RECEIVE_CALL','SMS_INVITE_WEB') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL';
ALTER TABLE redcap_surveys_emails_send_rate
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_surveys_emails
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE email_subject email_subject text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_content email_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_sender_display email_sender_display varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email sender display name',
CHANGE email_account email_account enum('1','2','3') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Sender''s account (1=Primary, 2=Secondary, 3=Tertiary)',
CHANGE email_static email_static varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Sender''s static email address (only for scheduled invitations)',
CHANGE delivery_type delivery_type enum('PARTICIPANT_PREF','EMAIL','VOICE_INITIATE','SMS_INITIATE','SMS_INVITE_MAKE_CALL','SMS_INVITE_RECEIVE_CALL','SMS_INVITE_WEB') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE lang_id lang_id varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_erase_twilio_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE sid sid varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE sid_hash sid_hash varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_login
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_surveys_participants
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE legacy_hash legacy_hash varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Migrated from RS',
CHANGE access_code access_code varchar(9) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE access_code_numeral access_code_numeral varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE participant_email participant_email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'NULL if public survey',
CHANGE participant_identifier participant_identifier varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE participant_phone participant_phone varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE delivery_preference delivery_preference enum('EMAIL','VOICE_INITIATE','SMS_INITIATE','SMS_INVITE_MAKE_CALL','SMS_INVITE_RECEIVE_CALL','SMS_INVITE_WEB') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX participant_email_phone,
ADD KEY participant_email_phone (participant_email(191),participant_phone),
DROP INDEX survey_event_email,
ADD KEY survey_event_email (survey_id,event_id,participant_email(191));
ALTER TABLE redcap_surveys_pdf_archive
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE identifier identifier varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE version version varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE type type varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE ip ip varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_phone_codes
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE phone_number phone_number varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE twilio_number twilio_number varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE access_code access_code varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE session_id session_id varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_queue_hashes
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_surveys_queue
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE condition_andor condition_andor enum('AND','OR') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Include survey complete AND/OR logic',
CHANGE condition_logic condition_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Logic using field values';
ALTER TABLE redcap_surveys_response
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE return_code return_code varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE results_code results_code varchar(8) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_scheduler_queue
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'NULL if record not created yet',
CHANGE status status enum('QUEUED','SENDING','SENT','DID NOT SEND','DELETED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'QUEUED' COMMENT 'Survey invitation status (default=QUEUED)',
CHANGE reason_not_sent reason_not_sent enum('EMAIL ADDRESS NOT FOUND','PHONE NUMBER NOT FOUND','EMAIL ATTEMPT FAILED','UNKNOWN','SURVEY ALREADY COMPLETED','VOICE/SMS SETTING DISABLED','ERROR SENDING SMS','ERROR MAKING VOICE CALL','LINK HAD ALREADY EXPIRED','PARTICIPANT OPTED OUT') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Explanation of why invitation did not send, if applicable';
ALTER TABLE redcap_surveys_scheduler_recurrence
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE record record varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE instrument instrument varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE status status enum('IDLE','QUEUED','SENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'IDLE';
ALTER TABLE redcap_surveys_scheduler
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE instance instance enum('FIRST','AFTER_FIRST') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FIRST' COMMENT 'survey instance being triggered',
CHANGE units_recurrence units_recurrence enum('DAYS','HOURS','MINUTES') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DAYS',
CHANGE email_subject email_subject text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Survey invitation subject',
CHANGE email_content email_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Survey invitation text',
CHANGE email_sender email_sender varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Static email address of sender',
CHANGE email_sender_display email_sender_display varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email sender display name',
CHANGE condition_surveycomplete_instance condition_surveycomplete_instance enum('FIRST','PREVIOUS') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'FIRST' COMMENT 'instance of trigger',
CHANGE condition_andor condition_andor enum('AND','OR') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Include survey complete AND/OR logic',
CHANGE condition_logic condition_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Logic using field values',
CHANGE condition_send_time_option condition_send_time_option enum('IMMEDIATELY','TIME_LAG','NEXT_OCCURRENCE','EXACT_TIME') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'When to send invites after condition is met',
CHANGE condition_send_time_lag_field condition_send_time_lag_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE condition_send_time_lag_field_after condition_send_time_lag_field_after enum('before','after') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'after',
CHANGE condition_send_next_day_type condition_send_next_day_type enum('DAY','WEEKDAY','WEEKENDDAY','SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Wait till specific day/time to send invites after condition is met',
CHANGE delivery_type delivery_type enum('EMAIL','VOICE_INITIATE','SMS_INITIATE','SMS_INVITE_MAKE_CALL','SMS_INVITE_RECEIVE_CALL','PARTICIPANT_PREF','SMS_INVITE_WEB') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'EMAIL',
CHANGE reminder_type reminder_type enum('TIME_LAG','NEXT_OCCURRENCE','EXACT_TIME') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'When to send reminders after original invite is sent',
CHANGE reminder_nextday_type reminder_nextday_type enum('DAY','WEEKDAY','WEEKENDDAY','SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Wait till specific day/time to send reminders';
ALTER TABLE redcap_surveys_short_codes
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE code code varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys_themes
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE theme_name theme_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_buttons theme_text_buttons varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_page theme_bg_page varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_title theme_text_title varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_title theme_bg_title varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_sectionheader theme_text_sectionheader varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_sectionheader theme_bg_sectionheader varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_question theme_text_question varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_question theme_bg_question varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_surveys
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE form_name form_name varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'NULL = assume first form',
CHANGE title title text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Survey title',
CHANGE instructions instructions text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Survey instructions',
CHANGE offline_instructions offline_instructions text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE acknowledgement acknowledgement text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Survey acknowledgement',
CHANGE stop_action_acknowledgement stop_action_acknowledgement text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE end_survey_redirect_url end_survey_redirect_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL to redirect to after completing survey',
CHANGE survey_expiration survey_expiration varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Timestamp when survey expires',
CHANGE confirmation_email_subject confirmation_email_subject text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE confirmation_email_content confirmation_email_content text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE confirmation_email_from confirmation_email_from varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE confirmation_email_from_display confirmation_email_from_display varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Email sender display name',
CHANGE text_to_speech_language text_to_speech_language varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'en',
CHANGE end_survey_redirect_next_survey_logic end_survey_redirect_next_survey_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_buttons theme_text_buttons varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_page theme_bg_page varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_title theme_text_title varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_title theme_bg_title varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_sectionheader theme_text_sectionheader varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_sectionheader theme_bg_sectionheader varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_text_question theme_text_question varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE theme_bg_question theme_bg_question varchar(6) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE repeat_survey_btn_text repeat_survey_btn_text varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE repeat_survey_btn_location repeat_survey_btn_location enum('BEFORE_SUBMIT','AFTER_SUBMIT','HIDDEN') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'BEFORE_SUBMIT',
CHANGE response_limit_custom_text response_limit_custom_text text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE email_participant_field email_participant_field varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_save_to_field pdf_save_to_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_version pdf_econsent_version varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_type pdf_econsent_type varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_firstname_field pdf_econsent_firstname_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_lastname_field pdf_econsent_lastname_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_dob_field pdf_econsent_dob_field varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_signature_field1 pdf_econsent_signature_field1 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_signature_field2 pdf_econsent_signature_field2 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_signature_field3 pdf_econsent_signature_field3 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_signature_field4 pdf_econsent_signature_field4 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE pdf_econsent_signature_field5 pdf_econsent_signature_field5 varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_btn_text_prev_page survey_btn_text_prev_page text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_btn_text_next_page survey_btn_text_next_page text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_btn_text_submit survey_btn_text_submit text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE survey_btn_hide_submit_logic survey_btn_hide_submit_logic text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_todo_list
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE request_to request_to varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE todo_type todo_type varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE action_url action_url text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE status status varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE comment comment text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_twilio_error_log
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE error_message error_message text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_two_factor_response
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE phone_number phone_number varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_user_allowlist
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE redcap_user_information_bck
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_user_information
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_email user_email varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Primary email',
CHANGE user_email2 user_email2 varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Secondary email',
CHANGE user_email3 user_email3 varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tertiary email',
CHANGE user_phone user_phone varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_phone_sms user_phone_sms varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_firstname user_firstname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_lastname user_lastname varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_inst_id user_inst_id varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE user_access_dashboard_email_queued user_access_dashboard_email_queued enum('QUEUED','SENDING') COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tracks status of email reminder for User Access Dashboard',
CHANGE user_sponsor user_sponsor varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Username of user''s sponsor or contact person',
CHANGE user_comments user_comments text COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Miscellaneous comments about user',
CHANGE email_verify_code email_verify_code varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Primary email verification code',
CHANGE email2_verify_code email2_verify_code varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Secondary email verification code',
CHANGE email3_verify_code email3_verify_code varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Tertiary email verification code',
CHANGE datetime_format datetime_format enum('M-D-Y_24','M-D-Y_12','M/D/Y_24','M/D/Y_12','M.D.Y_24','M.D.Y_12','D-M-Y_24','D-M-Y_12','D/M/Y_24','D/M/Y_12','D.M.Y_24','D.M.Y_12','Y-M-D_24','Y-M-D_12','Y/M/D_24','Y/M/D_12','Y.M.D_24','Y.M.D_12') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'M/D/Y_12' COMMENT 'User''s preferred datetime viewing format',
CHANGE number_format_decimal number_format_decimal enum('.',',') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '.' COMMENT 'User''s preferred decimal format',
CHANGE number_format_thousands_sep number_format_thousands_sep enum(',','.','','SPACE','''') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',' COMMENT 'User''s preferred thousands separator',
CHANGE csv_delimiter csv_delimiter enum(',',';','TAB','SPACE','|','^') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT ',',
CHANGE two_factor_auth_secret two_factor_auth_secret varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE api_token api_token varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE messaging_email_preference messaging_email_preference enum('NONE','2_HOURS','4_HOURS','6_HOURS','8_HOURS','12_HOURS','DAILY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '4_HOURS',
CHANGE ui_state ui_state mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
DROP INDEX user_email,
ADD KEY user_email (user_email(191)),
DROP INDEX user_firstname,
ADD KEY user_firstname (user_firstname(191)),
DROP INDEX user_inst_id,
ADD KEY user_inst_id (user_inst_id(191)),
DROP INDEX user_lastname,
ADD KEY user_lastname (user_lastname(191)),
DROP INDEX user_sponsor,
ADD KEY user_sponsor (user_sponsor(191));
ALTER TABLE redcap_user_rights_bck2
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_user_rights_bck
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_user_rights
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE username username varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
CHANGE data_export_instruments data_export_instruments text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_entry data_entry text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE api_token api_token varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE external_module_config external_module_config text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_user_roles
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE role_name role_name varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Name of user role',
CHANGE unique_role_name unique_role_name varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_export_instruments data_export_instruments text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_entry data_entry text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE external_module_config external_module_config text COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_user_whitelist
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
ALTER TABLE redcap_validation_types
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE validation_name validation_name varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Unique name for Data Dictionary',
CHANGE validation_label validation_label varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Label in Online Designer',
CHANGE regex_js regex_js text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE regex_php regex_php text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE data_type data_type enum('date','datetime','datetime_seconds','email','integer','mrn','number','number_comma_decimal','phone','postal_code','ssn','text','time','char') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE legacy_value legacy_value varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_web_service_cache
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE service service varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE category category varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE value value varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
CHANGE label label varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL;
ALTER TABLE redcap_config
CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
CHANGE field_name field_name varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CHANGE value value mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL;

-- Update Connection Encoding to UTF8MB4 --
-- The config for the connection encoding (db_character_set) is set to 3-byte UTF-8 or 'utf8[mb3],' which is a subset of full UTF-8 encoding (utf8mb4).
-- Since no text conversions are needed, update the connection encoding/collation utf8mb4/utf8mb4_unicode_ci at this step to complete the conversion process.
UPDATE redcap_config
SET value = 'utf8mb4'
WHERE field_name = 'db_character_set' AND lower(value) IN ('utf8', 'utf8mb3');
UPDATE redcap_config
SET value = 'utf8mb4_unicode_ci'
WHERE field_name = 'db_collation' AND lower(value) like 'utf8%';
SET FOREIGN_KEY_CHECKS = 1;
``