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');