From 8f2c0a6d70c16e9b1cb50edc58f864650bbf50ef Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Tue, 8 Jan 2019 10:57:23 -0500 Subject: [PATCH] adding parent/guardian data --- Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql | 4 ++++ 1 file changed, 4 insertions(+) diff --git a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql index 3afe6426fe..404ad1f3c1 100644 --- a/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql +++ b/Open-ILS/src/sql/Pg/version-upgrade/pines-post-3.2-upgrade.sql @@ -96,4 +96,8 @@ VALUES ( (SELECT id FROM permission.perm_list WHERE code = 'VIEW_COPY_ALERT'), 0 ); + +-- move parent/guardian field data to new field +UPDATE actor.usr SET guardian = ident_value2, ident_value2 = NULL WHERE NOT deleted AND ident_value2 IS NOT NULL; + COMMIT; -- 2.11.0