INSERT INTO router_configuration VALUES (75, 3732, '## Last commit: 2012-04-18 19:20:23 CEST by xuser\\012version 11.4R1.6;\\012system {\\012    host-name ANT-PE-01A;\\012    backup-router 172.24.13.1 destination 192.168.0.0/16;\\012    time-zone Europe/Berlin;\\012    root-authentication {\\012        encrypted-password "$1$7apXEz2D$Tf0L5kSxyAKixXuVrpTmR."; ## SECRET-DATA\\012    }\\012    name-server {\\012        192.168.42.101;\\012    }\\012    login {\\012        message "\\\\n\\\\n##############################################\\\\n\\\\n            WELCOME TO XT3LAB\\\\n\\\\nUnauthorized access is stricly prohibited.\\\\nIf not authorized, log off system immediately!\\\\n\\\\n##############################################\\\\n";\\012        class xt3labuser {\\012            permissions all;\\012            deny-commands "delete interface fxp0";\\012            deny-configuration "system root-authentication|interfaces fxp0"; ## Warning: ''deny-configuration'' is deprecated\\012        }\\012        user xuser {\\012            uid 2000;\\012            class super-user;\\012            authentication {\\012                encrypted-password "$1$2khNc798$0fwwTnJCf/s4SG1/enbcs/"; ## SECRET-DATA\\012            }\\012        }\\012    }\\012    services {\\012        ftp;\\012        ssh;\\012        telnet;\\012        web-management {\\012            module-mode;\\012            http;\\012        }\\012    }\\012    syslog {\\012        user * {\\012            any emergency;\\012        }\\012        file messages {\\012            any notice;\\012            authorization info;\\012        }\\012        file interactive-commands {\\012            interactive-commands any;\\012        }\\012    }\\012    ntp {\\012        server 192.168.254.101;\\012        server 192.168.254.102;\\012        source-address 172.24.11.15;\\012    }\\012}\\012interfaces {\\012    ge-0/0/0 {\\012        unit 0 {\\012            description "Up-Link to CORE-P-01A";\\012            family inet {\\012                address 10.1.3.2/31;\\012            }\\012            family iso;\\012            family mpls;\\012        }\\012    }\\012    fe-0/0/6 {\\012        unit 0 {\\012            family inet {\\012                address 172.24.13.27/24;\\012            }\\012        }\\012    }\\012    lo0 {\\012        unit 0 {\\012            family inet {\\012                address 10.1.0.4/32;\\012            }\\012            family iso {\\012                address 49.0010.0001.0000.0004.00;\\012            }\\012        }\\012        unit 10 {\\012            description "CUST_A_AUDIO VPN Loopback";\\012            family inet {\\012                address 10.10.10.4/32;\\012            }\\012        }\\012    }\\012}\\012snmp {\\012    contact "ARQIVA LAB";\\012    community public {\\012        clients {\\012            192.168.0.0/16;\\012        }\\012    }\\012}\\012routing-options {\\012    static {\\012        route 192.168.0.0/16 {\\012            next-hop 172.24.13.1;\\012            no-readvertise;\\012        }\\012    }\\012    router-id 10.1.0.4;\\012    autonomous-system 65000;\\012}\\012protocols {\\012    rsvp {\\012        interface ge-0/0/0.0;\\012    }\\012    mpls {\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012    bgp {\\012        group iBGP-PE-PE {\\012            type internal;\\012            local-address 10.1.0.4;\\012            family inet-vpn {\\012                any;\\012            }\\012            family inet-mvpn {\\012                signaling;\\012            }\\012            neighbor 10.1.0.254;\\012            neighbor 10.1.0.5;\\012            neighbor 10.1.0.255;\\012        }\\012    }\\012    isis {\\012        level 1 disable;\\012        level 2 wide-metrics-only;\\012        interface ge-0/0/0.0 {\\012            point-to-point;\\012            level 1 disable;\\012        }\\012        interface lo0.0 {\\012            passive;\\012        }\\012    }\\012    ldp {\\012        transport-address router-id;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012}\\012security {\\012    screen {\\012        ids-option untrust-screen {\\012            icmp {\\012                ping-death;\\012            }\\012            ip {\\012                tear-drop;\\012            }\\012            tcp {\\012                syn-flood {\\012                    alarm-threshold 1024;\\012                    attack-threshold 200;\\012                    source-threshold 1024;\\012                    destination-threshold 2048;\\012                    timeout 20;\\012                }\\012                land;\\012            }\\012        }\\012    }\\012    policies {\\012        from-zone trust to-zone untrust {\\012            policy trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                }\\012            }\\012        }\\012        from-zone MANAGEMENT to-zone untrust {\\012            policy MANAGEMENT-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                }\\012            }\\012        }\\012        from-zone untrust to-zone MANAGEMENT {\\012            policy MANAGEMENT-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                }\\012            }\\012        }\\012        from-zone untrust to-zone trust {\\012            policy trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                }\\012            }\\012        }\\012        from-zone MANAGEMENT to-zone trust {\\012            policy trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                }\\012            }\\012        }\\012        from-zone trust to-zone MANAGEMENT {\\012            policy trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    zones {\\012        security-zone trust {\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012        }\\012        security-zone untrust {\\012            screen untrust-screen;\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012            interfaces {\\012                ge-0/0/0.0 {\\012                    host-inbound-traffic {\\012                        system-services {\\012                            dhcp;\\012                            tftp;\\012                            reverse-ssh;\\012                            reverse-telnet;\\012                            snmp;\\012                            snmp-trap;\\012                            ssh;\\012                            telnet;\\012                            ftp;\\012                            ntp;\\012                            ping;\\012                            traceroute;\\012                            all;\\012                        }\\012                        protocols {\\012                            bfd;\\012                            pim;\\012                            ldp;\\012                            bgp;\\012                            rsvp;\\012                            all;\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012        security-zone MANAGEMENT {\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012            interfaces {\\012                fe-0/0/6.0;\\012            }\\012        }\\012    }\\012}\\012routing-instances {\\012    CUST_A_AUDIO {\\012        instance-type vrf;\\012        interface lo0.10;\\012        route-distinguisher 10.1.0.4:1;\\012        vrf-target target:65000:1;\\012        vrf-table-label;\\012        protocols {\\012            pim {\\012                rp {\\012                    static {\\012                        address 10.10.10.255;\\012                    }\\012                }\\012            }\\012            mvpn;\\012        }\\012    }\\012}\\012\\012', '2012-04-18 19:50:17');
INSERT INTO router_configuration VALUES (76, 3732, '## Last commit: 2012-04-19 20:00:17 CEST by xuser\\012version 11.4R1.6;\\012system {\\012    host-name ANT-PE-01A;\\012    backup-router 172.24.13.1 destination 192.168.0.0/16;\\012    time-zone Europe/Berlin;\\012    root-authentication {\\012        encrypted-password "$1$7apXEz2D$Tf0L5kSxyAKixXuVrpTmR."; ## SECRET-DATA\\012    }\\012    name-server {\\012        192.168.42.101;\\012    }\\012    login {\\012        message "\\\\n\\\\n##############################################\\\\n\\\\n            WELCOME TO XT3LAB\\\\n\\\\nUnauthorized access is stricly prohibited.\\\\nIf not authorized, log off system immediately!\\\\n\\\\n##############################################\\\\n";\\012        class xt3labuser {\\012            permissions all;\\012            deny-commands "delete interface fxp0";\\012            deny-configuration "system root-authentication|interfaces fxp0"; ## Warning: ''deny-configuration'' is deprecated\\012        }\\012        user xuser {\\012            uid 2000;\\012            class super-user;\\012            authentication {\\012                encrypted-password "$1$2khNc798$0fwwTnJCf/s4SG1/enbcs/"; ## SECRET-DATA\\012            }\\012        }\\012    }\\012    services {\\012        ftp;\\012        ssh;\\012        telnet;\\012        web-management {\\012            module-mode;\\012            http;\\012        }\\012    }\\012    syslog {\\012        user * {\\012            any emergency;\\012        }\\012        file messages {\\012            any notice;\\012            authorization info;\\012        }\\012        file interactive-commands {\\012            interactive-commands any;\\012        }\\012    }\\012    ntp {\\012        server 192.168.254.101;\\012        server 192.168.254.102;\\012        source-address 172.24.11.15;\\012    }\\012}\\012interfaces {\\012    ge-0/0/0 {\\012        unit 0 {\\012            description "Up-Link to CORE-P-01A";\\012            family inet {\\012                address 10.1.3.2/31;\\012            }\\012            family iso;\\012            family mpls;\\012        }\\012    }\\012    ge-0/0/1 {\\012        unit 0 {\\012            description CUST-A-RECEIVERS-VLAN;\\012            family inet {\\012                address 11.0.32.253/24 {\\012                    vrrp-group 1 {\\012                        virtual-address 11.0.32.254;\\012                        priority 253;\\012                        preempt;\\012                        accept-data;\\012                        track {\\012                            interface ge-0/0/0.0 {\\012                                priority-cost 100;\\012                            }\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    fe-0/0/6 {\\012        unit 0 {\\012            family inet {\\012                address 172.24.13.27/24;\\012            }\\012        }\\012    }\\012    lo0 {\\012        unit 0 {\\012            family inet {\\012                address 10.1.0.4/32;\\012            }\\012            family iso {\\012                address 49.0010.0001.0000.0004.00;\\012            }\\012        }\\012        unit 10 {\\012            description "CUST_A_AUDIO VPN Loopback";\\012            family inet {\\012                address 10.10.10.4/32;\\012            }\\012        }\\012    }\\012}\\012snmp {\\012    contact "ARQIVA LAB";\\012    community public {\\012        clients {\\012            192.168.0.0/16;\\012        }\\012    }\\012}\\012routing-options {\\012    static {\\012        route 192.168.0.0/16 {\\012            next-hop 172.24.13.1;\\012            no-readvertise;\\012        }\\012    }\\012    router-id 10.1.0.4;\\012    autonomous-system 65000;\\012}\\012protocols {\\012    igmp {\\012        interface ge-0/0/1.0 {\\012            version 2;\\012        }\\012    }\\012    rsvp {\\012        interface ge-0/0/0.0;\\012    }\\012    mpls {\\012        explicit-null;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012    bgp {\\012        group iBGP-PE-PE {\\012            type internal;\\012            local-address 10.1.0.4;\\012            family inet-vpn {\\012                any;\\012            }\\012            family inet-mvpn {\\012                signaling;\\012            }\\012            neighbor 10.1.0.254;\\012            neighbor 10.1.0.5;\\012            neighbor 10.1.0.255;\\012        }\\012    }\\012    isis {\\012        level 1 disable;\\012        level 2 wide-metrics-only;\\012        interface ge-0/0/0.0 {\\012            point-to-point;\\012            level 1 disable;\\012        }\\012        interface lo0.0 {\\012            passive;\\012        }\\012    }\\012    ldp {\\012        transport-address router-id;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012}\\012security {\\012    forwarding-options {\\012        family {\\012            mpls {\\012                mode packet-based;\\012            }\\012        }\\012    }\\012}\\012routing-instances {\\012    CUST_A_AUDIO {\\012        instance-type vrf;\\012        interface ge-0/0/1.0;\\012        interface lo0.10;\\012        route-distinguisher 10.1.0.4:1;\\012        vrf-target target:65000:1;\\012        vrf-table-label;\\012        protocols {\\012            pim {\\012                rp {\\012                    static {\\012                        address 10.10.10.255;\\012                    }\\012                }\\012            }\\012            mvpn;\\012        }\\012    }\\012}\\012\\012', '2012-04-19 03:50:03');
INSERT INTO router_configuration VALUES (77, 3733, '## Last commit: 2012-04-18 19:07:52 CEST by xuser\\012version 11.4R1.6;\\012system {\\012    host-name ANT-PE-01B;\\012    time-zone Europe/Berlin;\\012    root-authentication {\\012        encrypted-password "$1$7apXEz2D$Tf0L5kSxyAKixXuVrpTmR."; ## SECRET-DATA\\012    }\\012    name-server {\\012        192.168.42.101;\\012    }\\012    login {\\012        message "\\\\n\\\\n##############################################\\\\n\\\\n            WELCOME TO XT3LAB\\\\n\\\\nUnauthorized access is stricly prohibited.\\\\nIf not authorized, log off system immediately!\\\\n\\\\n##############################################\\\\n";\\012        class xt3labuser {\\012            permissions all;\\012            deny-commands "delete interface fxp0";\\012            deny-configuration "system root-authentication|interfaces fxp0"; ## Warning: ''deny-configuration'' is deprecated\\012        }\\012        user xuser {\\012            uid 2000;\\012            class super-user;\\012            authentication {\\012                encrypted-password "$1$2khNc798$0fwwTnJCf/s4SG1/enbcs/"; ## SECRET-DATA\\012            }\\012        }\\012    }\\012    services {\\012        ftp;\\012        ssh;\\012        telnet;\\012        web-management {\\012            module-mode;\\012            http;\\012        }\\012    }\\012    syslog {\\012        user * {\\012            any emergency;\\012        }\\012        file messages {\\012            any notice;\\012            authorization info;\\012        }\\012        file interactive-commands {\\012            interactive-commands any;\\012        }\\012    }\\012    ntp {\\012        server 192.168.254.101;\\012        server 192.168.254.102;\\012        source-address 172.24.11.15;\\012    }\\012}\\012interfaces {\\012    ge-0/0/0 {\\012        unit 0 {\\012            description "Up-Link to CORE-P-01B";\\012            family inet {\\012                address 10.1.3.4/31;\\012            }\\012            family iso;\\012            family mpls;\\012        }\\012    }\\012    fe-0/0/6 {\\012        unit 0 {\\012            family inet {\\012                address 172.24.13.28/24;\\012            }\\012        }\\012    }\\012    lo0 {\\012        unit 0 {\\012            family inet {\\012                address 10.1.0.5/32;\\012            }\\012            family iso {\\012                address 49.0010.0001.0000.0005.00;\\012            }\\012        }\\012        unit 10 {\\012            description "CUST_A_AUDIO VPN Loopback";\\012            family inet {\\012                address 10.10.10.5/32;\\012            }\\012        }\\012    }\\012}\\012snmp {\\012    contact "ARQIVA LAB";\\012    community public {\\012        clients {\\012            192.168.0.0/16;\\012        }\\012    }\\012}\\012routing-options {\\012    static {\\012        route 192.168.0.0/16 {\\012            next-hop 172.24.13.1;\\012            no-readvertise;\\012        }\\012    }\\012    router-id 10.1.0.5;\\012    autonomous-system 65000;\\012}\\012protocols {\\012    rsvp {\\012        interface ge-0/0/0.0;\\012    }\\012    mpls {\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012    bgp {\\012        group iBGP-PE-PE {\\012            type internal;\\012            local-address 10.1.0.5;\\012            family inet-vpn {\\012                any;\\012            }\\012            family inet-mvpn {\\012                signaling;\\012            }\\012            neighbor 10.1.0.254;\\012            neighbor 10.1.0.4;\\012            neighbor 10.1.0.255;\\012            neighbor 10.1.0.6;\\012        }\\012    }\\012    isis {\\012        level 1 disable;\\012        level 2 wide-metrics-only;\\012        interface ge-0/0/0.0 {\\012            point-to-point;\\012            level 1 disable;\\012        }\\012        interface lo0.0 {\\012            passive;\\012        }\\012    }\\012    ldp {\\012        transport-address router-id;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012}\\012security {\\012    forwarding-options {\\012        family {\\012            mpls {\\012                mode packet-based;\\012            }\\012        }\\012    }\\012}\\012routing-instances {\\012    CUST_A_AUDIO {\\012        instance-type vrf;\\012        interface lo0.10;\\012        route-distinguisher 10.1.0.5:1;\\012        vrf-target target:65000:1;\\012        vrf-table-label;\\012        protocols {\\012            pim {\\012                rp {\\012                    static {\\012                        address 10.10.10.255;\\012                    }\\012                }\\012            }\\012            mvpn;\\012        }\\012    }\\012}\\012\\012', '2012-04-18 19:50:17');
INSERT INTO router_configuration VALUES (78, 3733, '## Last commit: 2012-04-19 19:59:50 CEST by xuser\\012version 11.4R1.6;\\012system {\\012    host-name ANT-PE-01B;\\012    time-zone Europe/Berlin;\\012    root-authentication {\\012        encrypted-password "$1$7apXEz2D$Tf0L5kSxyAKixXuVrpTmR."; ## SECRET-DATA\\012    }\\012    name-server {\\012        192.168.42.101;\\012    }\\012    login {\\012        message "\\\\n\\\\n##############################################\\\\n\\\\n            WELCOME TO XT3LAB\\\\n\\\\nUnauthorized access is stricly prohibited.\\\\nIf not authorized, log off system immediately!\\\\n\\\\n##############################################\\\\n";\\012        class xt3labuser {\\012            permissions all;\\012            deny-commands "delete interface fxp0";\\012            deny-configuration "system root-authentication|interfaces fxp0"; ## Warning: ''deny-configuration'' is deprecated\\012        }\\012        user xuser {\\012            uid 2000;\\012            class super-user;\\012            authentication {\\012                encrypted-password "$1$2khNc798$0fwwTnJCf/s4SG1/enbcs/"; ## SECRET-DATA\\012            }\\012        }\\012    }\\012    services {\\012        ftp;\\012        ssh;\\012        telnet;\\012        web-management {\\012            module-mode;\\012            http;\\012        }\\012    }\\012    syslog {\\012        user * {\\012            any emergency;\\012        }\\012        file messages {\\012            any notice;\\012            authorization info;\\012        }\\012        file interactive-commands {\\012            interactive-commands any;\\012        }\\012    }\\012    ntp {\\012        server 192.168.254.101;\\012        server 192.168.254.102;\\012        source-address 172.24.11.15;\\012    }\\012}\\012interfaces {\\012    ge-0/0/0 {\\012        unit 0 {\\012            description "Up-Link to CORE-P-01B";\\012            family inet {\\012                address 10.1.3.4/31;\\012            }\\012            family iso;\\012            family mpls;\\012        }\\012    }\\012    ge-0/0/1 {\\012        unit 0 {\\012            description CUST-A-RECEIVERS-VLAN;\\012            family inet {\\012                address 11.0.32.252/24 {\\012                    vrrp-group 1 {\\012                        virtual-address 11.0.32.254;\\012                        priority 252;\\012                        preempt;\\012                        accept-data;\\012                        track {\\012                            interface ge-0/0/0.0 {\\012                                priority-cost 100;\\012                            }\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    fe-0/0/6 {\\012        unit 0 {\\012            family inet {\\012                address 172.24.13.28/24;\\012            }\\012        }\\012    }\\012    lo0 {\\012        unit 0 {\\012            family inet {\\012                address 10.1.0.5/32;\\012            }\\012            family iso {\\012                address 49.0010.0001.0000.0005.00;\\012            }\\012        }\\012        unit 10 {\\012            description "CUST_A_AUDIO VPN Loopback";\\012            family inet {\\012                address 10.10.10.5/32;\\012            }\\012        }\\012    }\\012}\\012snmp {\\012    contact "ARQIVA LAB";\\012    community public {\\012        clients {\\012            192.168.0.0/16;\\012        }\\012    }\\012}\\012routing-options {\\012    static {\\012        route 192.168.0.0/16 {\\012            next-hop 172.24.13.1;\\012            no-readvertise;\\012        }\\012    }\\012    router-id 10.1.0.5;\\012    autonomous-system 65000;\\012}\\012protocols {\\012    igmp {\\012        interface ge-0/0/1.0 {\\012            version 2;\\012        }\\012    }\\012    rsvp {\\012        interface ge-0/0/0.0;\\012    }\\012    mpls {\\012        explicit-null;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012    bgp {\\012        group iBGP-PE-PE {\\012            type internal;\\012            local-address 10.1.0.5;\\012            family inet-vpn {\\012                any;\\012            }\\012            family inet-mvpn {\\012                signaling;\\012            }\\012            neighbor 10.1.0.254;\\012            neighbor 10.1.0.4;\\012            neighbor 10.1.0.255;\\012            neighbor 10.1.0.6;\\012        }\\012    }\\012    isis {\\012        level 1 disable;\\012        level 2 wide-metrics-only;\\012        interface ge-0/0/0.0 {\\012            point-to-point;\\012            level 1 disable;\\012        }\\012        interface lo0.0 {\\012            passive;\\012        }\\012    }\\012    ldp {\\012        transport-address router-id;\\012        interface all;\\012        interface fxp0.0 {\\012            disable;\\012        }\\012    }\\012}\\012security {\\012    forwarding-options {\\012        family {\\012            mpls {\\012                mode packet-based;\\012            }\\012        }\\012    }\\012}\\012routing-instances {\\012    CUST_A_AUDIO {\\012        instance-type vrf;\\012        interface ge-0/0/1.0;\\012        interface lo0.10;\\012        route-distinguisher 10.1.0.5:1;\\012        vrf-target target:65000:1;\\012        vrf-table-label;\\012        protocols {\\012            pim {\\012                rp {\\012                    static {\\012                        address 10.10.10.255;\\012                    }\\012                }\\012            }\\012            mvpn;\\012        }\\012    }\\012}\\012\\012', '2012-04-19 03:50:03');
INSERT INTO router_configuration VALUES (79, 3734, '## Last commit: 2011-11-30 22:42:16 CET by taras\\012version 10.0R3.10;\\012system {\\012    host-name kerkedijk7;\\012    domain-name ziggo.nl;\\012    domain-search ziggo.nl;\\012    time-zone Europe/Amsterdam;\\012    root-authentication {\\012        encrypted-password "$1$vL9YoohK$BvyJVgFwHC4z2ih.z4j1G1"; ## SECRET-DATA\\012    }\\012    name-server {\\012        208.67.222.222;\\012        208.67.220.220;\\012    }\\012    login {\\012        class super-user-local {\\012            idle-timeout 30;\\012        }\\012        user taras {\\012            full-name Taras;\\012            uid 2000;\\012            class super-user;\\012            authentication {\\012                encrypted-password "$1$9nmriTEL$15AmvMLqsv76MSwpiOUw6/"; ## SECRET-DATA\\012            }\\012        }\\012    }\\012    services {\\012        ssh {\\012            protocol-version [ v1 v2 ];\\012            connection-limit 3;\\012            rate-limit 3;\\012        }\\012        telnet {\\012            connection-limit 3;\\012            rate-limit 3;\\012        }\\012        xnm-clear-text;\\012        web-management {\\012            http {\\012                interface [ vlan.0 vlan.1 ];\\012            }\\012            https {\\012                system-generated-certificate;\\012                interface [ vlan.0 vlan.1 lo0.0 ];\\012            }\\012        }\\012        dhcp {\\012            pool 192.168.2.0/24 {\\012                address-range low 192.168.2.100 high 192.168.2.254;\\012                default-lease-time 604800;\\012                router {\\012                    192.168.2.1;\\012                }\\012            }\\012            pool 192.168.1.0/24 {\\012                address-range low 192.168.1.100 high 192.168.1.254;\\012                default-lease-time 2592000;\\012                router {\\012                    192.168.1.1;\\012                }\\012            }\\012            pool 192.168.3.0/24 {\\012                address-range low 192.168.3.100 high 192.168.3.254;\\012                default-lease-time 2592000;\\012                router {\\012                    192.168.3.1;\\012                }\\012            }\\012            pool 192.168.252.0/24 {\\012                address-range low 192.168.252.200 high 192.168.252.210;\\012                default-lease-time 3600;\\012                router {\\012                    192.168.252.100;\\012                }\\012            }\\012            pool 192.168.0.0/24 {\\012                address-range low 192.168.0.100 high 192.168.0.254;\\012                router {\\012                    192.168.0.1;\\012                }\\012            }\\012            propagate-settings ge-0/0/0.0;\\012        }\\012    }\\012    syslog {\\012        archive size 100k files 5;\\012        user * {\\012            any emergency;\\012        }\\012        host 192.168.3.103 {\\012            any info;\\012        }\\012        file messages {\\012            any critical;\\012            authorization info;\\012        }\\012        file interactive-commands {\\012            interactive-commands error;\\012        }\\012        file policy_session {\\012            user info;\\012            match RT_FLOW;\\012            archive size 5218304 files 10 world-readable;\\012            structured-data;\\012        }\\012    }\\012    max-configurations-on-flash 5;\\012    max-configuration-rollbacks 5;\\012    license {\\012        autoupdate {\\012            url https://ae1.juniper.net/junos/key_retrieval;\\012        }\\012    }\\012    ntp {\\012        boot-server 17.72.133.42;\\012        server 17.72.133.42;\\012    }\\012}\\012interfaces {\\012    interface-range utility-trust {\\012        member fe-0/0/3;\\012        member fe-0/0/4;\\012        member fe-0/0/5;\\012        unit 0 {\\012            family ethernet-switching {\\012                vlan {\\012                    members utility;\\012                }\\012            }\\012        }\\012    }\\012    ge-0/0/0 {\\012        unit 0 {\\012            description "Dirty Net -> SP";\\012            family inet {\\012                dhcp {\\012                    update-server;\\012                }\\012            }\\012        }\\012    }\\012    ge-0/0/1 {\\012        unit 0 {\\012            family ethernet-switching {\\012                vlan {\\012                    members trust_hp;\\012                }\\012            }\\012        }\\012    }\\012    fe-0/0/2 {\\012        description "to WiFi AP - trust";\\012        unit 0 {\\012            description "Media/WiFi segment";\\012            family ethernet-switching {\\012                port-mode trunk;\\012                vlan {\\012                    members [ media default guest ];\\012                }\\012            }\\012        }\\012    }\\012    fe-0/0/3 {\\012        description "to IC panel - utility";\\012    }\\012    fe-0/0/4 {\\012        description "to Gate unit - utility";\\012    }\\012    fe-0/0/5 {\\012        description "to LED bridge - utility";\\012    }\\012    fe-0/0/6 {\\012        description "to IP camera - DMZ";\\012        unit 0 {\\012            family inet {\\012                address 192.168.253.1/24;\\012            }\\012        }\\012    }\\012    fe-0/0/7 {\\012        description "to Media LAN switch - trust";\\012        unit 0 {\\012            family ethernet-switching {\\012                vlan {\\012                    members media;\\012                }\\012            }\\012        }\\012    }\\012    lo0 {\\012        unit 0 {\\012            description "System ID - loopback";\\012            family inet {\\012                address 192.168.255.1/32;\\012            }\\012        }\\012    }\\012    vlan {\\012        unit 0 {\\012            description "Management LAN";\\012            family inet {\\012                address 192.168.0.1/24;\\012            }\\012        }\\012        unit 1 {\\012            description "Trust High Performance LAN";\\012            family inet {\\012                address 192.168.3.1/24;\\012            }\\012        }\\012        unit 2 {\\012            description "Media/WiFi LAN";\\012            family inet {\\012                address 192.168.2.1/24;\\012            }\\012        }\\012        unit 3 {\\012            description "Guest WiFi segment";\\012            family inet {\\012                address 192.168.252.100/24;\\012            }\\012        }\\012        unit 4 {\\012            description "Utility LAN";\\012            family inet {\\012                address 192.168.1.1/24;\\012            }\\012        }\\012    }\\012}\\012snmp {\\012    location "Kerkedijk 7";\\012    contact "Taras Matselyukh - tmatselyukh@gmail.com";\\012    community public {\\012        authorization read-only;\\012        clients {\\012            192.168.3.0/24;\\012            0.0.0.0/0 restrict;\\012        }\\012    }\\012    community private {\\012        authorization read-write;\\012        clients {\\012            192.168.3.0/24;\\012            0.0.0.0/0 restrict;\\012        }\\012    }\\012    trap-group public {\\012        version all;\\012        targets {\\012            192.168.3.103;\\012        }\\012    }\\012    health-monitor {\\012        interval 600;\\012        rising-threshold 90;\\012        falling-threshold 80;\\012    }\\012}\\012protocols {\\012    ospf {\\012        area 0.0.0.0 {\\012            interface lo0.0 {\\012                passive;\\012            }\\012            interface vlan.0;\\012            interface vlan.1;\\012        }\\012    }\\012}\\012security {\\012    nat {\\012        source {\\012            rule-set Trust-to-Untrust {\\012                from zone Trust;\\012                to zone Untrust;\\012                rule source-nat-rule {\\012                    match {\\012                        source-address 0.0.0.0/0;\\012                    }\\012                    then {\\012                        source-nat {\\012                            interface;\\012                        }\\012                    }\\012                }\\012            }\\012            rule-set Guest_to_Untrust {\\012                from zone Guest_wifi;\\012                to zone Untrust;\\012                rule guest_to_untrust {\\012                    match {\\012                        source-address 192.168.252.0/24;\\012                    }\\012                    then {\\012                        source-nat {\\012                            interface;\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    log {\\012        mode event;\\012        event-rate 1000;\\012    }\\012    screen {\\012        ids-option guest {\\012            ip {\\012                bad-option;\\012                spoofing;\\012                unknown-protocol;\\012                block-frag;\\012                tear-drop;\\012            }\\012        }\\012        ids-option trust {\\012            ip {\\012                spoofing;\\012            }\\012            limit-session;\\012        }\\012        ids-option untrust-screen {\\012            icmp {\\012                ping-death;\\012            }\\012            ip {\\012                source-route-option;\\012                tear-drop;\\012            }\\012            tcp {\\012                syn-flood {\\012                    alarm-threshold 1024;\\012                    attack-threshold 200;\\012                    source-threshold 1024;\\012                    destination-threshold 2048;\\012                    timeout 20;\\012                }\\012                land;\\012            }\\012        }\\012    }\\012    zones {\\012        functional-zone management {\\012            interfaces {\\012                vlan.0;\\012            }\\012            screen trust;\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012        }\\012        security-zone Trust {\\012            address-book {\\012                address trust_hp_net 192.168.3.0/24;\\012            }\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012            interfaces {\\012                lo0.0;\\012                vlan.1;\\012                vlan.2;\\012            }\\012        }\\012        security-zone Untrust {\\012            address-book {\\012                address Skype_CIDR_block 204.9.163.192/26;\\012            }\\012            screen untrust-screen;\\012            interfaces {\\012                ge-0/0/0.0 {\\012                    host-inbound-traffic {\\012                        system-services {\\012                            dhcp;\\012                            tftp;\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012        security-zone DMZ {\\012            address-book {\\012                address DMZ_net 192.168.253.0/24;\\012            }\\012            screen untrust-screen;\\012            host-inbound-traffic {\\012                system-services {\\012                    http;\\012                    https;\\012                }\\012            }\\012            interfaces {\\012                fe-0/0/6.0;\\012            }\\012        }\\012        security-zone Utility {\\012            address-book {\\012                address Utility_net 192.168.1.0/24;\\012            }\\012            screen trust;\\012            host-inbound-traffic {\\012                system-services {\\012                    all;\\012                }\\012                protocols {\\012                    all;\\012                }\\012            }\\012            interfaces {\\012                vlan.4;\\012            }\\012        }\\012        security-zone Guest_wifi {\\012            tcp-rst;\\012            screen guest;\\012            interfaces {\\012                vlan.3 {\\012                    host-inbound-traffic {\\012                        system-services {\\012                            dhcp;\\012                            tftp;\\012                        }\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    policies {\\012        from-zone Trust to-zone Untrust {\\012            policy Services_trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application [ junos-dns-udp junos-ntp junos-ssh ];\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy SIP_trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application junos-sip;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012            policy Web_trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application [ junos-https junos-http ];\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy Mail_Trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application [ junos-imap junos-pop3 junos-smtp junos-imaps ];\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy News_Trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application junos-nntp;\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy Trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application junos-ftp;\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy XMPP_from_trust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application Clear_XMPP;\\012                }\\012                then {\\012                    permit {\\012                        application-services {\\012                            idp;\\012                        }\\012                    }\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012            policy test_Skype_from_trust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application Skype_test_winXP;\\012                }\\012                then {\\012                    permit {\\012                        application-services {\\012                            idp;\\012                        }\\012                    }\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012            policy Deny_rest_trust-to-untrust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    reject;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012        }\\012        from-zone Trust to-zone Trust {\\012            policy Trust-to-trust {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                }\\012            }\\012        }\\012        from-zone Trust to-zone Utility {\\012            policy Trust_to_Utilities {\\012                match {\\012                    source-address trust_hp_net;\\012                    destination-address Utility_net;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                    log {\\012                        session-init;\\012                    }\\012                }\\012            }\\012        }\\012        from-zone Trust to-zone DMZ {\\012            policy Trust_to_DMZ {\\012                match {\\012                    source-address trust_hp_net;\\012                    destination-address DMZ_net;\\012                    application any;\\012                }\\012                then {\\012                    permit;\\012                }\\012            }\\012        }\\012        from-zone Guest_wifi to-zone Untrust {\\012            policy Guest_access {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application [ junos-http junos-https junos-pop3 junos-ntp junos-imap junos-dns-udp junos-imaps Apple-push-XMPP-SSL ];\\012                }\\012                then {\\012                    permit;\\012                    count;\\012                }\\012            }\\012            policy test_Skype_Guest_access {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application Skype_test_iOS;\\012                }\\012                then {\\012                    permit {\\012                        application-services {\\012                            idp;\\012                        }\\012                    }\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012            policy Deny_rest_Guest_access {\\012                match {\\012                    source-address any;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    reject;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                    count;\\012                }\\012            }\\012        }\\012        from-zone Utility to-zone Untrust {\\012            policy Utilities_to_Untrust {\\012                match {\\012                    source-address Utility_net;\\012                    destination-address any;\\012                    application [ junos-ntp junos-dns-udp ];\\012                }\\012                then {\\012                    permit;\\012                }\\012            }\\012            policy deny_Utilities_to_Untrust {\\012                match {\\012                    source-address Utility_net;\\012                    destination-address any;\\012                    application any;\\012                }\\012                then {\\012                    reject;\\012                    log {\\012                        session-init;\\012                        session-close;\\012                    }\\012                }\\012            }\\012        }\\012    }\\012    inactive: utm {\\012        utm-policy Web_scanner_cpa {\\012            anti-virus {\\012                http-profile junos-av-defaults;\\012            }\\012            web-filtering {\\012                http-profile junos-wf-cpa-default;\\012            }\\012            traffic-options {\\012                sessions-per-client {\\012                    over-limit log-and-permit;\\012                }\\012            }\\012        }\\012        utm-policy Web_scanner_wbsns {\\012            anti-virus {\\012                http-profile junos-av-defaults;\\012            }\\012            web-filtering {\\012                http-profile junos-wf-websense-default;\\012            }\\012            traffic-options {\\012                sessions-per-client {\\012                    over-limit log-and-permit;\\012                }\\012            }\\012        }\\012        utm-policy FTP_virus_scanner {\\012            anti-virus {\\012                ftp {\\012                    upload-profile junos-av-defaults;\\012                    download-profile junos-av-defaults;\\012                }\\012            }\\012            traffic-options {\\012                sessions-per-client {\\012                    over-limit log-and-permit;\\012                }\\012            }\\012        }\\012        utm-policy Mail_scanner_all {\\012            anti-virus {\\012                smtp-profile junos-av-defaults;\\012                pop3-profile junos-av-defaults;\\012                imap-profile junos-av-defaults;\\012            }\\012            anti-spam {\\012                smtp-profile junos-as-defaults;\\012            }\\012            traffic-options {\\012                sessions-per-client {\\012                    over-limit log-and-permit;\\012                }\\012            }\\012        }\\012    }\\012}\\012applications {\\012    application Apple-push-XMPP-SSL {\\012        protocol tcp;\\012        inactivity-timeout 3600;\\012    }\\012    application Clear_XMPP {\\012        protocol tcp;\\012        inactivity-timeout 3600;\\012    }\\012    application Skype_test_winXP {\\012        term test_Skype_U_S53341 protocol udp source-port 53341 inactivity-timeout 3600;\\012        term test_Skype_T_S53341 protocol tcp source-port 53341 inactivity-timeout 3600;\\012    }\\012    application Skype_test_iOS {\\012        term test_Skype_U_S57134 protocol udp source-port 57134 inactivity-timeout 3600;\\012    }\\012}\\012poe {\\012    interface fe-0/0/2;\\012    interface fe-0/0/3;\\012}\\012wlan {\\012    access-point kerkedijk7_ap {\\012        description "AX411 in the closet";\\012        mac-address 2c:6b:f5:04:75:80;\\012        location "Ground floor utility closet";\\012        external {\\012            system {\\012                ntp-server 17.72.133.55;\\012                ports {\\012                    ethernet {\\012                        management-vlan 1;\\012                        name-server [ 208.67.222.222 208.67.220.220 ];\\012                    }\\012                }\\012                console {\\012                    baud-rate 9600;\\012                }\\012            }\\012        }\\012        radio 1 {\\012            radio-options {\\012                mode an;\\012                channel {\\012                    number auto;\\012                    bandwidth 40;\\012                    primary lower;\\012                }\\012                transmit-power 50;\\012                fixed-multicast-rate auto;\\012            }\\012            virtual-access-point 0 {\\012                description "Secure WiFi ";\\012                ssid Kid7_Wirele77_Network;\\012                vlan 3;\\012                no-broadcast-ssid;\\012                security {\\012                    wpa-personal {\\012                        wpa-version {\\012                            both;\\012                        }\\012                        cipher-suites {\\012                            both;\\012                        }\\012                        key "$9$P536BIhrK80BK8LxsYmfTzCpOBEhylVwTF/9u0"; ## SECRET-DATA\\012                        broadcast-key-refresh-rate 3600;\\012                    }\\012                }\\012            }\\012            virtual-access-point 1 {\\012                description "Guest WiFi area";\\012                ssid Guest_network_an;\\012                vlan 10;\\012                security {\\012                    mac-authentication-type disabled;\\012                    none;\\012                }\\012            }\\012        }\\012        radio 2 {\\012            radio-options {\\012                mode bgn;\\012                channel {\\012                    number auto;\\012                    bandwidth 40;\\012                }\\012                transmit-power 25;\\012                fixed-multicast-rate auto;\\012            }\\012            virtual-access-point 0 {\\012                description "Guest WiFi area";\\012                ssid Guest_network_bgn;\\012                vlan 10;\\012                security {\\012                    mac-authentication-type disabled;\\012                    none;\\012                }\\012            }\\012        }\\012    }\\012}\\012vlans {\\012    default {\\012        vlan-id 1;\\012        l3-interface vlan.0;\\012    }\\012    guest {\\012        description "Guest WiFi segment";\\012        vlan-id 10;\\012        l3-interface vlan.3;\\012    }\\012    media {\\012        description "Media/WiFi LAN";\\012        vlan-id 3;\\012        l3-interface vlan.2;\\012    }\\012    trust_hp {\\012        description "Trust High-Performance LAN";\\012        vlan-id 2;\\012        l3-interface vlan.1;\\012    }\\012    utility {\\012        description "Utility LAN";\\012        vlan-id 4;\\012        l3-interface vlan.4;\\012    }\\012}\\012\\012', '2011-11-30 22:42:49');


