X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=b465888e5045cedd792bd21ae8acc74f65ad0d67;hp=8acf58b835f1cbff89c77cac5d63e1aa8eff584d;hb=6c3dbfe431a76596a1614e28039824aa1122977e;hpb=337680650a86c2fb1c5d5bddfb4053a56fb9964b

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')