Table of Contents
Sites who traditionally store parent/guardian information in the patron Secondary Identification field can migrate values from this field to the new guardian field with the following SQL:
BEGIN;
-- 1. Find the local ID of the parent/guardian identification type
SELECT * FROM config.identification_type;
-- 2. On my test system, the id is "101". It will vary!.
-- Migrate the value from the ident2 field to the guardian field.
UPDATE actor.usr
SET guardian = ident_value2
WHERE
ident_type2 = 101 -- !! CHANGE TO SUIT
AND ident_value2 IS NOT NULL
AND ident_value2 <> '';
-- 3. delete the original secondary identification data
UPDATE actor.usr
SET ident_value2 = NULL, ident_type2 = NULL
WHERE
ident_type2 = 101; -- !! CHANGE TO SUIT
COMMIT;