--
-- Data for Name: router_graph; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO router_graph VALUES (3724, 155.955, 103.482);
INSERT INTO router_graph VALUES (3725, 156.052, 224.311);
INSERT INTO router_graph VALUES (3726, 270.052, 103.311);
INSERT INTO router_graph VALUES (3727, 42.052101, 224.311);
INSERT INTO router_graph VALUES (3730, 489.052, 217.711);
INSERT INTO router_graph VALUES (3731, 389.052, 101.711);
INSERT INTO router_graph VALUES (3732, 489.052, 101.711);
INSERT INTO router_graph VALUES (3733, 30, 164);
INSERT INTO router_graph VALUES (3734, 320, 164);


--
-- Data for Name: router_icons; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO router_icons VALUES (1, 'Juniper', 1, '/router_white.png', 24, 24);
INSERT INTO router_icons VALUES (2, 'Juniper', 2, '/router_blue.png', 24, 24);
INSERT INTO router_icons VALUES (3, 'Juniper', 3, '/router_grey.png', 24, 24);
INSERT INTO router_icons VALUES (4, 'Cisco', 1, '/router_white.png', 24, 24);
INSERT INTO router_icons VALUES (5, 'Cisco', 2, '/router_green.png', 24, 24);
INSERT INTO router_icons VALUES (6, 'Cisco', 3, '/router_grey.png', 24, 24);
INSERT INTO router_icons VALUES (7, 'DEFAULT', 1, '/router_white.png', 24, 24);
INSERT INTO router_icons VALUES (8, 'DEFAULT', 2, '/router_white.png', 24, 24);
INSERT INTO router_icons VALUES (9, 'DEFAULT', 3, '/router_white.png', 24, 24);
INSERT INTO router_icons VALUES (10, 'OCX', 2, '/OCX_96x96.png', 96, 96);
INSERT INTO router_icons VALUES (11, 'CloudProvider', 2, '/Cloud_provider_96x96.png', 96, 96);
INSERT INTO router_icons VALUES (12, 'ocxStorage', 2, '/OCXclient_storage_up_96x96.png', 48, 48);
INSERT INTO router_icons VALUES (13, 'ocxStorage', 3, '/OCXclient_storage_dn_96x96.png', 48, 48);
INSERT INTO router_icons VALUES (14, 'Linux', 1, '/VM_dn-96X96.png', 48, 48);
INSERT INTO router_icons VALUES (15, 'Linux', 2, '/VM_in_cloud_96x96.png', 48, 48);
INSERT INTO router_icons VALUES (16, 'Linux', 3, '/VM_dn-96x96.png', 48, 48);


