The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=1096 ====================================================================== Reported By: jytou Assigned To: ====================================================================== Project: DBMail Issue ID: 1096 Category: installation scripts Reproducibility: always Severity: tweak Priority: normal Status: new target: ====================================================================== Date Submitted: 01-Jul-18 19:03 CEST Last Modified: 01-Jul-18 19:03 CEST ====================================================================== Summary: There is a duplicate FK name that causes install failure in mysql script Description: The file sql/mysql/create_tables.mysql contains: FOREIGN KEY user_idnr_fk (user_idnr) two times, one for dbmail_auto_notifications and one for the next table dbmail_auto_replies. I have renamed the first to user_idnr_fkn and the second to user_idnr_fkr and the create_table script runs fine. As there is no reason those FK names would be used elsewhere, I suppose the fix is straightforward and safe. ======================================================================
Issue History Date Modified Username Field Change ====================================================================== 01-Jul-18 19:03 jytou New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://lists.nfg.nl/mailman/listinfo/dbmail-dev