"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/40.sql" (15 Sep 2021, 575 Bytes) of package /linux/misc/pandorafms_console-7.0NG.757.tar.gz:


As a special service "Fossies" has tried to format the requested source page into HTML format using (guessed) PL/SQL source code syntax highlighting (style: standard) with prefixed line numbers. Alternatively you can here view or download the uninterpreted source code file.

    1 START TRANSACTION;
    2 
    3 UPDATE `talert_commands` SET name='Monitoring Event' WHERE name='Pandora FMS Event';
    4 
    5 ALTER TABLE `tservice_element` ADD COLUMN `rules` text;
    6 ALTER TABLE `tservice` ADD COLUMN `unknown_as_critical` tinyint(1) NOT NULL default 0 AFTER `warning`;
    7 ALTER TABLE `tserver` MODIFY COLUMN `version` varchar(25) NOT NULL DEFAULT '';
    8 
    9 UPDATE `tservice` SET `auto_calculate`=0;
   10 
   11 UPDATE `tservice` SET `cps`= `cps` - 1 WHERE `cps` > 0;
   12 UPDATE `tagente` SET `cps`= `cps` - 1 WHERE `cps` > 0;
   13 UPDATE `tagente_modulo` SET `cps`= `cps` - 1 WHERE `cps` > 0;
   14 
   15 COMMIT;