--
-- Data for Name: router_snmp_access; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO router_snmp_access VALUES (1, 3731, 1);


--
-- Data for Name: router_states; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO router_states VALUES (1, 'UNKNOWN');
INSERT INTO router_states VALUES (2, 'UP');
INSERT INTO router_states VALUES (3, 'DOWN');
INSERT INTO router_states VALUES (4, 'RED ALARM');
INSERT INTO router_states VALUES (5, 'YELLOW ALARM');
INSERT INTO router_states VALUES (6, 'RUNNING');
INSERT INTO router_states VALUES (7, 'STARTING');
INSERT INTO router_states VALUES (8, 'FINISHING');
INSERT INTO router_states VALUES (9, 'STOPPED');


--
-- Data for Name: router_vendors; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO router_vendors VALUES (2, 'Juniper', '0000FF');
INSERT INTO router_vendors VALUES (1, 'Cisco', '449970');


--
-- Data for Name: routers; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO routers VALUES (3732, 'r201', '10.100.254.23', 'm10                                               ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3730, 'atlas', '10.100.254.21', 'm5                                                ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3724, '192.168.50.2', '192.168.50.2', NULL, NULL, NULL, 'down                ', NULL);
INSERT INTO routers VALUES (3726, 'adrastea', '172.26.27.37', 'm40                                               ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3727, 'jupiter', '172.26.27.18', 't640                                              ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3725, '192.168.50.3', '192.168.50.3', NULL, NULL, NULL, 'down                ', NULL);
INSERT INTO routers VALUES (3731, 'ganymede', '10.100.254.20', 'm10                                               ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3733, '172.26.27.37', '0.0.0.0', 'm40                                               ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);
INSERT INTO routers VALUES (3734, '172.26.27.18', '0.0.0.0', 't640                                              ', 'Juniper                                           ', 'AMS, EPOC                                                                                                                                                                                                                                                      ', 'up                  ', NULL);


