From 3e52c324dc8760e92b5ed57b7c941133b75786e8 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Wed, 15 Aug 2018 10:00:40 -0400 Subject: [PATCH] adding libraries to the gsheet for patron thresholds --- mig-sql/init/020_common_tables.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index 64188d0..b3abe75 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -247,6 +247,7 @@ VALUES CREATE TABLE map_threshold ( id SERIAL + ,library TEXT ,profile TEXT ,checkout_threshold TEXT ,fine_threshold TEXT @@ -264,6 +265,7 @@ INSERT INTO gsheet_tracked_column (table_id,column_name) VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'profile') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'library') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'checkout_threshold') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'fine_threshold') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Patron Thresholds'),'overdue_threshold') -- 1.7.2.5