From: Rogan Hamby <rhamby@esilibrary.com>
Date: Tue, 27 Feb 2018 17:04:22 +0000 (-0500)
Subject: updating column name from copy_location to desired_shelf to match mig tools
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=6c3dbfe431a76596a1614e28039824aa1122977e

updating column name from copy_location to desired_shelf to match mig tools
---

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index 8acf58b..b465888 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -1,7 +1,7 @@
 CREATE TABLE map_create_shelving_location (
     id                  SERIAL
     ,owning_lib         TEXT            
-    ,location_name      TEXT
+    ,desired_shelf      TEXT
     ,opac_visible       TEXT
     ,checkin_alert      TEXT
     ,holdable           TEXT
@@ -19,7 +19,7 @@ INSERT INTO gsheet_tracked_column
     (table_id,column_name) 
 VALUES 
      ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'owning_lib')
-    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'location_name')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'desired_shelf')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'opac_visible')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'checkin_alert')
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'holdable')