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=a8e6b98afdde9dda53501052c35aef134a6e0971;hb=632e63a67f6a05e0685799f67524f822d0ea9090;hpb=b8cab247d3aee29fc01a8b4382d5f3e43394cb45

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index a8e6b98..aea35b9 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -1,3 +1,203 @@
+CREATE TABLE map_hold_policies (
+    l_org_unit            TEXT
+    ,l_user_group         TEXT
+    ,l_circ_mod           TEXT
+    ,l_holdable           TEXT
+    ,l_max_holds          TEXT
+    ,l_include_frozen     TEXT
+    ,l_transit_range      TEXT
+    ,l_range_from         TEXT
+    ,l_notes              TEXT
+    ,x_org_unit           INTEGER
+    ,x_grp_id             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_org_unit')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_user_group')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Hold Policies'),'l_circ_mod')
+    ,((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_include_frozen')
+    ,((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_range_from')
+    ,((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
+    ,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_grace_override       TEXT
+    ,l_renewal_boolean      TEXT
+    ,l_notes                TEXT
+    ,x_org_unit             INTEGER
+    ,x_grp_id               INTEGER
+    ,x_copy_location        INTEGER
+    ,x_circ_limit           INTEGER
+    ,x_duration             INTEGER
+    ,x_max_fine             INTEGER
+    ,x_fine_interval        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_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_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_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            
@@ -8,6 +208,7 @@ CREATE TABLE map_create_shelving_location (
     ,l_circulate          TEXT
     ,l_note               TEXT
     ,x_migrate            BOOLEAN NOT NULL DEFAULT TRUE
+    ,x_shelf              INTEGER
 ) INHERITS (asset_copy_location);
 
 INSERT INTO gsheet_tracked_table 
@@ -146,3 +347,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')
+;
+
+