From 2b034cde8c6d8d338f01273cc7a588a0dfc55499 Mon Sep 17 00:00:00 2001 From: Bradley Bonner Date: Fri, 16 Sep 2016 12:21:11 -0700 Subject: [PATCH] JBAS-1593 "Book Club" copy location BC SQL mods Please create a new shelving location named "Book Club" that will be non-visible to patrons (as discussed at the ILS Team meeting on 9/15/16). --- KCLS/utility-scripts/bc_missing/bc_missing.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/KCLS/utility-scripts/bc_missing/bc_missing.sql b/KCLS/utility-scripts/bc_missing/bc_missing.sql index d09b597ae3..c846cbeb22 100644 --- a/KCLS/utility-scripts/bc_missing/bc_missing.sql +++ b/KCLS/utility-scripts/bc_missing/bc_missing.sql @@ -35,7 +35,7 @@ UPDATE asset.copy 'Children''s Storytime' , 'Children''s Toys/Games' , 'Children''s Materials' , 'Children''s Easy Materials' , 'KidReach' , 'Tech Lab' , 'Storage' , 'Teen Materials' , - 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day' + 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day', 'Book Club' ) ); @@ -64,7 +64,7 @@ UPDATE asset.copy 'Children''s Storytime' , 'Children''s Toys/Games' , 'Children''s Materials' , 'Children''s Easy Materials' , 'KidReach' , 'Tech Lab' , 'Storage' , 'Teen Materials' , - 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day' ) + 'Generic' , 'Normandy Park' , 'Choice Reads', 'Lucky Day', 'Book Club' ) AND floating IS NULL ); -- 2.11.0