X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=mig-sql%2Finit%2F020_common_tables.sql;fp=mig-sql%2Finit%2F020_common_tables.sql;h=9dd5a1f4bb07fdc9605f8a9b5c6b2b5d92820738;hp=c6cad38e4565ad78234b1366e89a9fe3c130fa0c;hb=e336493f61d75cf8eb684fb87f8c772e8dea6846;hpb=9c3f19c7ad519ddf157d3499bc29172994ee09be 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 );