create-Pg.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

create table icelog (
  lognum serial primary key,
  logdate timestamp,
  logmachine varchar(255),
  logpos int,
  customer varchar(255),
  liveflag char(1),
  hostname varchar(255),
  start int,
  mountpoint varchar(255),
  bytes int,
  useragent varchar(255),
  seconds int
);