1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
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');
|
