From dceb6d161e87103444dca2631f599512127634b0 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rogan.hamby@gmail.com>
Date: Wed, 2 Nov 2016 13:54:25 -0400
Subject: [PATCH] remove example from opensrf file, field mapper and schema
 config bits

---
 Open-ILS/examples/fm_IDL.xml              | 18 ++++++++++++++++++
 Open-ILS/examples/opensrf.xml.example     |  2 --
 Open-ILS/src/sql/Pg/002.schema.config.sql | 16 ++++++++++++++++
 3 files changed, 34 insertions(+), 2 deletions(-)

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index a51113f262..5e25e789ed 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -729,6 +729,24 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
 		</links>
 	</class>
 
+	<class id="cpc" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="config::postal_codes" oils_persist:tablename="config.postal_codes" reporter:label="Postal Codes" oils_persist:field_safe="true">
+		<fields oils_persist:primary="id" oils_persist:sequence="config.postal_codes_id_seq">
+			<field reporter:label="ID" name="id" reporter:datatype="id"/>
+			<field reporter:label="State" name="state" reporter:datatype="text"/>
+			<field reporter:label="City" name="city" reporter:datatype="text"/>
+			<field reporter:label="Postal Code" name="postal_code" reporter:datatype="text"/>
+			<field reporter:label="Enabled" name="enabled" reporter:datatype="boolean"/>
+			<field reporter:label="County" name="county" reporter:datatype="text"/>
+			<field reporter:label="Alert Message" name="alert" reporter:datatype="text"/>
+		</fields>
+		<links/>
+		<permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
+			<actions>
+				<retrieve/>
+			</actions>
+		</permacrud>
+	</class>
+
     <class id="cgf" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="config::global_flag" oils_persist:tablename="config.global_flag" reporter:label="Global Flags and Settings" oils_persist:field_safe="true">
         <fields oils_persist:primary="name">
             <field reporter:label="Name" name="name" reporter:datatype="text"/>
diff --git a/Open-ILS/examples/opensrf.xml.example b/Open-ILS/examples/opensrf.xml.example
index 87db4cc49a..888df66ff5 100644
--- a/Open-ILS/examples/opensrf.xml.example
+++ b/Open-ILS/examples/opensrf.xml.example
@@ -634,8 +634,6 @@ vim:et:ts=4:sw=4:
                     <!-- How many superpages to consider for searching overall. -->
                     <max_superpages>10</max_superpages>
 
-                    <!-- zip code database file -->
-                    <!--<zips_file>LOCALSTATEDIR/data/zips.txt</zips_file>-->
                 </app_settings>
             </open-ils.search>
 
diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index cad3b82e56..508759c602 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -1201,4 +1201,20 @@ ALTER TABLE config.marc_subfield
            )
           );
 
+CREATE TABLE config.postal_codes (
+    id                  SERIAL PRIMARY KEY,
+    state               TEXT,
+    city                TEXT,
+    postal_code         TEXT NOT NULL,
+    enabled             BOOLEAN NOT NULL DEFAULT TRUE,
+    county              TEXT,
+    alert               TEXT
+    );
+
+COMMENT ON TABLE config.postal_codes IS $$
+This table stores the postal codes for use with the patron editor that used to live in an external text file.
+$$;
+
+
+
 COMMIT;
-- 
2.11.0