rebuild of derived values columns for map_circ_polices
authorRogan Hamby <rhamby@esilibrary.com>
Thu, 2 Aug 2018 18:33:45 +0000 (14:33 -0400)
committerRogan Hamby <rhamby@esilibrary.com>
Thu, 2 Aug 2018 18:33:45 +0000 (14:33 -0400)
mig-sql/init/020_common_tables.sql

index c6cad38..9dd5a1f 100644 (file)
@@ -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
 );