From 48f4b48e72abb57b415d7b93ee3ed3511158b9c6 Mon Sep 17 00:00:00 2001
From: Rogan Hamby <rogan.hamby@gmail.com>
Date: Wed, 2 Nov 2016 15:24:27 -0400
Subject: [PATCH] add sql to add table for codes in config schema

---
 .../src/sql/Pg/upgrade/xxxx.scheam.add_postal_codes.sql | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 Open-ILS/src/sql/Pg/upgrade/xxxx.scheam.add_postal_codes.sql

diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.scheam.add_postal_codes.sql b/Open-ILS/src/sql/Pg/upgrade/xxxx.scheam.add_postal_codes.sql
new file mode 100644
index 0000000000..8bdfba60f6
--- /dev/null
+++ b/Open-ILS/src/sql/Pg/upgrade/xxxx.scheam.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