From b8cab247d3aee29fc01a8b4382d5f3e43394cb45 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Tue, 27 Feb 2018 15:16:54 -0500 Subject: [PATCH] fixing column name in common gsheet tables --- 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 34333bc..a8e6b98 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 ( l_id SERIAL ,l_owning_lib TEXT - ,l_desired_shelf TEXT + ,l_copy_location TEXT ,l_opac_visible TEXT ,l_checkin_alert TEXT ,l_holdable TEXT @@ -20,7 +20,7 @@ INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_owning_lib') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_desired_shelf') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_copy_location') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_opac_visible') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_checkin_alert') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'New Copy Locations'),'l_holdable') -- 1.7.2.5