Merge remote branch 'working/collab/berick/invalidate_email_and_phone_revised'
authorLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Wed, 11 Jan 2012 15:37:29 +0000 (10:37 -0500)
committerLebbeous Fogle-Weekley <lebbeous@esilibrary.com>
Wed, 11 Jan 2012 15:39:48 +0000 (10:39 -0500)
Signed-off-by: Lebbeous Fogle-Weekley <lebbeous@esilibrary.com>

1  2 
Open-ILS/src/sql/Pg/002.schema.config.sql
Open-ILS/src/sql/Pg/upgrade/0670.data.mark-email-and-phone-invalid.sql
Open-ILS/web/opac/locale/en-US/lang.dtd

@@@ -86,7 -86,7 +86,7 @@@ CREATE TRIGGER no_overlapping_dep
      BEFORE INSERT OR UPDATE ON config.db_patch_dependencies
      FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates');
  
--INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0669', :eg_version); -- tsbere/miker
++INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0670', :eg_version); -- berick/senator
  
  CREATE TABLE config.bib_source (
        id              SERIAL  PRIMARY KEY,
index 0000000,2c76bc7..bbc6810
mode 000000,100644..100644
--- /dev/null
@@@ -1,0 -1,63 +1,63 @@@
 --- Evergreen DB patch XXXX.data.mark-email-and-phone-invalid.sql
++-- Evergreen DB patch 0670.data.mark-email-and-phone-invalid.sql
+ --
+ -- Add org unit settings and standing penalty types to support
+ -- the mark email/phone invalid features.
+ --
+ BEGIN;
+ -- check whether patch can be applied
 -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
++SELECT evergreen.upgrade_deps_block_check('0670', :eg_version);
+ INSERT INTO config.standing_penalty (id, name, label, staff_alert, org_depth) VALUES
+     (
+         31,
+         'INVALID_PATRON_EMAIL_ADDRESS',
+         oils_i18n_gettext(
+             31,
+             'Patron had an invalid email address',
+             'csp',
+             'label'
+         ),
+         TRUE,
+         0
+     ),
+     (
+         32,
+         'INVALID_PATRON_DAY_PHONE',
+         oils_i18n_gettext(
+             32,
+             'Patron had an invalid daytime phone number',
+             'csp',
+             'label'
+         ),
+         TRUE,
+         0
+     ),
+     (
+         33,
+         'INVALID_PATRON_EVENING_PHONE',
+         oils_i18n_gettext(
+             33,
+             'Patron had an invalid evening phone number',
+             'csp',
+             'label'
+         ),
+         TRUE,
+         0
+     ),
+     (
+         34,
+         'INVALID_PATRON_OTHER_PHONE',
+         oils_i18n_gettext(
+             34,
+             'Patron had an invalid other phone number',
+             'csp',
+             'label'
+         ),
+         TRUE,
+         0
+     );
+ COMMIT;