ipv6-dns v2 (fetich via SNMP, new DB schema)

1 files changed, 4 insertions, 21 deletions

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: