> diff --git a/stats/mkdb.mysql b/stats/mkdb.mysql
> index 8c2fd76..a30e269 100644
> --- a/stats/mkdb.mysql
> +++ b/stats/mkdb.mysql
> _at_@ -41,7 +41,7 @@ create table if not exists messages (
> jobid varchar(255) not null,
> reporter int unsigned not null,
> from_domain int unsigned not null,
> - ipaddr varchar(255) not null,
> + ip int unsigned not null,
opendkim/stats.c seems to handle ipv6 but unsigned int isn't big enough.
seems DECIMAL(39) is the only suitable mysql type though.
http://oierud.name/bliki/IPv6AdressesAndMysql.html
Received on Thu Jan 06 2011 - 03:33:17 PST