Determine DB Upgrades Required
Changes we need to make to use the latest OSCAR
Here is a summary of the changes, I will prepare a patch file.
Tables to add
- consultdocs
- fileUploadCheck
- formGrowth0_36
- formRourke2006
- log_letters
- report_letters
- scratch_pad
- table_modification
Columns to add
- table:document, columns: contenttype,public,observationdate
- table:scheduletemplatecode, columns: confirm
Indexes to add
- table is eform_data
- idx_eform_data_demographic_no
- idx_eform_data_status
- idx_eform_data_from_date
- idx_eform_data_form_name
- idx_eform_data_subject
- idx_eform_data_fid
- idx_eform_data_form_provider
Columns to change
- table:batcheligibility, column: reason
- table:formLabReq, column: phoneNumber
- table:measurementGroup, column: typeDisplayName
Changes we need to commit to OSCAR
add the new_tickler_warning_window column to preference table
