From ebd4cccb28dd53814a42ba0c50b1ed7a891397c2 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Fri, 3 Aug 2018 15:53:41 -0400 Subject: [PATCH] adding circ limit sets table --- mig-sql/init/020_common_tables.sql | 36 ++++++++++++++++++++++++++++++++++++ 1 files changed, 36 insertions(+), 0 deletions(-) diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index 0a4243c..9c1503e 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -106,6 +106,42 @@ VALUES ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes') ; +CREATE TABLE map_circ_limit_sets ( + l_owning_lib TEXT + ,l_name TEXT + ,l_items_out TEXT + ,l_depth TEXT + ,l_global TEXT + ,l_description TEXT + ,l_circ_mod TEXT + ,l_copy_loc TEXT + ,x_owning_lib INTEGER + ,x_name TEXT + ,x_items_out INTEGER + ,x_global BOOLEAN + ,x_depth INTEGER + ,x_description TEXT +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_circ_limit_sets','Circ Limit Sets',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +VALUES + ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc') +; + CREATE TABLE map_create_shelving_location ( l_id SERIAL ,l_owning_lib TEXT -- 1.7.2.5