X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=0a4243c7b4465ada0f0b83ce6e47c2cb7f61bba6;hp=ab1b01136a1eda65e5c0fb7e3075633937902415;hb=d4aa3a31e550efef14a4bcd0ba99188d4fa9b153;hpb=2d416d5e39c1f6a1b32876cf66512f99817d7ee3 diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index ab1b011..0a4243c 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -1,3 +1,111 @@ +CREATE TABLE map_hold_policies ( + l_user_home_ou TEXT + ,l_request_ou TEXT + ,l_item_owning_ou TEXT + ,l_item_circ_ou TEXT + ,l_requestor_grp TEXT + ,l_circ_modifier TEXT + ,l_active TEXT + ,l_holdable TEXT + ,l_max_holds TEXT + ,l_includes_frozen_holds TEXT + ,l_distance_is_from_owner TEXT + ,l_transit_range TEXT + ,l_usr_grp TEXT + ,x_user_home_ou INTEGER + ,x_request_ou INTEGER + ,x_item_owning_ou INTEGER + ,x_item_circ_ou INTEGER + ,x_requestor_grp INTEGER + ,x_circ_modifier TEXT + ,x_active BOOLEAN + ,x_holdable BOOLEAN + ,x_max_holds INTEGER + ,x_includes_frozen_holds BOOLEAN + ,x_distance_is_from_owner BOOLEAN + ,x_transit_range INTEGER + ,x_usr_grp INTEGER + ,x_migrate BOOLEAN DEFAULT TRUE +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_hold_policies','Hold Policies',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +VALUES + ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_user_home_ou') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_request_ou') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_owning_ou') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_item_circ_ou') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_requestor_grp') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_circ_modifier') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_active') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_holdable') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_max_holds') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_includes_frozen_holds') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_distance_is_from_owner') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_transit_range') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_usr_grp') +; + + +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_fine_rule TEXT + ,l_grace_override TEXT + ,l_max_fine TEXT + ,l_notes TEXT + ,x_org_unit INTEGER + ,x_user_group INTEGER + ,x_copy_owning_lib INTEGER + ,x_user_home_lib INTEGER + ,x_circ_mod TEXT + ,x_copy_location INTEGER + ,x_circulate BOOLEAN + ,x_circ_limit_set INTEGER + ,x_duration_rule INTEGER + ,x_fine_rule INTEGER + ,x_grace_override INTERVAL + ,x_max_fine INTEGER + ,x_migrate BOOLEAN DEFAULT FALSE +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_circ_policies','Circ Policies',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +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_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_max_fine') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes') +; + CREATE TABLE map_create_shelving_location ( l_id SERIAL ,l_owning_lib TEXT @@ -147,3 +255,34 @@ VALUES ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_value') ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Org Settings'),'l_note') ; + + +CREATE TABLE map_bib_manipulations ( + id SERIAL + ,action TEXT + ,field TEXT + ,subfield TEXT + ,matching_value TEXT + ,target_value TEXT + ,note TEXT +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_bib_manipulations','Bib Records',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +VALUES + ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'name') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'action') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'field') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'subfield') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'matching_value') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'target_value') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Bib Records'),'note') +; + +