Manitou-Mail Home

9.  Table: filter_log

Log filter hits. An entry is inserted in this table each time manitou-mdx applies a set of actions given by the filter_expr and filter_action tables. A message may have several entries if several filters have been applied to it but the (mail_id,expr_id) combination should be unique.

The filter logs can be displayed in the user interface.

Structure of filter_log

expr_id

integer

The reference to the expression. It is intentional that there is no foreign key to the filter_expr table, to avoid having to delete entries in the logs when the associated filter is removed.

mail_id

integer

The reference to the message. It is intentional that there is no foreign key to the mail table, to avoid having to delete entries in the logs when the associated message is removed.

hit_date

timestamp with time zone

The date and time when the filter has been applied.

DEFAULT now()