diff options
| author | Jonas 'j' Lindstad <jonaslindstad@gmail.com> | 2015-01-28 23:32:37 +0100 |
|---|---|---|
| committer | Jonas 'j' Lindstad <jonaslindstad@gmail.com> | 2015-01-28 23:32:37 +0100 |
| commit | 7e47c7aefd5074db9084e66a7bfc7614ec9834db (patch) | |
| tree | 2d57c7d65da4e35fdeaf18faf4be607bb44ad20a /junos-bootstrap/httpd/postgres_queries | |
| parent | f627e9c78241ea211391055aa5409c8f0fa5939a (diff) | |
Initial commit/upload - httpd working, but poorly written
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'); |