projects
/
migration-tools.git
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
(parent:
9c3f19c
)
rebuild of derived values columns for map_circ_polices
author
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 2 Aug 2018 18:33:45 +0000 (14:33 -0400)
committer
Rogan Hamby
<rhamby@esilibrary.com>
Thu, 2 Aug 2018 18:33:45 +0000 (14:33 -0400)
mig-sql/init/020_common_tables.sql
patch
|
blob
|
history
diff --git
a/mig-sql/init/020_common_tables.sql
b/mig-sql/init/020_common_tables.sql
index
c6cad38
..
9dd5a1f
100644
(file)
--- 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
);