--
-- PostgreSQL database dump
--

SET client_encoding = 'SQL_ASCII';
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS 'Standard public schema';


--
-- Name: plpgsql; Type: PROCEDURAL LANGUAGE; Schema: -; Owner: 
--

CREATE PROCEDURAL LANGUAGE plpgsql;


SET search_path = public, pg_catalog;

--
-- Name: datarate; Type: TYPE; Schema: public; Owner: sesse
--

CREATE TYPE datarate AS (
	switch integer,
	port integer,
	bytes_in double precision,
	bytes_out double precision
);


ALTER TYPE public.datarate OWNER TO sesse;

--
-- Name: get_current_datarate(); Type: FUNCTION; Schema: public; Owner: nms
--

CREATE FUNCTION get_current_datarate() RETURNS SETOF datarate
    AS $$
DECLARE
        num_entries INTEGER;
        poll polls;
        first_poll polls;
        last_poll polls;
        timediff float;
        ret datarate;
BEGIN
        num_entries := 0;
        last_poll.switch := -1;

        FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
                IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
                        IF num_entries >= 2 THEN
                                timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
                                ret.switch := last_poll.switch;
                                ret.port := last_poll.port;

                                IF last_poll.bytes_in >= first_poll.bytes_in AND last_poll.bytes_out >= first_poll.bytes_out THEN
                                        ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
                                        ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
                                        return next ret; 
                                END IF;
                        END IF;
                        num_entries := 0;
                ELSE
                        -- reset if we have wraparound
                        IF last_poll.bytes_in < first_poll.bytes_in OR
                           last_poll.bytes_out < first_poll.bytes_out THEN
                                num_entries := 0;
                        END IF;
                END IF;

                num_entries := num_entries + 1;
                IF num_entries = 1 THEN
                        first_poll.switch := poll.switch;
                        first_poll.port := poll.port;
                        first_poll.time := poll.time;
                        first_poll.bytes_in := poll.bytes_in;
                        first_poll.bytes_out := poll.bytes_out;
                END IF;

                last_poll.switch := poll.switch;
                last_poll.port := poll.port;
                last_poll.time := poll.time;
                last_poll.bytes_in := poll.bytes_in;
                last_poll.bytes_out := poll.bytes_out;
        END LOOP;

        -- last
        IF num_entries >= 2 THEN
                timediff := EXTRACT(epoch from last_poll.time - first_poll.time);
                ret.switch := last_poll.switch;
                ret.port := last_poll.port;

                IF last_poll.bytes_in >= first_poll.bytes_in AND
                   last_poll.bytes_out >= first_poll.bytes_out THEN
                        ret.bytes_in := (last_poll.bytes_in - first_poll.bytes_in) / timediff;
                        ret.bytes_out := (last_poll.bytes_out - first_poll.bytes_out) / timediff;
                        return next ret; 
                END IF;
        END IF;

        RETURN;
END;
$$
    LANGUAGE plpgsql;


ALTER FUNCTION public.get_current_datarate() OWNER TO nms;

