From fd1e6cd07787fd35b74ca78d6658fccf81582076 Mon Sep 17 00:00:00 2001
From: miker <miker@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Mon, 7 Mar 2011 16:03:40 +0000
Subject: [PATCH] add a description field to config.record_attr_definition

git-svn-id: svn://svn.open-ils.org/ILS/trunk@19621 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/examples/fm_IDL.xml                       |    1 +
 Open-ILS/src/sql/Pg/002.schema.config.sql          |    1 +
 .../sql/Pg/upgrade/XXXX.schema.svf-phase-one.sql   |    1 +
 3 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 6aa3b90..8c39296 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 4d14a59..d387044 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 8c7c82c..3c6d24c 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
 
-- 
1.7.2.5