From cca64eb664786b0713dac25640c878704fd6fcfd Mon Sep 17 00:00:00 2001
From: scottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 18 Jun 2009 21:06:48 +0000
Subject: [PATCH] Add table action.hold_request_note, class "ahrn"

git-svn-id: svn://svn.open-ils.org/ILS/trunk@13403 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/examples/fm_IDL.xml              | 13 +++++++++++++
 Open-ILS/src/sql/Pg/090.schema.action.sql | 15 +++++++++++++++
 2 files changed, 28 insertions(+)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 23d717127c..a0977c9a7a 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -2662,6 +2662,19 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<link field="cancel_cause" reltype="might_have" key="id" map="" class="ahrcc"/>
 		</links>
 	</class>
+	<class id="ahrn" controller="open-ils.cstore" oils_obj:fieldmapper="action::hold_request_note" oils_persist:tablename="action.hold_request_note" reporter:label="Hold Request Note">
+		<fields oils_persist:primary="id" oils_persist:sequence="action.hold_request_note_id_seq">
+			<field reporter:label="ID" name="id" reporter:datatype="id"/>
+			<field reporter:label="Hold ID" name="hold" reporter:datatype="link"/>
+			<field reporter:label="Title" name="title" reporter:datatype="text"/>
+			<field reporter:label="Body" name="body" reporter:datatype="text"/>
+			<field reporter:label="Slip?" name="slip" reporter:datatype="bool"/>
+			<field reporter:label="Pub?" name="pub" reporter:datatype="bool"/>
+		</fields>
+		<links>
+			<link field="hold" reltype="has_a" key="id" map="" class="ahr"/>
+		</links>
+	</class>
 	<class id="aou" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="actor::org_unit" oils_persist:tablename="actor.org_unit" reporter:label="Organizational Unit" oils_persist:field_safe="true">
 		<fields oils_persist:primary="id" oils_persist:sequence="actor.org_unit_id_seq">
 			<field reporter:label="Subordinate Organizational Units" name="children" oils_persist:virtual="true" reporter:datatype="org_unit"/>
diff --git a/Open-ILS/src/sql/Pg/090.schema.action.sql b/Open-ILS/src/sql/Pg/090.schema.action.sql
index ba5b1c749b..a5dd317bf9 100644
--- a/Open-ILS/src/sql/Pg/090.schema.action.sql
+++ b/Open-ILS/src/sql/Pg/090.schema.action.sql
@@ -296,6 +296,21 @@ CREATE INDEX hold_request_current_copy_idx ON action.hold_request (current_copy)
 CREATE INDEX hold_request_prev_check_time_idx ON action.hold_request (prev_check_time);
 
 
+CREATE TABLE action.hold_request_note (
+
+    id     BIGSERIAL PRIMARY KEY,
+    hold   BIGINT    NOT NULL REFERENCES action.hold_request (id)
+                              ON DELETE CASCADE
+                              DEFERRABLE INITIALLY DEFERRED,
+    title  TEXT      NOT NULL,
+    body   TEXT      NOT NULL,
+    slip   BOOL      NOT NULL DEFAULT FALSE,
+    pub    BOOL      NOT NULL DEFAULT FALSE
+
+);
+CREATE INDEX ahrn_hold_idx ON action.hold_request_note (hold);
+
+
 CREATE TABLE action.hold_notification (
 	id		SERIAL				PRIMARY KEY,
 	hold		INT				NOT NULL REFERENCES action.hold_request (id) DEFERRABLE INITIALLY DEFERRED,
-- 
2.43.2