"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/18.sql" (15 Sep 2021, 2729 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 `tservice` ADD COLUMN `quiet` tinyint(1) NOT NULL DEFAULT '0';
    4 ALTER TABLE `tservice` ADD COLUMN `cps` int NOT NULL DEFAULT '0';
    5 ALTER TABLE `tservice` ADD COLUMN `cascade_protection` tinyint(1) NOT NULL DEFAULT '0';
    6 
    7 ALTER TABLE `tagente` ADD COLUMN `cps` int NOT NULL DEFAULT '0';
    8 
    9 ALTER TABLE `tmetaconsole_agent` ADD COLUMN `cps` int NOT NULL DEFAULT '0';
   10 
   11 ALTER TABLE `tagente_modulo` ADD COLUMN `cps` int NOT NULL DEFAULT '0';
   12 
   13 ALTER TABLE `tservice` ADD COLUMN `evaluate_sla` int(1) NOT NULL DEFAULT '0';
   14 
   15 ALTER TABLE `tpolicy_modules` ADD COLUMN `cps` int NOT NULL DEFAULT '0';
   16 
   17 DROP INDEX id_policy ON `tpolicy_agents`;
   18 
   19 ALTER TABLE `tpolicy_agents` ADD COLUMN `id_node` int(10) NOT NULL DEFAULT '0';
   20 
   21 ALTER TABLE `tpolicy_agents` ADD UNIQUE(`id_policy`, `id_agent`, `id_node`);
   22 
   23 ALTER TABLE `tevento` ADD COLUMN `data` double(22,5) default NULL;
   24 
   25 ALTER TABLE `tmetaconsole_event` ADD COLUMN `data` double(22,5) default NULL;
   26 
   27 ALTER TABLE `tmetaconsole_event_history` ADD COLUMN `data` double(22,5) default NULL;
   28 
   29 ALTER TABLE `tevento` ADD COLUMN `module_status` int(4) NOT NULL default '0';
   30 
   31 ALTER TABLE `tmetaconsole_event` ADD COLUMN `module_status` int(4) NOT NULL default '0';
   32 
   33 ALTER TABLE `tmetaconsole_event_history` ADD COLUMN `module_status` int(4) NOT NULL default '0';
   34 
   35 CREATE TABLE `tautoconfig` (
   36   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   37   `name` varchar(100) NOT NULL,
   38   `order` int(11) NOT NULL DEFAULT '0',
   39   `description` text,
   40   PRIMARY KEY (`id`)
   41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   42 
   43 
   44 CREATE TABLE `tautoconfig_rules` (
   45   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   46   `id_autoconfig` int(10) unsigned NOT NULL,
   47   `order` int(11) NOT NULL DEFAULT '0',
   48   `operator` enum('AND','OR') DEFAULT 'OR',
   49   `type` enum('alias','ip-range','group','os','custom-field','script','server-name') DEFAULT 'alias',
   50   `value` text,
   51   `custom` text,
   52   PRIMARY KEY (`id`),
   53   KEY `id_autoconfig` (`id_autoconfig`),
   54   CONSTRAINT `tautoconfig_rules_ibfk_1` FOREIGN KEY (`id_autoconfig`) REFERENCES `tautoconfig` (`id`) ON DELETE CASCADE
   55 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   56 
   57 
   58 CREATE TABLE `tautoconfig_actions` (
   59   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
   60   `id_autoconfig` int(10) unsigned NOT NULL,
   61   `order` int(11) NOT NULL DEFAULT '0',
   62   `action_type` enum('set-group', 'set-secondary-group', 'apply-policy', 'launch-script', 'launch-event', 'launch-alert-action', 'raw-config') DEFAULT 'launch-event',
   63   `value` text,
   64   `custom` text,
   65   PRIMARY KEY (`id`),
   66   KEY `id_autoconfig` (`id_autoconfig`),
   67   CONSTRAINT `tautoconfig_action_ibfk_1` FOREIGN KEY (`id_autoconfig`) REFERENCES `tautoconfig` (`id`) ON DELETE CASCADE
   68 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   69 
   70 
   71 COMMIT;