From c34878987f58b9e61736f5886fe0bd6b20dbadd6 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rogan.hamby@gmail.com>
Date: Mon, 25 Apr 2016 15:34:09 -0400
Subject: [PATCH] initial work on updating field mapper, removing the loading
 of zips file from opensrf.xml and the files to create the table

Signed-off-by: Rogan Hamby <rogan.hamby@gmail.com>
---
 Open-ILS/examples/fm_IDL.xml                          | 19 +++++++++++++++++++
 Open-ILS/examples/opensrf.xml.example                 |  2 --
 Open-ILS/src/sql/Pg/002.schema.config.sql             | 14 ++++++++++++++
 .../sql/Pg/upgrade/xxxx.schema.add_postal_codes.sql   | 17 +++++++++++++++++
 4 files changed, 50 insertions(+), 2 deletions(-)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_postal_codes.sql

diff --git a/Open-ILS/examples/fm_IDL.xml b/Open-ILS/examples/fm_IDL.xml
index a51113f262..da07b08d9f 100644
--- a/Open-ILS/examples/fm_IDL.xml
+++ b/Open-ILS/examples/fm_IDL.xml
@@ -746,6 +746,25 @@ Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA
         </permacrud>
     </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_message" reporter:datatype="text"/>
+	</fields>
+	<links/>
+        <permacrud xmlns="http://open-ils.org/spec/opensrf/IDL/permacrud/v1">
+		<actions>
+			<retrieve/>
+		</actions>
+        </permacrud>
+</class>
+
     <class id="cin" controller="open-ils.cstore open-ils.pcrud" oils_obj:fieldmapper="config::index_normalizer" oils_persist:tablename="config.index_normalizer" reporter:label="Indexing Normalizer" oils_persist:field_safe="true">
         <fields oils_persist:primary="id">
             <field reporter:label="ID" name="id" reporter:datatype="id"/>
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 344c31658b..015caa5830 100644
--- a/Open-ILS/src/sql/Pg/002.schema.config.sql
+++ b/Open-ILS/src/sql/Pg/002.schema.config.sql
@@ -1201,4 +1201,18 @@ 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_message       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;
diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_postal_codes.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_postal_codes.sql
new file mode 100644
index 0000000000..44b5f7b983
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.schema.add_postal_codes.sql
@@ -0,0 +1,17 @@
+BEGIN;
+
+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_message       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