fixing column data type in circ matrix map 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 910a632..aea35b9 100644 (file)
--- 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,7 +33,6 @@ 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
@@ -60,7 +59,7 @@ VALUES
     ,x_max_holds            INTEGER
     ,x_max_includes_frozen  BOOLEAN DEFAULT FALSE
     ,x_range_from           BOOLEAN DEFAULT TRUE
-    ,x_trasnit_range        INTEGER
+    ,x_transit_range        INTEGER
     ,x_user_group           INTEGER
     ,x_migrate              BOOLEAN DEFAULT TRUE
 );
@@ -68,7 +67,7 @@ VALUES
 INSERT INTO gsheet_tracked_table
     (table_name,tab_name,created)
 VALUES
-    ('map_combo_circ_policies','Hold Combos',NOW())
+    ('map_hold_combo_policies','Hold Combos',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column
@@ -113,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)
@@ -177,7 +176,7 @@ VALUES
 INSERT INTO gsheet_tracked_table
     (table_name,tab_name,created)
 VALUES
-    ('map_combo_circ_policies','Circ Combos',NOW())
+    ('map_circ_combo_policies','Circ Combos',NOW())
 ;
 
 INSERT INTO gsheet_tracked_column