1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
|
create table switchtypes (
switchtype varchar not null primary key,
ports varchar not null
);
create table switches (
switch serial not null primary key,
ip inet not null,
secondary_ip inet,
sysname varchar not null,
switchtype varchar not null references switchtypes,
last_updated timestamp,
locked boolean not null default 'f'
);
create table poll (
time timestamp not null,
switch integer not null references switches,
port integer not null,
bytes_in bigint not null,
bytes_out bigint not null,
primary key ( time, switch, port )
);
create index poll_switch_port on poll ( switch, port );
|