--
-- Data for Name: snmp_access; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO snmp_access VALUES (1, 'IGVejdv/hgE=', '');


--
-- Data for Name: tbl_user; Type: TABLE DATA; Schema: public; Owner: -
--


INSERT INTO tbl_user VALUES (1, 'admin', '0192023a7bbd73250516f069df18b500', 'sales@opt-net.eu', 'Admin', 'Admin', 'Opt Net');


--
-- Data for Name: usrs; Type: TABLE DATA; Schema: public; Owner: -
--

INSERT INTO usrs VALUES ('admin', 'admin');
INSERT INTO usrs VALUES ('taras', 'taras');


--
-- Name: access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY access
    ADD CONSTRAINT access_pkey PRIMARY KEY (id);


--
-- Name: access_type_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY access_type
    ADD CONSTRAINT access_type_pkey PRIMARY KEY (id);


--
-- Name: admrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY admrecords
    ADD CONSTRAINT admrecords_pkey PRIMARY KEY (rec_id);


--
-- Name: archives_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY archives
    ADD CONSTRAINT archives_pkey PRIMARY KEY (archive_id);


--
-- Name: attr_access_id_access_type_id_attr_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY attr_access
    ADD CONSTRAINT attr_access_id_access_type_id_attr_key UNIQUE (id_access_type, id_attr);


