Daniel,
> The wblist table uses numeric references to another table for lookups:
>
> mysql> describe wblist
> | Field | Type | Null | Key | Default | Extra |
> | rid | int(10) unsigned | NO | PRI | NULL | |
> | sid | int(10) unsigned | NO | PRI | NULL | |
> | wb | varchar(10) | NO | | NULL | |
>
> If rid and sid don't refer to maddr, to what table do they refer?
They refer to mailaddr.id, unless you changed the
$sql_select_white_black_list from its default:
$sql_select_white_black_list =
'SELECT wb FROM wblist JOIN mailaddr ON wblist.sid=mailaddr.id'.
' WHERE wblist.rid=? AND mailaddr.email IN (%k)'.
' ORDER BY mailaddr.priority DESC';
Mark
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
AMaViS-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/amavis-user
Please visit http://www.ijs.si/software/amavisd/ regularly
For administrativa requests please send email to rainer at openantivirus dot
org
