From 64255d712a8af5f7e7488e12af73558323f0daa4 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 3 Dec 2009 15:58:34 +0000
Subject: [PATCH] adding max_fine to resource_type and reservation; moved
 au.reservation pointer from capturing staff to requesting user

git-svn-id: svn://svn.open-ils.org/ILS/trunk@15068 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/examples/fm_IDL.xml                                 | 8 +++-----
 Open-ILS/src/sql/Pg/095.schema.booking.sql                   | 2 ++
 Open-ILS/src/sql/Pg/upgrade/0103.schema.booking.max_fine.sql | 8 ++++++++
 3 files changed, 13 insertions(+), 5 deletions(-)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/0103.schema.booking.max_fine.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 1597a445e8..37352b22b9 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -1755,7 +1755,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<link field="cards" reltype="has_many" key="usr" map="" class="ac"/>
 			<link field="performed_circulations" reltype="has_many" key="circ_staff" map="" class="circ"/>
 			<link field="fund_alloc_pcts" reltype="has_many" key="allocator" map="" class="acqfap"/>
-			<link field="reservations" reltype="has_many" key="capture_staff" map="" class="bresv"/>
+			<link field="reservations" reltype="has_many" key="usr" map="" class="bresv"/>
 		</links>
 	</class>
 
@@ -2357,6 +2357,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field reporter:label="Resource Type Name" name="name" reporter:datatype="text"/>
 			<field reporter:label="Fine Interval" name="fine_interval" reporter:datatype="interval"/>
 			<field reporter:label="Fine Amount" name="fine_amount" reporter:datatype="money"/>
+			<field reporter:label="Max Fine Amount" name="max_fine" reporter:datatype="money"/>
 			<field reporter:label="Owning Library" name="owner" reporter:datatype="org_unit"/>
 			<field reporter:label="Catalog Item" name="catalog_item" reporter:datatype="bool"/>
 			<field reporter:label="Bibliographic Record" name="record" reporter:datatype="link"/>
@@ -2463,8 +2464,6 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field reporter:label="Transaction Finish Date/Time" name="xact_finish" reporter:datatype="timestamp"/>
 			<field reporter:label="Transaction Start Date/Time" name="xact_start" reporter:datatype="timestamp"/>
 			<field reporter:label="Unrecovered Debt" name="unrecovered" reporter:datatype="bool"/>
-			<field reporter:label="Grocery Billing link" name="grocery" oils_persist:virtual="true" reporter:datatype="link"/>
-			<field reporter:label="Circulation Billing link" name="circulation" oils_persist:virtual="true" reporter:datatype="link"/>
 			<field reporter:label="Billing Line Items" name="billings" oils_persist:virtual="true" reporter:datatype="link"/>
 			<field reporter:label="Payment Line Items" name="payments" oils_persist:virtual="true" reporter:datatype="link"/>
 			<field reporter:label="Billing Totals" name="billing_total" oils_persist:virtual="true" reporter:datatype="money"/>
@@ -2480,6 +2479,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field reporter:label="Booking Interval" name="booking_interval" reporter:datatype="interval"/>
 			<field reporter:label="Fine Interval" name="fine_interval" reporter:datatype="interval"/>
 			<field reporter:label="Fine Amount" name="fine_amount" reporter:datatype="money"/>
+			<field reporter:label="Max Fine Amount" name="max_fine" reporter:datatype="money"/>
 			<field reporter:label="Target Resource Type" name="target_resource_type" reporter:datatype="link"/>
 			<field reporter:label="Target Resource" name="target_resource" reporter:datatype="link"/>
 			<field reporter:label="Current Resource" name="current_resource" reporter:datatype="link"/>
@@ -2489,8 +2489,6 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field reporter:label="Attribute Value Maps" name="attr_val_maps" oils_persist:virtual="true" reporter:datatype="link"/>
 		</fields>
 		<links>
-			<link field="grocery" reltype="might_have" key="id" map="" class="mg"/>
-			<link field="circulation" reltype="might_have" key="id" map="" class="circ"/>
 			<link field="usr" reltype="has_a" key="id" map="" class="au"/>
 			<link field="payments" reltype="has_many" key="xact" map="" class="mp"/>
 			<link field="billings" reltype="has_many" key="xact" map="" class="mb"/>
diff --git a/Open-ILS/src/sql/Pg/095.schema.booking.sql b/Open-ILS/src/sql/Pg/095.schema.booking.sql
index 32840be291..79dbd767fe 100644
--- a/Open-ILS/src/sql/Pg/095.schema.booking.sql
+++ b/Open-ILS/src/sql/Pg/095.schema.booking.sql
@@ -25,6 +25,7 @@ CREATE TABLE booking.resource_type (
 	name           TEXT            NOT NULL,
 	fine_interval  INTERVAL,
 	fine_amount    DECIMAL(8,2)    NOT NULL DEFAULT 0,
+	max_fine       DECIMAL(8,2),
 	owner          INT             NOT NULL
 	                               REFERENCES actor.org_unit( id )
 	                               DEFERRABLE INITIALLY DEFERRED,
@@ -109,6 +110,7 @@ CREATE TABLE booking.reservation (
 	booking_interval INTERVAL,
 	fine_interval    INTERVAL,
 	fine_amount      DECIMAL(8,2),
+	max_fine         DECIMAL(8,2),
 	target_resource_type  INT       NOT NULL
 	                                REFERENCES booking.resource_type(id)
 	                                ON DELETE CASCADE
diff --git a/Open-ILS/src/sql/Pg/upgrade/0103.schema.booking.max_fine.sql b/Open-ILS/src/sql/Pg/upgrade/0103.schema.booking.max_fine.sql
new file mode 100644
index 0000000000..34dc26b610
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/0103.schema.booking.max_fine.sql
@@ -0,0 +1,8 @@
+BEGIN;
+
+INSERT INTO config.upgrade_log (version) VALUES ('0103'); -- miker
+
+ALTER TABLE booking.resource_type ADD COLUMN max_fine NUMERIC(8,2);
+ALTER TABLE booking.reservation ADD COLUMN max_fine NUMERIC(8,2);
+
+COMMIT;
-- 
2.11.0