CRM/Upgrade/Incremental/sql/3.3.beta2.mysql.tpl

   1 -- CRM-6902, update system workflow message templates
   2 {include file='../CRM/Upgrade/3.3.beta2.msg_template/civicrm_msg_template.tpl'}
   3
   4 -- CRM-6410, Create CiviMail Reports
   5 SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template';
   6 SELECT @mailCompId := max(id) FROM civicrm_component where name = 'CiviMail';
   7 INSERT INTO
   8    `civicrm_option_value` (`option_group_id`, {localize field='label'}label{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, {localize field='description'}description{/localize}, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`)
   9 VALUES
  10   (@option_group_id_report, {localize}'{ts escape="sql"}Mail Bounce Report{/ts}'{/localize}, 'Mailing/bounce', 'CRM_Report_Form_Mailing_Bounce', NULL, 0, NULL, 34, {localize}'{ts escape="sql"}Bounce Report for mailings{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
  11   (@option_group_id_report, {localize}'{ts escape="sql"}Mail Summary Report{/ts}'{/localize}, 'Mailing/summary', 'CRM_Report_Form_Mailing_Summary', NULL, 0, NULL, 35, {localize}'{ts escape="sql"}Summary statistics for mailings{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
  12   (@option_group_id_report, {localize}'{ts escape="sql"}Mail Opened Report{/ts}'{/localize}, 'Mailing/opened', 'CRM_Report_Form_Mailing_Opened', NULL, 0, NULL, 36, {localize}'{ts escape="sql"}Display contacts who opened emails from a mailing{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL),
  13   (@option_group_id_report, {localize}'{ts escape="sql"}Mail Clickthrough Report{/ts}'{/localize}, 'Mailing/clicks', 'CRM_Report_Form_Mailing_Clicks', NULL, 0, NULL, 37, {localize}'{ts escape="sql"}Display clicks from each mailing{/ts}'{/localize}, 0, 0, 1, @mailCompId, NULL);
  14
  15
  16 -- CRM-7031
  17
  18 ALTER TABLE `civicrm_entity_financial_trxn`
  19      CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  20
  21 ALTER TABLE `civicrm_financial_trxn`
  22      CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  23
  24 ALTER TABLE `civicrm_pledge_payment`
  25      CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  26
  27 ALTER TABLE `civicrm_contribution_recur`
  28     CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  29
  30 ALTER TABLE `civicrm_product`
  31     CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  32
  33 ALTER TABLE `civicrm_contribution_soft`
  34     CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  35
  36 ALTER TABLE `civicrm_contribution_page`
  37     CHANGE `currency` `currency` VARCHAR( 3 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT '3 character string, value from config setting or input via user.';
  38
  39 -- CRM-7088
  40 UPDATE  civicrm_navigation
  41    SET  label  = 'GOTV (Voter Tracking)'
  42  WHERE  name like 'Voter Listing';
  43
  44 --CRM-7067
  45 ALTER TABLE `civicrm_participant`
  46    DROP FOREIGN KEY `FK_civicrm_participant_registered_by_id`;
  47 ALTER TABLE `civicrm_participant`
  48     ADD CONSTRAINT `FK_civicrm_participant_registered_by_id` FOREIGN KEY (`registered_by_id`) REFERENCES `civicrm_participant` (`id`) ON DELETE SET NULL;