From ffd815e4f53f2c0002ac733db793fe5f52e1c019 Mon Sep 17 00:00:00 2001 From: dbs Date: Tue, 28 Apr 2009 04:27:09 +0000 Subject: [PATCH] Add OWA and OWAL flourishes git-svn-id: svn://svn.open-ils.org/ILS-Contrib/conifer/trunk@405 6d9bc8c9-1ec2-4278-b937-99fde70a366f --- tools/migration-scripts/generate_copies.sql | 8 ++++++++ 1 file changed, 8 insertions(+) diff --git a/tools/migration-scripts/generate_copies.sql b/tools/migration-scripts/generate_copies.sql index f094daefcc..62c31f272e 100644 --- a/tools/migration-scripts/generate_copies.sql +++ b/tools/migration-scripts/generate_copies.sql @@ -34,6 +34,14 @@ UPDATE staging_items WHERE owning_lib = 'HIRC'; UPDATE staging_items + SET owning_lib = 'OWA' + WHERE owning_lib = 'Leddy'; + +UPDATE staging_items + SET owning_lib = 'OWAL' + WHERE owning_lib = 'WINLAW'; + +UPDATE staging_items SET owning_lib = 'KAP' WHERE location IN (SELECT location FROM staging_items WHERE location LIKE 'HRSTK-%'); -- 2.11.0