From a82af673f0cff60f4e7424b9c1a516f28378bf1b Mon Sep 17 00:00:00 2001
From: Jane Sandberg <sandbej@linnbenton.edu>
Date: Tue, 11 Dec 2018 21:23:38 -0800
Subject: [PATCH] add note field

---
 Open-ILS/examples/fm_IDL.xml                               | 1 +
 Open-ILS/src/sql/Pg/095.schema.booking.sql                 | 3 ++-
 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_note_bresv.sql | 6 ++++++
 3 files changed, 9 insertions(+), 1 deletion(-)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_note_bresv.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 1be2c885e8..c3b5668bb8 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -5105,6 +5105,7 @@ SELECT  usr,
 			<field reporter:label="Pickup Library" name="pickup_lib" reporter:datatype="link"/>
 			<field reporter:label="Capture Staff" name="capture_staff" reporter:datatype="link"/>
 			<field reporter:label="Notify by Email?" name="email_notify" reporter:datatype="bool"/>
+			<field reporter:label="Note" name="note" reporter:datatype="text"/>
 			<field reporter:label="Attribute Value Maps" name="attr_val_maps" oils_persist:virtual="true" reporter:datatype="link"/>
 		</fields>
 		<links>
diff --git a/Open-ILS/src/sql/Pg/095.schema.booking.sql b/Open-ILS/src/sql/Pg/095.schema.booking.sql
index 974f3b9bba..7144fded4e 100644
--- a/Open-ILS/src/sql/Pg/095.schema.booking.sql
+++ b/Open-ILS/src/sql/Pg/095.schema.booking.sql
@@ -129,7 +129,8 @@ CREATE TABLE booking.reservation (
 	                                DEFERRABLE INITIALLY DEFERRED,
 	capture_staff    INT            REFERENCES actor.usr(id)
 	                                DEFERRABLE INITIALLY DEFERRED,
-	email_notify     BOOLEAN        NOT NULL DEFAULT FALSE
+	email_notify     BOOLEAN        NOT NULL DEFAULT FALSE,
+	note             TEXT
 ) INHERITS (money.billable_xact);
 
 ALTER TABLE booking.reservation ADD PRIMARY KEY (id);
diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_note_bresv.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_note_bresv.sql
new file mode 100644
index 0000000000..8484077526
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_note_bresv.sql
@@ -0,0 +1,6 @@
+BEGIN;
+
+ALTER TABLE booking.reservation 
+    ADD COLUMN note TEXT;
+
+COMMIT;
-- 
2.11.0