From 8dcb5e9202f478bf86be74dfc0d85bcf14c275ca Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 1 Apr 2016 15:35:56 -0400 Subject: [PATCH] JBAS-1243 Push user expire_date's to future Fixes issue where transactions (circs/holds) are not created because all users are expired. Signed-off-by: Bill Erickson --- KCLS/sql/sample-data/exports/kcls-dev-users.sql | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/KCLS/sql/sample-data/exports/kcls-dev-users.sql b/KCLS/sql/sample-data/exports/kcls-dev-users.sql index a5aed3315d..66843e9f9f 100644 --- a/KCLS/sql/sample-data/exports/kcls-dev-users.sql +++ b/KCLS/sql/sample-data/exports/kcls-dev-users.sql @@ -8000,3 +8000,9 @@ INSERT INTO actor.usr_address (country, within_city_limits, post_code, street1, INSERT INTO actor.card (barcode, usr) VALUES ('310044', CURRVAL('actor.usr_id_seq')); UPDATE actor.usr SET card = CURRVAL('actor.card_id_seq'), billing_address = CURRVAL('actor.usr_address_id_seq'), credit_forward_balance = '0', mailing_address = CURRVAL('actor.usr_address_id_seq') WHERE id=CURRVAL('actor.usr_id_seq'); +-- Expire dates above are all hard-coded in the past. Push most of them +-- out to the future. Leave a few for testing. +UPDATE actor.usr + SET expire_date = NOW() + '3 years'::INTERVAL + WHERE DATE(create_date) = CURRENT_DATE AND id > 10; + -- 2.11.0