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

Reply via email to