--
-- Name: attr_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY attr
    ADD CONSTRAINT attr_pkey PRIMARY KEY (id);


--
-- Name: attr_value_id_attr_access_id_access_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY attr_value
    ADD CONSTRAINT attr_value_id_attr_access_id_access_key UNIQUE (id_attr_access, id_access);


--
-- Name: attr_value_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY attr_value
    ADD CONSTRAINT attr_value_pkey PRIMARY KEY (id);


--
-- Name: authassignment_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY authassignment
    ADD CONSTRAINT authassignment_pkey PRIMARY KEY (itemname, userid);


--
-- Name: authitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY authitem
    ADD CONSTRAINT authitem_pkey PRIMARY KEY (name);


--
-- Name: authitemchild_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_pkey PRIMARY KEY (parent, child);


--
-- Name: event_id_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY events
    ADD CONSTRAINT event_id_pkey PRIMARY KEY (event_id);


--
-- Name: interfaces_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY interfaces
    ADD CONSTRAINT interfaces_pkey PRIMARY KEY (ifc_id);


--
-- Name: menu_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY menu
    ADD CONSTRAINT menu_pkey PRIMARY KEY (id);


--
-- Name: menuitem_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY menuitem
    ADD CONSTRAINT menuitem_pkey PRIMARY KEY (id);


