"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/20.sql" (15 Sep 2021, 2806 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 `recursion` TINYINT(1) default NULL;
    4 
    5 ALTER TABLE tevent_filter ADD COLUMN `user_comment` text NOT NULL;
    6 ALTER TABLE tevent_filter ADD COLUMN `source` tinytext NOT NULL;
    7 ALTER TABLE tevent_filter ADD COLUMN `id_extra` tinytext NOT NULL;
    8 
    9 ALTER TABLE tagente_modulo ALTER COLUMN `parent_module_id` SET default 0;
   10 
   11 -- Changes for the 'service like status' feature (Carrefour)
   12 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_type` ENUM ('default', 'weight', 'service') DEFAULT 'default';
   13 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_as_service_warning` FLOAT(20, 3) NOT NULL default 0;
   14 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_status_as_service_critical` FLOAT(20, 3) NOT NULL default 0;
   15 ALTER TABLE `tlayout_data` ADD COLUMN `linked_layout_node_id` INT(10) NOT NULL default 0;
   16 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_type` ENUM ('default', 'weight', 'service') DEFAULT 'default';
   17 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_as_service_warning` FLOAT(20, 3) NOT NULL default 0;
   18 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_status_as_service_critical` FLOAT(20, 3) NOT NULL default 0;
   19 ALTER TABLE `tlayout_template_data` ADD COLUMN `linked_layout_node_id` INT(10) NOT NULL default 0;
   20 
   21 -- -----------------------------------------------------
   22 -- Add column in table `treport`
   23 -- -----------------------------------------------------
   24 
   25 ALTER TABLE `treport` ADD COLUMN `hidden` tinyint(1) NOT NULL DEFAULT 0;
   26 
   27 ALTER TABLE `trecon_task` ADD COLUMN `snmp_version` varchar(5) NOT NULL default '1';
   28 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_user` varchar(255) NOT NULL default '';
   29 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_pass` varchar(255) NOT NULL default '';
   30 ALTER TABLE `trecon_task` ADD COLUMN `snmp_auth_method` varchar(25) NOT NULL default '';
   31 ALTER TABLE `trecon_task` ADD COLUMN `snmp_privacy_method` varchar(25) NOT NULL default '';
   32 ALTER TABLE `trecon_task` ADD COLUMN `snmp_privacy_pass` varchar(255) NOT NULL default '';
   33 ALTER TABLE `trecon_task` ADD COLUMN `snmp_security_level` varchar(25) NOT NULL default '';
   34 ALTER TABLE `tpolicy_modules_inventory` ADD COLUMN `custom_fields` MEDIUMBLOB NOT NULL;
   35 
   36 CREATE TABLE IF NOT EXISTS `tlog_graph_models` (
   37     `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   38     `title` TEXT NOT NULL,
   39     `regexp` TEXT NOT NULL,
   40     `fields` TEXT NOT NULL,
   41     `average` tinyint(1) NOT NULL default '0',
   42     PRIMARY KEY(`id`)
   43 ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
   44 
   45 INSERT INTO tlog_graph_models VALUES (1, 'Apache log model',
   46     '^.*?\s+.*".*?\s(\/.*?)\?.*1.1"\s+(.*?)\s+(.*?)\s+',
   47     'pagina, html_err_code, _tiempo_', 1);
   48 
   49 COMMIT;