X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;h=aea35b9a3d4a08f9ce9792093347563d0a1a908f;hp=ec69043fe2243cff76bb99fb97ec1b1977eb2970;hb=632e63a67f6a05e0685799f67524f822d0ea9090;hpb=fca643f7be010d29c08d481fa0bd794382088b9c diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql index ec69043..aea35b9 100644 --- a/mig-sql/init/020_common_tables.sql +++ b/mig-sql/init/020_common_tables.sql @@ -11,7 +11,7 @@ CREATE TABLE map_hold_policies ( ,x_org_unit INTEGER ,x_grp_id INTEGER ,x_migrate BOOLEAN DEFAULT TRUE -) INHERITS (config.hold_matrix_matchpoint); +); INSERT INTO gsheet_tracked_table (table_name,tab_name,created) @@ -33,6 +33,62 @@ VALUES ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_notes') ; + CREATE TABLE map_hold_combo_policies ( + l_user_home_lib TEXT + ,l_request_lib TEXT + ,l_owning_lib TEXT + ,l_item_circ_lib TEXT + ,l_request_user_group TEXT + ,l_circ_mod TEXT + ,l_active TEXT + ,l_holdable TEXT + ,l_max_holds TEXT + ,l_max_includes_frozen TEXT + ,l_range_from TEXT + ,l_transit_range TEXT + ,l_user_group TEXT + ,l_notes TEXT + ,x_user_home_lib INTEGER + ,x_request_lib INTEGER + ,x_owning_lib INTEGER + ,x_item_circ_lib INTEGER + ,x_request_user_group INTEGER + ,x_circ_mod TEXT + ,x_active BOOLEAN DEFAULT TRUE + ,x_holdable BOOLEAN DEFAULT TRUE + ,x_max_holds INTEGER + ,x_max_includes_frozen BOOLEAN DEFAULT FALSE + ,x_range_from BOOLEAN DEFAULT TRUE + ,x_transit_range INTEGER + ,x_user_group INTEGER + ,x_migrate BOOLEAN DEFAULT TRUE +); + +INSERT INTO gsheet_tracked_table + (table_name,tab_name,created) +VALUES + ('map_hold_combo_policies','Hold Combos',NOW()) +; + +INSERT INTO gsheet_tracked_column + (table_id,column_name) +VALUES + ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_home_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_owning_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_item_circ_lib') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_request_user_group') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_circ_mod') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_active') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_holdable') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_holds') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_max_includes_frozen') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_range_from') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_transit_range') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_user_group') + ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Combos'),'l_notes') +; + CREATE TABLE map_circ_policies ( l_org_unit TEXT ,l_user_group TEXT @@ -56,8 +112,8 @@ CREATE TABLE map_circ_policies ( ,x_duration INTEGER ,x_max_fine INTEGER ,x_fine_interval INTEGER - ,x_migrate INTEGER -) INHERITS (config.circ_matrix_matchpoint); + ,x_migrate BOOLEAN DEFAULT FALSE +); INSERT INTO gsheet_tracked_table (table_name,tab_name,created) @@ -86,6 +142,62 @@ VALUES ; + 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