diff options
author | David Sommerseth <dazo@users.sourceforge.net> | 2012-01-08 22:53:59 +0100 |
---|---|---|
committer | David Sommerseth <dazo@users.sourceforge.net> | 2013-06-13 01:01:55 +0200 |
commit | 8793bd3557e06f1194813e02902f3780ee1ebfb8 (patch) | |
tree | f366d427c3f99e7d9b25592f01418162a890fc7f | |
parent | d5a844f9067d6a119ab1be05ae938afda292825b (diff) | |
download | eurephia-8793bd3557e06f1194813e02902f3780ee1ebfb8.tar.gz eurephia-8793bd3557e06f1194813e02902f3780ee1ebfb8.tar.xz eurephia-8793bd3557e06f1194813e02902f3780ee1ebfb8.zip |
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>
-rw-r--r-- | database/postgresql/sql-schema.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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 |