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=a50b810d9f4b6bd58f52e06bc87aa1de4f54efcb;hb=d4aa3a31e550efef14a4bcd0ba99188d4fa9b153;hpb=3198dd53c3f3932a2806c9d101a055a58c716d42

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index a50b810..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