X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=b3abe75e159117bbed6d79f517120c8176dcdf46;hp=64188d06353bdd254b0494fd9ca43bb30e264788;hb=3e52c324dc8760e92b5ed57b7c941133b75786e8;hpb=d25847fe178bf9fabbd1846cafb6d90abe63f971 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')