Commit | Line | Data |
---|---|---|
6a488035 TO |
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'; | |
10824d34 | 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`) | |
6a488035 TO |
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` | |
10824d34 | 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.'; |
6a488035 TO |
29 | |
30 | ALTER TABLE `civicrm_product` | |
10824d34 | 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.'; |
6a488035 TO |
32 | |
33 | ALTER TABLE `civicrm_contribution_soft` | |
10824d34 | 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.'; |
6a488035 TO |
35 | |
36 | ALTER TABLE `civicrm_contribution_page` | |
10824d34 | 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.'; |
6a488035 TO |
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; |