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=910a632c63e33e86135788525e5ab80f79d27e78;hb=632e63a67f6a05e0685799f67524f822d0ea9090;hpb=ff15dd2f606804702b1fcb6f9c7d2e06c1ca6760

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