| 1 | -- Fix invalid api actions in Job table and insert missing job |
| 2 | UPDATE `civicrm_job` |
| 3 | SET api_action = 'process_membership_reminder_date' WHERE api_action = 'process_process_membership_reminder_date'; |
| 4 | UPDATE `civicrm_job` |
| 5 | SET api_action = 'mail_report' WHERE api_action = 'mail_reports'; |
| 6 | |
| 7 | SELECT @domainID := min(id) FROM civicrm_domain; |
| 8 | INSERT INTO `civicrm_job` |
| 9 | ( domain_id, run_frequency, last_run, name, description, api_prefix, api_entity, api_action, parameters, is_active ) |
| 10 | VALUES |
| 11 | ( @domainID, 'Always' , NULL, '{ts escape="sql" skip="true"}Process Survey Respondents{/ts}', '{ts escape="sql" skip="true"}Releases reserved survey respondents when they have been reserved for longer than the Release Frequency days specified for that survey.{/ts}','civicrm_api3', 'job', 'process_respondent','version=3\r\n', 0); |
| 12 | |
| 13 | -- Job table was initially delivered with invalid and not-used parameters. Clearing them out. Most jobs do not need any parameters. |
| 14 | UPDATE `civicrm_job` |
| 15 | SET parameters = NULL; |
| 16 | |
| 17 | -- Insert Schedule Jobs admin menu item |
| 18 | SELECT @systemSettingsID := id FROM civicrm_navigation where name = 'System Settings' AND domain_id = @domainID; |
| 19 | |
| 20 | INSERT INTO civicrm_navigation |
| 21 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) |
| 22 | VALUES |
| 23 | ( @domainID, 'civicrm/admin/job&reset=1', '{ts escape="sql" skip="true"}Scheduled Jobs{/ts}', 'Scheduled Jobs', 'administer CiviCRM', '', @systemSettingsID, '1', NULL, 15 ); |
| 24 | |
| 25 | -- CRM-9468 |
| 26 | -- update Serbia/Montenegro provinces |
| 27 | UPDATE civicrm_state_province SET country_id = 1243 WHERE id = 5112; |
| 28 | UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5113; |
| 29 | UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5114; |
| 30 | UPDATE civicrm_state_province SET country_id = 1242 WHERE id = 5115; |
| 31 | |
| 32 | -- CRM-9523 |
| 33 | ALTER TABLE `civicrm_note` MODIFY `privacy` VARCHAR(255) COMMENT 'Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)'; |