Domains missing after updating to 1.7.4 from 1.6.2 incrementally

Hi,

I recently updated to 1.7.4 from 1.6.2 (going to 1.7.0 first), and running the required migrations. It seems that all of my projects no longer show their CNAME'd domains in the console, and I can no longer use those domains as API endpoints, but when I try to add them again, it says they are already in use. Is there a simple way for me to force remove the domains so I can re-add them?

I've been able to resolve by running these queries and re-adding:

DELETE FROM _console_abuse        WHERE key    = 'backend.*.app';
DELETE FROM _console_certificates WHERE domain = 'backend.*.app';
DELETE FROM _console_rules        WHERE domain = 'backend.*.app';
DELETE FROM _console_rules        WHERE search = 'backend.*.app';