"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/1.sql" (15 Sep 2021, 1992 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 tusuario add default_event_filter int(10) unsigned NOT NULL DEFAULT 0;
    4 
    5 CREATE TABLE IF NOT EXISTS `treset_pass` (
    6     `id` bigint(10) unsigned NOT NULL auto_increment,
    7     `id_user` varchar(100) NOT NULL default '',
    8     `cod_hash` varchar(100) NOT NULL default '',
    9     `reset_time` int(10) unsigned NOT NULL default 0,
   10     PRIMARY KEY (`id`) 
   11 )ENGINE=InnoDB DEFAULT CHARSET=utf8;
   12 
   13 UPDATE tgis_map_connection SET conection_data = '{"type":"OSM","url":"http://tile.openstreetmap.org/${z}/${x}/${y}.png"}' where id_tmap_connection = 1;
   14 
   15 ALTER TABLE tpolicy_modules MODIFY post_process double(24,15) default 0;
   16 
   17 CREATE TABLE IF NOT EXISTS `tcontainer` (
   18     `id_container` mediumint(4) unsigned NOT NULL auto_increment,
   19     `name` varchar(100) NOT NULL default '',
   20     `parent` mediumint(4) unsigned NOT NULL default 0,
   21     `disabled` tinyint(3) unsigned NOT NULL default 0,
   22     `id_group` mediumint(8) unsigned NULL default 0, 
   23     `description` TEXT NOT NULL,
   24     PRIMARY KEY  (`id_container`),
   25     KEY `parent_index` (`parent`)
   26 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
   27 
   28 INSERT INTO `tcontainer` SET `name` = 'Default graph container';
   29 
   30 CREATE TABLE IF NOT EXISTS `tcontainer_item` (
   31     `id_ci` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
   32     `id_container` mediumint(4) unsigned NOT NULL default 0,
   33     `type` varchar(30) default 'simple_graph',
   34     `id_agent` int(10) unsigned NOT NULL default 0,
   35     `id_agent_module` bigint(14) unsigned NULL default NULL,
   36     `time_lapse` int(11) NOT NULL default 0,
   37     `id_graph` INTEGER UNSIGNED default 0,
   38     `only_average` tinyint (1) unsigned default 0 not null,
   39     `id_group` INT (10) unsigned NOT NULL DEFAULT 0,
   40     `id_module_group` INT (10) unsigned NOT NULL DEFAULT 0,
   41     `agent` varchar(100) NOT NULL default '',
   42     `module` varchar(100) NOT NULL default '',
   43     `id_tag` integer(10) unsigned NOT NULL DEFAULT 0,
   44     PRIMARY KEY(`id_ci`),
   45     FOREIGN KEY (`id_container`) REFERENCES tcontainer(`id_container`)
   46     ON DELETE CASCADE
   47 ) ENGINE = InnoDB DEFAULT CHARSET=utf8;
   48 
   49 COMMIT;