adding circ limit sets table

[migration-tools.git] / mig-sql / init / 020_common_tables.sql

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index 02e3fb8..9c1503e 100644 (file)
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -8,8 +8,8 @@ CREATE TABLE map_hold_policies (
     ,l_active           TEXT
     ,l_holdable         TEXT
     ,l_max_holds        TEXT
-    ,l_includes_frozen_holds    TEXT
-    ,l_distiance_is_from_owner  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
@@ -21,8 +21,8 @@ CREATE TABLE map_hold_policies (
     ,x_active           BOOLEAN
     ,x_holdable         BOOLEAN
     ,x_max_holds        INTEGER
-    ,x_includes_frozen_holds    BOOLEAN
-    ,x_distiance_is_from_owner  BOOLEAN
+    ,x_includes_frozen_holds   BOOLEAN
+    ,x_distance_is_from_owner  BOOLEAN
     ,x_transit_range    INTEGER
     ,x_usr_grp          INTEGER    
    ,x_migrate           BOOLEAN DEFAULT TRUE
@@ -106,6 +106,42 @@ VALUES
     ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Policies'),'l_notes')
 ;
 
+CREATE TABLE map_circ_limit_sets (
+    l_owning_lib        TEXT
+    ,l_name             TEXT
+    ,l_items_out        TEXT
+    ,l_depth            TEXT
+    ,l_global           TEXT
+    ,l_description      TEXT
+    ,l_circ_mod         TEXT
+    ,l_copy_loc         TEXT
+    ,x_owning_lib       INTEGER
+    ,x_name             TEXT
+    ,x_items_out        INTEGER
+    ,x_global           BOOLEAN
+    ,x_depth            INTEGER
+    ,x_description      TEXT
+);
+
+INSERT INTO gsheet_tracked_table
+    (table_name,tab_name,created)
+VALUES
+    ('map_circ_limit_sets','Circ Limit Sets',NOW())
+;
+
+INSERT INTO gsheet_tracked_column
+    (table_id,column_name)
+VALUES
+     ((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_owning_lib')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_name')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_items_out')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_depth')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_global')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_description')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_circ_mod')
+    ,((SELECT id FROM gsheet_tracked_table WHERE tab_name = 'Circ Limit Sets'),'l_copy_loc')
+;
+
 CREATE TABLE map_create_shelving_location (
     l_id                  SERIAL
     ,l_owning_lib         TEXT