text: /*
   * Your installation or use of this SugarCRM file is subject to the applicable
   * terms available at
   * http://support.sugarcrm.com/Resources/Master_Subscription_Agreements/.
   * If you do not agree to all of the applicable terms or do not have the
   * authority to bind the entity as an authorized representative, then do not
   * install or use this SugarCRM file.
   *
   * Copyright (C) SugarCRM Inc. All rights reserved.
   */
  
  UPDATE calls m SET m.parent_id = NULL WHERE m.parent_type = 'KBContents' AND m.parent_id in (SELECT id FROM kbcontents s WHERE s.deleted = 1);
  UPDATE tasks m SET m.parent_id = NULL WHERE m.parent_type = 'KBContents' AND m.parent_id in (SELECT id FROM kbcontents s WHERE s.deleted = 1);
  UPDATE meetings m SET m.parent_id = NULL WHERE m.parent_type = 'KBContents' AND m.parent_id in (SELECT id FROM kbcontents s WHERE s.deleted = 1);
  