From a499a47f3cfaa02e5117cf930f4d484415853044 Mon Sep 17 00:00:00 2001
From: Mike Rylander <mrylander@gmail.com>
Date: Thu, 3 Mar 2011 15:47:02 -0500
Subject: [PATCH] add a description field to config.record_attr_definition

---
 Open-ILS/examples/fm_IDL.xml                              | 1 +
 Open-ILS/src/sql/Pg/002.schema.config.sql                 | 1 +
 Open-ILS/src/sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql | 1 +
 3 files changed, 3 insertions(+)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 6aa3b90a66..8c392961ca 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -575,6 +575,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 		<fields oils_persist:primary="name">
 			<field reporter:label="Name" name="name" reporter:datatype="id" reporter:selector="label"  oils_obj:required="true"/>
 			<field reporter:label="Label" name="label" reporter:datatype="text"  oils_obj:required="true"/>
+			<field reporter:label="Description" name="description" reporter:datatype="text" />
 			<field reporter:label="Filter?" name="filter" reporter:datatype="bool"/>
 			<field reporter:label="Sorter?" name="sorter" reporter:datatype="bool"/>
 			<field reporter:label="MARC Tag" name="tag" reporter:datatype="text"/>
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index a09f55040f..0984679d5a 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -888,6 +888,7 @@ CREATE TABLE config.metabib_field_index_norm_map (
 CREATE TABLE config.record_attr_definition (
     name        TEXT    PRIMARY KEY,
     label       TEXT    NOT NULL, -- I18N
+    description TEXT,
     filter      BOOL    NOT NULL DEFAULT TRUE,  -- becomes QP filter if true
     sorter      BOOL    NOT NULL DEFAULT FALSE, -- becomes QP sort() axis if true
 
diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql
index 8c7c82c6ad..3c6d24c62b 100644
--- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql
+++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql
@@ -5,6 +5,7 @@ INSERT INTO config.upgrade_log (version) VALUES ('XXXX'); -- miker
 CREATE TABLE config.record_attr_definition (
     name        TEXT    PRIMARY KEY,
     label       TEXT    NOT NULL, -- I18N
+    description TEXT,
     filter      BOOL    NOT NULL DEFAULT TRUE,  -- becomes QP filter if true
     sorter      BOOL    NOT NULL DEFAULT FALSE, -- becomes QP sort() axis if true
 
-- 
2.11.0