certtools / intelmq

IntelMQ is a solution for IT security teams for collecting and processing security feeds using a message queuing protocol.
https://docs.intelmq.org/latest/
GNU Affero General Public License v3.0
977 stars 296 forks source link

PostgreSQL Init DB #44

Closed SYNchroACK closed 10 years ago

SYNchroACK commented 10 years ago

The file 'initdb.sql' should be generate autocatically from 'docs/DataHarmonization-table.md'.

Reason: if we need to add/change/remove a specific field in Data Harmonization is it ok because the procedure will parse autocatically DataHarmonization with new field and with that, we dont need to change in all bots that depend on this.

aaronkaplan commented 10 years ago

well, we nee to start writing down things then in docs/DataHarmonization-table.md so that it can be generated automatically ;-) Currently this file is not suitable for automatic generation of other text IMHO.

SYNchroACK commented 10 years ago

Aaron, i created a table with all fields. Take a look and tell me what we can improve to create a automated way to generate a table.

Short table example:

Section Fields Format Description
Feed feed string(30) Lower case name for the feeder, e.g. abusech or phishtank.
Feed feed_code string(10) Code name for the feed, e.g. DFGS, HSDAG etc.
SYNchroACK commented 10 years ago

Done