using mysql with nagios

[Luis Muñoz]

Godd mornig, 
i am trying to use mysql to maintain nagios comments status etc, but , for example ,     when i create the tables into the database mysql complains because i dont know what names are for each column for example


mysql>use nagios
Database changed
mysql> create table servicedowntime;
ERROR 1113: A table must have at least 1 column
mysql>

then  i supose to guess 

mysql> create table servicedowntime(servicedowntime   varchar(20) not null);

but i didnt find anything related to because i configured cgi.cfg and resource.cfg and compiled nagios with mysql support 

tanks
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/users/attachments/20030721/dac399cf/attachment.html>