From d9069802f61b3a36807c02c429ec0b9c9a63c857 Mon Sep 17 00:00:00 2001
From: Kristian Lyngstol <kristian@bohemians.org>
Date: Tue, 15 Nov 2016 10:00:14 +0100
Subject: Start clean switches-table

Lots of cruft
---
 build/schema.sql | 6 +-----
 1 file changed, 1 insertion(+), 5 deletions(-)

(limited to 'build/schema.sql')

diff --git a/build/schema.sql b/build/schema.sql
index e40ba15..3e8ee91 100644
--- a/build/schema.sql
+++ b/build/schema.sql
@@ -292,12 +292,10 @@ CREATE TABLE switches (
     switch integer DEFAULT nextval(('"switches_switch_seq"'::text)::regclass) NOT NULL,
     mgmt_v4_addr inet,
     sysname character varying NOT NULL,
-    switchtype character varying DEFAULT 'ex2200'::character varying NOT NULL,
     last_updated timestamp with time zone,
     locked boolean DEFAULT false NOT NULL,
     poll_frequency interval DEFAULT '00:01:00'::interval NOT NULL,
     community character varying DEFAULT 'FullPuppTilNMS'::character varying NOT NULL,
-    lldp_chassis_id character varying,
     mgmt_v6_addr inet,
     placement box,
     subnet4 cidr,
@@ -308,9 +306,7 @@ CREATE TABLE switches (
     mgmt_v4_gw inet,
     mgmt_vlan integer DEFAULT 666,
     traffic_vlan integer,
-    last_config_fetch timestamp with time zone,
-    tags jsonb DEFAULT '[]',
-    current_mac macaddr
+    tags jsonb DEFAULT '[]'::jsonb
 );
 
 
-- 
cgit v1.2.3

