From e336493f61d75cf8eb684fb87f8c772e8dea6846 Mon Sep 17 00:00:00 2001 From: Rogan Hamby Date: Thu, 2 Aug 2018 14:33:45 -0400 Subject: [PATCH] rebuild of derived values columns for map_circ_polices --- mig-sql/init/020_common_tables.sql | 13 +++++++++---- 1 files changed, 9 insertions(+), 4 deletions(-) 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 ); -- 1.7.2.5