From f8ac8c0b67d306319bcb404f49b4f0e7feb9d510 Mon Sep 17 00:00:00 2001
From: root <root@frank.tg14.gathering.org>
Date: Wed, 16 Apr 2014 16:35:25 +0200
Subject: Support pinging secondary loopbacks.

---
 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 47aacdb..6af4e2a 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -594,6 +594,10 @@ 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 ping_secondary_ip ( switch integer not null, updated timestamptz not null default current_timestamp, latency_ms float );
+create index updated_index3 on ping_secondary_ip ( updated );
+alter table public.ping_secondary_ip 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;
 
-- 
cgit v1.2.3