--
-- Name: network_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_pkey PRIMARY KEY (link_id);


--
-- Name: ph_int_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY ph_int
    ADD CONSTRAINT ph_int_pkey PRIMARY KEY (ph_int_id);


--
-- Name: pk_router_icons; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_icons
    ADD CONSTRAINT pk_router_icons PRIMARY KEY (id);


--
-- Name: pk_router_states; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_states
    ADD CONSTRAINT pk_router_states PRIMARY KEY (id);


--
-- Name: pk_rsa; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_snmp_access
    ADD CONSTRAINT pk_rsa PRIMARY KEY (id);


--
-- Name: pk_settings; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY general_settings
    ADD CONSTRAINT pk_settings PRIMARY KEY (id);


--
-- Name: pk_snmp_access; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY snmp_access
    ADD CONSTRAINT pk_snmp_access PRIMARY KEY (id);


--
-- Name: router_access_id_access_id_router_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_access
    ADD CONSTRAINT router_access_id_access_id_router_key UNIQUE (id_access, id_router);


--
-- Name: router_access_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_access
    ADD CONSTRAINT router_access_pkey PRIMARY KEY (id);


--
-- Name: router_configuration_id_key; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_configuration
    ADD CONSTRAINT router_configuration_id_key UNIQUE (id);


