[Perfparse-devel-int] RE: Perfparse Queation

[Alex P. <ale...@ci...>]

Hi,

host_id
host_name

service_id
service_description

I sea that host_id and serviice_id are defined  but not used into the other
tables.

How can I change the name form a host (host_name) when this is needed.

After I dit change the hostname, the data is sended with the new key to
Perfparse.

When I now want to delet the old hostname I get:
  "DELETE perfdata_service FROM perfdata_service,perfdata_host WHERE
perfdata_service.host_name = perfdata_host.host_name AND
perfdata_host.is_deleted = 1"
Because the charge the same services

CONSTRAINT `perfdata_service_ibfk_1` FOREIGN KEY (`host_name`) REFERENCES
`perfdata_host` (`host_name`),

CONSTRAINT `perfdata_service_ibfk_1` FOREIGN KEY (`host_id`) REFERENCES
`perfdata_host` (`host_id`),

-- Alex Peeters

-- 
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.17/226 - Release Date: 10/01/2006