aboutsummaryrefslogtreecommitdiffstats
path: root/junos-bootstrap/httpd/postgres_queries
diff options
context:
space:
mode:
Diffstat (limited to 'junos-bootstrap/httpd/postgres_queries')
-rw-r--r--junos-bootstrap/httpd/postgres_queries20
1 files changed, 0 insertions, 20 deletions
diff --git a/junos-bootstrap/httpd/postgres_queries b/junos-bootstrap/httpd/postgres_queries
deleted file mode 100644
index d7c07f2..0000000
--- a/junos-bootstrap/httpd/postgres_queries
+++ /dev/null
@@ -1,20 +0,0 @@
-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');