From 9c3f19c7ad519ddf157d3499bc29172994ee09be Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 2 Aug 2018 14:05:23 -0400 Subject: [PATCH] new verion of circ policies map table --- mig-sql/init/020_common_tables.sql | 77 ++++-------------------------------- 1 files changed, 8 insertions(+), 69 deletions(-) diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index aea35b9..c6cad38 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -92,18 +92,16 @@ VALUES CREATE TABLE map_circ_policies ( l_org_unit TEXT ,l_user_group TEXT + ,l_copy_owning_lib TEXT + ,l_user_home_lib TEXT ,l_circ_mod TEXT ,l_copy_location TEXT ,l_circulate TEXT ,l_circ_limit_set TEXT ,l_duration_rule TEXT - ,l_renewals TEXT - ,l_fine TEXT - ,l_fine_interval TEXT - ,l_grace_period TEXT - ,l_max_fine TEXT + ,l_fine_rule TEXT ,l_grace_override TEXT - ,l_renewal_boolean TEXT + ,l_max_fine TEXT ,l_notes TEXT ,x_org_unit INTEGER ,x_grp_id INTEGER @@ -126,78 +124,19 @@ INSERT INTO gsheet_tracked_column VALUES ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_org_unit') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_group') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_owning') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_user_home_lib') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_mod') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_copy_location') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circulate') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_circ_limit_set') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_duration_rule') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewals') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_interval') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_period') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_fine_rule') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_grace_override') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_renewal_boolean') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_max_fine') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes') ; - - CREATE TABLE map_circ_combo_policies ( - l_active TEXT - ,l_user_group TEXT - ,l_org_unit TEXT - ,l_copy_own_lib TEXT - ,l_user_home_lib TEXT - ,l_circ_mod TEXT - ,l_circulate TEXT - ,l_copy_loc TEXT - ,l_duration_rule TEXT - ,l_recurring_fine_rule TEXT - ,l_grace_override TEXT - ,l_max_fine_rule TEXT - ,l_circ_limit_set_name TEXT - ,l_notes TEXT - ,x_active BOOLEAN - ,x_user_group INTEGER - ,x_org_unit INTEGER - ,x_copy_own_lib INTEGER - ,x_user_home_lib INTEGER - ,x_circ_mod TEXT - ,x_circulate BOOLEAN - ,x_copy_loc INTEGER - ,x_duration_rule INTEGER - ,x_recurring_fine_rule INTEGER - ,x_grace_override INTERVAL - ,x_max_fine_rule INTEGER - ,x_circ_limit_set INTEGER - ,x_migrate BOOLEAN DEFAULT TRUE -); - -INSERT INTO gsheet_tracked_table - (table_name,tab_name,created) -VALUES - ('map_circ_combo_policies','Circ Combos',NOW()) -; - -INSERT INTO gsheet_tracked_column - (table_id,column_name) -VALUES - ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_active') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_group') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_org_unit') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_own_lib') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_user_home_lib') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_mod') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circulate') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_copy_loc') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_duration_rule') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_recurring_fine_rule') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_grace_override') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_max_fine_rule') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_circ_limit_set_name') - ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Combos'),'l_notes') -; - CREATE TABLE map_create_shelving_location ( l_id SERIAL ,l_owning_lib TEXT -- 1.7.2.5