aboutsummaryrefslogtreecommitdiffstats
path: root/sql/nms.sql
diff options
context:
space:
mode:
authorSteinar H. Gunderson <sgunderson@bigfoot.com>2014-04-06 19:14:30 +0200
committerSteinar H. Gunderson <sgunderson@bigfoot.com>2014-04-06 19:14:30 +0200
commit6e89dd3ce870714bd2a22615587181d25186fe7a (patch)
tree40c7fc4bfd6d792c0e748b466c03be988367a04b /sql/nms.sql
parent0804c84cbb43a56a021c4963e06c88b302a831a4 (diff)
Add a script to discover new devices based on LLDP information.
Diffstat (limited to 'sql/nms.sql')
-rw-r--r--sql/nms.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/sql/nms.sql b/sql/nms.sql
index d102798..acadcc5 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -545,7 +545,8 @@ CREATE TABLE switches (
locked boolean DEFAULT false NOT NULL,
priority integer DEFAULT 0 NOT NULL,
poll_frequency interval DEFAULT '00:01:00'::interval NOT NULL,
- community character varying DEFAULT 'public'::character varying NOT NULL
+ community character varying DEFAULT 'public'::character varying NOT NULL,
+ lldp_chassis_id character varying
);