1 CREATE TABLE IF NOT EXISTS ninja_report_comments (
2 timestamp int(11) NOT NULL default '0',
3 event_type int(11) NOT NULL default '0',
4 host_name varchar(255) default '',
5 service_description varchar(255) default '',
6 comment_timestamp int(11) NOT NULL default '0',
7 username varchar(100) NOT NULL,
8 user_comment TEXT NOT NULL,
9 KEY report_entry (timestamp, host_name, service_description, event_type)
10 ) COLLATE latin1_general_cs;