291b0d15 |
1 | {* file to handle db changes in 5.2.alpha1 during upgrade *} |
055c5fe6 |
2 | # CRM-19885 & https://lab.civicrm.org/dev/core/issues/36#note_3509 |
3 | UPDATE civicrm_action_schedule SET repetition_frequency_interval = 0 WHERE repetition_frequency_interval IS NULL; |
4 | UPDATE civicrm_action_schedule SET start_action_offset = 0 WHERE start_action_offset IS NULL; |
5 | UPDATE civicrm_action_schedule SET end_frequency_interval = 0 WHERE end_frequency_interval IS NULL; |
6 | |
7 | ALTER TABLE civicrm_action_schedule |
8 | ALTER column repetition_frequency_interval SET DEFAULT 0, |
9 | ALTER column start_action_offset SET DEFAULT 0, |
10 | ALTER column end_frequency_interval SET DEFAULT 0; |