From 41b1eca7a62d450bc0d2357027a6be6acd51a7a6 Mon Sep 17 00:00:00 2001 From: Joachim Tingvold 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