Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Cannot Reproduce
-
Affects Version/s: 3.3.1
-
Fix Version/s: 3.3.2
-
Component/s: Core CiviCRM
-
Labels:None
Description
Check CRM/Upgrade/Incremental/sql/3.3.alpha1.mysql.tpl
ALTER TABLE civicrm_mailing_job ADD CONSTRAINT parent_id FOREIGN KEY (parent_id) REFERENCES civicrm_mailing_job (id);
should be
ALTER TABLE civicrm_mailing_job ADD CONSTRAINT FK_civicrm_mailing_job_parent_id FOREIGN KEY (parent_id) REFERENCES civicrm_mailing_job (id) ON DELETE CASCADE;
Drop and create new FK contraint and add missing DELETE contraint