CRM/Upgrade/Incremental/sql/3.0.3.mysql.tpl

   1  -- CRM-5333
   2  -- Delete duplicate records in target and assignment exists if any
   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
  10                            AND cat.id <> dup_cat.id );
  11
  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
  18                            AND caa.id <> dup_caa.id );
  19
  20  -- Drop unique indexes of activity_target and activity_assignment
  21
  22   ALTER TABLE  civicrm_activity_assignment
  23   DROP INDEX `UI_activity_assignee_contact_id` ,
  24   ADD UNIQUE INDEX `UI_activity_assignee_contact_id` (`assignee_contact_id`,`activity_id`);
  25
  26   ALTER TABLE  civicrm_activity_target
  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';