1
-- $Id: mkdb.mysql,v 1.2 2010/05/20 18:39:10 cm-msk Exp $
3
-- MySQL command sequence to create a database to accumulate OpenDKIM
6
create table opendkim_statistics (
7
id int unsigned not null auto_increment,
9
jobid varchar(255) not null,
11
from_domain varchar(255) not null,
13
ipaddr varchar(255) not null,
15
msgtime timestamp not null,
16
algorithm int unsigned not null,
17
hdr_canon int unsigned not null,
18
body_canon int unsigned not null,
19
sigs_total int unsigned not null,
20
sigs_pass int unsigned not null,
21
sigs_fail int unsigned not null,
22
sigs_fail_body int unsigned not null,
23
extended int unsigned not null,
24
key_t int unsigned not null,
25
key_g int unsigned not null,
26
key_syntax int unsigned not null,
27
key_nx int unsigned not null,
28
sig_t int unsigned not null,
29
sig_t_future int unsigned not null,
30
sig_x int unsigned not null,
31
sig_l int unsigned not null,
32
sig_z int unsigned not null,
33
adsp int unsigned not null,
34
adsp_fail int unsigned not null,
35
adsp_discardable int unsigned not null,
36
author_sigs int unsigned not null,
37
author_sigs_fail int unsigned not null,
38
tp_sigs int unsigned not null,
39
tp_sigs_fail int unsigned not null,
40
mailing_list int unsigned not null
41
) default charset=latin1;