diff options
Diffstat (limited to 'junos-bootstrap/httpd/postgres_queries')
| -rw-r--r-- | junos-bootstrap/httpd/postgres_queries | 20 |
1 files changed, 20 insertions, 0 deletions
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'); |