Commit | Line | Data |
---|---|---|
b1fa85af | 1 | {* file to handle db changes in 4.5.beta9 during upgrade *} |
2f209434 CW |
2 | |
3 | -- CRM-15211 | |
a27c4bcf | 4 | UPDATE `civicrm_dashboard` SET `permission` = 'access my cases and activities,access all cases and activities', `permission_operator` = 'OR' WHERE `name` = 'casedashboard'; |
2f209434 CW |
5 | |
6 | -- CRM-15218 | |
7 | UPDATE `civicrm_uf_group` SET name = LOWER(name) WHERE name IN ("New_Individual", "New_Organization", "New_Household"); | |
e5a7dd17 CW |
8 | |
9 | -- CRM-15220 | |
10 | UPDATE `civicrm_navigation` SET url = 'civicrm/admin/options/grant_type?reset=1' WHERE url = 'civicrm/admin/options/grant_type&reset=1'; | |
cdf07184 CW |
11 | |
12 | SELECT @parent_id := `id` FROM `civicrm_navigation` WHERE `name` = 'CiviGrant' AND `domain_id` = {$domainID}; | |
13 | INSERT INTO civicrm_navigation | |
14 | ( domain_id, url, label, name, permission, permission_operator, parent_id, is_active, has_separator, weight ) | |
15 | VALUES | |
16 | ( {$domainID}, 'civicrm/admin/options/grant_status?reset=1', '{ts escape="sql" skip="true"}Grant Status{/ts}', 'Grant Status', 'access CiviGrant,administer CiviCRM', 'AND', @parent_id, '1', NULL, 2 ); | |
182228d5 PN |
17 | |
18 | -- CRM-14853 | |
19 | UPDATE civicrm_financial_trxn cft | |
20 | INNER JOIN ( SELECT max(cft.id) trxn_id, ceft.entity_id contribution_id | |
21 | FROM civicrm_financial_trxn cft | |
22 | LEFT JOIN civicrm_entity_financial_trxn ceft ON ceft.financial_trxn_id = cft.id | |
23 | WHERE ceft.entity_table = 'civicrm_contribution' | |
24 | GROUP BY ceft.entity_id ) as temp ON temp.trxn_id = cft.id | |
25 | INNER JOIN civicrm_contribution cc ON cc.id = temp.contribution_id | |
26 | AND cc.payment_instrument_id <> cft.payment_instrument_id | |
f33776d9 | 27 | SET cft.payment_instrument_id = cc.payment_instrument_id; |
28 | ||
29 | --CRM-15086 | |
30 | SELECT @option_group_id_batch_status := id FROM civicrm_option_group WHERE name = 'batch_status'; | |
31 | ||
32 | UPDATE civicrm_option_value SET name = 'Open' WHERE value = 1 AND option_group_id = @option_group_id_batch_status; | |
33 | UPDATE civicrm_option_value SET name = 'Closed' WHERE value = 2 AND option_group_id = @option_group_id_batch_status; | |
34 | UPDATE civicrm_option_value SET name = 'Data Entry' WHERE value = 3 AND option_group_id = @option_group_id_batch_status; | |
35 | UPDATE civicrm_option_value SET name = 'Reopened' WHERE value = 4 AND option_group_id = @option_group_id_batch_status; | |
36 | UPDATE civicrm_option_value SET name = 'Exported' WHERE value = 5 AND option_group_id = @option_group_id_batch_status; |