Use bytea data type to store session tokens

To be consistent with users.passwd - hashes are stored in binary. All
conversion from/to hex is done in the DB layer.

2 files changed, 2 insertions, 2 deletions

diff --git a/util/dump.sql b/util/dump.sql
index 2bb4fda5..ea5d7e68 100644
--- a/util/dump.sql
+++ b/util/dump.sql
@@ -164,7 +164,7 @@ CREATE TABLE screenshots (
 -- sessions
 CREATE TABLE sessions (
   uid integer NOT NULL,
-  token character(40) NOT NULL,
+  token bytea NOT NULL,
   expiration timestamp NOT NULL DEFAULT (now() + '1 year'::interval),
   PRIMARY KEY (uid, token)
 );
diff --git a/util/updates/update_2.6.sql b/util/updates/update_2.6.sql
index 79fefd69..f0ddff65 100644
--- a/util/updates/update_2.6.sql
+++ b/util/updates/update_2.6.sql
@@ -3,7 +3,7 @@
 -- Create table for session data storage
 CREATE TABLE sessions (
   uid integer NOT NULL REFERENCES users(id),
-  token character(40) NOT NULL,
+  token bytea NOT NULL,
   expiration timestamp NOT NULL DEFAULT (NOW() + '1 year'::interval),
   PRIMARY KEY (uid, token)
 );