From: Rogan Hamby <rhamby@esilibrary.com>
Date: Thu, 2 Aug 2018 18:33:45 +0000 (-0400)
Subject: rebuild of derived values columns for map_circ_polices
X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=commitdiff_plain;h=e336493f61d75cf8eb684fb87f8c772e8dea6846

rebuild of derived values columns for map_circ_polices
---

diff --git a/mig-sql/init/020_common_tables.sql b/mig-sql/init/020_common_tables.sql
index c6cad38..9dd5a1f 100644
--- a/mig-sql/init/020_common_tables.sql
+++ b/mig-sql/init/020_common_tables.sql
@@ -104,12 +104,17 @@ CREATE TABLE map_circ_policies (
     ,l_max_fine             TEXT
     ,l_notes                TEXT
     ,x_org_unit             INTEGER
-    ,x_grp_id               INTEGER
+    ,x_user_group           INTEGER
+    ,x_copy_owning_lib      INTEGER
+    ,x_user_home_lib        INTEGER
+    ,x_circ_mod             TEXT
     ,x_copy_location        INTEGER
-    ,x_circ_limit           INTEGER
-    ,x_duration             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_fine_interval        INTEGER
     ,x_migrate              BOOLEAN DEFAULT FALSE
 );