--
-- Name: get_datarate(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION get_datarate() RETURNS SETOF datarate
    AS $$
DECLARE
        num_entries INTEGER;
        poll polls;
        second_last_poll polls;
        last_poll polls;
        timediff float;
        ret datarate;
BEGIN
        num_entries := 0;
        last_poll.switch = -1;

        FOR poll IN select * from polls where time >= now() - '15 minutes'::interval and time < now() order by switch,port,time LOOP
                IF poll.switch <> last_poll.switch OR poll.port <> last_poll.port THEN
                        IF num_entries >= 2 THEN
                                timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
                                ret.switch := last_poll.switch;
                                ret.port := last_poll.port;
                                
                                IF last_poll.bytes_in < second_last_poll.bytes_in THEN
                                        second_last_poll.bytes_in = 0;
                                END IF;
                                IF last_poll.bytes_out < second_last_poll.bytes_out THEN
                                        second_last_poll.bytes_out = 0;
                                END IF;

                                ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
                                ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
                                return next ret;
                        ELSIF num_entries = 1 THEN
                                ret.switch := last_poll.switch;
                                ret.port := last_poll.port;
                                ret.bytes_in := -1;
                                ret.bytes_out := -1;
                                return next ret;
                        END IF;
                        num_entries := 1;
                ELSE
                        num_entries := num_entries + 1;
                END IF;
                second_last_poll.switch := last_poll.switch;
                second_last_poll.port := last_poll.port;
                second_last_poll.time := last_poll.time;
                second_last_poll.bytes_in := last_poll.bytes_in;
                second_last_poll.bytes_out := last_poll.bytes_out;
                last_poll.switch := poll.switch;
                last_poll.port := poll.port;
                last_poll.time := poll.time;
                last_poll.bytes_in := poll.bytes_in;
                last_poll.bytes_out := poll.bytes_out;
        END LOOP;
       -- pah, and once more, for the last switch/port...
        IF num_entries >= 2 THEN
                timediff := EXTRACT(epoch from last_poll.time - second_last_poll.time);
                ret.switch := last_poll.switch;
                ret.port := last_poll.port;
                
                IF last_poll.bytes_in < second_last_poll.bytes_in THEN
                        second_last_poll.bytes_in = 0;
                END IF;
                IF last_poll.bytes_out < second_last_poll.bytes_out THEN
                        second_last_poll.bytes_out = 0;
                END IF;

                ret.bytes_in := (last_poll.bytes_in - second_last_poll.bytes_in) / timediff;
                ret.bytes_out := (last_poll.bytes_out - second_last_poll.bytes_out) / timediff;
                return next ret;
        ELSIF num_entries = 1 THEN
                ret.switch := last_poll.switch;
                ret.port := last_poll.port;
                ret.bytes_in := -1;
                ret.bytes_out := -1;
                return next ret;
        END IF;
        
        RETURN;
END;
$$
    LANGUAGE plpgsql;


ALTER FUNCTION public.get_datarate() OWNER TO postgres;

--
-- Name: plpgsql_call_handler(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;


ALTER FUNCTION public.plpgsql_call_handler() OWNER TO postgres;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: cpuloadpoll; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE cpuloadpoll (
    id serial NOT NULL,
    "time" timestamp without time zone NOT NULL,
    switch integer NOT NULL,
    entity integer NOT NULL,
    value integer NOT NULL
);


ALTER TABLE public.cpuloadpoll OWNER TO sesse;

--
-- Name: cpuloadpoll_id_seq; Type: SEQUENCE SET; Schema: public; Owner: sesse
--

SELECT pg_catalog.setval(pg_catalog.pg_get_serial_sequence('cpuloadpoll', 'id'), 12, true);


--
-- Name: dhcp; Type: TABLE; Schema: public; Owner: sesse; Tablespace: 
--

CREATE TABLE dhcp (
    switch integer NOT NULL,
    network cidr NOT NULL,
    last_ack timestamp without time zone
);


ALTER TABLE public.dhcp OWNER TO sesse;

--
-- Name: placements; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE placements (
    switch integer NOT NULL,
    placement box NOT NULL
);


ALTER TABLE public.placements OWNER TO postgres;

--
-- Name: polls; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE polls (
    "time" timestamp with time zone NOT NULL,
    switch integer NOT NULL,
    port integer NOT NULL,
    bytes_in bigint NOT NULL,
    bytes_out bigint NOT NULL
);
ALTER TABLE ONLY polls ALTER COLUMN "time" SET STATISTICS 100;


ALTER TABLE public.polls OWNER TO postgres;

--
-- Name: polls_poll_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE polls_poll_seq
    START WITH 1
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.polls_poll_seq OWNER TO postgres;

--
-- Name: polls_poll_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('polls_poll_seq', 1, false);


SET default_with_oids = true;

--
-- Name: portnames; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE portnames (
    switchtype character varying NOT NULL,
    port integer NOT NULL,
    description character varying NOT NULL
);


ALTER TABLE public.portnames OWNER TO postgres;

--
-- Name: squeue; Type: TABLE; Schema: public; Owner: nms; Tablespace: 
--

CREATE TABLE squeue (
    id integer DEFAULT nextval(('squeue_sequence'::text)::regclass) NOT NULL,
    gid integer NOT NULL,
    added timestamp with time zone NOT NULL,
    updated timestamp with time zone,
    addr inet,
    cmd character varying NOT NULL,
    locked boolean DEFAULT false NOT NULL,
    processed boolean DEFAULT false NOT NULL,
    disabled boolean DEFAULT false NOT NULL,
    priority integer DEFAULT 3,
    sysname character varying NOT NULL,
    author character varying NOT NULL,
    result character varying,
    delay timestamp with time zone,
    delaytime interval DEFAULT '00:01:00'::interval
);


ALTER TABLE public.squeue OWNER TO nms;

--
-- Name: squeue_group_sequence; Type: SEQUENCE; Schema: public; Owner: nms
--

CREATE SEQUENCE squeue_group_sequence
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.squeue_group_sequence OWNER TO nms;

--
-- Name: squeue_group_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
--

SELECT pg_catalog.setval('squeue_group_sequence', 21, true);


--
-- Name: squeue_sequence; Type: SEQUENCE; Schema: public; Owner: nms
--

CREATE SEQUENCE squeue_sequence
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.squeue_sequence OWNER TO nms;

--
-- Name: squeue_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
--

SELECT pg_catalog.setval('squeue_sequence', 901, true);


--
-- Name: stemppoll_sequence; Type: SEQUENCE; Schema: public; Owner: nms
--

CREATE SEQUENCE stemppoll_sequence
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.stemppoll_sequence OWNER TO nms;

--
-- Name: stemppoll_sequence; Type: SEQUENCE SET; Schema: public; Owner: nms
--

SELECT pg_catalog.setval('stemppoll_sequence', 182534, true);


SET default_with_oids = false;

--
-- Name: switches; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE switches (
    switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL,
    ip inet NOT NULL,
    sysname character varying NOT NULL,
    switchtype character varying NOT NULL,
    last_updated timestamp with time zone,
    locked boolean DEFAULT false NOT NULL,
    priority integer DEFAULT 0 NOT NULL,
    poll_frequency interval DEFAULT '00:05:00'::interval NOT NULL,
    community character varying DEFAULT 'public'::character varying NOT NULL
);


ALTER TABLE public.switches OWNER TO postgres;

--
-- Name: switches_switch_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE switches_switch_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.switches_switch_seq OWNER TO postgres;

--
-- Name: switches_switch_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('switches_switch_seq', 225, true);


--
-- Name: switchtypes; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE switchtypes (
    switchtype character varying NOT NULL,
    ports character varying NOT NULL,
    wide_counters boolean DEFAULT false NOT NULL
);


ALTER TABLE public.switchtypes OWNER TO postgres;

SET default_with_oids = true;

--
-- Name: temppoll; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE temppoll (
    id integer DEFAULT nextval(('stemppoll_sequence'::text)::regclass) NOT NULL,
    "time" timestamp without time zone NOT NULL,
    switch integer NOT NULL,
    "temp" double precision
);


ALTER TABLE public.temppoll OWNER TO postgres;

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

COPY cpuloadpoll (id, "time", switch, entity, value) FROM stdin;
5	2006-03-28 23:16:18.950263	1	5017	1
6	2006-03-28 23:16:18.970211	1	5001	3
7	2006-03-28 23:16:18.999445	1	2007	76
8	2006-03-28 23:16:19.018999	1	1056	3
9	2006-03-29 14:21:07.052914	1	5017	0
10	2006-03-29 14:21:07.07474	1	5001	4
11	2006-03-29 14:21:07.104667	1	2007	69
12	2006-03-29 14:21:07.125	1	1056	3
\.


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

COPY dhcp (switch, network, last_ack) FROM stdin;
151	81.162.53.0/26	2005-03-27 11:53:29
41	81.162.16.64/26	2005-03-27 11:53:35
164	81.162.57.64/26	2005-03-27 11:53:39
20	81.162.9.64/26	2005-03-27 11:54:27
4	81.162.4.0/26	2005-03-27 11:55:33
44	81.162.17.64/26	2005-03-27 11:56:37
194	81.162.67.64/26	2005-03-27 11:56:38
139	81.162.49.0/26	2005-03-27 11:57:08
46	81.162.18.0/26	2005-03-27 11:57:27
193	81.162.67.0/26	2005-03-27 11:57:36
27	81.162.11.128/26	2005-03-27 11:58:07
107	81.162.38.64/26	2005-03-27 11:58:31
133	81.162.47.0/26	2005-03-27 11:58:52
99	81.162.35.128/26	2005-03-27 11:59:09
79	81.162.29.0/26	2005-03-27 11:59:18
34	81.162.14.0/26	2005-03-27 11:59:28
51	81.162.19.128/26	2005-03-27 11:59:34
160	81.162.56.0/26	2005-03-27 12:00:01
196	81.162.68.0/26	2005-03-27 12:00:11
184	81.162.64.0/26	2005-03-27 12:01:48
9	81.162.5.128/26	2005-03-27 12:01:54
195	81.162.67.128/26	2005-03-27 12:02:18
123	81.162.43.128/26	2005-03-27 12:02:46
192	81.162.66.128/26	2005-03-27 12:03:09
212	81.162.203.0/24	2005-03-27 12:04:12
5	81.162.4.64/26	2005-03-27 12:04:14
113	81.162.40.64/26	2005-03-27 12:05:01
191	81.162.66.64/26	2005-03-27 12:05:01
119	81.162.42.64/26	2005-03-27 12:06:01
3	81.162.2.128/26	2005-03-27 12:06:03
74	81.162.27.64/26	2005-03-27 12:06:12
201	81.162.70.0/26	2005-03-27 12:06:25
86	81.162.31.64/26	2005-03-27 12:07:56
50	81.162.19.64/26	2005-03-27 12:08:36
59	81.162.22.64/26	2005-03-27 12:08:59
43	81.162.17.0/26	2005-03-27 12:09:02
80	81.162.29.64/26	2005-03-27 12:09:14
106	81.162.38.0/26	2005-03-27 12:09:15
52	81.162.20.0/26	2005-03-27 12:09:22
205	81.162.72.0/26	2005-03-27 12:10:08
82	81.162.30.0/26	2005-03-27 12:10:10
128	81.162.45.64/26	2005-03-27 12:10:38
112	81.162.40.0/26	2005-03-27 12:11:16
202	81.162.70.64/26	2005-03-27 12:12:30
6	81.162.4.128/26	2005-03-27 12:12:49
95	81.162.34.64/26	2005-03-27 12:13:02
178	81.162.62.0/26	2005-03-27 12:13:10
145	81.162.51.0/26	2005-03-27 12:13:15
84	81.162.30.128/26	2005-03-27 12:13:34
28	81.162.12.0/26	2005-03-27 12:13:58
22	81.162.10.0/26	2005-03-27 12:14:40
122	81.162.43.64/26	2005-03-27 12:14:57
85	81.162.31.0/26	2005-03-27 12:15:21
18	81.162.8.128/26	2005-03-27 12:15:24
105	81.162.37.128/26	2005-03-27 12:15:24
81	81.162.29.128/26	2005-03-27 12:15:36
77	81.162.28.64/26	2005-03-27 12:15:47
146	81.162.51.64/26	2005-03-27 12:17:09
24	81.162.10.128/26	2005-03-27 12:17:10
190	81.162.66.0/26	2005-03-27 12:17:10
33	81.162.13.128/26	2005-03-27 12:17:17
150	81.162.52.128/26	2005-03-27 12:17:27
57	81.162.21.128/26	2005-03-27 12:17:37
17	81.162.8.64/26	2005-03-27 12:17:39
54	81.162.20.128/26	2005-03-27 12:18:24
94	81.162.34.0/26	2005-03-27 12:18:24
69	81.162.25.128/26	2005-03-27 12:18:26
141	81.162.49.128/26	2005-03-27 12:18:43
154	81.162.54.0/26	2005-03-27 12:19:25
177	81.162.61.128/26	2005-03-27 12:20:17
29	81.162.12.64/26	2005-03-27 12:20:37
91	81.162.33.0/26	2005-03-27 12:20:53
83	81.162.30.64/26	2005-03-27 12:20:57
47	81.162.18.64/26	2005-03-27 12:21:10
170	81.162.59.64/26	2005-03-27 12:22:01
78	81.162.28.128/26	2005-03-27 12:22:26
155	81.162.54.64/26	2005-03-27 12:23:11
35	81.162.14.64/26	2005-03-27 12:23:12
32	81.162.13.64/26	2005-03-27 12:23:55
199	81.162.69.64/26	2005-03-27 12:24:13
63	81.162.23.128/26	2005-03-27 12:24:33
90	81.162.32.128/26	2005-03-27 12:25:31
114	81.162.40.128/26	2005-03-27 12:26:04
75	81.162.27.128/26	2005-03-27 12:26:06
42	81.162.16.128/26	2005-03-27 12:26:26
87	81.162.31.128/26	2005-03-27 12:26:42
67	81.162.25.0/26	2005-03-27 12:27:31
204	81.162.71.128/26	2005-03-27 12:34:04
200	81.162.69.128/26	2005-03-27 12:37:19
207	81.162.73.64/26	2005-03-27 12:41:57
203	81.162.71.64/26	2005-03-27 12:58:48
214	81.162.213.0/24	2005-03-27 13:02:26
213	81.162.213.0/24	2005-03-27 13:02:26
209	81.162.212.0/24	2005-03-27 13:16:02
215	81.162.200.0/24	2005-03-27 13:16:14
210	81.162.250.0/24	2005-03-27 13:18:02
211	81.162.252.0/24	2005-03-27 12:39:02
129	81.162.45.128/26	2005-03-27 10:44:11
110	81.162.39.64/26	2005-03-27 08:19:17
10	81.162.6.0/26	2005-03-27 08:35:15
171	81.162.59.128/26	2005-03-27 08:42:52
167	81.162.58.64/26	2005-03-27 09:07:47
180	81.162.62.128/26	2005-03-27 09:22:15
140	81.162.49.64/26	2005-03-27 09:41:51
103	81.162.37.0/26	2005-03-27 09:42:30
55	81.162.21.0/26	2005-03-27 09:42:54
137	81.162.48.64/26	2005-03-27 09:47:06
62	81.162.23.64/26	2005-03-27 09:51:30
158	81.162.55.64/26	2005-03-27 09:51:55
70	81.162.26.0/26	2005-03-27 09:52:09
159	81.162.55.128/26	2005-03-27 10:05:56
165	81.162.57.128/26	2005-03-27 10:09:30
125	81.162.44.64/26	2005-03-27 10:10:14
169	81.162.59.0/26	2005-03-27 10:10:29
89	81.162.32.64/26	2005-03-27 10:11:14
168	81.162.58.128/26	2005-03-27 10:11:42
39	81.162.15.128/26	2005-03-27 10:11:49
134	81.162.47.64/26	2005-03-27 10:12:00
144	81.162.50.128/26	2005-03-27 10:15:46
61	81.162.23.0/26	2005-03-27 10:19:36
186	81.162.64.128/26	2005-03-27 10:24:08
97	81.162.35.0/26	2005-03-27 10:26:13
124	81.162.44.0/26	2005-03-27 10:28:37
162	81.162.56.128/26	2005-03-27 10:36:33
76	81.162.28.0/26	2005-03-27 10:38:20
156	81.162.54.128/26	2005-03-27 10:41:07
93	81.162.33.128/26	2005-03-27 10:42:16
58	81.162.22.0/26	2005-03-27 10:42:50
23	81.162.10.64/26	2005-03-27 10:43:27
132	81.162.46.128/26	2005-03-27 10:46:35
118	81.162.42.0/26	2005-03-27 10:47:16
16	81.162.8.0/26	2005-03-27 10:47:53
182	81.162.63.64/26	2005-03-27 10:47:58
88	81.162.32.0/26	2005-03-27 10:49:28
126	81.162.44.128/26	2005-03-27 10:50:02
130	81.162.46.0/26	2005-03-27 10:50:46
15	81.162.7.128/26	2005-03-27 10:54:20
12	81.162.6.128/26	2005-03-27 10:54:40
98	81.162.35.64/26	2005-03-27 10:55:15
104	81.162.37.64/26	2005-03-27 10:57:11
100	81.162.36.0/26	2005-03-27 10:58:55
45	81.162.17.128/26	2005-03-27 11:02:32
131	81.162.46.64/26	2005-03-27 11:04:23
175	81.162.61.0/26	2005-03-27 11:04:47
72	81.162.26.128/26	2005-03-27 11:04:50
148	81.162.52.0/26	2005-03-27 11:05:19
198	81.162.68.128/26	2005-03-27 11:06:42
68	81.162.25.64/26	2005-03-27 11:06:55
115	81.162.41.0/26	2005-03-27 11:08:58
157	81.162.55.0/26	2005-03-27 11:10:30
111	81.162.39.128/26	2005-03-27 11:11:10
120	81.162.42.128/26	2005-03-27 10:14:01
21	81.162.9.128/26	2005-03-27 10:39:11
64	81.162.24.0/26	2005-03-27 11:14:54
7	81.162.5.0/26	2005-03-27 11:15:07
163	81.162.57.0/26	2005-03-27 11:18:50
208	81.162.73.128/26	2005-03-27 11:18:53
189	81.162.65.128/26	2005-03-27 11:20:12
197	81.162.68.64/26	2005-03-27 11:20:46
31	81.162.13.0/26	2005-03-27 11:22:31
19	81.162.9.0/26	2005-03-27 11:22:48
13	81.162.7.0/26	2005-03-27 11:24:35
147	81.162.51.128/26	2005-03-27 11:27:37
135	81.162.47.128/26	2005-03-27 11:28:43
121	81.162.43.0/26	2005-03-27 11:28:58
136	81.162.48.0/26	2005-03-27 11:31:04
66	81.162.24.128/26	2005-03-27 11:32:10
166	81.162.58.0/26	2005-03-27 09:25:55
138	81.162.48.128/26	2005-03-27 10:08:33
56	81.162.21.64/26	2005-03-27 11:32:34
143	81.162.50.64/26	2005-03-27 11:33:03
176	81.162.61.64/26	2005-03-27 11:33:36
65	81.162.24.64/26	2005-03-27 11:33:40
102	81.162.36.128/26	2005-03-27 11:34:00
116	81.162.41.64/26	2005-03-27 11:34:56
183	81.162.63.128/26	2005-03-27 11:36:02
109	81.162.39.0/26	2005-03-27 11:36:45
25	81.162.11.0/26	2005-03-27 11:37:44
174	81.162.60.128/26	2005-03-27 11:38:11
216	81.162.202.0/24	2005-03-27 11:39:03
40	81.162.16.0/26	2005-03-27 11:39:31
152	81.162.53.64/26	2005-03-27 11:39:47
14	81.162.7.64/26	2005-03-27 11:39:59
92	81.162.33.64/26	2005-03-27 11:40:05
173	81.162.60.64/26	2005-03-27 11:40:28
48	81.162.18.128/26	2005-03-27 11:40:28
8	81.162.5.64/26	2005-03-27 11:40:45
108	81.162.38.128/26	2005-03-27 11:42:43
11	81.162.6.64/26	2005-03-27 08:50:50
188	81.162.65.64/26	2005-03-27 08:55:21
117	81.162.41.128/26	2005-03-27 09:23:35
26	81.162.11.64/26	2005-03-27 11:43:18
172	81.162.60.0/26	2005-03-27 11:43:21
71	81.162.26.64/26	2005-03-27 11:43:51
38	81.162.15.64/26	2005-03-27 11:44:11
153	81.162.53.128/26	2005-03-27 11:45:51
53	81.162.20.64/26	2005-03-27 11:46:24
1	81.162.2.0/26	2005-03-27 11:47:03
2	81.162.2.64/26	2005-03-27 11:47:10
149	81.162.52.64/26	2005-03-27 11:48:35
37	81.162.15.0/26	2005-03-27 11:49:04
127	81.162.45.0/26	2005-03-27 11:49:22
179	81.162.62.64/26	2005-03-27 11:49:48
185	81.162.64.64/26	2005-03-27 11:50:36
142	81.162.50.0/26	2005-03-27 11:51:18
36	81.162.14.128/26	2005-03-27 11:51:19
30	81.162.12.128/26	2005-03-27 11:51:20
60	81.162.22.128/26	2005-03-27 11:52:08
49	81.162.19.0/26	2005-03-27 10:22:15
73	81.162.27.0/26	2005-03-27 11:27:55
96	81.162.34.128/26	2005-03-27 11:32:26
101	81.162.36.64/26	2005-03-27 11:40:47
181	81.162.63.0/26	2005-03-27 11:52:55
187	81.162.65.0/26	2005-03-27 11:53:23
161	81.162.56.64/26	2005-03-27 08:54:44
\.


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

COPY placements (switch, placement) FROM stdin;
221	(375,325),(350,300)
222	(550,325),(525,300)
224	(775,325),(750,300)
223	(875,325),(850,300)
225	(675,325),(650,300)
218	(980,550),(930,520)
1	(306,306),(294,256)
2	(306,256),(294,206)
3	(306,206),(294,156)
4	(325,306),(313,256)
5	(325,256),(313,206)
6	(325,206),(313,156)
7	(344,470),(332,422)
8	(344,422),(332,374)
9	(344,374),(332,326)
10	(344,306),(332,256)
11	(344,256),(332,206)
12	(344,206),(332,156)
13	(363,470),(351,422)
14	(363,422),(351,374)
15	(363,374),(351,326)
16	(363,306),(351,256)
17	(363,256),(351,206)
18	(363,206),(351,156)
19	(382,470),(370,422)
20	(382,422),(370,374)
21	(382,374),(370,326)
22	(382,306),(370,256)
23	(382,256),(370,206)
24	(382,206),(370,156)
25	(400,470),(388,422)
26	(400,422),(388,374)
27	(400,374),(388,326)
28	(400,306),(388,256)
29	(400,256),(388,206)
30	(400,206),(388,156)
31	(419,470),(407,422)
32	(419,422),(407,374)
33	(419,374),(407,326)
34	(419,306),(407,256)
35	(419,256),(407,206)
36	(419,206),(407,156)
37	(438,470),(426,422)
38	(438,422),(426,374)
39	(438,374),(426,326)
40	(438,306),(426,256)
41	(438,256),(426,206)
42	(438,206),(426,156)
43	(457,470),(445,422)
44	(457,422),(445,374)
45	(457,374),(445,326)
46	(457,306),(445,256)
47	(457,256),(445,206)
48	(457,206),(445,156)
49	(483,470),(471,422)
50	(483,422),(471,374)
51	(483,374),(471,326)
52	(483,306),(471,256)
53	(483,256),(471,206)
54	(483,206),(471,156)
55	(502,470),(490,422)
56	(502,422),(490,374)
57	(502,374),(490,326)
58	(502,306),(490,256)
59	(502,256),(490,206)
60	(502,206),(490,156)
61	(521,470),(509,422)
62	(521,422),(509,374)
63	(521,374),(509,326)
64	(521,306),(509,256)
65	(521,256),(509,206)
66	(521,206),(509,156)
67	(540,470),(528,422)
68	(540,422),(528,374)
69	(540,374),(528,326)
70	(540,306),(528,256)
71	(540,256),(528,206)
72	(540,206),(528,156)
73	(559,470),(547,422)
74	(559,422),(547,374)
75	(559,374),(547,326)
76	(559,306),(547,256)
77	(559,256),(547,206)
78	(559,206),(547,156)
79	(578,470),(566,422)
80	(578,422),(566,374)
81	(578,374),(566,326)
82	(578,306),(566,256)
83	(578,256),(566,206)
84	(578,206),(566,156)
85	(596,470),(584,422)
86	(596,422),(584,374)
87	(596,374),(584,326)
88	(596,306),(584,256)
89	(596,256),(584,206)
90	(596,206),(584,156)
91	(615,470),(603,422)
92	(615,422),(603,374)
93	(615,374),(603,326)
94	(615,306),(603,256)
95	(615,256),(603,206)
96	(615,206),(603,156)
97	(648,470),(636,422)
98	(648,422),(636,374)
99	(648,374),(636,326)
100	(648,306),(636,256)
101	(648,256),(636,206)
102	(648,206),(636,156)
103	(667,470),(655,422)
104	(667,422),(655,374)
105	(667,374),(655,326)
106	(667,306),(655,256)
107	(667,256),(655,206)
108	(667,206),(655,156)
109	(686,470),(674,422)
110	(686,422),(674,374)
111	(686,374),(674,326)
112	(686,306),(674,256)
113	(686,256),(674,206)
114	(686,206),(674,156)
115	(705,470),(693,422)
116	(705,422),(693,374)
117	(705,374),(693,326)
118	(705,306),(693,256)
119	(705,256),(693,206)
120	(705,206),(693,156)
121	(724,470),(712,422)
122	(724,422),(712,374)
123	(724,374),(712,326)
124	(724,306),(712,256)
125	(724,256),(712,206)
126	(724,206),(712,156)
127	(743,470),(731,422)
128	(743,422),(731,374)
129	(743,374),(731,326)
130	(743,306),(731,256)
131	(743,256),(731,206)
132	(743,206),(731,156)
133	(762,470),(750,422)
134	(762,422),(750,374)
135	(762,374),(750,326)
136	(762,306),(750,256)
137	(762,256),(750,206)
138	(762,206),(750,156)
139	(781,470),(769,422)
140	(781,422),(769,374)
141	(781,374),(769,326)
142	(781,306),(769,256)
143	(781,256),(769,206)
144	(781,206),(769,156)
145	(808,470),(796,422)
146	(808,422),(796,374)
147	(808,374),(796,326)
148	(808,306),(796,256)
149	(808,256),(796,206)
150	(808,206),(796,156)
151	(827,470),(815,422)
152	(827,422),(815,374)
153	(827,374),(815,326)
154	(827,306),(815,256)
155	(827,256),(815,206)
156	(827,206),(815,156)
157	(846,470),(834,422)
158	(846,422),(834,374)
159	(846,374),(834,326)
160	(846,306),(834,256)
161	(846,256),(834,206)
162	(846,206),(834,156)
163	(865,470),(853,422)
164	(865,422),(853,374)
165	(865,374),(853,326)
166	(865,306),(853,256)
167	(865,256),(853,206)
168	(865,206),(853,156)
169	(884,470),(872,422)
170	(884,422),(872,374)
171	(884,374),(872,326)
172	(884,306),(872,256)
173	(884,256),(872,206)
174	(884,206),(872,156)
175	(903,470),(891,422)
176	(903,422),(891,374)
177	(903,374),(891,326)
178	(903,306),(891,256)
179	(903,256),(891,206)
180	(903,206),(891,156)
181	(922,470),(910,422)
182	(922,422),(910,374)
183	(922,374),(910,326)
184	(922,306),(910,256)
185	(922,256),(910,206)
186	(922,206),(910,156)
187	(941,470),(929,422)
188	(941,422),(929,374)
189	(941,374),(929,326)
190	(941,306),(929,256)
191	(941,256),(929,206)
192	(941,206),(929,156)
193	(960,470),(948,422)
194	(960,422),(948,374)
195	(960,374),(948,326)
196	(960,306),(948,256)
197	(960,256),(948,206)
198	(960,206),(948,156)
199	(988,422),(976,374)
200	(988,374),(976,326)
201	(979,306),(967,256)
202	(979,256),(967,206)
203	(1006,422),(994,374)
204	(1006,374),(994,326)
205	(997,306),(985,256)
207	(1025,422),(1013,374)
208	(1025,374),(1013,326)
209	(1125,225),(1100,200)
210	(680,550),(630,520)
211	(610,550),(560,520)
212	(305,385),(270,350)
213	(900,100),(800,75)
214	(900,100),(800,75)
215	(200,270),(170,240)
216	(250,180),(220,150)
\.


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

COPY polls ("time", switch, port, bytes_in, bytes_out) FROM stdin;
2006-03-28 22:39:09.893643+02	1	1	0	0
2006-03-28 22:39:09.913546+02	1	2	0	0
2006-03-28 22:39:09.933906+02	1	3	0	0
2006-03-28 22:39:09.953638+02	1	4	0	0
2006-03-28 22:39:09.973536+02	1	5	0	0
2006-03-28 22:39:09.993418+02	1	6	0	0
2006-03-28 22:39:10.013146+02	1	7	0	0
2006-03-28 22:39:10.032774+02	1	8	0	0
2006-03-28 22:39:10.052348+02	1	9	0	0
2006-03-28 22:39:10.072177+02	1	10	0	0
2006-03-28 22:39:10.092731+02	1	11	0	0
2006-03-28 22:39:10.11247+02	1	12	0	0
2006-03-28 22:39:10.132382+02	1	13	7747123	14112208
2006-03-28 22:39:10.152582+02	1	14	7713082	14042766
2006-03-28 22:39:10.172369+02	1	15	8056118	17207110
2006-03-28 22:39:10.192118+02	1	16	0	0
2006-03-28 22:39:10.212055+02	1	17	0	0
2006-03-28 22:39:10.231483+02	1	18	0	0
2006-03-28 22:39:10.251181+02	1	19	138414013	203348896
2006-03-28 22:39:10.271767+02	1	20	199834250	208491729
2006-03-28 22:39:10.29177+02	1	21	6357743	13961928
2006-03-28 22:39:10.311587+02	1	22	0	0
2006-03-28 22:39:10.331091+02	1	23	0	0
2006-03-28 22:39:10.350932+02	1	24	0	0
2006-03-28 22:39:10.370631+02	1	25	0	0
2006-03-28 22:39:10.390715+02	1	26	0	0
2006-03-28 22:39:10.410346+02	1	27	0	0
2006-03-28 22:39:10.430225+02	1	28	0	0
2006-03-28 22:39:10.450417+02	1	29	0	0
2006-03-28 22:39:10.471318+02	1	30	0	0
2006-03-28 22:39:10.490967+02	1	31	0	0
2006-03-28 22:39:10.511826+02	1	32	0	0
2006-03-28 22:39:10.53276+02	1	33	0	0
2006-03-28 22:39:10.553075+02	1	34	0	0
2006-03-28 22:39:10.573845+02	1	35	0	0
2006-03-28 22:39:10.595012+02	1	36	0	0
2006-03-28 22:39:10.615023+02	1	37	0	0
2006-03-28 22:39:10.634971+02	1	38	0	0
2006-03-28 22:39:10.654731+02	1	39	0	0
2006-03-28 22:39:10.686279+02	1	40	0	0
2006-03-28 22:39:10.705889+02	1	41	0	0
2006-03-28 22:39:10.72543+02	1	42	0	0
2006-03-28 22:39:10.745098+02	1	43	0	0
2006-03-28 22:39:10.764735+02	1	44	0	0
2006-03-28 22:39:10.784882+02	1	45	0	0
2006-03-28 22:39:10.804477+02	1	46	816	976127
2006-03-28 22:39:10.82424+02	1	47	748	503124
2006-03-28 22:39:10.843866+02	1	48	816	276935
2006-03-28 22:39:10.863439+02	1	49	2890	2890
2006-03-28 22:39:10.883028+02	1	50	210	210
2006-03-28 22:39:10.90281+02	1	51	210	210
2006-03-28 22:39:10.922442+02	1	52	210	210
2006-03-28 22:39:10.942226+02	1	53	210	210
2006-03-28 22:39:10.96199+02	1	54	210	210
2006-03-28 22:39:10.983951+02	1	55	210	210
2006-03-28 22:39:11.003594+02	1	56	210	210
2006-03-28 22:39:11.023272+02	1	57	1058	1058
2006-03-28 22:39:11.043103+02	1	58	210	210
2006-03-28 22:39:11.062924+02	1	59	210	210
2006-03-28 22:39:11.083132+02	1	60	210	210
2006-03-28 22:39:11.103073+02	1	61	210	210
2006-03-28 22:39:11.123076+02	1	62	370389	1367489
2006-03-28 22:39:11.142765+02	1	63	210	535911
2006-03-28 22:39:11.162409+02	1	64	210	243777
2006-03-28 22:39:11.18224+02	1	65	228	5275950
2006-03-28 22:39:11.202296+02	1	66	7020	164802316
2006-03-28 22:39:11.221934+02	1	67	0	0
2006-03-28 22:39:11.24138+02	1	68	0	0
2006-03-28 22:39:11.260987+02	1	69	0	0
2006-03-28 22:39:11.280526+02	1	70	0	0
2006-03-28 22:39:11.300239+02	1	71	228	228
2006-03-28 22:39:11.319742+02	1	72	146	5274588
2006-03-28 22:39:11.339383+02	1	73	240	240
2006-03-28 22:39:11.35914+02	1	74	240	240
2006-03-28 22:39:11.378792+02	1	75	240	240
2006-03-28 22:39:11.398351+02	1	76	240	240
2006-03-28 22:39:11.41811+02	1	77	240	240
2006-03-28 22:39:11.437892+02	1	78	240	240
2006-03-28 22:39:11.457433+02	1	79	0	0
2006-03-28 22:39:11.477388+02	1	80	4286507245	3471154200
2006-03-28 22:39:11.497485+02	1	81	146	146
2006-03-28 22:39:11.517205+02	1	82	0	0
2006-03-28 22:39:11.536948+02	1	83	146	146
2006-03-28 22:39:11.556906+02	1	84	0	0
2006-03-28 22:39:11.576549+02	1	85	0	0
2006-03-28 22:39:11.597038+02	1	86	0	0
2006-03-28 22:39:11.616963+02	1	87	0	0
2006-03-28 22:39:11.636499+02	1	88	0	0
2006-03-28 22:39:11.656367+02	1	89	0	0
2006-03-28 22:39:11.67601+02	1	90	0	0
2006-03-28 22:39:11.696501+02	1	91	0	0
2006-03-28 22:39:11.715967+02	1	92	0	0
2006-03-28 22:39:11.735507+02	1	93	0	0
2006-03-28 22:39:11.755479+02	1	94	0	0
2006-03-28 22:39:11.775257+02	1	95	0	0
2006-03-28 22:39:11.795138+02	1	96	0	0
2006-03-28 22:39:11.815197+02	1	97	240	1620567769
2006-03-28 22:39:11.834833+02	1	98	39356	122027824
2006-03-28 22:39:11.854636+02	1	99	9234	1182439
2006-03-28 22:39:11.874374+02	1	100	240	28805070
2006-03-28 22:39:11.894428+02	1	101	240	1096957
2006-03-28 22:39:11.91458+02	1	102	620	619669
2006-03-28 22:39:11.934683+02	1	103	0	0
2006-03-28 22:39:11.954545+02	1	104	2746281650	1380471316
2006-03-28 22:39:11.974981+02	1	105	0	0
2006-03-28 22:39:11.994707+02	1	106	0	0
2006-03-28 22:39:12.016469+02	1	107	0	0
2006-03-28 22:39:12.036156+02	1	108	154278739	16885365
2006-03-28 22:39:12.055859+02	1	109	0	953869
2006-03-28 22:39:12.075687+02	1	110	11485	93069
2006-03-28 22:39:12.095999+02	1	111	17993418	93133
2006-03-28 22:39:12.1156+02	1	112	5310060	6561837
2006-03-28 22:39:12.135708+02	1	113	0	97485
2006-03-28 22:39:12.155377+02	1	114	0	0
2006-03-28 22:39:12.174924+02	1	115	0	93133
2006-03-28 22:39:12.195017+02	1	116	0	93133
2006-03-28 22:39:12.214711+02	1	117	40502	130091
2006-03-28 22:39:12.234355+02	1	118	0	0
2006-03-28 22:39:12.253895+02	1	119	1440	1440
2006-03-28 22:39:12.273878+02	1	120	49930	1774299728
2006-03-28 22:39:12.383056+02	1	121	7476090	7476090
2006-03-28 22:39:12.403941+02	1	122	0	0
2006-03-28 22:39:12.424965+02	1	123	0	0
2006-03-28 22:45:50.691773+02	1	1	0	0
2006-03-28 22:45:50.712108+02	1	2	0	0
2006-03-28 22:45:50.732551+02	1	3	0	0
2006-03-28 22:45:50.752709+02	1	4	0	0
2006-03-28 22:45:50.772544+02	1	5	0	0
2006-03-28 22:45:50.792215+02	1	6	0	0
2006-03-28 22:45:50.811996+02	1	7	0	0
2006-03-28 22:45:50.838285+02	1	8	0	0
2006-03-28 22:45:50.859209+02	1	9	0	0
2006-03-28 22:45:50.879008+02	1	10	0	0
2006-03-28 22:45:50.899314+02	1	11	0	0
2006-03-28 22:45:50.918892+02	1	12	0	0
2006-03-28 22:45:50.938681+02	1	13	7781011	14166925
2006-03-28 22:45:50.958276+02	1	14	7742093	14093748
2006-03-28 22:45:50.978192+02	1	15	8089140	17260526
2006-03-28 22:45:50.998131+02	1	16	0	0
2006-03-28 22:45:51.017874+02	1	17	0	0
2006-03-28 22:45:51.037875+02	1	18	0	0
2006-03-28 22:45:51.057617+02	1	19	138442049	203409365
2006-03-28 22:45:51.07741+02	1	20	199872795	208568010
2006-03-28 22:45:51.09707+02	1	21	6385320	14021490
2006-03-28 22:45:51.116944+02	1	22	0	0
2006-03-28 22:45:51.136723+02	1	23	0	0
2006-03-28 22:45:51.156402+02	1	24	0	0
2006-03-28 22:46:04.439098+02	1	1	0	0
2006-03-28 22:46:04.459636+02	1	2	0	0
2006-03-28 22:46:04.479286+02	1	3	0	0
2006-03-28 22:46:04.498935+02	1	4	0	0
2006-03-28 22:46:04.5186+02	1	5	0	0
2006-03-28 22:46:04.538232+02	1	6	0	0
2006-03-28 22:46:04.55788+02	1	7	0	0
2006-03-28 22:46:04.577626+02	1	8	0	0
2006-03-28 22:46:04.597683+02	1	9	0	0
2006-03-28 22:46:04.617111+02	1	10	0	0
2006-03-28 22:46:04.637422+02	1	11	0	0
2006-03-28 22:46:04.657219+02	1	12	0	0
2006-03-28 22:46:04.67687+02	1	13	7781329	14167539
2006-03-28 22:46:04.696741+02	1	14	7742221	14094648
2006-03-28 22:46:04.716788+02	1	15	8089268	17261268
2006-03-28 22:46:04.736581+02	1	16	0	0
2006-03-28 22:46:04.756341+02	1	17	0	0
2006-03-28 22:46:04.775933+02	1	18	0	0
2006-03-28 22:46:04.795543+02	1	19	138442495	203409877
2006-03-28 22:46:04.815504+02	1	20	199872859	208568458
2006-03-28 22:46:04.835122+02	1	21	6385384	14022032
2006-03-28 22:46:04.855403+02	1	22	0	0
2006-03-28 22:46:04.875114+02	1	23	0	0
2006-03-28 22:46:04.895722+02	1	24	0	0
2006-03-28 23:04:10.517298+02	1	1	0	0
2006-03-28 23:04:10.537186+02	1	2	0	0
2006-03-28 23:04:10.556902+02	1	3	0	0
2006-03-28 23:04:10.576559+02	1	4	0	0
2006-03-28 23:04:10.596516+02	1	5	0	0
2006-03-28 23:04:10.617152+02	1	6	0	0
2006-03-28 23:04:10.636818+02	1	7	0	0
2006-03-28 23:04:10.656596+02	1	8	0	0
2006-03-28 23:04:10.676103+02	1	9	0	0
2006-03-28 23:04:10.696325+02	1	10	0	0
2006-03-28 23:04:10.716109+02	1	11	0	0
2006-03-28 23:04:10.736552+02	1	12	0	0
2006-03-28 23:04:10.75648+02	1	13	7856336	14296955
2006-03-28 23:04:10.776391+02	1	14	7823592	14228507
2006-03-28 23:04:10.796099+02	1	15	8167545	17392530
2006-03-28 23:04:10.816284+02	1	16	0	0
2006-03-28 23:04:10.836317+02	1	17	0	0
2006-03-28 23:04:10.855804+02	1	18	0	0
2006-03-28 23:04:10.876015+02	1	19	138516087	203568321
2006-03-28 23:04:10.896711+02	1	20	199973797	208768486
2006-03-28 23:04:10.916745+02	1	21	6458453	14179252
2006-03-28 23:04:10.937118+02	1	22	0	0
2006-03-28 23:04:10.956641+02	1	23	0	0
2006-03-28 23:04:10.976821+02	1	24	0	0
2006-03-28 23:04:38.934053+02	1	1	0	0
2006-03-28 23:04:38.95404+02	1	2	0	0
2006-03-28 23:04:38.973763+02	1	3	0	0
2006-03-28 23:04:38.993548+02	1	4	0	0
2006-03-28 23:04:39.013146+02	1	5	0	0
2006-03-28 23:04:39.032762+02	1	6	0	0
2006-03-28 23:04:39.05292+02	1	7	0	0
2006-03-28 23:04:39.073058+02	1	8	0	0
2006-03-28 23:04:39.093076+02	1	9	0	0
2006-03-28 23:04:39.112943+02	1	10	0	0
2006-03-28 23:04:39.142183+02	1	11	0	0
2006-03-28 23:04:39.16179+02	1	12	0	0
2006-03-28 23:04:39.181511+02	1	13	7857656	14300001
2006-03-28 23:04:39.201421+02	1	14	7825006	14231647
2006-03-28 23:04:39.221197+02	1	15	8169119	17395512
2006-03-28 23:04:39.24095+02	1	16	0	0
2006-03-28 23:04:39.260593+02	1	17	0	0
2006-03-28 23:04:39.28024+02	1	18	0	0
2006-03-28 23:04:39.300251+02	1	19	138516907	203572473
2006-03-28 23:04:39.320172+02	1	20	199974935	208772794
2006-03-28 23:04:39.340547+02	1	21	6459209	14183340
2006-03-28 23:04:39.36032+02	1	22	0	0
2006-03-28 23:04:39.379996+02	1	23	0	0
2006-03-28 23:04:39.399682+02	1	24	0	0
2006-03-28 23:08:25.811543+02	1	1	0	0
2006-03-28 23:08:25.832178+02	1	2	0	0
2006-03-28 23:08:25.851821+02	1	3	0	0
2006-03-28 23:08:25.871447+02	1	4	0	0
2006-03-28 23:08:25.891095+02	1	5	0	0
2006-03-28 23:08:25.911042+02	1	6	0	0
2006-03-28 23:08:25.930796+02	1	7	0	0
2006-03-28 23:08:25.950443+02	1	8	0	0
2006-03-28 23:08:25.970441+02	1	9	0	0
2006-03-28 23:08:25.990093+02	1	10	0	0
2006-03-28 23:08:26.009844+02	1	11	0	0
2006-03-28 23:08:26.029585+02	1	12	0	0
2006-03-28 23:08:26.04914+02	1	13	7876029	14330508
2006-03-28 23:08:26.068755+02	1	14	7842402	14260671
2006-03-28 23:08:26.088424+02	1	15	8186302	17425712
2006-03-28 23:08:26.108129+02	1	16	0	0
2006-03-28 23:08:26.128018+02	1	17	0	0
2006-03-28 23:08:26.147692+02	1	18	0	0
2006-03-28 23:08:26.167393+02	1	19	138532007	203604699
2006-03-28 23:08:26.187095+02	1	20	199996249	208814508
2006-03-28 23:08:26.206925+02	1	21	6474499	14215586
2006-03-28 23:08:26.226462+02	1	22	0	0
2006-03-28 23:08:26.246118+02	1	23	0	0
2006-03-28 23:08:26.265827+02	1	24	0	0
2006-03-28 23:09:33.136981+02	1	1	0	0
2006-03-28 23:09:33.15741+02	1	2	0	0
2006-03-28 23:09:33.177081+02	1	3	0	0
2006-03-28 23:09:33.196591+02	1	4	0	0
2006-03-28 23:09:33.216282+02	1	5	0	0
2006-03-28 23:09:33.235922+02	1	6	0	0
2006-03-28 23:09:33.255785+02	1	7	0	0
2006-03-28 23:09:33.27593+02	1	8	0	0
2006-03-28 23:09:33.295795+02	1	9	0	0
2006-03-28 23:09:33.3154+02	1	10	0	0
2006-03-28 23:09:33.337366+02	1	11	0	0
2006-03-28 23:09:33.357016+02	1	12	0	0
2006-03-28 23:09:33.376724+02	1	13	7880337	14338168
2006-03-28 23:09:33.396546+02	1	14	7845454	14268425
2006-03-28 23:09:33.416402+02	1	15	8189578	17433278
2006-03-28 23:09:33.436008+02	1	16	0	0
2006-03-28 23:09:33.455964+02	1	17	0	0
2006-03-28 23:09:33.475705+02	1	18	0	0
2006-03-28 23:09:33.495599+02	1	19	138538669	203617075
2006-03-28 23:09:33.515334+02	1	20	200004048	208829958
2006-03-28 23:09:33.535467+02	1	21	6478630	14226719
2006-03-28 23:09:33.556044+02	1	22	0	0
2006-03-28 23:09:33.575656+02	1	23	0	0
2006-03-28 23:09:33.595203+02	1	24	0	0
2006-03-28 23:09:35.995013+02	1	1	0	0
2006-03-28 23:09:36.014831+02	1	2	0	0
2006-03-28 23:09:36.035206+02	1	3	0	0
2006-03-28 23:09:36.054957+02	1	4	0	0
2006-03-28 23:09:36.074448+02	1	5	0	0
2006-03-28 23:09:36.094459+02	1	6	0	0
2006-03-28 23:09:36.114187+02	1	7	0	0
2006-03-28 23:09:36.134162+02	1	8	0	0
2006-03-28 23:09:36.153924+02	1	9	0	0
2006-03-28 23:09:36.173467+02	1	10	0	0
2006-03-28 23:09:36.192962+02	1	11	0	0
2006-03-28 23:09:36.212584+02	1	12	0	0
2006-03-28 23:09:36.232421+02	1	13	7880337	14338168
2006-03-28 23:09:36.252247+02	1	14	7845454	14268425
2006-03-28 23:09:36.271956+02	1	15	8189578	17433278
2006-03-28 23:09:36.291855+02	1	16	0	0
2006-03-28 23:09:36.311497+02	1	17	0	0
2006-03-28 23:09:36.331351+02	1	18	0	0
2006-03-28 23:09:36.351106+02	1	19	138538669	203617075
2006-03-28 23:09:36.371495+02	1	20	200004048	208829958
2006-03-28 23:09:36.391472+02	1	21	6478630	14226719
2006-03-28 23:09:36.411218+02	1	22	0	0
2006-03-28 23:09:36.432314+02	1	23	0	0
2006-03-28 23:09:36.452165+02	1	24	0	0
2006-03-28 23:15:40.752379+02	1	1	0	0
2006-03-28 23:15:40.772684+02	1	2	0	0
2006-03-28 23:15:40.792228+02	1	3	0	0
2006-03-28 23:15:40.811814+02	1	4	0	0
2006-03-28 23:15:40.83156+02	1	5	0	0
2006-03-28 23:15:40.851352+02	1	6	0	0
2006-03-28 23:15:40.870986+02	1	7	0	0
2006-03-28 23:15:40.890991+02	1	8	0	0
2006-03-28 23:15:40.911205+02	1	9	0	0
2006-03-28 23:15:40.931349+02	1	10	0	0
2006-03-28 23:15:40.951733+02	1	11	0	0
2006-03-28 23:15:40.971545+02	1	12	0	0
2006-03-28 23:15:40.991322+02	1	13	7911314	14387025
2006-03-28 23:15:41.010894+02	1	14	7871637	14313012
2006-03-28 23:15:41.031336+02	1	15	8219073	17479349
2006-03-28 23:15:41.051693+02	1	16	0	0
2006-03-28 23:15:41.071363+02	1	17	0	0
2006-03-28 23:15:41.091194+02	1	18	0	0
2006-03-28 23:15:41.111185+02	1	19	138562273	203670334
2006-03-28 23:15:41.131322+02	1	20	200037822	208897207
2006-03-28 23:15:41.15099+02	1	21	6502475	14279258
2006-03-28 23:15:41.171033+02	1	22	0	0
2006-03-28 23:15:41.190836+02	1	23	0	0
2006-03-28 23:15:41.210909+02	1	24	0	0
2006-03-28 23:16:18.461384+02	1	1	0	0
2006-03-28 23:16:18.481697+02	1	2	0	0
2006-03-28 23:16:18.501411+02	1	3	0	0
2006-03-28 23:16:18.521355+02	1	4	0	0
2006-03-28 23:16:18.541475+02	1	5	0	0
2006-03-28 23:16:18.561151+02	1	6	0	0
2006-03-28 23:16:18.581281+02	1	7	0	0
2006-03-28 23:16:18.601048+02	1	8	0	0
2006-03-28 23:16:18.621418+02	1	9	0	0
2006-03-28 23:16:18.641084+02	1	10	0	0
2006-03-28 23:16:18.660893+02	1	11	0	0
2006-03-28 23:16:18.680749+02	1	12	0	0
2006-03-28 23:16:18.700982+02	1	13	7914272	14391758
2006-03-28 23:16:18.720543+02	1	14	7874595	14317587
2006-03-28 23:16:18.740221+02	1	15	8221649	17484018
2006-03-28 23:16:18.760369+02	1	16	0	0
2006-03-28 23:16:18.780054+02	1	17	0	0
2006-03-28 23:16:18.800943+02	1	18	0	0
2006-03-28 23:16:18.820712+02	1	19	138564103	203674931
2006-03-28 23:16:18.84036+02	1	20	200041217	208903898
2006-03-28 23:16:18.860027+02	1	21	6506271	14285384
2006-03-28 23:16:18.87964+02	1	22	0	0
2006-03-28 23:16:18.899632+02	1	23	0	0
2006-03-28 23:16:18.919771+02	1	24	0	0
2006-03-29 14:21:06.538631+02	1	1	0	0
2006-03-29 14:21:06.566347+02	1	2	0	0
2006-03-29 14:21:06.586281+02	1	3	0	0
2006-03-29 14:21:06.606101+02	1	4	0	0
2006-03-29 14:21:06.626253+02	1	5	0	0
2006-03-29 14:21:06.646471+02	1	6	0	0
2006-03-29 14:21:06.666186+02	1	7	0	0
2006-03-29 14:21:06.685778+02	1	8	0	0
2006-03-29 14:21:06.705397+02	1	9	0	0
2006-03-29 14:21:06.725104+02	1	10	0	0
2006-03-29 14:21:06.745612+02	1	11	0	0
2006-03-29 14:21:06.765703+02	1	12	0	0
2006-03-29 14:21:06.785214+02	1	13	11913823	21156032
2006-03-29 14:21:06.805512+02	1	14	11834383	21035751
2006-03-29 14:21:06.825285+02	1	15	12216402	24218350
2006-03-29 14:21:06.845644+02	1	16	0	0
2006-03-29 14:21:06.865666+02	1	17	0	0
2006-03-29 14:21:06.885942+02	1	18	0	0
2006-03-29 14:21:06.905781+02	1	19	142415383	211673321
2006-03-29 14:21:06.926271+02	1	20	205266368	218989817
2006-03-29 14:21:06.946227+02	1	21	10315756	22231663
2006-03-29 14:21:06.966297+02	1	22	0	0
2006-03-29 14:21:06.985762+02	1	23	0	0
2006-03-29 14:21:07.005733+02	1	24	0	0
\.


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

COPY portnames (switchtype, port, description) FROM stdin;
blackdiamond	1001	BD6808/G8Xi-Port 1:1
blackdiamond	1002	BD6808/G8Xi-Port 1:2
blackdiamond	1003	BD6808/G8Xi-Port 1:3
blackdiamond	1004	BD6808/G8Xi-Port 1:4
blackdiamond	1005	BD6808/G8Xi-Port 1:5
blackdiamond	1006	BD6808/G8Xi-Port 1:6
blackdiamond	1007	BD6808/G8Xi-Port 1:7
blackdiamond	4001	BD6808/G16X3-Port 4:1
blackdiamond	4002	BD6808/G16X3-Port 4:2
blackdiamond	4003	BD6808/G16X3-Port 4:3
blackdiamond	4004	BD6808/G16X3-Port 4:4
blackdiamond	4005	BD6808/G16X3-Port 4:5
blackdiamond	4006	BD6808/G16X3-Port 4:6
blackdiamond	4007	BD6808/G16X3-Port 4:7
blackdiamond	4008	BD6808/G16X3-Port 4:8
blackdiamond	4009	BD6808/G16X3-Port 4:9
blackdiamond	4010	BD6808/G16X3-Port 4:10
blackdiamond	4011	BD6808/G16X3-Port 4:11
blackdiamond	4012	BD6808/G16X3-Port 4:12
blackdiamond	4013	BD6808/G16X3-Port 4:13
blackdiamond	4014	BD6808/G16X3-Port 4:14
blackdiamond	4015	BD6808/G16X3-Port 4:15
blackdiamond	4016	BD6808/G16X3-Port 4:16
blackdiamond	5001	BD6808/G24T3-Port 5:1
blackdiamond	5002	BD6808/G24T3-Port 5:2
blackdiamond	5003	BD6808/G24T3-Port 5:3
blackdiamond	5004	BD6808/G24T3-Port 5:4
blackdiamond	5005	BD6808/G24T3-Port 5:5
blackdiamond	5006	BD6808/G24T3-Port 5:6
blackdiamond	5007	BD6808/G24T3-Port 5:7
blackdiamond	5008	BD6808/G24T3-Port 5:8
blackdiamond	5009	BD6808/G24T3-Port 5:9
blackdiamond	5010	BD6808/G24T3-Port 5:10
blackdiamond	5011	BD6808/G24T3-Port 5:11
blackdiamond	5012	BD6808/G24T3-Port 5:12
blackdiamond	5013	BD6808/G24T3-Port 5:13
blackdiamond	5014	BD6808/G24T3-Port 5:14
blackdiamond	5015	BD6808/G24T3-Port 5:15
blackdiamond	5016	BD6808/G24T3-Port 5:16
blackdiamond	5017	BD6808/G24T3-Port 5:17
blackdiamond	5018	BD6808/G24T3-Port 5:18
blackdiamond	5019	BD6808/G24T3-Port 5:19
blackdiamond	5020	BD6808/G24T3-Port 5:20
blackdiamond	5021	BD6808/G24T3-Port 5:21
blackdiamond	5022	BD6808/G24T3-Port 5:22
blackdiamond	5023	BD6808/G24T3-Port 5:23
blackdiamond	5024	BD6808/G24T3-Port 5:24
blackdiamond	6001	BD6808/F48Ti-Port 6:1
blackdiamond	6002	BD6808/F48Ti-Port 6:2
blackdiamond	6003	BD6808/F48Ti-Port 6:3
blackdiamond	6004	BD6808/F48Ti-Port 6:4
blackdiamond	6005	BD6808/F48Ti-Port 6:5
blackdiamond	6006	BD6808/F48Ti-Port 6:6
blackdiamond	6007	BD6808/F48Ti-Port 6:7
blackdiamond	6008	BD6808/F48Ti-Port 6:8
blackdiamond	6009	BD6808/F48Ti-Port 6:9
blackdiamond	6010	BD6808/F48Ti-Port 6:10
blackdiamond	6011	BD6808/F48Ti-Port 6:11
blackdiamond	6012	BD6808/F48Ti-Port 6:12
blackdiamond	6013	BD6808/F48Ti-Port 6:13
blackdiamond	6014	BD6808/F48Ti-Port 6:14
blackdiamond	6015	BD6808/F48Ti-Port 6:15
blackdiamond	6016	BD6808/F48Ti-Port 6:16
blackdiamond	6017	BD6808/F48Ti-Port 6:17
blackdiamond	6018	BD6808/F48Ti-Port 6:18
blackdiamond	6019	BD6808/F48Ti-Port 6:19
blackdiamond	6020	BD6808/F48Ti-Port 6:20
blackdiamond	6021	BD6808/F48Ti-Port 6:21
blackdiamond	6022	BD6808/F48Ti-Port 6:22
blackdiamond	6023	BD6808/F48Ti-Port 6:23
blackdiamond	6024	BD6808/F48Ti-Port 6:24
blackdiamond	6025	BD6808/F48Ti-Port 6:25
blackdiamond	6026	BD6808/F48Ti-Port 6:26
blackdiamond	6027	BD6808/F48Ti-Port 6:27
blackdiamond	6028	BD6808/F48Ti-Port 6:28
blackdiamond	6029	BD6808/F48Ti-Port 6:29
blackdiamond	6030	BD6808/F48Ti-Port 6:30
blackdiamond	6031	BD6808/F48Ti-Port 6:31
blackdiamond	6032	BD6808/F48Ti-Port 6:32
blackdiamond	6033	BD6808/F48Ti-Port 6:33
blackdiamond	6034	BD6808/F48Ti-Port 6:34
blackdiamond	6035	BD6808/F48Ti-Port 6:35
blackdiamond	6036	BD6808/F48Ti-Port 6:36
blackdiamond	6037	BD6808/F48Ti-Port 6:37
blackdiamond	6038	BD6808/F48Ti-Port 6:38
blackdiamond	6039	BD6808/F48Ti-Port 6:39
blackdiamond	6040	BD6808/F48Ti-Port 6:40
blackdiamond	6041	BD6808/F48Ti-Port 6:41
blackdiamond	6042	BD6808/F48Ti-Port 6:42
blackdiamond	6043	BD6808/F48Ti-Port 6:43
blackdiamond	6044	BD6808/F48Ti-Port 6:44
blackdiamond	6045	BD6808/F48Ti-Port 6:45
blackdiamond	6046	BD6808/F48Ti-Port 6:46
blackdiamond	6047	BD6808/F48Ti-Port 6:47
blackdiamond	6048	BD6808/F48Ti-Port 6:48
cisco6509	1	GigabitEthernet1/1
cisco6509	2	GigabitEthernet1/2
cisco6509	3	GigabitEthernet1/3
cisco6509	4	GigabitEthernet1/4
cisco6509	5	GigabitEthernet1/5
cisco6509	6	GigabitEthernet1/6
cisco6509	7	GigabitEthernet1/7
cisco6509	8	GigabitEthernet1/8
cisco6509	9	GigabitEthernet1/9
cisco6509	10	GigabitEthernet1/10
cisco6509	11	GigabitEthernet1/11
cisco6509	12	GigabitEthernet1/12
cisco6509	13	GigabitEthernet1/13
cisco6509	14	GigabitEthernet1/14
cisco6509	15	GigabitEthernet1/15
cisco6509	16	GigabitEthernet1/16
cisco6509	17	GigabitEthernet1/17
cisco6509	18	GigabitEthernet1/18
cisco6509	19	GigabitEthernet1/19
cisco6509	20	GigabitEthernet1/20
cisco6509	21	GigabitEthernet1/21
cisco6509	22	GigabitEthernet1/22
cisco6509	23	GigabitEthernet1/23
cisco6509	24	GigabitEthernet1/24
cisco6509	25	GigabitEthernet1/25
cisco6509	26	GigabitEthernet1/26
cisco6509	27	GigabitEthernet1/27
cisco6509	28	GigabitEthernet1/28
cisco6509	29	GigabitEthernet1/29
cisco6509	30	GigabitEthernet1/30
cisco6509	31	GigabitEthernet1/31
cisco6509	32	GigabitEthernet1/32
cisco6509	33	GigabitEthernet1/33
cisco6509	34	GigabitEthernet1/34
cisco6509	35	GigabitEthernet1/35
cisco6509	36	GigabitEthernet1/36
cisco6509	37	GigabitEthernet1/37
cisco6509	38	GigabitEthernet1/38
cisco6509	39	GigabitEthernet1/39
cisco6509	40	GigabitEthernet1/40
cisco6509	41	GigabitEthernet1/41
cisco6509	42	GigabitEthernet1/42
cisco6509	43	GigabitEthernet1/43
cisco6509	44	GigabitEthernet1/44
cisco6509	45	GigabitEthernet1/45
cisco6509	46	GigabitEthernet1/46
cisco6509	47	GigabitEthernet1/47
cisco6509	48	GigabitEthernet1/48
cisco6509	49	GigabitEthernet2/1
cisco6509	50	GigabitEthernet2/2
cisco6509	51	GigabitEthernet2/3
cisco6509	52	GigabitEthernet2/4
cisco6509	53	GigabitEthernet2/5
cisco6509	54	GigabitEthernet2/6
cisco6509	55	GigabitEthernet2/7
cisco6509	56	GigabitEthernet2/8
cisco6509	57	GigabitEthernet2/9
cisco6509	58	GigabitEthernet2/10
cisco6509	59	GigabitEthernet2/11
cisco6509	60	GigabitEthernet2/12
cisco6509	61	GigabitEthernet2/13
cisco6509	62	GigabitEthernet2/14
cisco6509	63	GigabitEthernet2/15
cisco6509	64	GigabitEthernet2/16
cisco6509	65	FastEthernet4/1
cisco6509	66	FastEthernet4/2
cisco6509	67	FastEthernet4/3
cisco6509	68	FastEthernet4/4
cisco6509	69	FastEthernet4/5
cisco6509	70	FastEthernet4/6
cisco6509	71	FastEthernet4/7
cisco6509	72	FastEthernet4/8
cisco6509	73	FastEthernet4/9
cisco6509	74	FastEthernet4/10
cisco6509	75	FastEthernet4/11
cisco6509	76	FastEthernet4/12
cisco6509	77	FastEthernet4/13
cisco6509	78	FastEthernet4/14
cisco6509	79	FastEthernet4/15
cisco6509	80	FastEthernet4/16
cisco6509	81	FastEthernet4/17
cisco6509	82	FastEthernet4/18
cisco6509	83	FastEthernet4/19
cisco6509	84	FastEthernet4/20
cisco6509	85	FastEthernet4/21
cisco6509	86	FastEthernet4/22
cisco6509	87	FastEthernet4/23
cisco6509	88	FastEthernet4/24
cisco6509	89	FastEthernet4/25
cisco6509	90	FastEthernet4/26
cisco6509	91	FastEthernet4/27
cisco6509	92	FastEthernet4/28
cisco6509	93	FastEthernet4/29
cisco6509	94	FastEthernet4/30
cisco6509	95	FastEthernet4/31
cisco6509	96	FastEthernet4/32
cisco6509	97	FastEthernet4/33
cisco6509	98	FastEthernet4/34
cisco6509	99	FastEthernet4/35
cisco6509	100	FastEthernet4/36
cisco6509	101	FastEthernet4/37
cisco6509	102	FastEthernet4/38
cisco6509	103	FastEthernet4/39
cisco6509	104	FastEthernet4/40
cisco6509	105	FastEthernet4/41
cisco6509	106	FastEthernet4/42
cisco6509	107	FastEthernet4/43
cisco6509	108	FastEthernet4/44
cisco6509	109	FastEthernet4/45
cisco6509	110	FastEthernet4/46
cisco6509	111	FastEthernet4/47
cisco6509	112	FastEthernet4/48
cisco6509	113	GigabitEthernet5/1
cisco6509	114	GigabitEthernet5/2
cisco6509	115	GigabitEthernet8/1
cisco6509	116	GigabitEthernet8/2
cisco6509	117	GigabitEthernet8/3
cisco6509	118	GigabitEthernet8/4
cisco6509	119	GigabitEthernet8/5
cisco6509	120	GigabitEthernet8/6
cisco6509	121	GigabitEthernet8/7
cisco6509	122	GigabitEthernet8/8
cisco6509	123	GigabitEthernet8/9
\.


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

COPY squeue (id, gid, added, updated, addr, cmd, locked, processed, disabled, priority, sysname, author, result, delay, delaytime) FROM stdin;
\.


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

COPY switches (switch, ip, sysname, switchtype, last_updated, locked, priority, poll_frequency, community) FROM stdin;
210	81.162.239.10	noc	cisco6509	2005-03-27 13:21:26.109659+02	f	5	00:00:20	removed
1	62.148.36.20	zorro	cisco6509	2006-03-29 14:21:06.525009+02	f	5	00:01:00	tg06
\.


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

COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
blackdiamond	1001-1007,4001-4016,5001-5024,6001-6048	f
es3024	1-25	f
summit400	1-50	f
cisco3550	1-50	f
summit7i	1-32	f
summit48	1-50	f
cisco6509	1-24	t
\.


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

COPY temppoll (id, "time", switch, "temp") FROM stdin;
\.


--
-- Name: cpuloadpoll_pkey; Type: CONSTRAINT; Schema: public; Owner: sesse; Tablespace: 
--

ALTER TABLE ONLY cpuloadpoll
    ADD CONSTRAINT cpuloadpoll_pkey PRIMARY KEY (id);


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

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: cpuloadpoll; Type: ACL; Schema: public; Owner: sesse
--

REVOKE ALL ON TABLE cpuloadpoll FROM PUBLIC;
REVOKE ALL ON TABLE cpuloadpoll FROM sesse;
GRANT ALL ON TABLE cpuloadpoll TO sesse;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll TO nms;


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

REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM PUBLIC;
REVOKE ALL ON TABLE cpuloadpoll_id_seq FROM sesse;
GRANT ALL ON TABLE cpuloadpoll_id_seq TO sesse;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE cpuloadpoll_id_seq TO nms;


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

REVOKE ALL ON TABLE polls FROM PUBLIC;
REVOKE ALL ON TABLE polls FROM postgres;
GRANT ALL ON TABLE polls TO postgres;
GRANT INSERT ON TABLE polls TO nms;


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

REVOKE ALL ON TABLE switches FROM PUBLIC;
REVOKE ALL ON TABLE switches FROM postgres;
GRANT ALL ON TABLE switches TO postgres;
GRANT INSERT,SELECT,UPDATE,DELETE ON TABLE switches TO nms;


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

REVOKE ALL ON TABLE switchtypes FROM PUBLIC;
REVOKE ALL ON TABLE switchtypes FROM postgres;
GRANT ALL ON TABLE switchtypes TO postgres;
GRANT SELECT ON TABLE switchtypes TO nms;


--
-- PostgreSQL database dump complete
--

