X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=sql%2Ftrigger.mysql;h=ff95ea22b02e92c168774c3756b41c0cf1828810;hb=0f1428e71dd43dc0b146d18a64aa51cd7ac832da;hp=9c98e3e04a3e6803e88c6aef2d7b45cb74a5dedd;hpb=6a4880350680e1e4d20e5c8a622a791f926ca750;p=civicrm-core.git diff --git a/sql/trigger.mysql b/sql/trigger.mysql index 9c98e3e04a..ff95ea22b0 100644 --- a/sql/trigger.mysql +++ b/sql/trigger.mysql @@ -1,7 +1,7 @@ -- +--------------------------------------------------------------------+ --- | CiviCRM version 3.2 | +-- | CiviCRM version 4.6 | -- +--------------------------------------------------------------------+ --- | Copyright CiviCRM LLC (c) 2004-2010 | +-- | Copyright CiviCRM LLC (c) 2004-2015 | -- +--------------------------------------------------------------------+ -- | This file is a part of CiviCRM. | -- | | @@ -31,12 +31,12 @@ BEGIN -- we delete the corresponding entity_id/entity_table entries -- from all the linked tables (note, log etc) DELETE FROM civicrm_note - WHERE entity_id = OLD.id + WHERE entity_id = OLD.id AND entity_table = 'civicrm_contact'; DELETE FROM civicrm_log WHERE entity_id = OLD.id AND entity_table = 'civicrm_contact'; - DELETE FROM civicrm_task_status + DELETE FROM civicrm_task_status WHERE responsible_entity_id = OLD.id AND responsible_entity_table = 'civicrm_contact';