From 4c9a1b45c3e4983ed9f4ba5758d41fc775a81310 Mon Sep 17 00:00:00 2001 From: gmc Date: Fri, 5 Nov 2010 17:12:51 +0000 Subject: [PATCH] fix user password reset request time column def Needs to be a timestamp with time zone; fixes a bug where it was interpreted as a UTC time, throwing off the calculation of the expiration of the password reset request. Signed-off-by: Galen Charlton git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6@18628 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index b029de7d8a..039bf002f9 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -528,7 +528,7 @@ CREATE TABLE actor.usr_password_reset ( id SERIAL PRIMARY KEY, uuid TEXT NOT NULL, usr BIGINT NOT NULL REFERENCES actor.usr(id) DEFERRABLE INITIALLY DEFERRED, - request_time TIMESTAMP NOT NULL DEFAULT NOW(), + request_time TIMESTAMP WITH TIME ZONE NOT NULL DEFAULT NOW(), has_been_reset BOOL NOT NULL DEFAULT false ); COMMENT ON TABLE actor.usr_password_reset IS $$ -- 2.11.0