--
-- Name: router_vendors_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_vendors
    ADD CONSTRAINT router_vendors_pkey PRIMARY KEY (id);


--
-- Name: routers_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY routers
    ADD CONSTRAINT routers_pkey PRIMARY KEY (router_id);


--
-- Name: tbl_user_pkey; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY tbl_user
    ADD CONSTRAINT tbl_user_pkey PRIMARY KEY (id);


--
-- Name: uni_rsa_router; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY router_snmp_access
    ADD CONSTRAINT uni_rsa_router UNIQUE (router_id);


--
-- Name: uni_settings; Type: CONSTRAINT; Schema: public; Owner: -; Tablespace: 
--

ALTER TABLE ONLY general_settings
    ADD CONSTRAINT uni_settings UNIQUE (name);


--
-- Name: aattr_acc_a; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX aattr_acc_a ON attr_access USING hash (id_attr);


--
-- Name: access_id_access_type_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX access_id_access_type_idx ON access USING btree (id_access_type);


--
-- Name: attr_acc_a_t; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX attr_acc_a_t ON attr_access USING hash (id_access_type);


--
-- Name: attr_value_id_access_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX attr_value_id_access_idx ON attr_value USING btree (id_access);


--
-- Name: attr_value_id_attr_access_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX attr_value_id_attr_access_idx ON attr_value USING btree (id_attr_access);


--
-- Name: child; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX child ON authitemchild USING btree (child);


--
-- Name: event_origin_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX event_origin_idx ON events USING btree (origin_ts);


--
-- Name: event_receiver_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX event_receiver_idx ON events USING btree (receiver_ts);


--
-- Name: events_event_id_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX events_event_id_key ON events USING btree (event_id);


--
-- Name: r_s_a_router_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX r_s_a_router_id ON router_snmp_access USING btree (router_id);


--
-- Name: r_s_a_snmp_access_id; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX r_s_a_snmp_access_id ON router_snmp_access USING btree (snmp_access_id);


--
-- Name: router_access_id_router_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX router_access_id_router_idx ON router_access USING btree (id_router);


--
-- Name: snmp_access_id_idx; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE INDEX snmp_access_id_idx ON snmp_access USING btree (id);


--
-- Name: usrs_usr_key; Type: INDEX; Schema: public; Owner: -; Tablespace: 
--

CREATE UNIQUE INDEX usrs_usr_key ON usrs USING btree (usr);


