From 6e89dd3ce870714bd2a22615587181d25186fe7a Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Sun, 6 Apr 2014 19:14:30 +0200
Subject: Add a script to discover new devices based on LLDP information.

---
 sql/nms.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'sql/nms.sql')

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
 );
 
 
-- 
cgit v1.2.3

