From 7e47c7aefd5074db9084e66a7bfc7614ec9834db Mon Sep 17 00:00:00 2001 From: Jonas 'j' Lindstad Date: Wed, 28 Jan 2015 23:32:37 +0100 Subject: Initial commit/upload - httpd working, but poorly written --- junos-bootstrap/httpd/postgres_queries | 20 ++++++++++++++++++++ 1 file changed, 20 insertions(+) create mode 100644 junos-bootstrap/httpd/postgres_queries (limited to 'junos-bootstrap/httpd/postgres_queries') diff --git a/junos-bootstrap/httpd/postgres_queries b/junos-bootstrap/httpd/postgres_queries new file mode 100644 index 0000000..d7c07f2 --- /dev/null +++ b/junos-bootstrap/httpd/postgres_queries @@ -0,0 +1,20 @@ +CREATE TABLE switches ( + id serial primary key, + hostname varchar(20) NOT NULL, + distro_name varchar(100) NOT NULL, + distro_phy_port varchar(100) NOT NULL, + mgmt_addr varchar(15) NOT NULL, + mgmt_cidr smallint NOT NULL, + mgmt_gw varchar(15) NOT NULL, + mgmt_vlan smallint NOT NULL, + last_config_fetch integer default NULL, + current_mac varchar(17) default NULL +); + + + +insert into switches (hostname, distro_name, distro_phy_port, mgmt_addr, mgmt_cidr, mgmt_gw, mgmt_vlan) values +('e-00-0-test', 'distro-test', 'ge-0/0/0', '10.0.200.2', '24', '10.0.200.1', '300'), +('e-00-1-test', 'distro-test', 'ge-0/0/3', '10.0.200.3', '24', '10.0.200.1', '300'), +('e-00-2-test', 'distro-test', 'ge-0/0/6', '10.0.200.4', '24', '10.0.200.1', '300'), +('e-60-0-test', 'distro-test', 'ge-0/0/9', '10.0.200.5', '24', '10.0.200.1', '300'); -- cgit v1.2.3