Hi all,
maybe an sql expert could give me a hint...
2.6.1 changed the mysql database used for the reputation feature.
There is an new key(msgtime). Here is the relevand diff:
--- opendkim-2.6.0/stats/mkdb.mysql 2012-03-01 00:52:30.000000000 +0100
+++ opendkim-2.6.1/stats/mkdb.mysql 2012-06-25 05:33:43.000000000 +0200
_at_@ -1,6 +1,6 @@
-- $Id: mkdb.mysql,v 1.11 2010/10/25 17:16:00 cm-msk Exp $
--- Copyright (c) 2010, 2011, The OpenDKIM Project. All rights reserved.
+-- Copyright (c) 2010-2012, The OpenDKIM Project. All rights reserved.
-- MySQL command sequence to create a database to accumulate OpenDKIM
-- statistics reports
_at_@ -53,6 +53,7 @@
key(reporter),
key(from_domain),
key(ip),
+ key(msgtime),
unique key(reporter, jobid, msgtime),
foreign key(from_domain) references domains(id) on delete cascade,
foreign key(ip) references ipaddrs(id) on delete cascade,
My question: how do I add that key to an existing database?
Thanks.
--
Viele Grüße
Andreas Schulze
Received on Wed Jun 27 2012 - 11:33:20 PST