initial importSTART

1 files changed, 15 insertions, 0 deletions

diff --git a/create-Pg.sql b/create-Pg.sql
new file mode 100644
index 0000000..c5592a1
--- /dev/null
+++ b/create-Pg.sql
@@ -0,0 +1,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
+);
+