The following issue has been SUBMITTED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=636 ====================================================================== Reported By: andy Assigned To: ====================================================================== Project: DBMail Issue ID: 636 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: new target: ====================================================================== Date Submitted: 02-Aug-07 17:27 CEST Last Modified: 02-Aug-07 17:27 CEST ====================================================================== Summary: key or unique constraint in table dbmail_sievescripts (mysql/innodb) missing Description: Obviously the dbmail_sievecmd expects and works with the unique constraint (owner_idnr, name).
Anyhow this constraint is missing in the DB create script and it is possible to insert several columns with the same (owner_idnr, name). The behaviour is then inconsistent, because dbmail_sievecmd will drop all those columns and replace by 1. This is right, but there should be never several columns with same (owner_idnr, name). ====================================================================== Issue History Date Modified Username Field Change ====================================================================== 02-Aug-07 17:27 andy New Issue ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
