diff options
Diffstat (limited to 'junos-bootstrap/httpd/postgres_queries')
-rw-r--r-- | junos-bootstrap/httpd/postgres_queries | 20 |
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'); |