"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/12.sql" (15 Sep 2021, 2258 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 tcontainer_item ADD COLUMN type_graph tinyint(1) unsigned default '0';
    4 
    5 ALTER TABLE tlayout_data ADD COLUMN `clock_animation` varchar(60) NOT NULL default "analogic_1";
    6 ALTER TABLE tlayout_data ADD COLUMN `time_format` varchar(60) NOT NULL default "time";
    7 ALTER TABLE tlayout_data ADD COLUMN `timezone` varchar(60) NOT NULL default "Europe/Madrid";
    8 
    9 -- ---------------------------------------------------------------------
   10 -- Table `tcluster`
   11 -- ---------------------------------------------------------------------
   12 
   13 create table IF NOT EXISTS `tcluster`(
   14     `id` int unsigned not null auto_increment,
   15     `name` tinytext not null default '',
   16     `cluster_type` enum('AA','AP') not null default 'AA',
   17         `description` text not null default '',
   18         `group` int(10) unsigned NOT NULL default '0',
   19         `id_agent` int(10) unsigned NOT NULL,
   20         PRIMARY KEY (`id`),
   21         FOREIGN KEY (`id_agent`) REFERENCES tagente(`id_agente`)
   22             ON UPDATE CASCADE
   23 ) engine=InnoDB DEFAULT CHARSET=utf8;
   24 
   25 -- ---------------------------------------------------------------------
   26 -- Table `tcluster_item`
   27 -- ---------------------------------------------------------------------
   28 
   29 create table IF NOT EXISTS `tcluster_item`(
   30         `id` int unsigned not null auto_increment,
   31     `name` tinytext not null default '',
   32     `item_type` enum('AA','AP')  not null default 'AA',
   33         `critical_limit` int unsigned NOT NULL default '0',
   34         `warning_limit` int unsigned NOT NULL default '0',
   35         `is_critical` tinyint(2) unsigned NOT NULL default '0',
   36         `id_cluster` int unsigned,
   37         PRIMARY KEY (`id`),
   38         FOREIGN KEY (`id_cluster`) REFERENCES tcluster(`id`)
   39             ON DELETE SET NULL ON UPDATE CASCADE
   40 ) engine=InnoDB DEFAULT CHARSET=utf8;
   41 
   42 -- ---------------------------------------------------------------------
   43 -- Table `tcluster_agent`
   44 -- ---------------------------------------------------------------------
   45 
   46 create table IF NOT EXISTS `tcluster_agent`(
   47     `id_cluster` int unsigned not null,
   48     `id_agent` int(10) unsigned not null,
   49         PRIMARY KEY (`id_cluster`,`id_agent`),
   50         FOREIGN KEY (`id_agent`) REFERENCES tagente(`id_agente`)
   51             ON UPDATE CASCADE,
   52         FOREIGN KEY (`id_cluster`) REFERENCES tcluster(`id`)
   53             ON UPDATE CASCADE
   54 ) engine=InnoDB DEFAULT CHARSET=utf8;
   55 
   56 COMMIT;