From 584defa4537c544682bf5f2a9f11795755b52914 Mon Sep 17 00:00:00 2001 From: gmc Date: Fri, 5 Nov 2010 17:02:59 +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_1@18623 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql | 2 ++ 2 files changed, 3 insertions(+), 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 $$ diff --git a/Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql index 2500201997..c9f23ac574 100644 --- a/Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.6.1.2-1.6.1.3-upgrade-db.sql @@ -180,5 +180,7 @@ CREATE OR REPLACE FUNCTION action.hold_retarget_permit_test( pickup_ou INT, requ SELECT * FROM action.hold_request_permit_test( $1, $2, $3, $4, $5, TRUE ); $func$ LANGUAGE SQL; +ALTER TABLE actor.usr_password_reset ALTER COLUMN request_time TYPE TIMESTAMP WITH TIME ZONE; + COMMIT; -- 2.11.0