diff options
author | Yorhel <git@yorhel.nl> | 2009-07-31 12:50:31 +0200 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2009-07-31 12:50:31 +0200 |
commit | af5293b8d33f4948ee5c9bcc2c4df38e611c88c6 (patch) | |
tree | 7f530f9df07bbfb893c74e406f127237b89b316b /util/dump.sql | |
parent | 5e9e6a78d3b7ffd177d91dba6602946dbd9a4c09 (diff) |
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.
Diffstat (limited to 'util/dump.sql')
-rw-r--r-- | util/dump.sql | 2 |
1 files changed, 1 insertions, 1 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) ); |