From 13a86e0ee15a18f29388979f71e39f639195910c Mon Sep 17 00:00:00 2001 From: miker Date: Sat, 31 Jan 2009 02:04:38 +0000 Subject: [PATCH] typo in upgrade scripts git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_4@12020 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql | 4 ++-- Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql index 65583a33b6..00b16c86db 100644 --- a/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.3-1.4-upgrade-db.sql @@ -1508,7 +1508,7 @@ BEGIN WHERE usr = match_user AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND checkin_time IS NULL - AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL) + AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL); IF items_out >= circ_test.max_items_out THEN result.fail_part := 'config.circ_matrix_test.max_items_out'; result.success := FALSE; @@ -1543,7 +1543,7 @@ BEGIN AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND checkin_time IS NULL AND due_date < NOW() - AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL) + AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL); IF items_overdue >= circ_test.max_overdue THEN result.fail_part := 'config.circ_matrix_test.max_overdue'; result.success := FALSE; diff --git a/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql index 276c7c40a0..95e4ccf6ff 100644 --- a/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.2.4-1.4-upgrade-db.sql @@ -1507,7 +1507,7 @@ BEGIN WHERE usr = match_user AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND checkin_time IS NULL - AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL) + AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL); IF items_out >= circ_test.max_items_out THEN result.fail_part := 'config.circ_matrix_test.max_items_out'; result.success := FALSE; @@ -1542,7 +1542,7 @@ BEGIN AND (circ_test.org_depth IS NULL OR (circ_test.org_depth IS NOT NULL AND circ_lib IN ( SELECT * FROM explode_array(overdue_orgs) ))) AND checkin_time IS NULL AND due_date < NOW() - AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL) + AND (stop_fines IN ('MAXFINES','LONGOVERDUE') OR stop_fines IS NULL); IF items_overdue >= circ_test.max_overdue THEN result.fail_part := 'config.circ_matrix_test.max_overdue'; result.success := FALSE; -- 2.11.0