From 92edcf8db55f060f4ba0096a525b245fab7797e1 Mon Sep 17 00:00:00 2001
From: Dan Pearl <dpearl@cwmars.org>
Date: Tue, 19 Mar 2013 15:10:16 -0400
Subject: [PATCH] LP #1157382 - Provide a way to override default sorting in
 monograph parts

In the occasion that the current label_sortkey mechanism does not provide correct results,
allow explicit ordering in monograph_parts overriding derived label_sortkey.

The database schema change as part of this source change would need to be part of an upgrade
script.

Signed-off-by: Dan Pearl <dpearl@cwmars.org>
---
 Open-ILS/examples/fm_IDL.xml              | 1 +
 Open-ILS/src/sql/Pg/010.schema.biblio.sql | 1 +
 2 files changed, 2 insertions(+)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 1b7cee523c..504b12aa98 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -2734,6 +2734,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field name="record" reporter:datatype="link"/>
 			<field name="label" reporter:datatype="text"/>
 			<field name="label_sortkey" reporter:datatype="text"/>
+                        <field name="sort_order" reporter:datatype="int"/>
 		</fields>
 		<links>
 			<link field="record" reltype="has_a" key="id" map="" class="bre"/>
diff --git a/Open-ILS/src/sql/Pg/010.schema.biblio.sql b/Open-ILS/src/sql/Pg/010.schema.biblio.sql
index 4ce54ae96b..a6943f2cbf 100644
--- a/Open-ILS/src/sql/Pg/010.schema.biblio.sql
+++ b/Open-ILS/src/sql/Pg/010.schema.biblio.sql
@@ -98,6 +98,7 @@ CREATE TABLE biblio.monograph_part (
     record          BIGINT  NOT NULL REFERENCES biblio.record_entry (id),
     label           TEXT    NOT NULL,
     label_sortkey   TEXT    NOT NULL,
+    sort_order      INT     NOT NULL DEFAULT 0,
     CONSTRAINT record_label_unique UNIQUE (record,label)
 );
 
-- 
2.11.0