aboutsummaryrefslogtreecommitdiffstats
path: root/build/schema.sql
diff options
context:
space:
mode:
Diffstat (limited to 'build/schema.sql')
-rw-r--r--build/schema.sql6
1 files changed, 1 insertions, 5 deletions
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
);