From 46959e031175a33d9a7ab52501323f7b1f9873e5 Mon Sep 17 00:00:00 2001
From: root <root@frank.tg14.gathering.org>
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

