-- Migration 027: Make lead_id nullable in tasks so admin can create tasks without assigning a lead
ALTER TABLE tasks DROP FOREIGN KEY tasks_ibfk_1;
ALTER TABLE tasks MODIFY COLUMN lead_id INT NULL;
ALTER TABLE tasks ADD CONSTRAINT tasks_lead_id_fk FOREIGN KEY (lead_id) REFERENCES leads(id) ON DELETE SET NULL;
