From 46cb978bc54303a537a70397c006c977400f242a Mon Sep 17 00:00:00 2001
From: root <root@frank.tg14.gathering.org>
Date: Tue, 15 Apr 2014 17:12:03 +0200
Subject: Add a little script to find loopbacks and linknets.

---
 sql/nms.sql | 7 +++++++
 1 file changed, 7 insertions(+)

(limited to 'sql/nms.sql')

diff --git a/sql/nms.sql b/sql/nms.sql
index fe5f4b8..d5182fe 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -593,6 +593,13 @@ create table ping ( switch integer not null, updated timestamptz not null defaul
 create index updated_index on ping ( updated );
 alter table public.ping owner to nms;
 
+create table linknets ( linknet serial not null, switch1 integer not null, addr1 inet not null, switch2 integer not null, addr2 inet not null );
+alter table public.linknets owner to nms;
+
+create table linknet_ping ( linknet integer not null, updated timestamptz not null default current_timestamp, latency1_ms float, latency2_ms float );
+create index updated_index2 on linknet_ping ( updated );
+alter table public.linknet_ping owner to nms;
+
 --
 -- Data for Name: ap_poll; Type: TABLE DATA; Schema: public; Owner: nms
 --
-- 
cgit v1.2.3

