From 8793bd3557e06f1194813e02902f3780ee1ebfb8 Mon Sep 17 00:00:00 2001
From: David Sommerseth <dazo@users.sourceforge.net>
Date: Sun, 8 Jan 2012 22:53:59 +0100
Subject: edb-pgsql: Change lastlog.sessionduration to interval

PostgreSQL have a better data type for storing session duration.

Signed-off-by: David Sommerseth <dazo@users.sourceforge.net>
---
 database/postgresql/sql-schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'database/postgresql/sql-schema.sql')

diff --git a/database/postgresql/sql-schema.sql b/database/postgresql/sql-schema.sql
index f66f067..3103d34 100644
--- a/database/postgresql/sql-schema.sql
+++ b/database/postgresql/sql-schema.sql
@@ -88,7 +88,7 @@ CREATE TABLE lastlog (
        login            timestamp    ,
        logout           timestamp    ,
        session_deleted  timestamp    ,
-       session_duration timestamp,
+       session_duration interval     ,
        bytes_sent       integer      ,
        bytes_received   integer      ,
        llid             SERIAL       PRIMARY KEY
-- 
cgit 

