The following issue has been ACKNOWLEDGED. 
====================================================================== 
http://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:                     acknowledged
target:                      
====================================================================== 
Date Submitted:             02-Aug-07 17:27 CEST
Last Modified:              09-Aug-07 08:20 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).
====================================================================== 

---------------------------------------------------------------------- 
 aaron - 02-Aug-07 20:52  
---------------------------------------------------------------------- 
Good point, thanks. I'm going to assign this bug toward 2.3 development. 

Issue History 
Date Modified   Username       Field                    Change               
====================================================================== 
02-Aug-07 17:27 andy           New Issue                                    
02-Aug-07 20:52 aaron          Note Added: 0002317                          
09-Aug-07 08:20 aaron          Status                   new => acknowledged 
======================================================================

_______________________________________________
Dbmail-dev mailing list
[email protected]
http://twister.fastxs.net/mailman/listinfo/dbmail-dev

Reply via email to