Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-8248 |
2 | {include file='../CRM/Upgrade/3.4.5.msg_template/civicrm_msg_template.tpl'} | |
3 | ||
4 | -- CRM-8348 | |
5 | ||
6 | CREATE TABLE IF NOT EXISTS civicrm_action_log ( | |
7 | id int UNSIGNED NOT NULL AUTO_INCREMENT, | |
8 | contact_id int UNSIGNED NULL DEFAULT NULL COMMENT 'FK to Contact ID', | |
9 | entity_id int UNSIGNED NOT NULL COMMENT 'FK to id of the entity that the action was performed on. Pseudo - FK.', | |
10 | entity_table varchar(255) COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'name of the entity table for the above id, e.g. civicrm_activity, civicrm_participant', | |
11 | action_schedule_id int UNSIGNED NOT NULL COMMENT 'FK to the action schedule that this action originated from.', | |
12 | action_date_time DATETIME NULL DEFAULT NULL COMMENT 'date time that the action was performed on.', | |
13 | is_error TINYINT( 4 ) NULL DEFAULT '0' COMMENT 'Was there any error sending the reminder?', | |
14 | message TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL COMMENT 'Description / text in case there was an error encountered.', | |
15 | repetition_number INT( 10 ) UNSIGNED NULL COMMENT 'Keeps track of the sequence number of this repetition.', | |
16 | PRIMARY KEY ( id ), | |
17 | CONSTRAINT FK_civicrm_action_log_contact_id FOREIGN KEY (contact_id) REFERENCES civicrm_contact(id) ON DELETE CASCADE, | |
18 | CONSTRAINT FK_civicrm_action_log_action_schedule_id FOREIGN KEY (action_schedule_id) REFERENCES civicrm_action_schedule(id) ON DELETE CASCADE | |
19 | ) ENGINE=InnoDB DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci; | |
20 | ||
21 | -- CRM-8370 | |
22 | ALTER TABLE `civicrm_action_log` CHANGE `repetition_number` `repetition_number` INT( 10 ) UNSIGNED NULL COMMENT 'Keeps track of the sequence number of this repetition.'; | |
23 | ||
24 | -- CRM-8085 | |
25 | UPDATE civicrm_mailing SET domain_id = {$domainID} WHERE domain_id IS NULL; | |
26 | ||
27 | -- CRM-8402, CRM-8679 | |
10824d34 | 28 | DELETE et2.* from civicrm_entity_tag et1 |
6a488035 TO |
29 | INNER JOIN civicrm_entity_tag et2 ON et1.entity_table = et2.entity_table AND et1.entity_id = et2.entity_id AND et1.tag_id = et2.tag_id |
30 | WHERE et1.id < et2.id; | |
31 | ||
10824d34 | 32 | ALTER TABLE civicrm_entity_tag |
6a488035 TO |
33 | DROP INDEX index_entity; |
34 | ||
10824d34 | 35 | ALTER TABLE civicrm_entity_tag |
6a488035 TO |
36 | ADD UNIQUE INDEX UI_entity_id_entity_table_tag_id( entity_table, entity_id, tag_id ); |
37 | ||
38 | -- CRM-8513 | |
39 | ||
40 | SELECT @report_template_gid := MAX(id) FROM civicrm_option_group WHERE name = 'report_template'; | |
41 | ||
42 | {if $multilingual} | |
43 | {foreach from=$locales item=locale} | |
44 | UPDATE civicrm_option_value SET label_{$locale} = 'Pledge Report (Detail)', description_{$locale} = 'Pledge Report' WHERE option_group_id = @report_template_gid AND value = 'pledge/summary'; | |
45 | {/foreach} | |
46 | {else} | |
47 | UPDATE civicrm_option_value SET label = 'Pledge Report (Detail)', description = 'Pledge Report' WHERE option_group_id = @report_template_gid AND value = 'pledge/summary'; | |
48 | {/if} | |
49 | ||
50 | UPDATE civicrm_option_value SET name = 'CRM_Report_Form_Pledge_Detail', value = 'pledge/detail' WHERE option_group_id = @report_template_gid AND value = 'pledge/summary'; | |
51 | ||
52 | UPDATE civicrm_report_instance SET report_id = 'pledge/detail' WHERE report_id = 'pledge/summary'; | |
53 | ||
54 | SELECT @weight := MAX(weight) FROM civicrm_option_value WHERE option_group_id = @report_template_gid; | |
55 | SELECT @pledgeCompId := MAX(id) FROM civicrm_component where name = 'CiviPledge'; | |
56 | INSERT INTO civicrm_option_value | |
57 | (option_group_id, {localize field='label'}label{/localize}, value, name, weight, {localize field='description'}description{/localize}, is_active, component_id) VALUES | |
58 | (@report_template_gid, {localize}'Pledge Summary Report'{/localize}, 'pledge/summary', 'CRM_Report_Form_Pledge_Summary', @weight := @weight + 1, {localize}'Pledge Summary Report.'{/localize}, 1, @pledgeCompId); | |
59 | ||
60 | -- CRM-8519 | |
10824d34 | 61 | UPDATE civicrm_payment_processor |
62 | SET `url_site` = 'https://sec.paymentexpress.com/pxpay/pxpay.aspx' | |
63 | WHERE `url_site` = 'https://www.paymentexpress.com/pxpay/pxpay.aspx' | |
6a488035 TO |
64 | OR url_site = 'https://sec2.paymentexpress.com/pxpay/pxpay.aspx'; |
65 | ||
10824d34 | 66 | UPDATE civicrm_payment_processor |
67 | SET `url_site` = 'https://sec.paymentexpress.com/pxpay/pxaccess.aspx' | |
68 | WHERE `url_site` = 'https://www.paymentexpress.com/pxpay/pxaccess.aspx' | |
6a488035 TO |
69 | OR url_site = 'https://sec2.paymentexpress.com/pxpay/pxpay/pxaccess.aspx'; |
70 | ||
71 | UPDATE civicrm_payment_processor_type | |
72 | SET url_site_default = 'https://sec.paymentexpress.com/pxpay/pxaccess.aspx', | |
10824d34 | 73 | url_site_test_default = 'https://sec.paymentexpress.com/pxpay/pxaccess.aspx' |
6a488035 TO |
74 | WHERE name = 'Payment_Express'; |
75 | ||
76 | ||
77 | -- CRM-8125 | |
78 | SELECT @option_group_id_languages := MAX(id) FROM civicrm_option_group WHERE name = 'languages'; | |
79 | SELECT @languages_max_weight := MAX(weight) FROM civicrm_option_value WHERE option_group_id = @option_group_id_languages; | |
80 | ||
81 | {if $multilingual} | |
82 | {foreach from=$locales item=locale} | |
83 | UPDATE civicrm_option_value SET label_{$locale} = '{ts escape="sql"}Persian (Iran){/ts}' WHERE value = 'fa' AND option_group_id = @option_group_id_languages; | |
84 | {/foreach} | |
85 | {else} | |
86 | UPDATE civicrm_option_value SET label = '{ts escape="sql"}Persian (Iran){/ts}' WHERE value = 'fa' AND option_group_id = @option_group_id_languages; | |
87 | {/if} | |
88 | ||
89 | INSERT INTO civicrm_option_value | |
90 | (option_group_id, is_default, is_active, name, value, {localize field='label'}label{/localize}, weight) | |
91 | VALUES | |
92 | (@option_group_id_languages, 0, 1, 'de_CH', 'de', {localize}'{ts escape="sql"}German (Swiss){/ts}'{/localize}, @weight := @languages_max_weight + 1), | |
93 | (@option_group_id_languages, 0, 1, 'es_PR', 'es', {localize}'{ts escape="sql"}Spanish; Castilian (Puerto Rico){/ts}'{/localize}, @weight := @languages_max_weight + 2); | |
94 | ||
95 | -- CRM-8218, contact dashboard changes | |
96 | {if $alterContactDashboard} | |
97 | ALTER TABLE `civicrm_dashboard` DROP `content`, DROP `created_date`; | |
98 | ALTER TABLE `civicrm_dashboard_contact` ADD `content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL AFTER `weight`, ADD `created_date` DATETIME NULL DEFAULT NULL AFTER `content`; | |
99 | {/if} |