From 41b1eca7a62d450bc0d2357027a6be6acd51a7a6 Mon Sep 17 00:00:00 2001
From: Joachim Tingvold <joachim@tingvold.com>
Date: Wed, 1 Apr 2015 03:49:53 +0200
Subject: Changes...

---
 fap/database/create_tables.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 fap/database/create_tables.sql

(limited to 'fap/database/create_tables.sql')

diff --git a/fap/database/create_tables.sql b/fap/database/create_tables.sql
new file mode 100644
index 0000000..b4aab3f
--- /dev/null
+++ b/fap/database/create_tables.sql
@@ -0,0 +1,17 @@
+CREATE TABLE switches (
+ id serial,
+ hostname character varying(20),
+ distro_name character varying(100),
+ distro_phy_port character varying(100),
+ mgmt_v4_addr character varying(15),
+ mgmt_v4_cidr smallint,
+ mgmt_v4_gw character varying(15),
+ mgmt_v6_cidr smallint,
+ mgmt_v6_addr character varying(35),
+ mgmt_v6_gw character varying(35),
+ mgmt_vlan smallint,
+ last_config_fetch integer,
+ current_mac character varying(17),
+ model character varying(20),
+ traffic_vlan integer
+);
-- 
cgit v1.2.3

