From 7685165ad046cbe73e5e545fc66cd5f5b24aedcf Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Mon, 7 Apr 2014 23:08:30 +0200
Subject: Add some scripts to ping all the switches, and display the ping
 status on a map.

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

(limited to 'sql/nms.sql')

diff --git a/sql/nms.sql b/sql/nms.sql
index acadcc5..3b2c029 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -606,6 +606,10 @@ CREATE TABLE uplinks (
 
 ALTER TABLE public.uplinks OWNER TO nms;
 
+create table ping ( switch integer not null, updated timestamptz not null default current_timestamp, latency_ms float );
+create index updated_index on ping ( updated );
+alter table public.ping owner to nms;
+
 --
 -- Data for Name: ap_poll; Type: TABLE DATA; Schema: public; Owner: nms
 --
-- 
cgit v1.2.3

