From 1851491106219b63b5451db79137206ee91b7736 Mon Sep 17 00:00:00 2001 From: miker Date: Wed, 25 Apr 2007 14:07:09 +0000 Subject: [PATCH] adding some default circ related rules git-svn-id: svn://svn.open-ils.org/ILS/trunk@7162 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/002.schema.config.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 618f0ba847..37a4dbe5f2 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -272,6 +272,8 @@ INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '1_hour_2_renew', '1 hour INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '28_days_0_renew', '28 days', '28 days', '28 days', 0); INSERT INTO config.rule_circ_duration VALUES (DEFAULT, '14_days_2_renew', '14 days', '14 days', '14 days', 2); +INSERT INTO config.rule_circ_duration VALUES (DEFAULT, 'default', '21 days', '14 days', '7 days', 2); + CREATE TABLE config.rule_max_fine ( id SERIAL PRIMARY KEY, @@ -303,6 +305,8 @@ COMMENT ON TABLE config.rule_max_fine IS $$ */ $$; +INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'default', 5.00); + INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_min', 5.00); INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_mid', 10.00); INSERT INTO config.rule_max_fine VALUES (DEFAULT, 'overdue_max', 100.00); @@ -346,6 +350,7 @@ COMMENT ON TABLE config.rule_recuring_fine IS $$ */ $$; +INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, 'default', 0.50, 0.10, 0.05, '1 day'); INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '10_cent_per_day', 0.50, 0.10, 0.10, '1 day'); INSERT INTO config.rule_recuring_fine VALUES (DEFAULT, '50_cent_per_day', 0.50, 0.50, 0.50, '1 day'); -- 2.11.0