--
-- Name: access_id_access_type_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY access
    ADD CONSTRAINT access_id_access_type_fkey FOREIGN KEY (id_access_type) REFERENCES access_type(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: attr_value_id_access_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY attr_value
    ADD CONSTRAINT attr_value_id_access_fkey FOREIGN KEY (id_access) REFERENCES access(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: authassignment_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY authassignment
    ADD CONSTRAINT authassignment_ibfk_1 FOREIGN KEY (itemname) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: authitemchild_ibfk_1; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_ibfk_1 FOREIGN KEY (parent) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: authitemchild_ibfk_2; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY authitemchild
    ADD CONSTRAINT authitemchild_ibfk_2 FOREIGN KEY (child) REFERENCES authitem(name) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_id_snmp_access_router; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_snmp_access
    ADD CONSTRAINT fk_id_snmp_access_router FOREIGN KEY (snmp_access_id) REFERENCES snmp_access(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_icons_router_state; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_icons
    ADD CONSTRAINT fk_router_icons_router_state FOREIGN KEY (router_state) REFERENCES router_states(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_graph
    ADD CONSTRAINT fk_router_id FOREIGN KEY (router_id) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_id_conf; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_configuration
    ADD CONSTRAINT fk_router_id_conf FOREIGN KEY (router_id) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: fk_router_id_snmp_access; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_snmp_access
    ADD CONSTRAINT fk_router_id_snmp_access FOREIGN KEY (router_id) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: interfaces_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY interfaces
    ADD CONSTRAINT interfaces_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: inv_hw_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY inv_hw
    ADD CONSTRAINT inv_hw_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: inv_sw_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY inv_sw
    ADD CONSTRAINT inv_sw_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: network_router_id_a_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_router_id_a_fkey FOREIGN KEY (router_id_a) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: network_router_id_b_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY network
    ADD CONSTRAINT network_router_id_b_fkey FOREIGN KEY (router_id_b) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: ph_int_router_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY ph_int
    ADD CONSTRAINT ph_int_router_id_fkey FOREIGN KEY (router_id) REFERENCES routers(router_id) ON DELETE CASCADE;


--
-- Name: router_access_id_access_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_access
    ADD CONSTRAINT router_access_id_access_fkey FOREIGN KEY (id_access) REFERENCES access(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: router_access_id_router_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY router_access
    ADD CONSTRAINT router_access_id_router_fkey FOREIGN KEY (id_router) REFERENCES routers(router_id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: public; Type: ACL; Schema: -; Owner: -
--

REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO PUBLIC;


--
-- Name: admrecords; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE admrecords FROM PUBLIC;
REVOKE ALL ON TABLE admrecords FROM ngnms;
GRANT ALL ON TABLE admrecords TO ngnms;
GRANT ALL ON TABLE admrecords TO ngnms;


--
-- Name: admrecords_RecID_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE "admrecords_RecID_seq" FROM PUBLIC;
REVOKE ALL ON SEQUENCE "admrecords_RecID_seq" FROM ngnms;
GRANT ALL ON SEQUENCE "admrecords_RecID_seq" TO ngnms;
GRANT ALL ON SEQUENCE "admrecords_RecID_seq" TO ngnms;


--
-- Name: archives; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE archives FROM PUBLIC;
REVOKE ALL ON TABLE archives FROM ngnms;
GRANT ALL ON TABLE archives TO ngnms;
GRANT ALL ON TABLE archives TO ngnms;


--
-- Name: archives_archive_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE archives_archive_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE archives_archive_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE archives_archive_id_seq TO ngnms;
GRANT ALL ON SEQUENCE archives_archive_id_seq TO ngnms;


--
-- Name: events; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE events FROM PUBLIC;
REVOKE ALL ON TABLE events FROM ngnms;
GRANT ALL ON TABLE events TO ngnms;
GRANT ALL ON TABLE events TO ngnms;


--
-- Name: events_event_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE events_event_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE events_event_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE events_event_id_seq TO ngnms;
GRANT ALL ON SEQUENCE events_event_id_seq TO ngnms;


--
-- Name: interfaces; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE interfaces FROM PUBLIC;
REVOKE ALL ON TABLE interfaces FROM ngnms;
GRANT ALL ON TABLE interfaces TO ngnms;
GRANT ALL ON TABLE interfaces TO ngnms;


--
-- Name: interfaces_ifc_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE interfaces_ifc_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE interfaces_ifc_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE interfaces_ifc_id_seq TO ngnms;
GRANT ALL ON SEQUENCE interfaces_ifc_id_seq TO ngnms;


--
-- Name: inv_hw; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE inv_hw FROM PUBLIC;
REVOKE ALL ON TABLE inv_hw FROM ngnms;
GRANT ALL ON TABLE inv_hw TO ngnms;
GRANT ALL ON TABLE inv_hw TO ngnms;


--
-- Name: inv_sw; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE inv_sw FROM PUBLIC;
REVOKE ALL ON TABLE inv_sw FROM ngnms;
GRANT ALL ON TABLE inv_sw TO ngnms;
GRANT ALL ON TABLE inv_sw TO ngnms;


--
-- Name: network; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE network FROM PUBLIC;
REVOKE ALL ON TABLE network FROM ngnms;
GRANT ALL ON TABLE network TO ngnms;
GRANT ALL ON TABLE network TO ngnms;


--
-- Name: network_link_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE network_link_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE network_link_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE network_link_id_seq TO ngnms;
GRANT ALL ON SEQUENCE network_link_id_seq TO ngnms;


--
-- Name: pga_forms; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_forms FROM PUBLIC;
REVOKE ALL ON TABLE pga_forms FROM ngnms;
GRANT ALL ON TABLE pga_forms TO ngnms;
GRANT ALL ON TABLE pga_forms TO ngnms;
GRANT ALL ON TABLE pga_forms TO PUBLIC;


--
-- Name: pga_layout; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_layout FROM PUBLIC;
REVOKE ALL ON TABLE pga_layout FROM ngnms;
GRANT ALL ON TABLE pga_layout TO ngnms;
GRANT ALL ON TABLE pga_layout TO ngnms;
GRANT ALL ON TABLE pga_layout TO PUBLIC;


--
-- Name: pga_queries; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_queries FROM PUBLIC;
REVOKE ALL ON TABLE pga_queries FROM ngnms;
GRANT ALL ON TABLE pga_queries TO ngnms;
GRANT ALL ON TABLE pga_queries TO ngnms;
GRANT ALL ON TABLE pga_queries TO PUBLIC;


--
-- Name: pga_reports; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_reports FROM PUBLIC;
REVOKE ALL ON TABLE pga_reports FROM ngnms;
GRANT ALL ON TABLE pga_reports TO ngnms;
GRANT ALL ON TABLE pga_reports TO ngnms;
GRANT ALL ON TABLE pga_reports TO PUBLIC;


--
-- Name: pga_schema; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_schema FROM PUBLIC;
REVOKE ALL ON TABLE pga_schema FROM ngnms;
GRANT ALL ON TABLE pga_schema TO ngnms;
GRANT ALL ON TABLE pga_schema TO ngnms;
GRANT ALL ON TABLE pga_schema TO PUBLIC;


--
-- Name: pga_scripts; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE pga_scripts FROM PUBLIC;
REVOKE ALL ON TABLE pga_scripts FROM ngnms;
GRANT ALL ON TABLE pga_scripts TO ngnms;
GRANT ALL ON TABLE pga_scripts TO ngnms;
GRANT ALL ON TABLE pga_scripts TO PUBLIC;


--
-- Name: ph_int; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE ph_int FROM PUBLIC;
REVOKE ALL ON TABLE ph_int FROM ngnms;
GRANT ALL ON TABLE ph_int TO ngnms;
GRANT ALL ON TABLE ph_int TO ngnms;


--
-- Name: ph_int_ph_int_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE ph_int_ph_int_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE ph_int_ph_int_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE ph_int_ph_int_id_seq TO ngnms;
GRANT ALL ON SEQUENCE ph_int_ph_int_id_seq TO ngnms;


--
-- Name: router_graph; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE router_graph FROM PUBLIC;
REVOKE ALL ON TABLE router_graph FROM ngnms;
GRANT ALL ON TABLE router_graph TO ngnms;
GRANT ALL ON TABLE router_graph TO ngnms;


--
-- Name: router_vendors; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE router_vendors FROM PUBLIC;
REVOKE ALL ON TABLE router_vendors FROM ngnms;
GRANT ALL ON TABLE router_vendors TO ngnms;
GRANT ALL ON TABLE router_vendors TO ngnms;


--
-- Name: router_vendors_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE router_vendors_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE router_vendors_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE router_vendors_id_seq TO ngnms;
GRANT ALL ON SEQUENCE router_vendors_id_seq TO ngnms;


--
-- Name: routers; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON TABLE routers FROM PUBLIC;
REVOKE ALL ON TABLE routers FROM ngnms;
GRANT ALL ON TABLE routers TO ngnms;
GRANT ALL ON TABLE routers TO ngnms;


--
-- Name: routers_router_id_seq; Type: ACL; Schema: public; Owner: -
--

REVOKE ALL ON SEQUENCE routers_router_id_seq FROM PUBLIC;
REVOKE ALL ON SEQUENCE routers_router_id_seq FROM ngnms;
GRANT ALL ON SEQUENCE routers_router_id_seq TO ngnms;
GRANT ALL ON SEQUENCE routers_router_id_seq TO ngnms;


--
--

