"Fossies" - the Fresh Open Source Software Archive

Member "pandora_console/extras/mr/10.sql" (15 Sep 2021, 615 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 tsnmp_filter ADD unified_filters_id int(10) NOT NULL DEFAULT 0;
    4 ALTER TABLE treport_content_template ADD COLUMN hide_no_data tinyint(1) DEFAULT 0;
    5 ALTER TABLE tgraph_source ADD COLUMN `field_order` int(10) NOT NULL default 0;
    6 UPDATE tgraph_source c, (SELECT @n := 0) m SET c.field_order = @n := @n + 1;
    7 
    8 ALTER TABLE tgraph ADD COLUMN `summatory_series` tinyint(1) UNSIGNED NOT NULL default '0';
    9 ALTER TABLE tgraph ADD COLUMN `average_series`  tinyint(1) UNSIGNED NOT NULL default '0';
   10 ALTER TABLE tgraph ADD COLUMN `modules_series`  tinyint(1) UNSIGNED NOT NULL default '0';
   11 
   12 COMMIT;