From f3bf94ee66e63b9049bd538acd06a4f7ebc357de Mon Sep 17 00:00:00 2001
From: "Steinar H. Gunderson" <sgunderson@bigfoot.com>
Date: Sun, 6 Apr 2014 17:57:38 +0200
Subject: Drop obsolete column wide_counters; we only support SNMPv2 and newer
 now.

---
 sql/nms.sql | 41 ++++++++++++++++++++---------------------
 1 file changed, 20 insertions(+), 21 deletions(-)

(limited to 'sql/nms.sql')

diff --git a/sql/nms.sql b/sql/nms.sql
index 23f20b2..9b5ae01 100644
--- a/sql/nms.sql
+++ b/sql/nms.sql
@@ -572,7 +572,6 @@ ALTER TABLE public.switches_switch_seq OWNER TO nms;
 CREATE TABLE switchtypes (
     switchtype character varying NOT NULL,
     ports character varying NOT NULL,
-    wide_counters boolean DEFAULT false NOT NULL
 );
 
 
@@ -1542,26 +1541,26 @@ SELECT pg_catalog.setval('switches_switch_seq', 417, true);
 -- Data for Name: switchtypes; Type: TABLE DATA; Schema: public; Owner: nms
 --
 
-COPY switchtypes (switchtype, ports, wide_counters) FROM stdin;
-dlink3100	1-44,46-48	t
-dlink3100full	1-48	t
-ciscoap		f
-nocgw	1-114	t
-telegw	1-94,99-102	t
-camgw	1-52,55	t
-stageboh	1-52,55	t
-wtfgw	1-52,55	t
-logistikkgw	1-52,55	t
-crewgw	1-52,55	t
-gamegw	1-52,55	t
-resepsjongw	10101-10110	t
-sponsorgw		t
-eldregw	1-5	t
-distro0	1-201	t
-distro1	1-201	t
-distro2	1-201	t
-distro3	1-201	t
-distro4	1-201	t
+COPY switchtypes (switchtype, ports) FROM stdin;
+dlink3100	1-44,46-48
+dlink3100full	1-48
+ciscoap	
+nocgw	1-114
+telegw	1-94,99-102
+camgw	1-52,55
+stageboh	1-52,55
+wtfgw	1-52,55
+logistikkgw	1-52,55
+crewgw	1-52,55
+gamegw	1-52,55
+resepsjongw	10101-10110
+sponsorgw	
+eldregw	1-5
+distro0	1-201
+distro1	1-201
+distro2	1-201
+distro3	1-201
+distro4	1-201
 \.
 
 
-- 
cgit v1.2.3

