Source

iredmail / iRedMail / samples / amavisd.mysql

Diff from to

File iRedMail/samples/amavisd.mysql

   KEY (rid)
 ) ENGINE=InnoDB;
 
+CREATE INDEX msgrcpt_idx_mail_id  ON msgrcpt (mail_id);
+CREATE INDEX msgrcpt_idx_rid      ON msgrcpt (rid);
+
 -- mail quarantine in SQL, enabled by $*_quarantine_method='sql:'
 -- NOTE: records in quarantine without corresponding msgs.mail_id record are
 --  orphaned and should be ignored and eventually deleted by external utilities