Cannot delete Certificate Authority due to Android cert templates

[getvictor]

Fleet version:
4.78.0
Web browser and operating system:

---

💥  Actual behavior

method=DELETE uri=/api/latest/fleet/certificate_authorities/1 took=3.322042ms err="deleting certificate authority with id 1: Error 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`fleet`.`certificate_templates`, CONSTRAINT `certificate_templates_ibfk_2` FOREIGN KEY (`certificate_authority_id`) REFERENCES `certificate_authorities` (`id`))"

Note: deleting the CA should not delete the certs already installed on Android devices.

🛠️ To fix

TODO

🧑‍💻  Steps to reproduce

These steps:

• Have been confirmed to consistently lead to reproduction in multiple Fleet instances.
• Describe the workflow that led to the error, but have not yet been reproduced in multiple Fleet instances.

1. TODO
2. TODO

🕯️ More info (optional)

N/A

[rachaelshaw]

Closing as duplicate of #38036

[fleet-release]

Android certs in cloud,
Delete, yet remain unbowed;
Fleet shines, firm and proud.