CRM/Upgrade/Incremental/sql/5.2.alpha1.mysql.tpl

   1 {* file to handle db changes in 5.2.alpha1 during upgrade *}
   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;