--- /dev/null
+--
+-- 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
+--
+
projects / nms / commitdiff