"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/28.sql" (15 Sep 2021, 3045 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 ALTER TABLE `treport_content` ADD COLUMN `current_month` TINYINT(1) DEFAULT '1';
    4 
    5 ALTER TABLE `treport_content_template` ADD COLUMN `current_month` TINYINT(1) DEFAULT '1';
    6 
    7 ALTER TABLE `talert_commands` ADD COLUMN `fields_hidden` text;
    8 
    9 ALTER TABLE `talert_templates` MODIFY COLUMN `type` ENUM('regex','max_min','max','min','equal','not_equal','warning','critical','onchange','unknown','always','not_normal');
   10 
   11 DELETE FROM `tevent_response` WHERE `name` LIKE 'Create Integria IMS incident from event';
   12 INSERT INTO `tnews` (`id_news`, `author`, `subject`, `text`, `timestamp`) VALUES (NULL,'admin','Welcome to Pandora FMS Console', '<p style="text-align: center; font-size: 13px;">Hello, congratulations, if you've arrived here you already have an operational monitoring console. Remember that our forums and online documentation are available 24x7 to get you out of any trouble. You can replace this message with a personalized one at Admin tools -> Site news.</p> ',NOW());
   13 
   14 
   15 INSERT INTO `tnotification_source_user` (`id_source`, `id_user`, `enabled`, `also_mail`) VALUES ((SELECT `id` FROM `tnotification_source` WHERE `description`="Official communication"), "admin", 1, 0);
   16 UPDATE `tnotification_source` SET `enabled`=1 WHERE `description` = 'System status' OR `description` = 'Official communication';
   17 UPDATE `tnotification_source` SET `icon`="icono_logo_pandora.png" WHERE `description` = 'Official communication';
   18 
   19 -- ---------------------------------------------------------------------
   20 -- Table `tvisual_console_items_cache`
   21 -- ---------------------------------------------------------------------
   22 CREATE TABLE IF NOT EXISTS `tvisual_console_elements_cache` (
   23     `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   24     `vc_id` INTEGER UNSIGNED NOT NULL,
   25     `vc_item_id` INTEGER UNSIGNED NOT NULL,
   26     `user_id` VARCHAR(60) DEFAULT NULL,
   27     `data` TEXT NOT NULL,
   28     `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
   29     `expiration` INTEGER UNSIGNED NOT NULL COMMENT 'Seconds to expire',
   30     PRIMARY KEY(`id`),
   31     FOREIGN KEY(`vc_id`) REFERENCES `tlayout`(`id`)
   32     ON DELETE CASCADE,
   33     FOREIGN KEY(`vc_item_id`) REFERENCES `tlayout_data`(`id`)
   34     ON DELETE CASCADE,
   35     FOREIGN KEY (`user_id`) REFERENCES `tusuario`(`id_user`)
   36     ON DELETE CASCADE ON UPDATE CASCADE
   37 ) engine=InnoDB DEFAULT CHARSET=utf8;
   38 
   39 ALTER TABLE `tlayout_data` ADD COLUMN `cache_expiration` INTEGER UNSIGNED NOT NULL DEFAULT 0;
   40 
   41 ALTER TABLE `tusuario` ADD COLUMN `ehorus_user_level_user` VARCHAR(60);
   42 ALTER TABLE `tusuario` ADD COLUMN `ehorus_user_level_pass` VARCHAR(45);
   43 ALTER TABLE `tusuario` ADD COLUMN `ehorus_user_level_enabled` TINYINT(1) DEFAULT '1';
   44 
   45 COMMIT;