From 743dd814caabaf3f29ded1d5dd48432c17c8d4aa Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 30 May 2018 16:38:34 -0400 Subject: [PATCH] LP#1750894 Workstation settings base schema sync Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/005.schema.actors.sql | 2 +- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/005.schema.actors.sql b/Open-ILS/src/sql/Pg/005.schema.actors.sql index 4b391d464f..1152d97616 100644 --- a/Open-ILS/src/sql/Pg/005.schema.actors.sql +++ b/Open-ILS/src/sql/Pg/005.schema.actors.sql @@ -1109,7 +1109,7 @@ BEGIN -- if we have a value, we have a setting type summary.has_user_setting := TRUE; - IF workstation_id THEN + IF workstation_id IS NOT NULL THEN -- Only inform the caller about the workstation -- setting type disposition when a workstation id is -- provided. Otherwise, it's NULL to indicate UNKNOWN. diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql index bb877c02ad..11ff097c3c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.workstation-settings.sql @@ -113,7 +113,7 @@ BEGIN -- if we have a value, we have a setting type summary.has_user_setting := TRUE; - IF workstation_id THEN + IF workstation_id IS NOT NULL THEN -- Only inform the caller about the workstation -- setting type disposition when a workstation id is -- provided. Otherwise, it's NULL to indicate UNKNOWN. -- 2.11.0