Commit | Line | Data |
---|---|---|
f2720c51 | 1 | {* file to handle db changes in 4.7.beta1 during upgrade *} |
7a2916e4 | 2 | |
95974e8e DG |
3 | -- CRM-16901 Recurring contributions summary report template |
4 | SELECT @option_group_id_report := max(id) from civicrm_option_group where name = 'report_template'; | |
5 | SELECT @contributeCompId := max(id) FROM civicrm_component where name = 'CiviContribute'; | |
6 | INSERT INTO | |
3197dd01 | 7 | `civicrm_option_value` (`option_group_id`, {localize field='label'}`label`{/localize}, `value`, `name`, `grouping`, `filter`, `is_default`, `weight`, `description`, `is_optgroup`, `is_reserved`, `is_active`, `component_id`, `visibility_id`) |
95974e8e DG |
8 | VALUES |
9 | (@option_group_id_report, {localize}'{ts escape="sql"}Recurring Contributions Summary{/ts}'{/localize}, 'contribute/recursummary', 'CRM_Report_Form_Contribute_RecurSummary', NULL, 0, NULL, 49, {localize}'{ts escape="sql"}Provides simple summary for each payment instrument for which there are recurring contributions (e.g. Credit Card, Standing Order, Direct Debit etc.), showing within a given date range.{/ts}'{/localize}, 0, 0, 1, @contributeCompId, NULL); | |
10 | ||
7a2916e4 CW |
11 | SELECT @parent_id := id from `civicrm_navigation` where name = 'Administration Console' AND domain_id = {$domainID}; |
12 | INSERT INTO civicrm_navigation | |
13 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
14 | VALUES | |
c1c370a7 KB |
15 | ( {$domainID}, 'civicrm/a/#/status', '{ts escape="sql" skip="true"}System Status{/ts}', 'System Status', 'administer CiviCRM', '', @parent_id, '1', NULL, 0 ); |
16 | ||
0982ca95 DG |
17 | UPDATE civicrm_contact SET is_deceased = 0 WHERE is_deceased IS NULL; |
18 | ||
5002e6c1 | 19 | -- CRM-16597 |
20 | UPDATE civicrm_option_value | |
21 | SET label_{$locale} = '{ts escape="sql"}Pledge Detail Report{/ts}', description_{$locale} = '{ts escape="sql"}List of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.{/ts}' | |
22 | WHERE option_group_id = @option_group_id_report AND name = 'CRM_Report_Form_Pledge_Detail'; | |
23 | ||
24 | UPDATE civicrm_option_value | |
25 | SET description_{$locale} = '{ts escape="sql"}Groups and totals pledges by criteria including contact, time period, pledge status, location, etc.{/ts}' | |
26 | WHERE option_group_id = @option_group_id_report AND name = 'CRM_Report_Form_Pledge_Summary'; | |
27 | ||
28 | UPDATE civicrm_report_instance | |
29 | SET title = '{ts escape="sql"}Pledge Detail{/ts}', description_{$locale} = '{ts escape="sql"}List of pledges including amount pledged, pledge status, next payment date, balance due, total amount paid etc.{/ts}' | |
30 | WHERE report_id = 'pledge/detail'; | |
31 | ||
0982ca95 DG |
32 | -- CRM-17503 PayPal Express processor type can support recurring payments |
33 | UPDATE civicrm_payment_processor_type pp | |
34 | LEFT JOIN civicrm_payment_processor p ON p.payment_processor_type_id = pp.id | |
35 | SET pp.is_recur = 1, p.is_recur = 1 | |
c50ec08e CW |
36 | WHERE pp.name='PayPal_Express'; |
37 | ||
b3114a81 | 38 | UPDATE civicrm_preferences_date SET description = '{ts escape="sql"}Used in search forms and for relationships.{/ts}' |
c50ec08e | 39 | WHERE name = 'searchDate'; |
7dbb67ae DG |
40 | |
41 | --CRM-16761 Self service cancel or transfer for events | |
42 | ALTER TABLE civicrm_event | |
43 | ADD COLUMN selfcancelxfer_time INT(10) unsigned DEFAULT 0 COMMENT 'Number of hours prior to event start date to allow self-service cancellation or transfer.', | |
44 | ADD COLUMN allow_selfcancelxfer TINYINT(4) DEFAULT '0' COMMENT 'Allow self service cancellation or transfer for event?'; | |
45 | ALTER TABLE civicrm_participant | |
46 | ADD COLUMN transferred_to_contact_id INT(10) unsigned DEFAULT NULL COMMENT 'Contact to which the event registration is transferred', | |
47 | ADD CONSTRAINT `FK_civicrm_participant_transferred_to_contact_id` FOREIGN KEY (`transferred_to_contact_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; | |
48 | ||
49 | INSERT INTO civicrm_participant_status_type(name, {localize field='label'}label{/localize}, class, is_reserved, is_active, is_counted, weight, visibility_id) | |
4f715c48 | 50 | VALUES ('Transferred', {localize}'{ts escape="sql"}Transferred{/ts}'{/localize}, 'Negative', 1, 1, 0, 16, 2); |
adaa01fa DG |
51 | |
52 | {include file='../CRM/Upgrade/4.7.beta1.msg_template/civicrm_msg_template.tpl'} |