| 1 | {* file to handle db changes in 4.5.beta9 during upgrade *} |
| 2 | |
| 3 | -- CRM-15211 |
| 4 | UPDATE `civicrm_dashboard` SET `permission` = 'access my cases and activities,access all cases and activities', `permission_operator` = 'OR' WHERE `name` = 'casedashboard'; |
| 5 | |
| 6 | -- CRM-15218 |
| 7 | UPDATE `civicrm_uf_group` SET name = LOWER(name) WHERE name IN ("New_Individual", "New_Organization", "New_Household"); |
| 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'; |
| 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 ); |
| 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 |
| 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; |