From e166e2a2db389ab376b3b2bf474e723205fc7b3d Mon Sep 17 00:00:00 2001 From: Thomas Berezansky Date: Tue, 2 Aug 2011 14:15:44 -0400 Subject: [PATCH] Unwrapped upgrade script for descripition changes Signed-off-by: Thomas Berezansky Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/upgrade/XXXX.phone_pw.sql | 3 +++ 1 file changed, 3 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.phone_pw.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.phone_pw.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.phone_pw.sql new file mode 100644 index 0000000000..b39ff970b2 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.phone_pw.sql @@ -0,0 +1,3 @@ +UPDATE config.org_unit_setting_type SET description = E'The Regular Expression for validation on the day_phone field in patron registration. Note: The first capture group will be used for the "last 4 digits of phone number" feature, if enabled. Ex: "[2-9]\\d{2}-\\d{3}-(\\d{4})( x\\d+)?" will ignore the extension on a NANP number.' WHERE name = 'ui.patron.edit.au.day_phone.regex'; + +UPDATE config.org_unit_setting_type SET description = 'The Regular Expression for validation on phone fields in patron registration. Applies to all phone fields without their own setting. NOTE: See description of the day_phone regex for important information about capture groups with it.' WHERE name = 'ui.patron.edit.phone.regex'; -- 2.11.0