diff options
| author | Jonas Lindstad <jonaslindstad@gmail.com> | 2015-03-16 23:09:40 +0100 |
|---|---|---|
| committer | Jonas Lindstad <jonaslindstad@gmail.com> | 2015-03-16 23:09:40 +0100 |
| commit | 939b606944b6892d26581bce598c66c790786de9 (patch) | |
| tree | 6780dc26bd26c22ca8dce6a7832841b5f4efc37a /junos-bootstrap/httpd/postgres_queries | |
| parent | 88dfb934e546d02d1f4356032e91277f9f5b94f1 (diff) | |
rename + fixes
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'); |