message: chore: add cleanup migration for project data
diff: @@ -1737,6 +1737,16 @@ CREATE OR REPLACE PROCEDURE
  END;
  $$
  +CREATE OR REPLACE PROCEDURE
  + clean_stale_project_data()
  +
  + BEGIN
  + DELETE FROM env_vars WHERE project NOT IN (SELECT id FROM project);
  + DELETE FROM project_notification WHERE pid NOT IN (SELECT id FROM project);
  + DELETE FROM deploy_target_config WHERE project NOT IN (SELECT id FROM project);
  + END;
  +$$
  +
  DELIMITER ;
  -- If adding new procedures, add them to the bottom of this list
  @@ -1826,6 +1836,7 @@ CALL add_new_task_status_types();
  CALL update_active_succeeded_tasks();
  CALL update_missing_tasknames();
  CALL add_build_image_to_openshift();
  +CALL clean_stale_project_data();
  -- Drop legacy SSH key procedures
  DROP PROCEDURE IF EXISTS CreateProjectSshKey;
  