diff options
| author | Steinar H. Gunderson <sgunderson@bigfoot.com> | 2014-04-07 23:08:30 +0200 |
|---|---|---|
| committer | Steinar H. Gunderson <sgunderson@bigfoot.com> | 2014-04-07 23:08:30 +0200 |
| commit | 7685165ad046cbe73e5e545fc66cd5f5b24aedcf (patch) | |
| tree | a5724eb41e4fbe846ba37a7887da2cbb5d1f880c /sql/nms.sql | |
| parent | b83b26425343dae0e587c759574e6193822ce7fa (diff) | |
Add some scripts to ping all the switches, and display the ping status on a map.
Diffstat (limited to 'sql/nms.sql')
| -rw-r--r-- | sql/nms.sql | 4 |
1 files changed, 4 insertions, 0 deletions
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 -- |