Re: mySQL database for nessusd (code!)

Minderhout, Doug wrote:

> 
>>It might also end up being a problem to store these ID's and pass
>>them in the program.
> 
> 
> The ID colums are generated in the database and are used as indexes
> into some of the tables and to link rows in the tables together. We 
> really shouldn't have to worry about having the IDs used in the 
> program.
> 

No, they should be used by the code which adds new table elements which 
reference them. Otherwise you end up with a scan that does not include 
any valuable information in the DetectedService table, for example 
(since you omit the inclusion of the ServiceID which is the information 
you really want). Or which does not crossreference the SessionID when a 
new plugin gets executed and is introduced in the ExecutedPlugins table.

Table IDs have are generated by the database (when the code inserts new 
items) but need to be retrieved whenever they are going to be used and 
probably passed along between functions.

Regards


Javi