Improve 'downloads' and 'virustotals' tables

[mcantoni]

ISSUE TYPE

• Feature

DIONAEA VERSION

master

OS / ENVIRONMENT

Ubuntu 16.04.4 LTS

SUMMARY

Improve logging support. Add some info to 'downloads' and 'virustotals' tables:

download_timestamp

virustotal_sha1_hash
virustotal_sha256_hash
virustotal_positives
virustotal_total

sqlite> PRAGMA table_info(downloads);
0|download|INTEGER|0||1
1|connection|INTEGER|0||0
2|download_url|TEXT|0||0
3|download_md5_hash|TEXT|0||0
4|download_timestamp|INTEGER|0||0

sqlite> PRAGMA table_info(virustotals);
0|virustotal|INTEGER|0||1
1|virustotal_md5_hash|TEXT|1||0
2|virustotal_sha1_hash|TEXT|1||0
3|virustotal_sha256_hash|TEXT|1||0
4|virustotal_positives|INTEGER|1||0
5|virustotal_total|INTEGER|1||0
6|virustotal_timestamp|INTEGER|1||0
7|virustotal_permalink|TEXT|1||0

[phibos]

Thanks for your work but I think there should be an ALTER command to migrate existing tables to the new format. What do you think?

[mcantoni]

You are right, a new solution: https://github.com/DinoTools/dionaea/pull/153/commits/ab43f158419f8395212113cf155ec345c67338b3