[opendmarc-users] Bug in opendmarc-expire script

[Murray S. Kucherawy]

On Thu, 9 Aug 2012, Todd Lyons wrote:
>> There should be an index on the field that is being used in the WHERE:
>> ALTER TABLE `requests` ADD KEY `lastsent_idx` (`lastsent`);
>
> Added two more indexes to fix the same issue:
> ALTER TABLE messages ADD KEY `date_idx`(`date`);
> ALTER TABLE `signatures` ADD KEY `message_idx`(`message`);

Good points, thanks!  Added to db/schema.mysql for next release.

-MSK