INSERT INTO scans (scanID,scanCMD,scanStart,scannmapver) values(,"","","");

INSERT into hosts (hostIP,hostMAC,hostNICManuf,host_scanID) values("","","","");

INSERT into hostnames (hostname_hostID,hostname,hostname_scanID) values((SELECT hostID from hosts where hostIP = "" and hostMAC="" and host_scanID = ), "","");

INSERT into ports (port,port_hostID,port_scanID,port_status,port_protocol) values(,(SELECT hostID from hosts where hostIP = "" and hostMAC="" and host_scanID = ),"","","");

INSERT into os (os_hostID,os_scanID,os_name) values((SELECT hostID from hosts where hostIP = "" and hostMAC="" and host_scanID = ),"","");