Nagios Support Forum

--001636c927cf367d6e0475277832
Content-Type: text/plain; charset=ISO-8859-1

I used alter table for all table mentioned in the patch.

cat mysql-upgrade-1.4b8.sql
ALTER TABLE `nagios_hostchecks` ADD COLUMN `long_output` varchar(8192) NOT
NULL default '' AFTER `output`;
ALTER TABLE `nagios_hoststatus` ADD COLUMN `long_output` varchar(8192) NOT
NULL default '' AFTER `output`;
ALTER TABLE `nagios_servicechecks` ADD COLUMN `long_output` varchar(8192)
NOT NULL default '' AFTER `output`;
ALTER TABLE `nagios_servicestatus` ADD COLUMN `long_output` varchar(8192)
NOT NULL default '' AFTER `output`;
ALTER TABLE `nagios_statehistory` ADD COLUMN `long_output` varchar(8192) NOT
NULL default '' AFTER `output`;

ALTER TABLE `nagios_eventhandlers` ADD COLUMN `long_output` varchar(8192)
NOT NULL default '' AFTER `output`;
ALTER TABLE `nagios_systemcommands` ADD COLUMN `long_output` varchar(8192)
NOT NULL default '' AFTER `output`;
ALTER TABLE `nagios_notifications` ADD COLUMN `long_output` varchar(8192)
NOT NULL default '' AFTER `output`;




mysql> desc nagios_hostchecks
-> ;
+-----------------------+---------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key | Default |
Extra |
+-----------------------+---------------+------+-----+---------------------+----------------+
| hostcheck_id | int(11) | NO | PRI | NULL |
auto_increment |
| instance_id | smallint(6) | NO | MUL | 0
| |
| host_object_id | int(11) | NO | | 0
| |
| check_type | smallint(6) | NO | | 0
| |
| is_raw_check | smallint(6) | NO | | 0
| |
| current_check_attempt | smallint(6) | NO | | 0
| |
| max_check_attempts | smallint(6) | NO | | 0
| |
| state | smallint(6) | NO | | 0
| |
| state_type | smallint(6) | NO | | 0
| |
| start_time | datetime | NO | MUL | 0000-00-00 00:00:00
| |
| start_time_usec | int(11) | NO | | 0
| |
| end_time | datetime | NO | | 0000-00-00 00:00:00
| |
| end_time_usec | int(11) | NO | | 0
| |
| command_object_id | int(11) | NO | | 0
| |
| command_args | varchar(255) | NO | |
| |
| command_line | varchar(255) | NO | |
| |
| timeout | smallint(6) | NO | | 0
| |
| early_timeout | smallint(6) | NO | | 0
| |
| execution_time | double | NO | | 0
| |
| latency | double | NO | | 0
| |
| return_code | smallint(6) | NO | | 0
| |
| output | varchar(255) | NO | |
| |
| long_output | varchar(8192) | NO | |
| |
| perfdata | varchar(255) | NO | |
| |
+-----------------------+---------------+------+-----+---------------------+----------------+




mysql> desc nagios_hoststatus;
+-------------------------------+---------------+------+-----+---------------------+----------------+
| Field | Type | Null | Key |
Default | Extra |
+-------------------------------+---------------+------+-----+---------------------+----------------+
| hoststatus_id | int(11) | NO | PRI |
NULL | auto_increment |
| instance_id | smallint(6) | NO | |
0 | |
| host_object_id | int(11) | NO | UNI |
0 | |
| status_update_time | datetime | NO | | 0000-00-00
00:00:00 | |
| output

...[email truncated]...


This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]