Commit | Line | Data |
---|---|---|
6a488035 TO |
1 | -- CRM-5333 |
2 | -- Delete duplicate records in target and assignment exists if any | |
10824d34 | 3 | |
4 | DELETE cat.* FROM civicrm_activity_target cat | |
5 | INNER JOIN ( SELECT id, activity_id, target_contact_id | |
6 | FROM civicrm_activity_target | |
7 | GROUP BY activity_id, target_contact_id HAVING count(*) > 1 ) dup_cat | |
8 | ON ( cat.activity_id = dup_cat.activity_id | |
9 | AND cat.target_contact_id = dup_cat.target_contact_id | |
6a488035 TO |
10 | AND cat.id <> dup_cat.id ); |
11 | ||
10824d34 | 12 | DELETE caa.* FROM civicrm_activity_assignment caa |
13 | INNER JOIN ( SELECT id, activity_id, assignee_contact_id | |
14 | FROM civicrm_activity_assignment | |
15 | GROUP BY activity_id, assignee_contact_id HAVING count(*) > 1 ) dup_caa | |
16 | ON ( caa.activity_id = dup_caa.activity_id | |
17 | AND caa.assignee_contact_id = dup_caa.assignee_contact_id | |
6a488035 TO |
18 | AND caa.id <> dup_caa.id ); |
19 | ||
20 | -- Drop unique indexes of activity_target and activity_assignment | |
21 | ||
10824d34 | 22 | ALTER TABLE civicrm_activity_assignment |
6a488035 TO |
23 | DROP INDEX `UI_activity_assignee_contact_id` , |
24 | ADD UNIQUE INDEX `UI_activity_assignee_contact_id` (`assignee_contact_id`,`activity_id`); | |
25 | ||
10824d34 | 26 | ALTER TABLE civicrm_activity_target |
6a488035 TO |
27 | DROP INDEX `UI_activity_target_contact_id` , |
28 | ADD UNIQUE INDEX `UI_activity_target_contact_id` (`target_contact_id`,`activity_id`); | |
29 | ||
30 | ||
31 | -- CRM-5437 | |
32 | UPDATE civicrm_participant_status_type SET class = 'Pending' WHERE class NOT IN ('Positive', 'Pending', 'Waiting', 'Negative'); | |
33 | ||
34 | -- CRM-5451 | |
35 | ALTER TABLE `civicrm_custom_group` | |
36 | DROP FOREIGN KEY `FK_civicrm_custom_group_created_id`; | |
37 | ||
38 | ALTER TABLE `civicrm_custom_group` | |
39 | ADD CONSTRAINT `FK_civicrm_custom_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; | |
40 | ||
41 | ALTER TABLE `civicrm_event` | |
42 | DROP FOREIGN KEY `FK_civicrm_event_created_id`; | |
43 | ||
44 | ALTER TABLE `civicrm_event` | |
45 | ADD CONSTRAINT `FK_civicrm_event_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; | |
46 | ||
47 | ALTER TABLE `civicrm_contribution_page` | |
48 | DROP FOREIGN KEY `FK_civicrm_contribution_page_created_id`; | |
49 | ||
50 | ALTER TABLE `civicrm_contribution_page` | |
51 | ADD CONSTRAINT `FK_civicrm_contribution_page_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; | |
52 | ||
53 | ALTER TABLE `civicrm_uf_group` | |
54 | DROP FOREIGN KEY `FK_civicrm_uf_group_created_id`; | |
55 | ||
56 | ALTER TABLE `civicrm_uf_group` | |
57 | ADD CONSTRAINT `FK_civicrm_uf_group_created_id` FOREIGN KEY (`created_id`) REFERENCES `civicrm_contact` (`id`) ON DELETE SET NULL; | |
58 | ||
59 | -- CRM-5471 | |
60 | UPDATE civicrm_mailing_bounce_pattern | |
61 | SET pattern = 'delivery to the following recipient(s)? failed' | |
62 | WHERE pattern = 'delivery to the following recipients failed'; | |
63 | ||
64 | UPDATE civicrm_navigation SET permission ='access CiviCRM', permission_operator ='' WHERE civicrm_navigation.name= 'Manage Groups'; |