CRM/Upgrade/Incremental/sql/3.4.alpha3.mysql.tpl

   1 -- CRM-7743
   2 SELECT @option_group_id_languages := MAX(id) FROM civicrm_option_group WHERE name = 'languages';
   3 UPDATE civicrm_option_value SET name = 'ce_RU' WHERE value = 'ce' AND option_group_id = @option_group_id_languages;
   4
   5 -- CRM-7750
   6 SELECT @option_group_id_report := MAX(id)     FROM civicrm_option_group WHERE name = 'report_template';
   7 SELECT @weight                 := MAX(weight) FROM civicrm_option_value WHERE option_group_id = @option_group_id_report;
   8 SELECT @contributeCompId       := MAX(id)     FROM civicrm_component    WHERE name = 'CiviContribute';
   9
  10 INSERT INTO civicrm_option_value
  11   (option_group_id, {localize field='label'}label{/localize}, value, name, weight, {localize field='description'}description{/localize}, is_active, component_id)
  12   VALUES
  13   (@option_group_id_report, {localize}'Personal Campaign Page Report'{/localize}, 'contribute/pcp', 'CRM_Report_Form_Contribute_PCP', @weight := @weight + 1, {localize}'Shows Personal Campaign Page Report.'{/localize}, 1, @contributeCompId );
  14
  15 -- CRM-7775
  16 ALTER TABLE `civicrm_activity`
  17 ADD `engagement_level` int(10) unsigned default NULL COMMENT 'Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.';
  18
  19
  20 {if $renameColumnVisibility}
  21  ALTER TABLE `civicrm_mailing` CHANGE `visibilty` `visibility` ENUM( 'User and User Admin Only', 'Public Pages' ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'User and User Admin Only' COMMENT 'In what context(s) is the mailing contents visible (online viewing)';
  22 {/if}
  23
  24 -- CRM-7453
  25  UPDATE `civicrm_navigation`
  26     SET `url` = 'civicrm/activity/email/add&atype=3&action=add&reset=1&context=standalone' WHERE `name` = 'New Email';
  27