CRM/Upgrade/Incremental/sql/4.6.beta3.mysql.tpl

   1 {* file to handle db changes in 4.6.beta3 during upgrade *}
   2
   3 {*--CRM-15979 - differentiate between standalone mailings, A/B tests, and A/B final-winner *}
   4 ALTER TABLE  `civicrm_mailing` ADD mailing_type varchar(32) CHARACTER SET utf8 COLLATE utf8_unicode_ci COMMENT  'differentiate between standalone mailings, A/B tests, and A/B final-winner';
   5
   6 UPDATE `civicrm_mailing`cm
   7 LEFT JOIN civicrm_mailing_abtest ab
   8 ON cm.id = ab.mailing_id_a
   9   OR cm.id = ab.mailing_id_b
  10   OR cm.id = ab.mailing_id_c
  11   SET `mailing_type` = CASE
  12     WHEN cm.id IN (ab.mailing_id_a,ab.mailing_id_b) THEN 'experiment'
  13     WHEN cm.id IN (ab.mailing_id_c) THEN 'winner'
  14     ELSE 'standalone'
  15   END
  16 WHERE cm.id IS NOT NULL;