"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/26.sql" (15 Sep 2021, 889 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 CREATE TABLE IF NOT EXISTS `tnetwork_matrix` (
    4     `id` int(10) unsigned NOT NULL auto_increment,
    5     `source` varchar(60) default '',
    6     `destination` varchar(60) default '',
    7     `utimestamp` bigint(20) default 0,
    8     `bytes` int(18) unsigned default 0,
    9     `pkts` int(18) unsigned default 0,
   10     PRIMARY KEY (`id`),
   11     UNIQUE (`source`, `destination`, `utimestamp`)
   12 ) ENGINE = InnoDB DEFAULT CHARSET=utf8 ;
   13 
   14 ALTER TABLE `treport_content` ADD COLUMN `show_extended_events` tinyint(1) default '0';
   15 
   16 UPDATE `treport_content` SET type="netflow_summary" WHERE type="netflow_pie" OR type="netflow_statistics";
   17 
   18 UPDATE `tnetflow_filter` SET aggregate="dstip" WHERE aggregate NOT IN ("dstip", "srcip", "dstport", "srcport");
   19 
   20 ALTER TABLE tagent_custom_fields ADD COLUMN `combo_values` VARCHAR(255) DEFAULT '';
   21 
   22 ALTER TABLE `trecon_task` ADD COLUMN `summary` text;
   23 
   24 COMMIT;