From 8793bd3557e06f1194813e02902f3780ee1ebfb8 Mon Sep 17 00:00:00 2001 From: David Sommerseth 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 --- 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