From 46959e031175a33d9a7ab52501323f7b1f9873e5 Mon Sep 17 00:00:00 2001 From: root Date: Tue, 15 Apr 2014 13:49:39 +0200 Subject: ipv6-dns v2 (fetich via SNMP, new DB schema) --- sql/nms.sql | 25 ++++--------------------- 1 file changed, 4 insertions(+), 21 deletions(-) (limited to 'sql/nms.sql') diff --git a/sql/nms.sql b/sql/nms.sql index 002ae6b..fe5f4b8 100644 --- a/sql/nms.sql +++ b/sql/nms.sql @@ -347,34 +347,17 @@ CREATE TABLE dhcp ( ALTER TABLE public.dhcp OWNER TO nms; +-- Name: seen_mac; Type: TABLE; Schema: public; Owner: postgres; Tablespace: -- --- Name: ipv4; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE ipv4 ( - mac macaddr NOT NULL, - address inet NOT NULL, - "time" timestamp without time zone NOT NULL, - age integer -); - -ALTER TABLE public.ipv4 OWNER TO nms; - --- --- Name: ipv6; Type: TABLE; Schema: public; Owner: nms; Tablespace: --- - -CREATE TABLE ipv6 ( +CREATE TABLE seen_mac ( mac macaddr NOT NULL, address inet NOT NULL, - "time" timestamp with time zone NOT NULL, - age integer, - vlan text + seen timestamp with time zone DEFAULT now() NOT NULL ); -ALTER TABLE public.ipv6 OWNER TO nms; +ALTER TABLE public.seen_mac OWNER TO nms; -- -- Name: mbd_log; Type: TABLE; Schema: public; Owner: nms; Tablespace: -- cgit v1.2.3