From 6c3dbfe431a76596a1614e28039824aa1122977e Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 27 Feb 2018 12:04:22 -0500 Subject: [PATCH] updating column name from copy_location to desired_shelf to match mig tools --- mig-sql/init/020_common_tables.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) 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') -- 1.7.2.5