What we need to solve this properly is an additional dbconfig schema migration that cleanly updates the previous database schema to the new one. The migration script would have to be patched in and installed to /usr/share/dbconfig-common/data/opendmarc/upgrade/mysql/1.4.0~beta1+dfsg-1. It must also take into account our Debian patches in this area.
I think it is important to have this for a seamless upgrade experience, however it is non-trivial work and needs to be written from scratch. This work is perhaps best contributed by someone who uses the reporting feature and who can test the migration properly and with real data. I don’t use this feature and won’t be looking into it further. -- David
