From 93380a6ee3d45f8ee2bc51cc7a16f9ffeeb177ce Mon Sep 17 00:00:00 2001
From: scottmk <scottmk@dcc99617-32d9-48b4-a31d-7c20da2025e4>
Date: Thu, 9 Jul 2009 18:45:54 +0000
Subject: [PATCH] Add new column org_depth to config.standing_penalty.

SQL to alter existing table:

alter table config.standing_penalty
add column org_depth integer;


git-svn-id: svn://svn.open-ils.org/ILS/trunk@13556 dcc99617-32d9-48b4-a31d-7c20da2025e4
---
 Open-ILS/examples/fm_IDL.xml              | 1 +
 Open-ILS/src/sql/Pg/002.schema.config.sql | 5 +++--
 2 files changed, 4 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index 23f7f1fcdd..4ab08d12e8 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -1894,6 +1894,7 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 			<field name="name"  reporter:datatype="text"/>
 			<field name="label"  reporter:datatype="text" oils_persist:i18n="true"/>
 			<field name="block_list" reporter:datatype="text"/>
+			<field name="org_depth" reporter:datatype="int"/>
 		</fields>
 		<links/>
         <permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 1718a7d5f2..1c21959411 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -112,10 +112,11 @@ COMMENT ON TABLE config.standing IS $$
 $$;
 
 CREATE TABLE config.standing_penalty (
-	id		SERIAL	PRIMARY KEY,
+	id			SERIAL	PRIMARY KEY,
 	name		TEXT	NOT NULL UNIQUE,
 	label		TEXT	NOT NULL,
-	block_list	TEXT
+	block_list	TEXT,
+	org_depth	INTEGER
 );
 INSERT INTO config.standing_penalty (id,name,label,block_list)
 	VALUES (1,'PATRON_EXCEEDS_FINES','Patron exceeds fine threshold','CIRC|HOLD|RENEW');
-- 
2.11.0