SESSIONS

This table contains information about scanning sessions and should have the following structure:

Field	Type	Description
id	integer	Unique session identifier
name	varchar(255)	Session name
owner	varchar(255)	Scan owner (user who did the scan). NOTE: this field was added in version 1.4.0
time_start	datetime	Date and time when scan was started
time_finish	datetime	Date and time when scan was finished
time_elapsed	integer	Scan duration in seconds

RESULTS

This table contains actual scanning results and should have the following structure:

Field	Type	Description
session_id	integer	Identifier of a session this result record belongs to
host	varchar(128)	Host name or IP address
service	varchar(48)	Service name and port number
plugin_id	integer	ID of plugin generated this record
type	integer	Record type: 0 - open port, 2 - warning, 3 - hole
is_false	bool	1 if this record was marked as "false positive"
description	blob	Security hole description
risk_factor	varchar(32)	Risk factor extracted from original description
cve_id	varchar(32)	Security hole's CVE ID
solution	blob	Solution for a problem (extracted from original description)

Here you can find SQL command file for tables creation.