diff options
author | Mrten <bugzilla@ii.nl> | 2018-06-01 12:39:50 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-06-01 12:39:50 +0300 |
commit | eb720079892f2e6ccdc40e8855dadf7ec81734f4 (patch) | |
tree | 4573b6b142874c2a90fc665074d1a675305819a1 /dmarcts-report-parser.pl | |
parent | f94087bcc6d371d78b89263a23292a61c276adf7 (diff) |
Don't create as MyISAM, add primary key
InnoDB would otherwise create an implicit primary key which is slow.
Diffstat (limited to 'dmarcts-report-parser.pl')
-rwxr-xr-x | dmarcts-report-parser.pl | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/dmarcts-report-parser.pl b/dmarcts-report-parser.pl index 139d506..2b3e2a8 100755 --- a/dmarcts-report-parser.pl +++ b/dmarcts-report-parser.pl @@ -786,6 +786,7 @@ sub checkDatabase { }, "rptrecord" =>{ column_definitions => [ + "id" , "int(10) unsigned NOT NULL AUTO_INCREMENT", "serial" , "int(10) unsigned NOT NULL", "ip" , "int(10) unsigned", "ip6" , "binary(16)", @@ -800,8 +801,8 @@ sub checkDatabase { "dkim_align" , "enum('fail','pass','unknown') NOT NULL", "identifier_hfrom" , "varchar(255)", ], - additional_definitions => "KEY serial (serial,ip), KEY serial6 (serial,ip6)", - table_options => "ENGINE=MyISAM", + additional_definitions => "PRIMARY KEY (id), KEY serial (serial,ip), KEY serial6 (serial,ip6)", + table_options => "", }, ); |