ALTER TABLE tasks
  ADD COLUMN created_by_employee_id INT NULL AFTER assignee_id,
  ADD KEY idx_tasks_open_creator (is_open_task, created_by_employee_id);

UPDATE tasks
SET created_by_employee_id = assignee_id
WHERE is_open_task = 1 AND created_by_employee_id IS NULL AND assignee_id IS NOT NULL;