[Nagios-checkins] ndoutils/db mysql.sql,1.7,1.8

[Hendrik Bäc. <hen...@us...>]

Update of /cvsroot/nagios/ndoutils/db
In directory fdv4jf1.ch3.sourceforge.com:/tmp/cvs-serv19615/db

Modified Files:
	mysql.sql 
Log Message:
Set long_output and perfdata to TEXT


Index: mysql.sql
===================================================================
RCS file: /cvsroot/nagios/ndoutils/db/mysql.sql,v
retrieving revision 1.7
retrieving revision 1.8
diff -C2 -d -r1.7 -r1.8
*** mysql.sql	27 Aug 2009 09:38:43 -0000	1.7
--- mysql.sql	7 Oct 2009 10:55:49 -0000	1.8
***************
*** 429,433 ****
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
    PRIMARY KEY  (`eventhandler_id`),
    UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`start_time`,`start_time_usec`)
--- 429,433 ----
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
    PRIMARY KEY  (`eventhandler_id`),
    UNIQUE KEY `instance_id` (`instance_id`,`object_id`,`start_time`,`start_time_usec`)
***************
*** 502,507 ****
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
!   `perfdata` varchar(8192) character set latin1 NOT NULL default '',
    PRIMARY KEY  (`hostcheck_id`),
    UNIQUE KEY `instance_id` (`instance_id`,`host_object_id`,`start_time`,`start_time_usec`)
--- 502,507 ----
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
!   `perfdata` TEXT character set latin1 NOT NULL default '',
    PRIMARY KEY  (`hostcheck_id`),
    UNIQUE KEY `instance_id` (`instance_id`,`host_object_id`,`start_time`,`start_time_usec`)
***************
*** 695,700 ****
    `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
!   `perfdata` varchar(8192) character set latin1 NOT NULL default '',
    `current_state` smallint(6) NOT NULL default '0',
    `has_been_checked` smallint(6) NOT NULL default '0',
--- 695,700 ----
    `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
!   `perfdata` TEXT character set latin1 NOT NULL default '',
    `current_state` smallint(6) NOT NULL default '0',
    `has_been_checked` smallint(6) NOT NULL default '0',
***************
*** 853,857 ****
    `state` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
    `escalated` smallint(6) NOT NULL default '0',
    `contacts_notified` smallint(6) NOT NULL default '0',
--- 853,857 ----
    `state` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
    `escalated` smallint(6) NOT NULL default '0',
    `contacts_notified` smallint(6) NOT NULL default '0',
***************
*** 1002,1007 ****
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
!   `perfdata` varchar(8192) character set latin1 NOT NULL default '',
    PRIMARY KEY  (`servicecheck_id`),
    KEY `instance_id` (`instance_id`),
--- 1002,1007 ----
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
!   `perfdata` TEXT character set latin1 NOT NULL default '',
    PRIMARY KEY  (`servicecheck_id`),
    KEY `instance_id` (`instance_id`),
***************
*** 1193,1198 ****
    `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
!   `perfdata` varchar(8192) character set latin1 NOT NULL default '',
    `current_state` smallint(6) NOT NULL default '0',
    `has_been_checked` smallint(6) NOT NULL default '0',
--- 1193,1198 ----
    `status_update_time` datetime NOT NULL default '0000-00-00 00:00:00',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
!   `perfdata` TEXT character set latin1 NOT NULL default '',
    `current_state` smallint(6) NOT NULL default '0',
    `has_been_checked` smallint(6) NOT NULL default '0',
***************
*** 1307,1311 ****
    `last_hard_state` smallint(6) NOT NULL default '-1',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
    PRIMARY KEY  (`statehistory_id`)
  ) ENGINE=MyISAM COMMENT='Historical host and service state changes';
--- 1307,1311 ----
    `last_hard_state` smallint(6) NOT NULL default '-1',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
    PRIMARY KEY  (`statehistory_id`)
  ) ENGINE=MyISAM COMMENT='Historical host and service state changes';
***************
*** 1330,1334 ****
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` varchar(8192) NOT NULL default '',
    PRIMARY KEY  (`systemcommand_id`),
    KEY `instance_id` (`instance_id`),
--- 1330,1334 ----
    `return_code` smallint(6) NOT NULL default '0',
    `output` varchar(255) character set latin1 NOT NULL default '',
!   `long_output` TEXT NOT NULL default '',
    PRIMARY KEY  (`systemcommand_id`),
    KEY `instance_id` (`instance_id`),